The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit your spreadsheet through D2L, and I will check your work by changing one of the input values for each formula to see if your spreadsheet calculates the correct answer. Note that interest rates in Excel are entered in decimal form, not as a percent as with the TI calculator. For example, in Excel 9.5% is entered in a cell as 0.095. Also, the type variable for each formula defines when the cash flows occur. Setting type equal to 0 means the cash flows occur at the end of each period. Setting type equal to 1 means the cash flows occur at the beginning of each period.

A B C Present value Rate 0.11 3 Nper 8 4 PMT 10 5 FV 100 6 Type 0 7 PV -94.85 8 9 Number of periods 10 Rate 0.11 11 PMT 10 12 PV -94.85 13 FV 100 14 Type 0 15 Nper 8.01 16 17 Payment 18 Rate 0.11 19 Nper 8 20 PV -94.85 21 FV 100 22 Type 0 23 PMT 10.00 24 25 Interest rate 26 Nper 27 PMT 10 28 PV -94.85 29 FV 100 30 Type 0 31 Rate 0.11 32 33 Future value 34 Rate 0.11 35 Nper 8 36 PMT 10 37 PV -94.85 38 Type 0 39 FV 99.99 40 41 Net present value 42 Rate 0.11 43 Value 1 100 Value 2 200 45 Value 3 300 46 Value 4 400 47 Value 5 500 48 NPV 1031.99 What is the annual risk-free interest rate, if the re premium is 0 6% per year the inflation premium