Excel Practice Problems
Jump to navigation
Jump to search
These are the 3 most recent published exams for CAS Exam 5 in Excel. See examiner's reports for solutions. You can download the examiner's report from the CAS website or use the Exam Summaries wiki article.
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.)
The TBE exams from 2018.Spring:
BattleActs Practice Problems in Excel Format:
set problem types Version 01 Version 02 Version 03 Version 04 Reserving-A building triangles
development method
ECR method
BF method
CC methodReserving-A-01 Reserving-A-02 Reserving-A-03
Reserving-A-03-SolnsReserving-A-04
Reserving-A-04-SolnsReserving-B FS basic method
COS formula method
RBS methodReserving-B-01 Reserving-B-02 Reserving-B-03
Reserving-B-03-SolnsReserving-B-04
Reserving-B-04-SolnsReserving-C building triangles
development method
BF method (tort reform)
CC method (adjs)Reserving-C-01 Reserving-C-02 Reserving-C-03 Reserving-C-04 Reserving-D disposal rate method
PBS method
case O/S hard method
evaluationReserving-D-01 Reserving-D-02 Reserving-D-03
Reserving-D-03-SolnsReserving-D-04
Reserving-D-04-SolnsReserving-E S/S multiplicative
reinsurance net unpaid
ALAE additive/mult.
ULAE - classical/Kittel
ULAE - Conger/NolibosReserving-E-01 Reserving-E-02 Reserving-E-03
Reserving-E-03-SolnsReserving-E-04
Reserving-E-04-Solns
Excel Pricing Problems: Coming in January 2021. Until then, you can find Excel pricing problems in the 2018.Spring TBE exams at the top of this page.
