Comparing investment opportunities when cash flows don’t line up
Finance professionals rarely get the neat textbook choice where one option pays a single lump sum today and returns a single lump sum on a fixed date. Real opportunities are messier. A lender structures repayments with step-ups. A project generates uneven operating cash flows. A portfolio manager tops up capital mid-way and takes partial distributions when liquidity allows. Even within the same business, two initiatives can look comparable on paper but differ materially in the timing, scale, and certainty of cash movements.
When cash flows do not line up, the most common failure mode is not a bad spreadsheet. It is choosing a metric that answers the wrong question.
This matters more in an environment where both the cost of capital and inflation can move meaningfully. The Bank of England’s Bank Rate is a key reference point for funding costs and discount rates used in practice, and it is updated through Monetary Policy Committee decisions. At the same time, inflation remains a live variable in commercial planning. The Office for National Statistics reported CPI inflation at 3.2% in the 12 months to November 2025, down from 3.6% in the 12 months to October 2025. In other words, the “background rate” assumptions used to evaluate cash flows are not static, so the discipline of matching method to problem becomes even more important.
Start with the question you are trying to answer
When comparing opportunities with uneven cash flows, there are usually three distinct questions hidden inside the conversation:
- Which option creates more value in pounds, after accounting for timing?
- Which option is more efficient at turning invested capital into returns?
- Which option looks better under stress, if rates, inflation, or cash flow timing changes?
No single metric answers all three. A sensible process uses a small set of measures that each have a clear job.
Use NPV logic to compare value, not just returns
If you are deciding between mutually exclusive opportunities, value comparisons should start with discounted cash flow thinking. That does not mean you need to run an elaborate model, but it does mean you need to respect time.
UK government appraisal guidance is explicit about discounting for time preference. The Green Book sets a standard social time preference discount rate of 3.5% in real terms for central government appraisal, and it discusses circumstances where different approaches apply. The point for commercial readers is not to copy the public-sector rate, but to recognise the principle: cash received later is worth less than cash received sooner, and you need an explicit rate assumption to compare uneven patterns.
Practical takeaway: if the decision is about “which deal adds more value”, anchor your comparison on net present value (NPV) using a discount rate that reflects your funding costs, risk, and inflation assumptions.
Where IRR helps and where it misleads
Internal rate of return (IRR) is popular because it compresses a messy schedule of cash flows into a single annualised percentage. When cash flows do not line up, IRR is often the first metric people reach for, and often the first one they misinterpret.
IRR is useful when:
- You want an annualised return measure that accounts for timing
- Cash flows include interim distributions or follow-on investment
- You need a comparable percentage figure across opportunities
IRR can mislead when:
- Projects are different sizes. A small project can show a higher IRR but create less value.
- There are multiple sign changes in cash flows, which can produce multiple IRRs.
- Reinvestment assumptions are unrealistic. The standard IRR mechanism effectively assumes reinvestment at the IRR itself, which can be aggressive for high-IRR projects.
- Timing differences are extreme. Pulling returns forward can inflate IRR even if the long-run value is lower.
This is why many finance teams use IRR as a secondary measure, not the primary decision rule, and pair it with an absolute value measure like NPV.
If you want a quick way to compute IRR for uneven cash flows without rebuilding your model each time, an IRR calculator can be used as a cross-check against spreadsheet output.
Why CAGR is still useful, even with irregular cash flows
Compound annual growth rate (CAGR) is often treated as the “simple” cousin of IRR. It is not wrong, it is just answering a narrower question.
CAGR is appropriate when:
- The cash flow profile is effectively a start value and an end value
- Interim flows are small, rare, or not material to the story
- You are communicating performance to a broad audience and need a clean narrative
CAGR becomes unreliable when:
- There are meaningful intermediate contributions or withdrawals
- The end value is strongly path-dependent, such as strategies with large mid-period distributions
Used properly, CAGR can still be a helpful companion metric. It communicates the growth of capital over a period in a way that is easy to compare across time or portfolios. A CAGR calculator can provide a fast check when you are sanity-testing numbers.
A worked comparison: Two opportunities, same headline story, different cash flow timing
Consider two opportunities, A and B, each requiring an initial investment of £1,000,000.
Opportunity A
- Year 0: -£1,000,000
- Year 1: +£250,000
- Year 2: +£250,000
- Year 3: +£250,000
- Year 4: +£600,000
Opportunity B
- Year 0: -£1,000,000
- Year 1: +£0
- Year 2: +£0
- Year 3: +£0
- Year 4: +£1,600,000
On a headline basis, B looks “bigger” because the final payoff is larger. But A starts returning cash earlier, which can materially change the comparison once you account for time and funding costs.
How to evaluate:
- NPV will tell you which is better once you pick a discount rate that reflects your capital cost.
- IRR will often favour the option that returns cash earlier, all else equal.
- CAGR will often favour the option with the bigger end value, because it mainly “sees” start and finish.
Now overlay real-world constraints:
- If your funding cost is linked to floating rates, shifts in policy rates can affect your hurdle rate. The Bank of England publishes both the current Bank Rate and the official Bank Rate history, which are common reference inputs for UK funding and valuation frameworks.
- If inflation assumptions change, your real return expectations change. ONS CPI data is a core reference point for inflation in UK planning contexts.
What this example illustrates is not that one metric is “best”. It is that each metric has a different bias, and those biases become important when cash flows are uneven.
Stress-testing: What happens when assumptions shift?
Comparisons become more robust when you test a small number of “what if” scenarios:
- Discount rate up or down by 100 to 200 basis points: This captures funding cost swings and risk appetite changes. In the UK context, Bank Rate is a widely used anchor for how the interest rate environment is moving, even if your true hurdle rate sits above it.
- Inflation different from plan: Even if your model is nominal, inflation affects pricing power, wage costs, and working capital. Use ONS CPI as a disciplined reference point for scenario anchoring.
- Timing slippage: Push back key inflows by 6 to 12 months. Opportunities with back-ended cash flows are more exposed to delays.
- Downside cash flows: Reduce the largest inflows by a realistic haircut. Many opportunities look resilient until you stress the peak cash flow.
A useful mindset here is that IRR often looks stable until late-stage cash flows change, whereas NPV can reveal sensitivity earlier because it measures value in pounds, not just a percentage.
A practical decision framework for uneven cash flows
For business-money.com’s audience, the objective is a repeatable framework that works across lending, project finance, and investment decisions.
A practical checklist:
- Start with a cash flow schedule you believe. Precision is less important than honesty about timing.
- Use NPV to compare value when choosing between mutually exclusive options.
- Use IRR to understand efficiency and to communicate performance, but do not let it override value.
- Use CAGR for simple end-to-end comparisons where interim flows are not decision-critical.
- Stress-test discount rate, inflation, and timing. In the UK context, anchor assumptions using official series such as Bank Rate and CPI.
- Document the decision rule in plain English. If a deal only “wins” under one narrow assumption set, treat it as fragile.
Closing thought
Cash flows that do not line up are not a modelling inconvenience. They are the main feature of commercial finance. The teams that perform best are not those with the most complex spreadsheets, but those that consistently match the right measure to the right question, and can explain the choice clearly to credit committees, investment boards, and clients.