PLEASE SHOW HOW TO DO THIS IN EXCEL

In each part, you will create an Excel table that will verify the article's claims

If 20-year-old Britney makes a one-time $5,000 contribution to her Roth IRA and earns an average, 8% annual return, and if she never touches the money, that $5,000 will grow to almost $160,000 by the time she retires at age 65. Create a table with rows for ages 20 - 65 that verifies this claim. Find the sum of the earned interest.

	Amount
Age	in Account	Interest
20
21

But if she waits until shes my age (39) to make her single investment, that $5,000 would only grow to approximately $37,000. Create a table with rows for ages 39 - 65 that verifies this claim. Find the sum of the earned interest. Compare the results with Part 1 and summarize the consequences of waiting until age 39.

	Amount
Age	in Account	Interest
39
40

Compounding can be made more powerful through regular investments. Its great that a single $5,000 IRA contribution can grow to almost $160,000 in 45 years, but its even more exciting to see what happens when Britney makes saving a habit. If she contributes $5,000 annually to her Roth IRA for 45 years, and if she leaves the money to earn an average 8% return, her retirement savings will total over $1.93 million. Create a table with rows for ages 20 - 65 that verifies this claim. Calculate the total earned interest.

	Amount
AGE	in Account	INTEREST
20
21

If Britney makes $5,000 annual contributions to her Roth IRA, and she earns an 8% return, shell have approximately $2 million saved for retirement. What are the consequences of waiting five years to begin this investment? Create a table with rows for ages 25 - 65 that verifies this claim. Calculate the total earned interest. Compare the results with Part 3 and summarize the consequences of waiting 5 years to begin this savings.

	Amount
Age	in Account	Interest
25
26