FIGURING “RETURN ON INVESTMENT” (ROI)
Analyzing Capital Expenditures
The following example is taken from FINANCIAL INTELLIGENCE by Karen Berman & Joe Knight. Harvard Business School Press, 2006. (If you are not familiar with this book, you might consider adding it to your personal library. I find myself referring to it over and over again. )
Example:
Your company is considering purchasing a $3,000 piece of equipment—a computer for example.
Its useful life is expected to be 3 years.
At the end of each of the three years the expected cash flow is estimated to be $1,300.
Your company’s required rate of return—the hurdle rate—is 8 percent.
Do you buy the computer or not?
PAYBACK METHOD
Initial Investment/Cash Flow per Year
$3,000/$1,300 = 2.31 Years
The payback period is shorter than the life of the asset. It passes the first test.
NET PRESENT VALUE
The ‘discounting equation’ looks like this…
PV = FV1/(1+i) + FV2/(1+I)(1+i) + FV3/(1+i)(1+i)(1+i)
PV = $1,300/1.08 + $1,300/(1.08)(1.08) +$1,300/(1.08)(1.08)(1.08)
PV = $1,300/1.08 + $1,300/1.17 +$1,300/1.26
PV = $1203.70 + $1,111.11 + $1031.75
PV = $3346.56 or $3347 rounded
The anticipated future cash flows of $3900 are worth only $3346.56 in today’s dollars at 8%.
If you subtract the original investment of $3,000 you get a net present value of $347.
If the net present value is greater than zero you should buy the computer because it exceeds the company’s hurdle rate of 8%. It passes the second test.
INTERNAL RATE OF RETURN
Internal Rate of Return (IRR) is the rate at which the net present value (NPV) of future cash flows will equal zero. In other words it is the rate where the future cash flows when discounted at some rate will equal the original investment.
Using a financial calculator or web tool you find that the IRR for this example is 14.36%.
When compared to the hurdle rate of 8%, the IRR of 14.36% is greater so you should buy the computer. It passes the third test.
COMPARING THE THREE METHODS
Two things to always remember when comparing the three methods…
•
The three methods may lead you to making different decisions
•
The Net Present Value method is the best choice when the methods conflict
Example:
Your company has $3,000 to invest.
There are three different possible investments to consider.
•
Investment A: Returns cash flow of $1,000 per year for three years
•
Investment B: Returns cash flow of $3,600 at the end of year one
•
Investment C: Returns cash flow of $4,600 at the end of year three
The required rate of return—the hurdle rate—is 9%.
All investments carry equal risk.
You can select only one of the investments—which one will it be?
USING THE PAYBACK METHOD
•
Investment A: three years
•
Investment B: one year
•
Investment C; three years
Investment B would be the choice.
USING THE NET PRESENT VALUE METHOD
•
Investment A: ($469)
•
Investment B: $303
•
Investment C: $552
Investment C would be the choice.
USING THE INTERNAL RATE OF RETURN METHOD
•
Investment A: 0 percent
•
Investment B: 20%
•
Investment C: 15.3%
Investment B would be the choice.
WHY SHOULD WE CHOOSE INVESTMENT C?
Investment C is worth more in today’s dollars than the other investments.