Difference between revisions of "Excel Practice Problems"

From BattleActs
Jump to navigation Jump to search
(→‎Past Exams)
(→‎Past Exams)
 
(61 intermediate revisions by the same user not shown)
Line 7: Line 7:
  
 
==Past Exams==
 
==Past Exams==
−
 
−
The BattleActs Mug Challenge described in the section below applies to this new BattleActs practice exam also (published Oct 3, 2021).
 
−
 
−
* <u>MUG</u> Winner: '''LHD''' &#128522; October 20, 2021 (#22)
 
−
* <u>MUG</u> Winner: '''STS''' &#128512; October 23, 2021 (#14, #15)
 
−
* <u>MUG</u> Winner: '''SM''' &#128541; October 23, 2021 (#7, #25)
 
−
* <u>shout-out!</u>: '''TC''' &#128527; April 28, 2022 (#17)
 
−
* <u>shout-out!</u>: '''AT''' &#128539; May 2, 2022 (2018.Fall #16, #17)
 
−
* <u>shout-out!</u>: '''humbertov''' &#128512; Sep 2, 2022 (2016.Spring #15)
 
  
 
<span id="BA6U_Practice_Exam"></span>
 
<span id="BA6U_Practice_Exam"></span>
Line 25: Line 16:
  
 
|-
 
|-
−
|[https://www.battleacts6us.ca/Excel/CBT_Exam_6u_Practice_1_Questions_(v5).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_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_(v8).xlsx BattleActs 6U Practice Exam #1 Answers]''
+
|| ''[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.19.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/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 40: Line 35:
 
|| ''[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 49: Line 44:
  
 
|-
 
|-
−
| [https://www.battleacts6us.ca/Excel/CBT_Exam_6u_S.17.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/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.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/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]''
 
|| ''[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/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/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]''
  
−
==Excel Format Problems==
+
|-
 +
|[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]''
  
−
{| class='wikitable' style='background-color: peachpuff; width: 1050px;'
 
−
|-
 
−
|| <span style="color: black;">'''BattleActs Coffee Mug Challenge!'''</span> &nbsp; Good ol' reliable ''[https://www.battleacts6us.ca/images/alice.jpg Alice-the-Actuary]'' has double-checked her calculations but if you find a calculation error that slipped past her, please let her know at <span style="color: blue;">info@battleacts.ca</span> and we'll send you a BattleActs coffee mug, or a BattleActs sticker if your cupboard is already overflowing with coffe mugs! (Typos get a shout-out.)
 
−
* shout-out to '''mdl''' &#128512; July 24, 2021 (Feldblum.Surplus)
 
−
* <u>MUG</u> Winner: '''FH''' &#128522; August 1, 2021 (NAIC.IRIS)
 
−
* shout-out to '''luo''' &#128527; August 9, 2021 (broken link to Odomirok.8-9-IS)
 
−
* shout-out to '''js''' &#128579; September 3, 2021 (#DIV/0! errors in Odomirok.19-RBC R1 tab.)
 
−
* <u>MUG</u> Winner: '''jcam''' &#127774; September 26, 2021 (Klann.Reins)
 
−
* <u>MUG</u> Winner: '''ME''' &#128518; October 16, 2021 (Odomirok.22-23-GAAP)
 
−
* shout-out to '''KR''' &#128540; March 14, 2022 (grammar mistake!)
 
−
* shout-out to '''NK''' &#129312; May 1, 2022 (unclear wording in Odomirok.19-RBC R4 tab)
 
 
|}
 
|}
  
−
: [[File: mug.png | 200px]]
+
==Excel Format Problems==
  
 
{| class='wikitable'
 
{| class='wikitable'
Line 129: 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;">''&larr; 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;">''&larr; removed from Odomirok''</span> <br> GAAP Goodwill (cost-of-capital approach)
  
−
|| [https://www.battleacts6us.ca/Excel/POWER_PACK/SAP_GAAP_1_(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;">'''SAP & GAAP: Set 1'''</span>]
+
|| [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_(v3)_(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>]
+
[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 139: 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/IEE_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;">'''Insurance Expense Exhibit: Set 1'''</span>]
+
|| [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 182: 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 199: 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/Surplus_Bonds_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;">'''Surplus/Bonds/TRIA: Set 1'''</span>]
+
|| [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_(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;">'''Surplus/Bonds/TRIA: Set 1 (Solutions)'''</span>]   
+
[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 Problems Examiner's Report
BattleActs 6U Practice Exam #1 BattleActs 6U Practice Exam #1 Answers
BattleActs 6U Practice Exam #2 BattleActs 6U Practice Exam #2 Answers
Exam 6U: 2019.Fall 2019.Fall Examiner's Report
Exam 6U: 2019.Spring 2019.Spring Examiner's Report
Exam 6U: 2018.Fall 2018.Fall Examiner's Report
Exam 6U: 2018.Spring 2018.Spring Examiner's Report
Exam 6U: 2017.Fall 2017.Fall Examiner's Report
Exam 6U: 2017.Spring 2017.Spring Examiner's Report
Exam 6U: 2016.Fall 2016.Fall Examiner's Report
Exam 6U: 2016.Spring 2016.Spring Examiner's Report
Exam 6U: 2015.Fall 2015.Fall Examiner's Report
Exam 6U: 2015.Spring 2015.Spring Examiner's Report
Exam 6U: 2014.Fall 2014.Fall Examiner's Report
Exam 6U: 2014.Spring 2014.Spring Examiner's Report
Exam 6U: 2013.Fall 2013.Fall Examiner's Report
Exam 6U: 2012.Fall 2012.Fall Examiner's Report

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 1 (Solutions)

IRIS Ratios: Set 2

IRIS Ratios: Set 2 (Solutions)

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

Schedule P: Set 1 (Solutions)

Odomirok.19-RBC Overall RBC Ratio
RBC Charges
Calculate R1
Calculate R1 & R2
Calculate R3
Calculate R4
Calculate R5
Calculate Rcat 		RBC: Set 1

RBC: Set 1 (Solutions)

Odomirok.8-9-IS Statutory Net Income (version 1)
Policyholder's Surplus
Statutory Net Income (version 2) 		Income Statement: Set 1

Income Statement: Set 1 (Solutions)

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

SAP & GAAP: Set 1 (Solutions)

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

Insurance Expense Exhibit: Set 1 (Solutions)

Odomirok.14-F Restating the Balance Sheet
Provision for Reinsurance 		Schedule F: Set 1

Schedule F: Set 1 (Solutions)

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

Klann - Reinsurance Commutations: Set 1 (Solutions)

Freihaut.Reins 10-10 Rule for Testing Risk Transfer
(4 problems) 		Freihaut (Risk Transfer): Set 1

Freihaut (Risk Transfer): Set 1 (Solutions)

Odomirok.26-Taxes Tax-Basis Income
Income Tax
BEAT Tax 		Taxes: Set 1

Taxes: Set 1 (Solutions)

AAA.UncollReins Estimating URR (Rating-Based Method)
Estimating URR (Experience-Based Method) 		Estimating URR: Set 1

Estimating URR: Set 1 (Solutions)

Odomirok.25-Solv2 Solvency II Capital Requirements
(4 problems) 		Solvency II: Set 1

Solvency II: Set 1 (Solutions)

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

Surplus/Bonds/TRIA: Set 1 (Solutions)

Videos

Retrieved from "https://battleacts6us.ca/wiki6us/index.php?title=Excel_Practice_Problems&oldid=7840"