Public agency financial model, built free.
A three-statement Excel model for a public transport authority or appropriation-funded agency, built from your own figures and checked to balance.
- Free account
- No card
- Usually ready within the hour
We use generative AI in parts of our process, so mistakes can occur. Every model should be checked by a person before it is relied on. Read more
A government department or statutory authority funded mainly by parliamentary appropriations with some own-source revenue (fares, fees), delivering services itself or buying them from operators and NGOs — for example a transport authority contracting bus, ferry and rail operators and keeping the fare revenue.
In short
- 01
Three linked statements
Income statement, balance sheet and cash flow, linked in every period.
- 02
Valued two ways
Discounted cash flow and trading multiples, side by side.
- 03
Monthly to annual
Monthly, quarterly, half-yearly or annual periods, for up to 30 years.
- 04
Checked every period
A Checks sheet shows the balance sheet balances and the cash reconciles.
The sample, as Excel draws it.
Built by the same system and checks as yours: its structure and its inputs, ready for your own figures.
The sample describes no real business. Yours is calibrated to your own figures, so its results are your business’s.
How the model works for a public agency.
- How it earns revenue3 formulasPatronage and fare revenue · All programsFare revenueJourneysAverage fare revenue per journeyInfrastructure assets, capital works and depreciation · All infrastructure asset classesCapital worksRenewal worksUpgrade worksNew worksInfrastructure assets, capital works and depreciation · All infrastructure asset classesAdditions to the classCapital worksAssets contributed by developers (not modelled)
- What drives its costs3 formulasPurchased service delivery contracts · All programsBase contract paymentPayment for service kilometresPayment for service hoursPayment for peak vehiclesPurchased service delivery contracts · All programsPurchased service contractsBase contract paymentPerformance incentivesAbatementsOperating expenses · Across the businessTotal FTEsOperations and deliverySales and marketingTechnologyFinance, HR and administration
- What it invests in3 formulasLeasesPrincipal elements of lease paymentsLease payments (cash)from cashInterest on lease liabilitiesLeasesClosing lease liabilitiesLease 1Lease 2Lease 3Lease 4Lease 5Lease 6LeasesLease payments (cash)Lease 1Lease 2Lease 3Lease 4Lease 5Lease 6
- How profit becomes cash3 formulasWorking capitalTrade receivablesRevenuefrom statementsDebtor daysDays in periodWorking capitalInventoryDirect costs (positive)from statementsInventory daysDays in periodWorking capitalTrade payablesCash operating costs (positive)from statementsCreditor daysDays in period
12 parts, each one tested.
Every part is a tested building block with its own checks: yours is put together from the ones your business needs.
- CPI forecastConsensus curve with long-run anchor
- Operating expensesHeadcount build by function
- Corporate costsFixed cost base indexed to CPI
- Working capitalFull working capital
- Discounted cash flow valuationDCF on free cash flow to the firm
- Multiples valuationEV / EBITDA multiple
- Capital grants and contributionsFunding mix by capital projectGrants to build or acquire assets the entity will control, recognised as income as the asset is built (AASB 1058 paragraphs 15–16; a conditional-grant liability under IPSAS 23 and similar standards), with unspent amounts held as a liability and the income kept below the operating result. Used by councils, agencies, health services, charities, clubs and housing providers.
- LeasesLease register
- Purchased service delivery contractsGross-cost contract per service kilometreServices an agency buys rather than delivers — bus and ferry operating contracts, rail franchises, outsourced community services — priced per unit of service, per output or as block payments with incentives and abatements.
- Patronage and fare revenuePatronage × average fare yieldJourneys on a public transport mode or contract area and the fare revenue they yield after concessions, fare caps and free-travel policies.
- Asset renewal requirement and backlogAnnual consumption as the requirementThe renewal spend each asset class needs to hold its target service level (from the asset management plan) and the backlog of assets below a satisfactory standard — the basis of the renewal gap.
- Infrastructure assets, capital works and depreciationCapital works program with straight-line depreciationRoll-forward of each asset class — capital works split into renewal, upgrade and new, assets contributed by developers, depreciation and revaluations — carried at fair value (current replacement cost) under AASB 116 and AASB 13 or IPSAS 17. Revaluation increments go to the asset revaluation reserve (other comprehensive income).
The numbers it tracks.
- 01appropriation revenue
- 02net cost of services
- 03farebox recovery
- 04subsidy per journey
- 05cost per service kilometre
- 06operating result
- 07capital program
What it is used for.
- Budget and rolling forecastGuide · Cash flow forecast
- Operating forecastGuide · Financial projections
- Restructuring and liquidityGuide · Financial modelling services
- Scenarios and sensitivities
More in government.
- Local council financial model
- Government business enterprise financial model
- Public hospital financial model
Looking for a public agency financial model template? Ours arrives built for your business, with your figures in it.
See a finished model, sheet by sheetThe sample is built on illustrative figures and describes no real business. Models are calculations prepared from the information you provide. They are not financial advice and must be independently verified. See our terms.