Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

The director of capital budgeting for a firm has identified two mutually exclusi

ID: 2629695 • Letter: T

Question

The director of capital budgeting for a firm has identified two mutually exclusive projects, A and B, with the following expected net cash flows: Expected Net Cash Flows Year Project A Project B 0 ($120) ($120) 1 80 20 2 60 70 3 30 90 Both of the projects have a cost of capital of 14 percent. (i) What is Project A's and Project Bs net present value (NPV)? (4 points) NPV for A = ____________________. NPV for B = ____________________. (ii) What is the profitability index (PI) for Project B? (3 points) Profitability Index for B = ____________________. (iii) What is the modified internal rate of return for Project A? (3 points) MIRR for Project A = ____________________.

Explanation / Answer

Hi,

Please find the detailed answer as follows:

Part A: NPV

NPV = -Initial Investment + Present Value of Cash Inflows

NPV (Project A) = -120 + 80/(1+.14)^1 + 60/(1+.14)^2 + 30/(1+.14)^3 = $16.592 or $16.59

NPV (Project B) = -120 + 20/(1+.14)^1 + 70/(1+.14)^2 + 90/(1+.14)^3 = $12.154 or $12.15

---------

Part B: Profitability Index

Profitability Index = Present Value of Cash Inflows/Initial Investment

Present Value of Cash Inflows (Project B) = 20/(1+.14)^1 + 70/(1+.14)^2 + 90/(1+.14)^3 = 132.154

Profitablity Index (Project B) = 132.154/120 = 1.101 or 1.10

-----------

Part C: MIRR

MIRR = (Cash Flows/Values,finance_rate,reinvest_rate)

MIRR (Project A) = (-120,80,60,30,0,14%) = 19.029% or 19.03%

Thanks.