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
![6. [10 marks] Please refer to your Makeham Excel spreadsheet from](https://s3.amazonaws.com/si.experts.images/answers/2024/09/66da12356d5cf_54066da1234c6451.jpg)
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
Get step-by-step solutions from verified subject matter experts
