In: Finance
5.1
a. Calculate the present value of your bequest of $100,000 in real dollars. (1 mark)
b. Determine the constant value of consumption that equates the value of your initial wealth on the right side of the equation with the total of consumption and your bequest.
Hint: To do this, you need to recognize that the equation contains an annuity for future consumption. The bequest is a single lump sum value, and the initial wealth is already stated at present value. The present value of labour income is zero.
Use this information to determine
i. the present value of consumption for all 20 years.
ii. use that value to determine the annual consumption for each of the 20 years. This part is very similar to the last question on Assignment 1.
Answer 5.a. For the PV of $100,000 we will use the formula
where FV= future value= $100,000, r= interest rate = 5%, and n=
number of years= 20
Substituting the values in the equation, we get
PV= $37,688.95
Answer 5.b.The constant annual consumption is the annuity. Thus to calculate the annuity we will have to use the EXCEL function of PMT. To use this just type =PMT and click on the PMT function from the drop down menu.
Now input rate=0.05, nper=20, PV=-1000000 and FV=100000
The PMT= $77,218.33
Thus the constant annual consumption of $77,218.33 can be made for 20 years and have a remainder of $100,000 at the end of the 20 years for kids. I am also attatching a before and after pic of the excel spreadsheet for calculating this