What is the Present Value of the cash flow above if the discount rate is 19? Enter 01 for each interest rate and copy and paste your answer kere, Answer $886.20 Spreadsheet Solution with the Excel Wizard: Year Year 2 Year 3 Today 0.07 0 3 a Interest Rate b Time Cash Flow d Present Value 1 500 2 300 100 $1.81 1. Put the cursor on E65 and click the function wizard ). click financial, scroll down to NPV and click OK. is located on your standard menu bar. NPV is the Net Present value because some of the cash flows may be negative NPV is also for cash Bows that are not constant 2. The dialog box will appear. Enter E62 or 07 for the Rate and the range of cells containing the cash flows F61H64, for value 1. Click OK. Note: You can also enter each cash flow in a separate value box by pointing and clicking Using the NPV formula directly What is the Present Value of the cash flow above if the discount rate is 19? Enter 01 for each interest rate and copy and paste your answer kere, Answer $886.20 Spreadsheet Solution with the Excel Wizard: Year Year 2 Year 3 Today 0.07 0 3 a Interest Rate b Time Cash Flow d Present Value 1 500 2 300 100 $1.81 1. Put the cursor on E65 and click the function wizard ). click financial, scroll down to NPV and click OK. is located on your standard menu bar. NPV is the Net Present value because some of the cash flows may be negative NPV is also for cash Bows that are not constant 2. The dialog box will appear. Enter E62 or 07 for the Rate and the range of cells containing the cash flows F61H64, for value 1. Click OK. Note: You can also enter each cash flow in a separate value box by pointing and clicking Using the NPV formula directly