Project Finance & Financial ModellingProject finance foundations · Lesson 2 of 20
Capex, opex, budgeting and cash flow
Video lecture
Capex, opex, budgeting and cash flow
The narrated lecture is in production
Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.
Chapters
Transcript of the narration, chapter by chapter.
0:00 The uses side nobody finishes
Here's a mistake I've seen sink more than one project. The team budgets the headline construction price, the EPC contract, and forgets everything else it takes to reach operations: owner's costs, contingency, interest during construction, financing fees, reserve accounts and working capital. On a big project, those items can add a large share on top of the construction price. Discover them late, and you have a funding gap at the worst possible moment. In this lecture you'll learn the difference between capital and operating expenditure, how to think in whole-life cost, how to structure development, construction and operating budgets, how to build a sources and uses table that actually balances, and how to turn a budget into a cash-flow profile. By the end, you'll be able to draft a complete sources and uses table for any project.
1:00 Why it matters
Why does this matter? Three reasons. First, classification. Whether a cost is capital or operating changes reported profit, tax timing and often who approves it. Second, whole-life thinking. The cheapest asset to buy is often not the cheapest to own, and project finance deals last decades, so the SPV lives with its running costs for a very long time. Third, completeness. Lenders fund a sources and uses table at financial close. If a use is missing, it isn't funded, and the gap surfaces during construction, when your options are expensive: sponsor top-ups, standby facilities or cutting scope.
1:42 The concept: capex, opex and whole-life cost
Capital expenditure, or capex, buys or builds long-lived assets: land, construction, equipment, major upgrades. It's usually capitalised on the balance sheet and depreciated over the asset's life. Operating expenditure, or opex, covers day-to-day running: staff, maintenance, insurance, utilities, consumables and management fees. It's expensed in the period incurred. Some items are grey areas, like major component replacements or customised software, and the exact classification depends on accounting standards, IFRS in Pakistan, the UAE, Saudi Arabia and the UK, or US GAAP in the US, and on company policy. Always check with finance. Then think whole-life: whole-life cost equals capex, plus the present value of opex, plus major maintenance and decommissioning, minus any residual value. It's like buying a car: the sticker price matters, but so do fuel, servicing and what it's worth when you sell it.
2:41 Worked example one: two chillers in Lahore
Let's work a simple example from the lesson. A fictional hospital operator in Lahore compares two chillers for a new wing. Option A costs one point two million dollars and has energy and maintenance costs of two hundred and sixty thousand a year. Option B costs one point six million and runs at one hundred and eighty thousand a year. Both last fifteen years. At an eight per cent discount rate, the fifteen-year annuity factor is about eight point five six. So the present value of A's running costs is about two point two three million, and B's is about one point five four million. Whole-life cost: A about three point four three million, B about three point one four million. Option B costs more upfront but is roughly three hundred thousand cheaper over its life. And if the capex budget is capped, finance might explore leasing or energy-performance contracting to access option B.
3:48 Worked example two: sources and uses
Now the realistic example: a sources and uses table, with illustrative numbers in millions. Uses first. The EPC contract, three hundred and ten. Owner's costs, eighteen. Development costs and fees, twelve. Contingency, twenty-five. Interest during construction, thirty-eight. Financing fees, nine. Initial funding of the debt service reserve account, twenty. Working capital, eight. Total uses: four hundred and forty. So the headline construction price is only about seventy per cent of what must be funded. Sources: senior debt, three hundred and thirty, and sponsor equity, one hundred and ten. Total: four hundred and forty. Uses equal sources. Now notice something important. Interest and fees are themselves uses that must be funded. More debt means more interest, which needs more funding. That's a circularity, and the model has to handle it carefully, which we'll cover in the modelling module.
4:48 Watch me do it: a balancing sources and uses sheet
Let me show you how I lay out a sources and uses sheet so it never goes out of balance silently. Uses on the left, each with a basis column: the EPC price from the signed contract, owner's costs from the budget, interest during construction from the model, and so on. Total uses is a simple SUM. On the sources side, senior debt is the lower of the gearing cap times total uses, and the debt capacity from the cash-flow sizing, which comes later in the course. Equity is total uses minus debt, so it always balances by construction. And then a check cell: sources minus uses, which must be zero, formatted to turn red if it isn't. Finally, a gearing line: debt over total uses. Now, when someone changes the contingency, everything updates, and the check tells you immediately if something's broken.
5:50 Budget phases and cash timing
Project budgets usually have three phases. Development costs: feasibility, permits, advisers, land options and bid costs, which are at risk until financial close. Construction costs, which are the uses of funds we just built. And operating costs: fixed and variable opex, lifecycle or major maintenance, insurance and taxes. Then comes timing. A budget says how much; a cash-flow profile says when. Build a monthly or quarterly construction cash-flow forecast from the EPC payment schedule, owner's cost timing and financing fees. Then agree the funding order. Lenders often require equity to go in first, or pro rata with debt, so their money isn't at risk before the sponsors'. Some sponsors use an equity bridge loan to defer their cash injection, backed by guarantees, which improves their returns but adds cost.
6:46 Common mistakes
The common mistakes. Forgetting financing costs, reserve funding and working capital in the uses. Misclassifying costs and then being surprised by the effect on profit or tax. Choosing the lowest capex option without whole-life analysis. And assuming funds will be available when needed, without a drawdown plan. A quick self-check for any budget: are capex and opex coded separately from the first transaction? Does the uses side include financing costs, reserves and working capital, or only the headline construction price? Is there a cash-flow profile showing when each source is drawn? And has any major option been compared on whole-life cost rather than purchase price? A no to any of these is a common root cause of funding surprises later.
7:38 Recap and try this now
Let's recap. Capex buys long-lived assets and is capitalised; opex runs the asset and is expensed, and the classification should be agreed with finance. Compare options on whole-life cost, not purchase price. Build complete budgets across development, construction and operations, and make sure the uses side includes financing costs, reserves and working capital. Sources must equal uses, and a check cell should prove it every time something changes. Then turn the budget into a cash-flow profile with an agreed drawdown order. Your try-this-now: draft a sources and uses table for a small project you know, even a business expansion. Include financing costs, contingency and working capital, and add a check cell that proves it balances.
Capital vs operating expenditure
Capital expenditure (capex) buys or builds long-lived assets: land, construction, equipment, major upgrades. It is usually capitalised on the balance sheet and depreciated over the asset's life. Operating expenditure (opex) covers the day-to-day costs of running the asset: staff, maintenance, insurance, utilities, consumables, management fees. It is expensed in the period incurred.
| Item | Typically capex | Typically opex |
|---|---|---|
| Building a warehouse | ✓ | |
| Annual routine maintenance | ✓ | |
| Replacing a major component that extends asset life | ✓ (often) | |
| Software licences (subscription) | ✓ (often) | |
| Customised software development | ✓ (often, if criteria met) | |
| Staff salaries for operations | ✓ |
Exact classification depends on accounting standards (e.g., IFRS used widely in Pakistan, the UAE, KSA and the UK; US GAAP in the US) and company policy. Always check with finance. The classification matters because it changes reported profit, tax timing and how budgets are approved.
Whole-life cost
A cheap asset with high running costs may cost more over its life. Whole-life (life-cycle) cost = capex + present value of opex + major maintenance + decommissioning − residual value. PPP and project finance models are built on this view because the SPV bears costs for decades.
Development, construction and operations budgets
A project finance budget typically has three phases:
- Development costs: feasibility, permits, advisers (legal, technical, financial), land options, bid costs. At risk until financial close.
- Construction costs (the "uses" of funds): EPC price, owner's costs, contingency, development fees, financing costs during construction (interest during construction, arrangement and commitment fees), initial reserve account funding, working capital.
- Operating costs: fixed and variable opex, lifecycle/major maintenance, insurance, taxes.
Sources and uses
Every project finance model starts with a sources and uses table: the uses (all costs to reach operations) must equal the sources (debt + equity + any grants).
USES (illustrative, $M) SOURCES ($M)
EPC contract 310 Senior debt 330
Owner's costs 18 Sponsor equity 110
Development costs & fees 12
Contingency 25
Interest during construction 38
Financing fees 9
Initial DSRA funding 20
Working capital 8
TOTAL 440 TOTAL 440Notice that financing costs are themselves uses that must be funded, which creates a circular calculation (more debt means more interest, which needs more funding). Models handle this carefully, as covered later.
From budget to cash flow
Budgets say how much; cash flow says when. Build a monthly or quarterly construction cash-flow forecast from the EPC payment schedule, owner's cost timing and financing fees. Then decide the funding order: equity first, pro rata with debt, or via an equity bridge loan. Lenders often require equity to be committed and injected first or pro rata, so their money is not at risk before sponsors' money.
Worked example: capex vs opex decision
Illustrative. A fictional hospital operator in Lahore compares two chiller options for a new wing:
| Option A | Option B | |
|---|---|---|
| Capex | $1.2M | $1.6M |
| Annual energy + maintenance | $260k | $180k |
| Life | 15 years | 15 years |
At an 8% discount rate, the annuity factor for 15 years is about 8.56. PV of opex: A ≈ 260k × 8.56 ≈ $2.23M; B ≈ 180k × 8.56 ≈ $1.54M. Whole-life cost: A ≈ $3.43M, B ≈ $3.14M. Option B costs more upfront but is cheaper over its life. If the capex budget is capped, the finance team might explore leasing or energy-performance contracting to access Option B.
Budget control essentials
- Budget by WBS and phase, with explicit contingency.
- Track commitments, not just spend.
- Separate capex and opex codes from day one.
- Re-forecast regularly; compare forecast uses to available sources.
Common mistakes
- Forgetting financing costs, reserves and working capital in the uses.
- Misclassifying costs, then being surprised by profit or tax effects.
- Choosing the lowest capex option without whole-life analysis.
- Assuming funds are available when needed without a drawdown plan.
Quick self-check
Take the last budget you worked with and ask four questions. Are capex and opex coded separately from the first transaction? Does the uses side include financing costs, reserves and working capital, or only the headline construction price? Is there a cash-flow profile showing when each source is drawn? And has any major option been compared on whole-life cost rather than purchase price alone? A "no" to any of these is a common root cause of funding surprises later in the project.
Hands-on: whole-life cost and sources and uses in Excel
Whole-life cost comparison
Named inputs: Rate (8%), Life (15)
PV of opex =PV(Rate, Life, -Annual_opex) (returns ≈ 8.559 × annual opex)
Whole-life =Capex + PV_of_opex + PV_major_maint + PV_decom - PV_residual
PV of a one-off cost in year n =Cost/(1+Rate)^nFor the chillers: =1200000+PV(8%,15,-260000) ≈ 3,425,000 and =1600000+PV(8%,15,-180000) ≈ 3,141,000.
Sources and uses that always balance
Total_uses =SUM(Uses_range)
Debt =MIN(Gearing_cap*Total_uses, Debt_capacity) (Debt_capacity from DSCR sizing)
Equity =Total_uses-Debt
Check =ROUND((Debt+Equity)-Total_uses, 2) must be 0
Gearing =Debt/Total_usesHands-on: the same checks in Python
import numpy_financial as npf
rate, life = 0.08, 15
for name, capex, opex in [("A", 1_200_000, 260_000), ("B", 1_600_000, 180_000)]:
pv_opex = -npf.pv(rate, life, opex) # present value of an annuity
print(f"Option {name}: whole-life cost {capex + pv_opex:,.0f}")
uses = {"EPC": 310, "Owner's costs": 18, "Development & fees": 12, "Contingency": 25,
"IDC": 38, "Financing fees": 9, "Initial DSRA": 20, "Working capital": 8}
total = sum(uses.values())
debt = min(0.75 * total, 330) # 330 = illustrative debt capacity from DSCR sizing
equity = total - debt
assert abs(debt + equity - total) < 1e-9
print(f"Uses {total}, debt {debt} ({debt/total:.0%}), equity {equity}")Install with pip install numpy-financial. Note that npf.pv returns a negative value for a positive payment (cash-flow sign convention), hence the minus sign.
How to measure success
- Uses include financing costs, reserves and working capital, each with a basis.
- The check cell is zero in every scenario.
- Major options are compared on whole-life cost with the discount rate stated.
Key takeaways
- Capex builds long-lived assets; opex runs them. Classification follows accounting standards and policy.
- Whole-life cost combines capex, the present value of opex, lifecycle costs and residual value.
- Sources must equal uses, and uses include financing costs, reserves and working capital.
- Budgets show how much; cash-flow forecasts show when, and drive funding order.
Check your understanding
Quick questions to lock in the lesson. They don’t count towards your certificate.
Put it into practice
Draft a sources and uses table for a small project you know (even a business expansion). Include financing costs, contingency and working capital.
Enrol for free to save your progress
Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.