apital Budgeting Discount Rate 6% et Present Value using a Time Line eriod ash flowS 321 534 $40 533 $17 Calculate the PV of the individual cash flows Present Value of Each Cash Flow let Present Value using the algebraic method. The value in the yellow cell will calculate on its own. Treat each value in row 7 as if it was a single cash flow Net Prosent Value using the NPV Function Enter the NPV function. Be sure to properly Net Present Value Internal Rate of Return using the IRR Function Internal Rate of Return Enter the IRR function Modified Internal Rato of Return Period 540 534 533 17 23 Calculate the future value of the individual cash flows using the algebraic method. The value in the yellow cell will calculate on its own Treat each value in row 19 as it was a single cash Cash flows Future Value of Each Cash Flow Terminal Value Internal Rate of Return using the IRR Function Internal Rate of Return Enter the IRR function. Modified Internal Rate of Return Period 19 Cash flows Future Value of Each Cash Flow $17 $21 $34 $40 $33 Terminal Value $0.00 23 Modified Internal Rate of Return Calculate the MIRR using the RATE function with nper 5, pvs- 1 100, and fv-terminal value. Note pmt.