Excel Financial Formula Project 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. C 0.11 Rate Nper PMT 8 10 100 0 -94.85 0.11 10 -94.85 100 0 8.01 B 1 Present value 2 3 4 5 FV 6 Type 7 PV 8 9 Number of periods 10 Rate 11 PMT 12 PV 13 FV 14 Type 15 Nper 16 17 Payment 18 Rate 19 Nper 20 PV 21 FV 22 Type 23 PMT 24 25 Interest rate 26 Nper 27 PMT 28 PV 29 FV 30 31 Rate 32 33 Future value 34 35 Nper 36 |PMT 37 PV 38 Type 39 FV 40 41 Net present value 42 Rate 43 Value 1 44 Value 2 Value 3 46 Value 4 47 Value 5 48 INRV 0.11 8. -94.85 100 0 10.00 8 10 -94.85 100 0 0.11 Type Rate 0.11 8 10 -94.85 0 99.99 0.11 100 200 300 400 500 1031.991