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)

Due to the transition of CAS exams from paper/pencil to CBT for Fall 2020, I am creating problem sets in Excel and will provide links below. (Due to the compressed time frame and other events in 2020 and early 2021, I'm still working on these.)

BattleActs Reserving Problems: Excel Format

set	problem types	Version 01	Version 02	Version 03	Version 04
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-A-03 Reserving-A-03-Solns	Reserving-A-04 Reserving-A-04-Solns
Reserving-B	FS basic method COS formula method RBS method	Reserving-B-01 Reserving-B-01-Solns	Reserving-B-02 Reserving-B-02-Solns	Reserving-B-03 Reserving-B-03-Solns	Reserving-B-04 Reserving-B-04-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 PBS method case O/S hard method evaluation	Reserving-D-01 Reserving-D-01-Solns	Reserving-D-02 Reserving-D-02-Solns	Reserving-D-03 Reserving-D-03-Solns	Reserving-D-04 Reserving-D-04-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	Reserving-E-03 Reserving-E-03-Solns	Reserving-E-04 Reserving-E-04-Solns

BattleActs Pricing Problems: Excel Format

set	problem types	Version 01	Version 02
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 trending 2-step trending premium trend	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