Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
| Line 49: | Line 49: | ||
||Reserving-D-03 <br> Reserving-D-03-Solns | ||Reserving-D-03 <br> Reserving-D-03-Solns | ||
||Reserving-D-04 <br> Reserving-D-04-Solns | ||Reserving-D-04 <br> Reserving-D-04-Solns | ||
| + | |||
| + | |- | ||
| + | || '''Reserving-E''' | ||
| + | || S/S multiplicative <br> reinsurance net unpaid <br> ALAE additive/mult. <br> ULAE - classical/Kittel <br> ULAE - Congor/Nolibos | ||
| + | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_problems.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01'''</span>] | ||
| + | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01-Solns'''</span>] | ||
| + | || [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-02_problems.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-02'''</span>] | ||
| + | [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-02-Solns'''</span>] | ||
| + | ||Reserving-E-03 <br> Reserving-E-03-Solns | ||
| + | ||Reserving-E-04 <br> Reserving-E-04-Solns | ||
|} | |} | ||
Revision as of 20:05, 26 August 2020
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 short notice about CBT, I'm still working on these.)
The TBE exams from 2018.Spring will also be posted here.
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 - Congor/NolibosReserving-E-01 Reserving-E-02 Reserving-E-03
Reserving-E-03-SolnsReserving-E-04
Reserving-E-04-Solns
