IRR Answer Options: IRR (B2:B6) , XIRR (B2,B3,B4,B5,B6) , MIRR (B2:B6) , IRR (b3:B6)

MIRR Answer Options: MIRR( B4:B8, B2,B3) , MIRR (B2:B8) , IRR (B4:B8, B3, B2) , IRR(B2,B6)

Consider the data from a possible project that you are evaluating and calculate the project's NPV: (Hint: Round all calculations to two decimal places. Also, be sure to enter a minus sign if the answer is negative.) B 1 Data Description 2 Annual Discount Rate 8% 3 Initial Investment cost - $5,000 $3,000 4 Cash inflow from year 1 5 Cash inflow from year 2 $3,500 6 Cash inflow from year 3 $3,250 7 8 Net Present Value = NPV(B2, B4, B5, B6) + B3 9 IMPORTANT NOTE: The NPV function in Excel does not include the initial investment value in its arguments. You have to manually add this value to your calculations to derive the correct value. Since the initial investment is a cash outflow the NPV calculation would involve adding a negative value. Some other commonly used capital budgeting techniques are the IRR and the MIRR methods. You will learn more about them during your finance course. For the purpose of this module you should be able to understand how Excel functions can be used to calculate the values. For MIRR calculations use 4% as the rate at which the investment is financed and assume that the cash flows from the project can be reinvested at the rate of 5%. (Hint: Round all calculations to two decimal places.) A B 1 Data Description 2 Initial Investment cost - $2,000 3 Cash inflow from year 1 $600 4 Cash inflow from year 2 $500 5 Cash inflow from year 3 $800 6 Cash inflow from year 4 $1,000 7 8 IRR 9 % 10 B 1 Data Description 2 Finance rate 4% 3 Reinvestment rate 5% 4 Initial Investment cost - $2,000 5 Cash inflow from year 1 $600 6 Cash inflow from year 2 $500 7 Cash inflow from year 3 $800 8 Cash inflow from year 4 $1,000 9 MIRR 10 %