Investing Basics

Articles of the Week

Net Present Value (NPV) - A Financial Tool for Investment Comparison

Net Present Value combined with Internal Rate of Return are useful tools when comparing investments with different projected cash flows. Take this case for example:

Acura, a car manufacturer wants to open a new manufacturing plant. It is considering 2 locations:

Cash Flows
Shanghai
Mumbai
Initial Investment $15,000,000 $18,000,000
Year 1 -750,000 750,000
Years 2-4 250,000 450,000
Years 5-15 800,000 1,500,000
Years 16-25 1,200,000 3,000,000

More Capital Budgeting Tutorials

If Acura requires a minimum of 10% required return, which investment would you choose?

In order to perform this calculation, we will use the Business Analyst BAII Plus Financial Calculator.

Notes:

CFO = Initial Investment and is always entered as a negative (since the company is paying out the money). E.g an initial investment of $-10,000 means the company paid out that amount.

CO1 = Cash flow (in) for Year 1
CO2 = Cash flow (in) for Year 2
CO3 = Cash flow (in) for Year 3... etc

1) Shanghai

In your calculator, type in 2nd -> CF

CFO = -15,000,000
CO1 = -750,000
FO1 = 1 (means cash flow for 1 year)
CO2 = 250,000
FO2 = 3 (means cash flow for 3 years)
CO3 = 800,000
FO3 = 11 (means cash flow for 11 years)
CO4 = 1,200,000
FO4 = 10 (means cash flow for 10 years)

CPT -> NPV

I = 10% (this is the Acura's required rate of return)

NPV -> CPT = -$9,802,501

IRR -> CPT = 2.09%

2) Mumbai

In your calculator, type in 2nd -> CF

CFO = -18,000,000
CO1 = 750,000
FO1 = 1 (means cash flow for 1 year)
CO2 = 450,000
FO2 = 3 (means cash flow for 3 years)
CO3 = 1,500,000
FO3 = 11 (means cash flow for 11 years)
CO4 = 3,000,000
FO4 = 10 (means cash flow for 10 years)

CPT -> NPV

I = 10% (this is the Acura's required rate of return)

NPV -> CPT = -$5,233,631

IRR -> CPT = 7.01%

Here's a snapshot of the results we found:

Tool Shanghai Mumbai
NPV -$9,802,501 -$5,233,631
IRR 2.09% 7.01%

If you look at the NPV of both cities, they are negative. What are the rules of Net Present Value?

The rules of NPV?

- If an investment has a Positive NPV, then go ahead and do it!
- If an investment has a Negative NPV, then do not invest in it!

If you look at the IRR of both cities, they are below the 10% required return by Acura. Shanghai's IRR of 2.09% and Mumbai's IRR of 7.01% are below the required 10% return.

Solution: Therefore, we have to reject both the investment projects.

 


Website Statistics