Excel Practice Problems

Past CAS Exams: Excel Format

These are the 3 most recent published exams for CAS Exam 5 converted into Excel format. See examiner's reports for solutions. You can download the examiner's report from the CAS website or use the Exam Summaries wiki article to quickly check individual problems & solutions.

CAS Exam 5: 2019.Fall (Problems)

CAS Exam 5: 2019.Spring (Problems)

CAS Exam 5: 2018.Fall (Problems)

These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:

Exam 5: 2018.Spring (version 1) - QUESTIONS ONLY

Exam 5: 2018.Spring (version 1)

Exam 5: 2018.Spring (version 2) - QUESTIONS ONLY

Exam 5: 2018.Spring (version 2)

BattleActs: Excel Format Reserving Problems

title	problem types	Set 1	Set 2	Set 3	Set 4
Reserving-A	building triangles development method ECR method BF method CC method	Reserving-A-01 Reserving-A-01-Solns	Reserving-A-02 Reserving-A-02-Solns
Reserving-B	FS basic method case OS formula method reported Berq-Sherm method	Reserving-B-01 Reserving-B-01-Solns	Reserving-B-02 Reserving-B-02-Solns
Reserving-C	building triangles development method BF method (tort reform) CC method (adjs)	Reserving-C-01 Reserving-C-01-Solns	Reserving-C-02 Reserving-C-02-Solns	Reserving-C-03 Reserving-C-03-Solns	Reserving-C-04 Reserving-C-04-Solns
Reserving-D	disposal rate method paid Berq-Sherm method case O/S hard method evaluation	Reserving-D-01 Reserving-D-01-Solns	Reserving-D-02 Reserving-D-02-Solns
Reserving-E	S/S multiplicative reinsurance net unpaid ALAE additive/mult. ULAE - classical/Kittel ULAE - Conger/Nolibos	Reserving-E-01 Reserving-E-01-Solns	Reserving-E-02 Reserving-E-02-Solns

BattleActs: Excel Format Pricing Problems

chapter	problem types	Set 1	Set 2
Pricing-01-03-04	basic formulas AY & CY losses exposure aggregation	Pricing: Set 1 (01-03-04) Pricing: Set 1 (01-03-04) Solns	Pricing: Set 2 (01-03-04) Pricing: Set 2 (01-03-04) Solns
Pricing-05a	EP @ CRL: annual, 1 rt chg EP @ CRL: annual, 2 rt chgs EP @ CRL: 6-month EP @ CRL: policy years EP @ CRL: law change	Pricing: Set 1 (05a) Pricing: Set 1 (05a) Solns	Pricing: Set 2 (05a) Pricing: Set 2 (05a) Solns
Pricing-05b	1-step premium trending 2-step premium trending premium development	Pricing: Set 1 (05b) Pricing: Set 1 (05b) Solns	Pricing: Set 2 (05b) Pricing: Set 2 (05b) Solns
Pricing-06	excess loss factor benefit change impact trend selection trend period (losses) leveraged effect of limits	Pricing: Set 1 (06) Pricing: Set 1 (06) Solns	Pricing: Set 2 (06) Pricing: Set 2 (06) Solns
Pricing-07-08	pure premium method all-variable expense method premium-based expense method exposure-based expense method loss ratio method	Pricing: Set 1 (07-08) Pricing: Set 1 (07-08) Solns	Pricing: Set 2 (07-08) Pricing: Set 2 (07-08) Solns
Pricing-09	relativities: pure premium method relativities: with credibility relativities: loss ratio method relativities: adjusted pure premium method relativities: detecting distortion	Pricing: Set 1 (09) Pricing: Set 1 (09) Solns	Pricing: Set 2 (09) Pricing: Set 2 (09) Solns
Pricing-11	ILFs: uncensored data ILFs: censored data deductible relativities: ground-up losses deductible relativities: net losses WC: premium discount WC: loss constant ITV: premium rate per $1,000 ITV: coninsurance	Pricing: Set 1 (11) Pricing: Set 1 (11) Solns	Pricing: Set 2 (11) Pricing: Set 2 (11) Solns
Pricing-12-13	C of C: Harwayne's method C of C: increased limits analysis C of C: lower limits analysis C of C: limits analysis lifetime value analysis	Pricing: Set 1 (12-13) Pricing: Set 1 (12-13) Solns	Pricing: Set 2 (12-13) Pricing: Set 2 (12-13) Solns
Pricing-14	additive expense fee extension of exposures AARD method A(Δ)ARD method limiting premium effect: non-base level limiting premium effect: base level	Pricing: Set 1 (14) Pricing: Set 1 (14) Solns	Pricing: Set 2 (14) Pricing: Set 2 (14) Solns
Pricing-15	experience modification: CGL experience modification: WC loss-rated composite rating large deductible policies retrospective rating	Pricing: Set 1 (15) Pricing: Set 1 (15) Solns	Pricing: Set 2 (15) Pricing: Set 2 (15) Solns
Pricing-App	HO indication : pure premium method WC indication: loss ratio method	Pricing: Set 1 (App) Pricing: Set 1 (App) Solns	Pricing: Set 2 (App) Pricing: Set 2 (App) Solns