Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please answer in excel. please consider the intere

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

50.1K

Verified Solution

Question

Accounting

imageimage

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]

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

Compute the future value of: An initial $2,000 compounded annually for 10 years at 8% An initial $2,000...

Physics
1.2K views

A pressure P absolute temperature T diagram was obtained when a given mass of gas...

Physics
1.2K views

8 A steel rod of length 1 m is heated from 25 to 75 C...

Geometry
1.2K views

15 A die was rolled 40 times The results of each roll is given in...

Calculus
1.2K views

points possible graded For the given function f evaluate f 3 f 2 f 1...

Algebra
1.2K views

Determine if the given number belongs to the set Whole 1 78778777 Natural Integers Rational...

Accounting
1.2K views

When all authorized shares of stock have the same rights and characteristics, the stock is...

Accounting
1.2K views

Fisk Corporation is trying to improve its inventory control system and has installed an online...

Accounting
1.2K views

Renetwee the negalintuon 18 What is the maxnum price Zua Motoes induitues would be willing...

Accounting
1.2K views

Se declara un pasivo por pensiones cuando: A.. la obligacin por beneficios proyectada...

Accounting
1.2K views

Factory labor data for Dieker Company is given. During January, time tickets show that the...

Accounting
1.2K views

Andretti Company has a single product called a Dak. The company normally produces and sells...