In: Finance
20. Assume that you just graduate and get a job. You will work for 40 years and save each year before you retire. During retirement you plan to receive a pension annuity of $100,000 each year for another 40 years. How much money will you need to have at the moment you retire? How much money do you need to save every year before retirement? Assume the interest rate is always 8%. Before retirement, you deposit your saving at the end of each year. During retirement, you receive the annuity at the beginning of each year.
Please using excel function to solve this
rate, nper, pmt, pv, fv
Hence, Amount required after 40 years was $1,192,461.33
Hence, Deposit for each of the next 40 years was $4,603.09