Part C:

Requirements: Complete both requirement 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 the you can earn $7\%$ 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,$$$3,500,$$$4,000,$$$5,000,$$$6,000,$ and $$7,000.$

Create a two$-$input Data Table that calculates the amount of money that you will have saved based on working for a different number of years and earning different annual interest rates. Assume that you save $$5,000$ at the end of each year.

a$.$ Use the following annual interest rates as the column data in the Data Table: $2\%,4\%,5\%,8\%,10\%,$ and $12\%.$

b$.$ Use the following number of years as the row data in the Data Table: $20,25,30,35,$ and $40.$