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