1.

Create an Excel Table and chart.The inputs will be an interest rate and an initial deposit amount.The output of the chart will be the future value of the deposit on the y-axis and the number of years into the future on the x-axis.Your chart should show the future value (a separate line for each) of the future value if the interest rate is compounded:

Annually

Semi-annually

Quarterly

Monthly

Weekly

Daily

2.

Create an Excel sheet to calculate the Present Value of an Annuity that your rich aunt bequeathed to you in a trust fund.The output will be the Present Value of the Annuity.Assume that the first payment begins in exactly one year and that the payments are annual.The inputs will be:

The interest rate (compounded annually)

The growth rate of the payments (compounded annually)

The amount of the first payment

The number of years that the payments will occur for