You will need time value a money function from chapter $10$

Requirements: Complete both requirements on a single worksheet.

Create a one$-$input Data Table that calculates the amount of money that you will have

saved at the end of $30$ years if you earn $8\%$ interest per year.

a$.$ Use the following annual end of the year annual savings amounts as the column

data in the Data Table: $$1,000,$$$2,000,$$$3,000,$$$4,000,$ and $$5,000.$

Create a two$-$input Data Table that calculates the amount of money that you will have

saved based on different numbers of years and earning different annual interest rates.

Assume that you save $$5,000$ at the end of each year.

a$.$ Use the following number of years as the row data in the Data Table: $10,20,30,$

and $40.$

b$.$ Use the following annual interest rates as the column data in the Data Table: $2\%,$

$4\%,6\%,8\%,$ and $10\%.$