Most organizations have their own preferred methods of calculating the business value of projects and weighing them against other alternatives. The prerequisite to each of these methods is that the model gives scheduled value generation on a periodic basis (either months or years). For example, a project may present the following schedule of value delivery.
Period Cash Flow
Year 0 $ -750,000
Year 1 $ 150,000
Year 2 $ 500,000
Year 3 $ 400,000
Year 4 $ 200,000
Year 5 $ 200,000
The following are several of the most common methods to describe summarize the value that is created in the schedule above:
Monthly Payback
This is the simplest of all methods. It is simply a statement of how long it will take to recoup the investment made into the project. Given the data above, the payback would be calculated as the following:
Payback = -750,000 + 150,000 + 500,000 + (400,000 x 0.25)
Year 0 Year 1 Year 2 Year 3
or
2 years 3 months payback
The value of this method is its simplicity. One aspect of the risk of the project can be judged by how long it will take to see the benefits. The shortfall of this method is that it does not consider what happens after the breakeven point has been met.
Net Present Value
Calculating the net present value or NPV of a project provides a more complete picture of the business value delivered because it includes the project’s entire lifespan in addition to also factoring risks and alternatives.
The reason for this lies in the concept of the time value of money. Compounding interest allows wealth to grow over time. Every person on the planet has the opportunity to invest money into an account that will collect interest. With this in mind, it follows that collecting $100 today is more valuable than collecting exactly $100 five years now. By accepting the money today and taking it straight to the bank, interest will accumulate allowing you to pull more than $100 when it is withdrawn five years from now.
Exactly how much will the $100 be worth after five years? The answer depends on the interest rate offered by the account that the money was deposited. If a company has a bank that will offer 10% interest rate compounded annually with no risk of default that means in the long run the company should only invest in projects that will result gains better than the 10% per year offered by the bank. The 10% from this example represents the discount rate for that company. The discount rate is used in NPV calculations to compare the value of money gained in future periods against its value in today’s terms by relating it to the other investment opportunities available to the company. If the effects of a project result in a positive NPV, the project is better than alternatives. Projects that calculate to a negative NPV should not be pursued because they are not better than investing in alternatives.
The following formula is the first step in calculating NPV. It should be performed for each period.
Present Value for Each Period = Future Value / (1 + Discount Rate)^Period
Assuming the company has a 10% discount rate and the given data above, the Net Present Value calculates to the following:
Period Future Value Calculation Present Value
Year 0 $ -750,000 -750,000/(1+.10)^0 $ -750,000
Year 1 $ 150,000 150,000/(1.10)^1 $ 136,364
Year 2 $ 500,000 500,000/(1.10)^2 $ 413,223
Year 3 $ 400,000 400,000/(1.10)^3 $ 300,526
Year 4 $ 200,000 200,000/(1.10)^4 $ 136,603
Year 5 $ 200,000 200,000/(1.10)^5 $ 124,184
Net Present Value: $ 360,900
First, the value generated each year is calculated in today’s terms. Notice that money now is more valuable than the same amount in future years. Working backwards, the chart also shows that given our 10% investment alternative, $124,184 will be worth exactly $200,000 five years from now.
Once each period’s values a have been calculated in today’s terms they are now valid to add together to create the Net Present Value. The value generated by this project is worth $360,900 in today’s dollars. As other projects’ NPV are calculated, the decision makers have an apples-to-apples comparison to justify their actions
Internal Rate of Return
Calculating the internal rate of return or IRR for a project is very similar in concept to the NPV calculation. The distinction is that the value derived by the project is communicated as percentage of annual return on the investment. Similar to the 10% return offered by the bank in the previous example, our project has its own annual return value known as the IRR.
To calculate the IRR, take the value delivered each period and then calculate the discount rate that gives the project an NPV = 0. The values from the above project give us the following equation:
0 = -750,000 + 150,000/(1+r)1 + 500,000/(1+r)2 + 400,000/(1+r)3 + 200,000/(1+r)4 + 200,000/(1+r)5
Plug these values into a solver or use the IRR function in Excel to solve for r. In this example the IRR is 28%. The higher rate of return (as opposed to the 10% offered by the bank) shows that the company should invest in this project. If the IRR is lower than 10% or lower than other project alternatives it may not be advisable to pursue the project.