USING ONLY EXCEL FUNCTIONS SOLVE THE FOLLOWING EXCEL 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! 0 1 2 3 4 5 6 7 8 9 10 4000 4000 6000 2000 2000 2000 2000 1000 1000 Project 1 Project 2 Project 3 6000 8000 8000 -5000 8000 2000 2000 1000 1000 ($20,000) ($30,000) ($40,000) ($50,000) ($60,000) $6,000 $4,000 $5,000 $8,000 $15,000 5000 5000 5000 5000 5000 5000 5000 5000 5000 Project 4 8000 8000 8000 8000 8000 8000 8000 8000 8000 Project 5 10000 7000 -2000 10000 12000 4000 4000 4000 1000 Discount rate 6% NPV IRR Project 1 calculate NPV and IRR with the appropriate Excel function Project 2 Project 3 Project 4 Project 5