Compare alternatives with different cash and benefit timing
17 min read
Lesson objectives
- Build a consistent time-based comparison including operations, terminal effects and transition service.
- Separate present value from liquidity and benefit type, and test the input that switches the choice.
Please sign in to use all the tools
Once you sign in, the reading tools are yours: larger or smaller text, typeface, line spacing, focus mode, highlighting and bold, and notes saved to your account and gathered in My study.
A portfolio committee needs continuous service for three years. One supplier offers an asset purchase with a large initial cost; another offers a leased service with a smaller upfront payment and higher annual charges. One presentation chooses the cheapest start, while another totals benefits without placing them in time. Each leaves part of the decision out of view. This comparison builds one timeline showing what the organisation pays, when service arrives and what remains at the comparison's end. It then separates value over the selected horizon from affordability and continuity during transition. The highest-value option may be unaffordable this year, while the affordable option may fit later needs less well. The board needs these distinct judgements together to choose an intelligible commitment.
Define the comparison question first: are we choosing how to provide a particular service for three years, or a permanent capability for ten? The horizon is not automatically the shorter contract's expiry date. It should cover the need approved for the decision, with asset-life and commitment differences handled explicitly. State the required service level, users, starting date and duration of organisational need. If duration is uncertain, present a base horizon and an extension or early-exit case. Each should have a reason, such as known funding expiry or possible renewal of authority. Choosing whichever horizon makes a favoured option win embeds the desired conclusion inside an allegedly neutral input.
Construct a simple timeline before applying discount factors. The starting row contains immediate payments; each annual row places flows at an explicit assumed date. Purchase has annual net benefit of 100, from benefit of 120 less operating cost of 20, with sale proceeds of 60 added in year three. Leasing has annual net benefit of fifty, from 120 less seventy. Do not deduct operating cost again after using net flows. Retain the gross-benefit and cost detail so each net row can be checked. Where benefits arrive midyear instead of year-end, use an appropriate timing convention consistently rather than awarding one option an advantage through different spreadsheet conventions.
Put prices on a consistent basis before comparing time. Nominal prices include what is expected to be paid in the payment year; constant prices remove general inflation relative to a base year. A particular asset's price may move faster or slower than general inflation, requiring an explicit relative-price assumption. The example uses constant prices and an illustrative real discount rate of 10% to simplify calculation. This is neither an official rate nor a financing recommendation. The UK Green Book distinguishes inflation adjustment from discounting. We use that conceptual distinction while leaving the actual rate to organisational policy and evaluation purpose. Private financial and social analyses can use different perspectives, flows and rates; identify which question the model answers.
The present value of a flow at the end of year one is the flow divided by one plus the discount rate. At the end of year two, divide by that quantity squared, continuing according to the year number. At 10%, the first three factors are approximately 0.909091, 0.826446 and 0.751315. Immediate payments have a factor of one. Calculate internally with full precision and round the display for readability. Using 0.75 instead of 0.751315 can be reasonable for explanation if identified as rounding, but may reverse almost-tied options. In that situation, show sensitivity to numerical precision and input uncertainty rather than announcing decisive superiority.
Residual value at the horizon requires an evidential basis. Here it is expected disposal proceeds after necessary selling costs, not automatically the asset's accounting book value. An asset recorded at sixty may not sell for sixty, or its contract may prohibit transfer or require costly removal. If the organisation retains the asset, the basis for valuing its remaining ability to serve later needs differs and must be stated. In either case, ensure terminal value does not recount benefits already included beyond the horizon. State whether use ends with a sale or continues with remaining value estimated by an appropriate method.
Now examine service before the new option starts. Asset installation may take months while leasing begins immediately, invalidating an assumption of equal first-year benefits. The organisation might buy bridging service, accept an interruption within an approved limit or revise the schedule. Each path requires its own costs, outcomes and authority. Bridging service maintains delivery until transition completes; state whom it covers and when it ends. Where interruption makes an option impermissible, that is a feasibility constraint before value ranking, not an arbitrary monetary penalty chosen to balance an allowed outcome against one that is prohibited.
Separate net present value from maximum cash requirements. The committee does not pay 23.764 to purchase; that number combines discounted outcomes across time after bridging cost. It pays 270 initially: 240 for the asset and thirty for bridging, then needs twenty at each year-end before accounting for available cash receipts. Leasing needs eighty initially and seventy annually. If only two hundred is available at the start, purchase with bridging is infeasible without new funding or revised payment arrangements, regardless of eventual return. Moreover, a benefit of 120 might represent social costs avoided or released staff time rather than money entering the account. Such benefits cannot fund supplier instalments in the liquidity schedule.
Do not handle unequal lifetimes by automatically repeating the shorter contract. If need lasts six years, leasing might require another setup payment after year three while the purchased asset continues without replacement. The asset could nevertheless need major maintenance absent from the three-year model. Rebuild the six-year timeline with flows appropriate to it. A sale assumed at year three cannot remain if the asset is retained to year six: that sale never happens. An equivalent annual comparison can suit some cases, but repeating identical cycles needs justification when technology, prices or demand change.
The board may request payback alongside present value. In the three-year example, purchase accumulates one hundred annually before disposal and could recover 240 during year three if cash arrived uniformly within the year. The original convention, however, places flows at year-end. Under that discrete schedule, payback occurs at the end of year three, not after 2.4 years without changing the timing assumption. Simple payback measures return speed and ignores flows after recovery. Use it as evidence about cash exposure with its limits stated, while the complete comparison retains later flows. A memorable number does not replace the question of which service is obtained throughout the entire horizon.
Check the perspective used to combine benefits and costs. A supplier payment is an organisational cost and supplier revenue, while a social analysis may treat transfers and some impacts differently from the organisation's financial analysis. Define the required question before mixing figures from different models. This example uses a training financial perspective with verifiable cash benefits assumed. For public services, benefits might instead be user time, safety or access, requiring suitable valuation or nonmonetary presentation alongside cost. Calling a number a benefit does not make it social value; expressing it in riyals does not make it available cash. The effect and its valuation method determine the conclusions it supports.
Test timing and quality sensitivity together. A week's delay in a critical service may breach an approved obligation even when its financial impact is small. First ask whether each option meets the limits, then rank those remaining feasible. Within that set, test installation duration, benefit arrival, operating cost and terminal proceeds. Change one variable first to understand what reverses ranking, then model linked changes where delayed installation increases bridging cost and delays benefits together. Combining independently favourable changes can create an impossible scenario. Record links that cause inputs to move together.
Treat nonimplementation fairly. Existing service may require additional maintenance or face licence expiry during the horizon, so cost-free continuation may be unrealistic. A one-year extension could provide time to learn or negotiate. Define its cost, service limit and expiry, then compare it with purchase and leasing against the same need. The baseline is not a penalty designed to make new proposals look attractive. If waiting increases later cost or preserves useful flexibility, show those effects at their actual dates. The board can then understand what it loses or retains by waiting, rather than mistaking absence of a new project for absence of a decision.
Present three connected lines in the final recommendation: value over the chosen horizon, maximum funding need and timing, and transition service level. Add the assumption capable of reversing ranking, its source and the verification owner. Retain the decision's timeline version and update affected branches when actual timing or prices change. This skill needs a model proportionate to the decision, with one definition of need and a timeline hiding no payment, benefit or interruption. Where differences are small relative to uncertainty, explain an explicitly approved preference for flexibility or quality rather than exaggerating a minor numerical gap.
The comparison's end requires exit costs as well as residual asset value. A lease may end without ownership but require data migration, device removal or training a replacement supplier. Running both services during the final month may be necessary to verify transfer. Identify the payer, payment date and whether the cost is common to options or specific to one. Common costs still matter for funding even if they do not change ranking; option-specific differences affect selection. If no contractual exit price exists, disclose the gap and test an evidenced range tied to actual work. The final invoice does not automatically mark the end of every obligation.
Lesson summary
The lesson compares purchase and leasing over one need horizon. It dates flows and tests disposal, bridging and exit costs. Differences in lifetimes, prices and funding are made explicit, preventing estimated time benefits from being treated as cash for supplier payments.