USING THE FOLLOWING INPUT NUMBERS ONLY USE EXCEL FUNCTIONS AND COMPLETE THE TABLE.

ANALYZING CASH FLOWS Calculate NPV and IRR for a number of cash flow series Blue cells are input cells and green cells are where your calculations should go. Don't hardcode any numbers, always refer back to input cells! Initial investment $10,000 $3,000 Annual cash flow occuring for the next 5 years, at the end of each year Discount rate 11% Build out the cash flow stream and calculate NPV and IRR with the appropriate Excel formulas 0 refer to assumptions above to build out the cash flow stream 1 2 3 m. 4 5 NPV calculate NPV with the appropriate Excel function calculate IRR with the appropriate Excel function IRR Build out the cash flow stream assuming cash flows occur quarterly 0 1 2 Nm 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 NPV calculate NPV with the appropriate Excel function calculate IRR with the appropriate Excel function IRR