CHAPTER 8 - EXCEL EXERCISE You can use the function capability in excel to help solve for NPV, IRR and MIRR Using these functions solve for the highlighted sections in the charts below. Single Lum Sum Problems Yearly Project Cash Flows Project O (3400,000) 350.000 B (550,000) ($20,000) (5250,000) 145,000 D (30,000) $1,000 (355,000) 35.000 560,000 $25,000 6000 525.000 370.000 $25,000 $55,000 $2,000 35,000 300.000 $25,000 165,000 12,000 35,000 50.000 325.000 3100,000 32.000 35.000 RATE SOX 10.0% 3.6% 7.6% 15.09% $2,000 350,000 $2.000 For NPV you have to manually add in year o seperatly. As you can see I use the function for NPV and then adda + at the end and include year o The MIRR is going to ask you for both a Finance and a Reinvestment rate. For this exercise we will just use the rate in the table above for both Project NPV 1545,746) IRR 1.39% MIRR 200 B MOO Click on the Function button in excel and select what you are trying to solve for (NPV, IRR, MIRR)