Please show answer using excel format

1. Calculate the present value Present Value and Interest Rates Excel HOME INSERT PAGE LAYOUT FORMULAS DATA Sign In Calibri 11A A 1 u . tu. Alignment Number Conditional Format as. Cell. Cells Editing Formatting Table Styles- Clipboard A1 What is the relationship between the value of an annuity and the level of interest rates? Suppose you just bought a 20-year annuity of $7,500 per year at the current interest rate of 10 percent per year. What happens to the value of your investment if interest rates suddenly drop to 5 percent? What if interest rates suddenly rise to 15 percent? 4 # of years Annuity payment per year Interest rate Interest rate Interest rate 20 7,500 10% 5% 15% $ 10 13 Complete the following analysis. Do not hard code values in your answers All answers should be positive values 14 15 16 17 18 19 20 21 Value of investment at 10% Value of investment at 5% Value of investment at 15% Sheet1 100%