You may have heard or read that frequent releases can improve project economics and ROI (return on investment). Here’s the math.
I use some terms that you may or may not be familiar with: NPV (net present value), IRR (internal rate of return), payback period and ROI (return on investment). You’ll find these terms explained briefly towards the end.
Now, on to the juice.
(Note: The following calculations are technically correct – but if you find any errors anyway, be sure to let me know
Our Fictional Project
First, let’s imagine a project:
- It is scheduled to last for 12 months
- During that time it costs 5 million USD
- The resulting product will provide a financial benefit of USD 200,000 per month (extra revenue or saved costs minus any monthly expenses), until
- The product abruptly stops producing its benefit 4 years after the project is started. You may say there’s a 4-year window of opportunity for this particular product.
- (I also assume a 10 percent discount rate in the NPV calculations
You may download the spreadsheet used for the calculations and graphs (Excel 2003 format)
Waterfall: The Baseline Project
I want to have a waterfall project as a baseline. If all goes according to the waterfall plan, the product is released after 12 months and will generate 36 months x USD 200,000 = USD 7,200,000. The project will have cost 5,000,000. All in all, a nice net profit of 2,200,000.
This is what the cash flow will look like:
|Break Even||37 months|
|Net Present Value (NPV)||USD 920,000|
|Internal Rate of Return (IRR)||20,7 %|
A reasonably good project, I think most of us would agree on.
One interim release
Now, instead of releasing after 12 months, let’s have an interim release after 6 months that realizes half of the value, i.e. it generates a financial benefit of USD 100,000 per month for six months until the final release that realizes all of the value:
|What||Waterfall||Release every 6 months|
|Break Even||37 months||34 months|
|ROI||44,0 %||56,0 %|
|Net Present Value (NPV)||USD 920,000||USD 1,477,000|
|Internal Rate of Return (IRR)||20,7 %||28,7 %|
Amazing! We didn’t change a thing in the product itself, we only added an interim release containing half of the value we eventually will have – and that increased the value of the project, NPV, from USD 920,000 to USD 1,477,000 – a 60% increase!
Release every 3 months
Hmm, maybe even more releases would be even better? Let’s see what it would look like if we released every 3 months, with each release realizing an incremental quarter of the value:
|What||Waterfall||Release every 6 months||Release every 3 months|
|Break Even||37 months||34 months||33 months|
|ROI||44,0 %||56,0 %||62,0 %|
|Net Present Value (NPV)||USD 920,000||USD 1,477,000||USD 1,758,000|
|Internal Rate of Return (IRR)||20,7 %||28,7 %||33,5 %|
By doing this one, single thing; releasing every 3 months instead of once after 12 months, we nearly doubled the value of the project! We also see that the increase in return is diminishing when we release more and more often. With a costly release process, there is a limit to how often one should release. However, if you streamline the release process…
Prioritize the functionality
So far we’ve assumed that all released functionality has equal value. But what if this isn’t true? What if some functionality has higher value than other functionality? And that we can prioritize, so that the most valuable functionality is released first?
Just to put numbers on it, let’s assume that 20 percent of the functionality represents 80 percent of the value. This may sound overoptimistic, but it’s kind of a magic rule and it illustrates the point I’m trying to make:
|What||Waterfall||Release every 3 months, not prioritized||Release every 3 months, prioritized|
|Break Even||37 months||33 months||29 months|
|ROI||44,0 %||62,0 %||76,0 %|
|Net Present Value (NPV)||USD 920,000||USD 1,758,000||USD 2,420,000|
|Internal Rate of Return (IRR)||20,7 %||33,5 %||47,3 %|
From applying these two, simple principles: Prioritize and release often, we’ve increased the value of the project from a baseline NPV of USD 920,000 to USD 2,420,000. Even though the product itself has the same value as before, the value of the project is 2,6 times the baseline value!
In part 2 of CFO’s Case for Frequent Releases, we’ll take a look at what happens when things don’t go exactly according to plan…
Spreadsheet used for calculations
Download CFO case for frequent releases – spreadsheet (Excel 2003 format)
Brief explanation of terms
Payback period: If you invest something now that will give you a return in the future, how long does it take until you have recouped your original investment (disregarding the time value of money)? This is the payback period. For more, check Wikipedia on payback period.
ROI (Return On Investment): There are various definitions and formulas for calculating ROI. However, the main point is always: What’s the payback related to the investment? In this article I’ve used the simple single-period formula (Return – Investment)/Investment – a much-used variation of ROI. For more, check Wikipedia on ROI.
NPV (Net Present Value): The main point is that a dollar today is worth more to you than a dollar a year from now, and even more than a dollar five years from now. If you are able to put, say, 100 dollars to use so that you can get 110 dollars back in one year, then the NPV of getting 110 dollars one year into the future is 100 dollars. In the article, I’ve applied this concept to the future cash flow to generate the entire project’s NPV. To generate the NPV of a cash flow, you must decide on a discount rate that should reflect how much return you would normally expect to get from an alternative investment with the same risk profile. In the article I’ve simply used 10 percent as the discount rate. For more, check Wikipedia on NPV.
IRR (Internal Rate of Return): Given a time series of cash flows and a discount rate, we can calculate the NPV. The NPV is affected by what discount rate we use. By using a specific discount rate, the NPV will be 0 – zero. This is the IRR – the interest rate we can use in the NPV calculations that will result in a NPV of 0. For more, check Wikipedia on IRR.