Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
| Line 89: | Line 89: | ||
|| basic formulas <br> AY & CY losses <br> exposure aggregation | || basic formulas <br> AY & CY losses <br> exposure aggregation | ||
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04)'''</span>] | || [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04)'''</span>] | ||
| − | [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: | + | [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: orange; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04) Solns'''</span>] |
|| Pricing: Set 2 (01-03-04) <br> Pricing: Set 2 (01-03-04) Solns | || Pricing: Set 2 (01-03-04) <br> Pricing: Set 2 (01-03-04) Solns | ||
|} | |} | ||
Revision as of 19:45, 12 February 2021
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.
These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:
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 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
set problem types Version 01 Version 02 Pricing-01-03-04 basic formulas
AY & CY losses
exposure aggregationPricing: Set 1 (01-03-04) Pricing: Set 2 (01-03-04)
Pricing: Set 2 (01-03-04) Solns
