Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. [10 marks] Please refer to your Makeham Excel spreadsheet from your second assignment. Set up your own spreadsheet, similar to the new spreadsheet template

image text in transcribed

6. [10 marks] Please refer to your Makeham Excel spreadsheet from your second assignment. Set up your own spreadsheet, similar to the new spreadsheet template I have posted on LEARN. Try and keep the parameter values floating so that you can change these values for questions in the future, if necessary. For your sheet in this question, use the following parameters: A = 0.007, B = 0.0003, and c = 1.092, and a limiting age of 120. Assume that the effective rate of interest is 3% per year. [2 marks for each part, and 2 marks for submitting a printout of your spreadsheet] a. Construct a table of values for Ax for integer ages starting at x = 50. b. Construct values for A*) for x = 50,50.25, 50.5, (Do not use UDD for this.) C. From the information in part b., give the exact values for A60, A9o, Aft), and A Now, use the exact values for Ago and A9o to estimate A4 , and Amusing the UDD assumption. d. *** Please be sure to include a printout of your spreadsheet when you submit this question. 6. [10 marks] Please refer to your Makeham Excel spreadsheet from your second assignment. Set up your own spreadsheet, similar to the new spreadsheet template I have posted on LEARN. Try and keep the parameter values floating so that you can change these values for questions in the future, if necessary. For your sheet in this question, use the following parameters: A = 0.007, B = 0.0003, and c = 1.092, and a limiting age of 120. Assume that the effective rate of interest is 3% per year. [2 marks for each part, and 2 marks for submitting a printout of your spreadsheet] a. Construct a table of values for Ax for integer ages starting at x = 50. b. Construct values for A*) for x = 50,50.25, 50.5, (Do not use UDD for this.) C. From the information in part b., give the exact values for A60, A9o, Aft), and A Now, use the exact values for Ago and A9o to estimate A4 , and Amusing the UDD assumption. d. *** Please be sure to include a printout of your spreadsheet when you submit this

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

Understanding And Auditing IT Systems Volume 1

Authors: Young-Woon Min

2nd Edition

978-1257124084

More Books

Students also viewed these Accounting questions