Difference between revisions of "Excel Practice Problems"
Jump to navigation
Jump to search
(→BattleActs: Excel Format Pricing Problems) |
(→BattleActs: Excel Format Pricing Problems) |
||
| Line 102: | Line 102: | ||
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a)'''</span>] | || [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a)'''</span>] | ||
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a) Solns'''</span>] | [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a) Solns'''</span>] | ||
| − | || [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a)'''</span>] | + | || [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a)'''</span>] |
| − | [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set2) | + | [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a) Solns'''</span>] |
|- | |- | ||
Revision as of 13:39, 27 April 2021
Contents
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.
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: 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 methodReserving-A-01 Reserving-A-02 Reserving-B FS basic method
case OS formula method
reported Berq-Sherm methodReserving-B-01 Reserving-B-02 Reserving-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
paid Berq-Sherm method
case O/S hard method
evaluationReserving-D-01 Reserving-D-02 Reserving-E S/S multiplicative
reinsurance net unpaid
ALAE additive/mult.
ULAE - classical/Kittel
ULAE - Conger/NolibosReserving-E-01 Reserving-E-02
BattleActs: Excel Format Pricing Problems
chapter problem types Set 1 Set 2 Pricing-01-03-04 basic formulas
AY & CY losses
exposure aggregationPricing: Set 1 (01-03-04) Pricing: Set 2 (01-03-04) 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 changePricing: Set 1 (05a) Pricing: Set 2 (05a) Pricing-05b 1-step premium trending
2-step premium trending
premium developmentPricing: Set 1 (05b) Pricing: Set 2 (05b) Pricing-06 excess loss factor
benefit change impact
trend selection
trend period (losses)
leveraged effect of limitsPricing: Set 1 (06) Pricing: Set 2 (06) Pricing-07-08 pure premium method
all-variable expense method
premium-based expense method
exposure-based expense method
loss ratio methodPricing: Set 1 (07-08) Pricing: Set 2 (07-08) Pricing-09 relativities: pure premium method
relativities: with credibility
relativities: loss ratio method
relativities: adjusted pure premium method
relativities: detecting distortionPricing: Set 1 (09) Pricing: Set 2 (09) 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: coninsurancePricing: Set 1 (11) Pricing: Set 2 (11) 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 analysisPricing: Set 1 (12-13) Pricing: Set 2 (12-13) Pricing-14 additive expense fee
extension of exposures
AARD method
A(Δ)ARD method
limiting premium effect: non-base level
limiting premium effect: base levelPricing: Set 1 (14) Pricing: Set 2 (14) Pricing-15 experience modification: CGL
experience modification: WC
loss-rated composite rating
large deductible policies
retrospective ratingPricing: Set 1 (15) Pricing: Set 2 (15) Pricing-App HO indication : pure premium method
WC indication: loss ratio methodPricing: Set 1 (App) Pricing: Set 2 (App)
