Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer in excel. Please consider the interest rate of 5%. Thank You Interest rate On 1st January 2001 an insurance company issued the following

image text in transcribedimage text in transcribed

Please answer in excel. Please consider the interest rate of 5%. Thank You

Interest rate On 1st January 2001 an insurance company issued the following policy to policyholders age 40 exact: - a 20 year without-profit endowment assurance with death benefit of $50,000 payable at the end of year of death; - level premiums are paid annually in advance for up to 20 years and payment will cease on the policyholder's death. The mortality rates and interest rate assumed are given in the worksheet named q1_data. The number of policies in existence at the start of each calendar year are also included in the worksheet named q1_data. The reduction in policyholders is entirely due to deaths. (i) Compute the mortality gains or losses in each calendar year. [13 minutes] (ii) Was the mortality assumption an accurate reflection of actual experience? Explain your answer. (No further calculations are needed.) [2 minutes] (iii) Explain why the mortality profit / loss experienced identified from this analysis contributed to the insurance company's expected profits or losses. (No further calculations are needed.) [2 minutes]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Walter B. Meigs, Robert F. Meigs, Mark Bettner, Ray Whittington

9th Edition

0070434360, 978-0070434363

More Books

Students also viewed these Accounting questions