Question

1. You want $6,000 per month in your retirement. You expect to retire 40 years from today. At the time you retire, you want the payments to be at the beginning of the month and want them to last 30 years or 360 months. You expect an annual interest rate of 5% during retirement. You need to save to obtain this retirement. How much per month at the end of each month do you need to save for the next 480 months in order to obtain the money needed for retirement? During your saving period you expect to earn 8% annually. Select the best answer.

$268 per month

$321 per month

$817 per month

$1,242 per month

$1,561 per month

2. What is the present value of $1,800 per year, at a discount rate of 14 percent if the first payment is received 6 years from now and the last payment is received 30 years from now?

Group of answer choices

$6,199.74

$6,238.87

$6,333.33

$6,425.25

$6,511.08

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

A В C D 1 $6,000.00 2 1 Monthly withdrawal during retirement No. of withdrawal Monthly interest rate Value of withdrawal on retirement date 3 360 4 0.4167% $1,122,346.74 6 No. of monthly saving monthly interest rate for saving 7 480 8 0.6667% $321 Saving per month 9 10 11 2 Annual pament No. of payment from 6th to 30th year Discount rate Value of Payment at end of 5th year 12 1800 13 25 14 14% $12,371.27 15 16 $6,425.25 Present value of Payment 17 18 19 LC

Cell reference -

А В 1 2 1 Monthly withdrawal during retirement 6000 No. of withdrawal Monthly interest rate Value of withdrawal on retirement date 360 =5%/12 | ЕPV(C4,С3,-С2, 1) 4 6 No. of monthly saving monthly interest rate for saving 480 -8% /12 |-РMT(С8,С7,-С5,0) 7 8 Saving per month 9 10 11 Annual payment No. of payment from 6th to 30th year 1800 12 2 13 25 0.14 14 Discount rate Value of Payment at end of 5th year =PV(C14,C13,-C12,0) 15 16 -C15/(1+с14)л5 Present value of Payment 17 18 19 20 Lr LC

Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.