Jason is 25 years old and has a new job in Web development. He wants to make sure he is financially sound when he retires 30 year later. He plans to invest the same amount to a retirement account for next 30 years. Assume Jason invests the same amount of contribution at the beginning of each year given 8% annual interest rate. Suppose he wants to accumulate $2,000,000 when he retires. Construct a table that shows the balance of his retirement account for every year. After creating the table in the spreadsheet, find the amount of annual contribution to achieve $2,000,000 goal when he retires.

Please show step by step using the Excel function.

Answer rating: 100% (QA)

Jasons Retirement Savings Plan Step 1 Calculate the Future Value of an Ordinary Annuity We can use the FV function in Excel to calculate the future va... View the full answer