Question

Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $6,100,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:
Sales $ 5,400,000

Variable expenses 2,400,000

Contribution margin 3,000,000

Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs $900,000

Depreciation 1,220,000

Total fixed expenses 2,120,000

Net operating income $ 880,000

Required: 1. What is the project’s net present value? (Round discount factor(s) to 3 decimal places.)

2. What is the project’s internal rate of return to the nearest whole percent?

3. What is the project’s simple rate of return? (Round percentage answer to 1 decimal place. i.e. 0.123 should be considered as 12.3%.)

Answer 1

Answer:

NPV: $180,285.49

IRR: 21.336%

simple rate of return: 72.13%

Explanation:

6,100,000 investment

contribution margin 3,000,000

fixed expense:           900,000  

EBITA                         2,100,000

We will calculate the NPV without the depreciation, as the depreciation is the distribution of the investment cost over the project life.

If we include the depreciation we will be counting the investment amount twice. Entirely at Time 0  and then subtracting on each cash inflow.

We will calculate the NPV at 20% as is the company's discount rate. Even if the current division returns are in 24% as the company accepts project which yields 20%.

$C \times \frac{1-(1+r)^{-time} }{rate} = PV$

C 2,100,000

time 5 years

rate 20% = 20/100 = 0.2

$2100000 \times \frac{1-(1+0.2)^{-5} }{0.2} = PV$

PV $6,280,285.49

NPV = PV of cash inflow - investment

6,280,285.49 - 6,100,000 = 180,285.49

the IRR:

The internal rate of return is the rate at which the NPV of a priject is zero.

We calculate this using excel formula IRR

or a financial calculator

it could also be done with trial and error using the PV tables.

I will explain you in Excel

FIrst, you write the inflow and outflow per year:

-6,100,000

2,100,000

2,100,000

2,100,000

2,100,000

2,100,000

then we write on another cell:

=IRR(

then, select the cells

and press enter

21.336%

the simple rate of return:

(total return - investment) / investment

(2,100,000 x 5 - 6,100,000) / 6,100,000 =

4,400,000 / 6,100,000 = 0.721311475 = 72.13%