Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started