Share
Explore BrainMass

NPV, IRR, MIRR

PRACTICE PROBLEMS

1.Project K has a cost of $52,125, its expected net cash inflows are $12,000 per year for 8 years, and its cost of capital is 12 percent. (Hint: Begin by constructing a time line.

A. What is the projected payback period (to the closest year)?
B. What is the project's discounted payback period?
C. What is the projected NPV?
D. What is the projected IRR?
E. What is the project's MIRR?

2.Your division is considering two investment projects, each of which requires an up-front expenditure of $15 million. Your estimate that the investments will produce the following net cash flows:

Year Project A Project B

1 5,000,000 20,000,000

2 10,000,000 10,000,000

3 20,000,000 6,000,000

What are the two projects net present value, assuming the cost of capital is 10 percent? 5 percent? 15 percent?

3.Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The project are independent. The cash outlay for the truck is 17,000, and that for the pully system is 22,430. The firm's cost of capital is 14 percent. After-tax cash flows, including depreciation, are as follows:

Year Truck Pully
1 5,100 7500
2 5,100 7500
3 5100 7500
4 5100 7500
5 5100 7500

Calculate the IRR, the NPV, and the MIRR for the project, and indicate the correct accept/reject decision for each.

4.Your company is considering two mutually exclusive projects. X and Y, whose costs and cash flows are shown below:

Year X Y
0 ($1,000) ($1,000)
1 100 1,000
2 300 100
3 400 50
4 700 50

The projects are equally risky, and their cost of capital is 12 percent. You must make a recommendation, and you must base it on the modified IRR (MIRR). What is the MIRR of the better project?

Solution Preview

PRACTICE PROBLEMS

1.Project K has a cost of $52,125, its expected net cash inflows are $12,000 per year for 8 years, and its cost of capital is 12 percent. (Hint: Begin by constructing a time line.)

Year
0 1 2 3 4 5 6 7 8
(52,125) 12,000 ------------------------------------------------12,000

The arrow line means that from year 1 to 8, there will be the net cash inflows of $12,000.

A. What is the projected payback period (to the closest year)?

Payback period = Incremental investment/cash flow per year
= $52,125/$12,000
= 4.34 years

B. What is the project's discounted payback period?

First, we need to find the discount net cash inflow for each year by using the cost of capital of 12%.

Discount factor = 1/(1 + k)n where k is the cost of capital while n is the period

Year Discount factor Net cash inflow Discounted cash inflow

1 0.8929 12,000 10,714.8
2 0.7972 12,000 9,566.4
3 0.7118 12,000 8,541.6
4 0.6355 12,000 7,626.0
5 0.5674 12,000 6,808.8
6 0.5066 12,000 6,079.2
7 0.4523 12,000 5,427.6
8 0.4039 12,000 4,846.8

Total 59,611.2

Discounted payback period = 6 + (2,788.2/5,427.6)
= 6.51 years

C. What is the projected NPV?

Find NPV by finding the present value of each cash flow, including both inflows and outflows, discounted at the project's cost of capital.

NPV = sum of CFt where CF is the cash flow
(1 + k)n k is the cost of capital
n is the period.

NPV = - 52,125 + 59,611.2 =7,486.2

D. What is the projected IRR?

The internal rate of return is defined as that discount rate which equates the present value of a project's expected cash inflows to the present value of the project's costs:

PV(Inflows) = PV(Investment costs), or the rate which forces the NPV to equal zero.

IRR = 16%

E. What is the project's MIRR?

While the internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR, the modified IRR assumes that all cash flows are reinvested at the firm's cost of capital. Then, we will find how much MIRR is

IRR = 16%

First, we need to find the future net cash inflow for each year by using the cost of capital of 12%.

Future discount factor = (1 + k)n where k is the cost of capital while n is the period

Year Discount factor Net cash inflow Discounted cash inflow

1 2.2107 12,000 26,528.4
2 1.9738 12,000 ...

Solution Summary

This solution is comprised of a detailed explanation to calculate what is the projected payback period (to the closest year), what is the project's discounted payback period, what is the projected NPV, what is the projected IRR, and what is the project's MIRR.

$2.19