An investment promises to pay $500 each year for 15 years. Calculate the future value of this annuity under the following circumstances: Annual payment at the end of each year Quarterly payment at the end of each quarter Monthly payment at the end of each month Daily payment at the end of each day Create an Excel spreadsheet and specify the variable "Annual interest rater in Cell A1 and your choice of the rate value in Cell B1. Create an Excel spreadsheet and specify the variable "Annual interest rater in Cell A1 and your choice of the rate value in Cell B1. In following rows, use the Excel function to calculate the future value of each of the above annuity in Column B and display the function used in Column C. If the number of payment per year isn, what is the Excel function used to calculate the future value of the annuity investment above? Draw a line chartin Excel showing the relationship between future value of this investment (Y-axis) and number of payment per year (X-axis). Let the Y-axis start from (minimum of Y-axis equal to) the value when n=1. What does the chart tell us