Difference between revisions of "Excel Practice Problems"
(→Excel Format Problems) |
(→Past Exams) |
||
(108 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
==Past Exams== | ==Past Exams== | ||
+ | <span id="BA6U_Practice_Exam"></span> | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 13: | Line 14: | ||
|| '''Excel Problems''' | || '''Excel Problems''' | ||
|| '''Examiner's Report''' | || '''Examiner's Report''' | ||
+ | |||
+ | |- | ||
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_Practice_1_Questions_(v11).xlsx <span style="color: white; font-size: 14px; background-color: red; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BattleActs 6U Practice Exam #1'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_Practice_1_Answers_(v11).xlsx BattleActs 6U Practice Exam #1 Answers]'' | ||
+ | |||
+ | |- style = "border-bottom: 2px solid;" | ||
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_Practice_2_Questions_(v09).xlsx <span style="color: white; font-size: 14px; background-color: red; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BattleActs 6U Practice Exam #2'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_Practice_2_Answers_(v09).xlsx BattleActs 6U Practice Exam #2 Answers]'' | ||
|- | |- | ||
− | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F. | + | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.19_v6.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2019.Fall'''</span>] |
|| ''[https://www.battleacts6us.ca/pdf/Exam_2019_2_final.pdf 2019.Fall Examiner's Report]'' | || ''[https://www.battleacts6us.ca/pdf/Exam_2019_2_final.pdf 2019.Fall Examiner's Report]'' | ||
Line 23: | Line 32: | ||
|- | |- | ||
− | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.18_( | + | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.18_(v6).xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2018.Fall'''</span>] |
|| ''[https://www.battleacts6us.ca/pdf/Exam_2018_2_final.pdf 2018.Fall Examiner's Report]'' | || ''[https://www.battleacts6us.ca/pdf/Exam_2018_2_final.pdf 2018.Fall Examiner's Report]'' | ||
− | |- | + | |- style = "border-bottom: 2px solid;" |
| [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.18.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2018.Spring'''</span>] | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.18.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2018.Spring'''</span>] | ||
|| ''[https://www.battleacts6us.ca/pdf/Exam_2018_1_final.pdf 2018.Spring Examiner's Report]'' | || ''[https://www.battleacts6us.ca/pdf/Exam_2018_1_final.pdf 2018.Spring Examiner's Report]'' | ||
Line 35: | Line 44: | ||
|- | |- | ||
− | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S. | + | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.17_v2.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2017.Spring'''</span>] |
|| ''[https://www.battleacts6us.ca/pdf/Exam_2017_1_final.pdf 2017.Spring Examiner's Report]'' | || ''[https://www.battleacts6us.ca/pdf/Exam_2017_1_final.pdf 2017.Spring Examiner's Report]'' | ||
− | | | + | |- |
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.16_v2.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2016.Fall'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2016_2_final.pdf 2016.Fall Examiner's Report]'' | ||
− | = | + | |- style = "border-bottom: 2px solid;" |
+ | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.16_v2.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2016.Spring'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2016_1_final.pdf 2016.Spring Examiner's Report]'' | ||
− | |||
|- | |- | ||
− | | | + | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.15_v01.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2015.Fall'''</span>] |
− | + | || ''[https://www.battleacts6us.ca/pdf/Exam_2015_2_final.pdf 2015.Fall Examiner's Report]'' | |
− | + | ||
− | + | |- | |
− | + | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.15_v01.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2015.Spring'''</span>] | |
− | + | || ''[https://www.battleacts6us.ca/pdf/Exam_2015_1_final.pdf 2015.Spring Examiner's Report]'' | |
+ | |||
+ | |- | ||
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.14.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2014.Fall'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2014_2_final.pdf 2014.Fall Examiner's Report]'' | ||
+ | |||
+ | |- style = "border-bottom: 2px solid;" | ||
+ | | [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.14_v01.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2014.Spring'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2014_1_final.pdf 2014.Spring Examiner's Report]'' | ||
+ | |||
+ | |- | ||
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.13_v01.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2013.Fall'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2013_2_final.pdf 2013.Fall Examiner's Report]'' | ||
+ | |||
+ | |- | ||
+ | |[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_F.12_v01.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6U: 2012.Fall'''</span>] | ||
+ | || ''[https://www.battleacts6us.ca/pdf/Exam_2012_2_final.pdf 2012.Fall Examiner's Report]'' | ||
+ | |||
|} | |} | ||
− | + | ==Excel Format Problems== | |
{| class='wikitable' | {| class='wikitable' | ||
Line 66: | Line 95: | ||
[https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_1_(v4)_(solutions).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;">'''IRIS Ratios: Set 1 (Solutions)'''</span>] | [https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_1_(v4)_(solutions).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;">'''IRIS Ratios: Set 1 (Solutions)'''</span>] | ||
− | || [https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_2_( | + | || [https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_2_(v5).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;">'''IRIS Ratios: Set 2'''</span>] |
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_2_( | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/IRIS_Ratios_2_(v5)_(solutions).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;">'''IRIS Ratios: Set 2 (Solutions)'''</span>] |
|- | |- | ||
Line 84: | Line 113: | ||
|| Overall RBC Ratio <br> RBC Charges <br> Calculate R<sub>1</sub> <br> Calculate R<sub>1</sub> & R<sub>2</sub> <br> Calculate R<sub>3</sub> <br> Calculate R<sub>4</sub> <br> Calculate R<sub>5</sub> <br> Calculate R<sub>cat</sub> | || Overall RBC Ratio <br> RBC Charges <br> Calculate R<sub>1</sub> <br> Calculate R<sub>1</sub> & R<sub>2</sub> <br> Calculate R<sub>3</sub> <br> Calculate R<sub>4</sub> <br> Calculate R<sub>5</sub> <br> Calculate R<sub>cat</sub> | ||
− | || [https://www.battleacts6us.ca/Excel/POWER_PACK/RBC_1_( | + | || [https://www.battleacts6us.ca/Excel/POWER_PACK/RBC_1_(v4).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;">'''RBC: Set 1'''</span>] |
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/RBC_1_( | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/RBC_1_(v4)_(solutions).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;">'''RBC: Set 1 (Solutions)'''</span>] |
|| | || | ||
Line 104: | Line 133: | ||
|| Ceded Reinsurance under GAAP & SAP <br> PDR under GAAP & SAP <br> SAP Admitted Assets <br> SAP Liabilities <br> ''SAP 10-K Exhibit'' <span style="color: red;">''← removed from Odomirok''</span> <br> GAAP Goodwill (cost-of-capital approach) | || Ceded Reinsurance under GAAP & SAP <br> PDR under GAAP & SAP <br> SAP Admitted Assets <br> SAP Liabilities <br> ''SAP 10-K Exhibit'' <span style="color: red;">''← removed from Odomirok''</span> <br> GAAP Goodwill (cost-of-capital approach) | ||
− | || [https://www.battleacts6us.ca/Excel/POWER_PACK/SAP_GAAP_1_( | + | || [https://www.battleacts6us.ca/Excel/POWER_PACK/SAP_GAAP_1_(v4).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;">'''SAP & GAAP: Set 1'''</span>] |
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/SAP_GAAP_1_( | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/SAP_GAAP_1_(v4)_(solutions).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;">'''SAP & GAAP: Set 1 (Solutions)'''</span>] |
|| | || | ||
Line 114: | Line 143: | ||
|| Net Investment Gain (ratio) <br> Net Investment Gain (value) <br> Net Investment Gain (using PPE ratio) <br> Surplus Allocation to LOB <br> Calculating FAIT & TIA <br> Profit/Loss | || Net Investment Gain (ratio) <br> Net Investment Gain (value) <br> Net Investment Gain (using PPE ratio) <br> Surplus Allocation to LOB <br> Calculating FAIT & TIA <br> Profit/Loss | ||
− | || [https://www.battleacts6us.ca/Excel/POWER_PACK/ | + | || [https://www.battleacts6us.ca/Excel/POWER_PACK/IEE_1_(v2).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;">'''Insurance Expense Exhibit: Set 1'''</span>] |
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/IEE_1_(solutions).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;">'''Insurance Expense Exhibit: Set 1 (Solutions)'''</span>] | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/IEE_1_(v2)_(solutions).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;">'''Insurance Expense Exhibit: Set 1 (Solutions)'''</span>] |
|| | || | ||
Line 126: | Line 155: | ||
|| [https://www.battleacts6us.ca/Excel/POWER_PACK/Schedule_F_1.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;">'''Schedule F: Set 1'''</span>] | || [https://www.battleacts6us.ca/Excel/POWER_PACK/Schedule_F_1.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;">'''Schedule F: Set 1'''</span>] | ||
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/ | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/Schedule_F_1_v2_(solutions).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;">'''Schedule F: Set 1 (Solutions)'''</span>] |
|| | || | ||
Line 157: | Line 186: | ||
[https://www.battleacts6us.ca/Excel/POWER_PACK/Taxes_1_(solutions).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;">'''Taxes: Set 1 (Solutions)'''</span>] | [https://www.battleacts6us.ca/Excel/POWER_PACK/Taxes_1_(solutions).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;">'''Taxes: Set 1 (Solutions)'''</span>] | ||
+ | |||
+ | || | ||
+ | |||
+ | |- | ||
+ | || [[AAA.UncollReins]] | ||
+ | || Estimating URR (Rating-Based Method) <br> Estimating URR (Experience-Based Method) | ||
+ | |||
+ | || [https://www.battleacts6us.ca/Excel/POWER_PACK/AAA_Uncoll-Reins_1.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;">'''Estimating URR: Set 1'''</span>] | ||
+ | |||
+ | [https://www.battleacts6us.ca/Excel/POWER_PACK/AAA_Uncoll-Reins_1_(solutions).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;">'''Estimating URR: Set 1 (Solutions)'''</span>] | ||
|| | || | ||
Line 174: | Line 213: | ||
|| Premium Margin to Offset Double-Taxation <br> Invested Capital (Liquidate or Continue Operations) <br> Bond Valuation <br> TRIA Loss-Sharing | || Premium Margin to Offset Double-Taxation <br> Invested Capital (Liquidate or Continue Operations) <br> Bond Valuation <br> TRIA Loss-Sharing | ||
− | || [https://www.battleacts6us.ca/Excel/POWER_PACK/ | + | || [https://www.battleacts6us.ca/Excel/POWER_PACK/Surplus_Bonds_1_(v4).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;">'''Surplus/Bonds/TRIA: Set 1'''</span>] |
− | [https://www.battleacts6us.ca/Excel/POWER_PACK/Surplus_Bonds_1_( | + | [https://www.battleacts6us.ca/Excel/POWER_PACK/Surplus_Bonds_1_(v4)_(solutions).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;">'''Surplus/Bonds/TRIA: Set 1 (Solutions)'''</span>] |
|| | || | ||
|} | |} | ||
+ | |||
+ | [[Videos]] |
Latest revision as of 12:46, 23 June 2024
Battleacts is here to help you prepare for not only the syllabus content but also the exam environment. Now that the CAS has moved to Computer Based Testing (CBT) with Pearson VUE we're providing Excel files which feel like the exam experience. As more information is made available about the testing experience we'll update the files accordingly.
For past exams: To get the most out of these files you should attempt each exam under timed conditions and then grade yourself carefully and harshly. The examiner's report is a great source of information about things the CAS didn't award credit for - read these carefully and relate them back to the question to avoid wasting time on BattleDay. You can also use the Exam Summaries wiki article to see individual questions and answers from the examiner's report.
Alice: "I've heard the F2 and F4 keys don't work in the Pearson environment. They do work in our Excel files but you've been warned for BattleDay!"
Past Exams
Excel Format Problems
Wiki Link | Problem Type | Set 1 | Set 2 |
---|---|---|---|
NAIC.IRIS | IRIS Ratios (Calculation & Acceptable Ranges) |
IRIS Ratios: Set 1 | IRIS Ratios: Set 2 |
Odomirok.15-P | Schedule P - Parts 2,3,4 (basic layout) Schedule P - Part 5 Schedule P - Parts 2,3,4 (updating) Schedule P - Intercompany Pooling |
Schedule P: Set 1 | |
Odomirok.19-RBC | Overall RBC Ratio RBC Charges Calculate R1 Calculate R1 & R2 Calculate R3 Calculate R4 Calculate R5 Calculate Rcat |
RBC: Set 1 | |
Odomirok.8-9-IS | Statutory Net Income (version 1) Policyholder's Surplus Statutory Net Income (version 2) |
Income Statement: Set 1 | |
Odomirok.22-23-GAAP | Ceded Reinsurance under GAAP & SAP PDR under GAAP & SAP SAP Admitted Assets SAP Liabilities SAP 10-K Exhibit ← removed from Odomirok GAAP Goodwill (cost-of-capital approach) |
SAP & GAAP: Set 1 | |
Odomirok.18-IEE | Net Investment Gain (ratio) Net Investment Gain (value) Net Investment Gain (using PPE ratio) Surplus Allocation to LOB Calculating FAIT & TIA Profit/Loss |
Insurance Expense Exhibit: Set 1 | |
Odomirok.14-F | Restating the Balance Sheet Provision for Reinsurance |
Schedule F: Set 1 | |
Klann.ReinsComm | Restating Triangles after Commutation Change in Taxable Income (easy) Change in Taxable Income (hard) Mutually Beneficial Commutation Price |
Klann - Reinsurance Commutations: Set 1 | |
Freihaut.Reins | 10-10 Rule for Testing Risk Transfer (4 problems) |
Freihaut (Risk Transfer): Set 1 | |
Odomirok.26-Taxes | Tax-Basis Income Income Tax BEAT Tax |
Taxes: Set 1 | |
AAA.UncollReins | Estimating URR (Rating-Based Method) Estimating URR (Experience-Based Method) |
Estimating URR: Set 1 | |
Odomirok.25-Solv2 | Solvency II Capital Requirements (4 problems) |
Solvency II: Set 1 | |
Feldblum.Surplus Odomirok.6-7-BS Webel.TRIA-2019 |
Premium Margin to Offset Double-Taxation Invested Capital (Liquidate or Continue Operations) Bond Valuation TRIA Loss-Sharing |
Surplus/Bonds/TRIA: Set 1 |