The quality of a model is demonstrated by management’s understanding of it
A financial model is not decision-quality merely because it contains multiple worksheets, detailed formulas or attractive charts.
Its value depends on whether it represents the commercial reality of the business or project, exposes the assumptions driving performance and enables management to understand the financial consequences of different decisions.
A model that cannot be clearly explained by management may create false confidence rather than useful insight.
Before relying on a model for investment, budgeting, financing or expansion decisions, manageme
1. What decision the model is designed to support
Every model should have a defined purpose.
It may be designed to assess:
- · Business expansion.
- · A capital requirement.
- · Project feasibility.
- · Pricing.
- · Acquisition economics.
- · Debt affordability.
- · New-market entry.
- · Operating capacity.
- · Working-capital requirements.
- · Shareholder returns.
- · A restructuring or turnaround.
A single model may support several decisions, but its architecture should reflect its principal purpose.
A model prepared for internal budgeting will not necessarily contain the analysis required for project finance, valuation or investor due diligence.
2. How revenue is generated
Revenue should be built from identifiable commercial drivers rather than inserted as an unsupported annual growth percentage.
Depending on the business, management should be able to explain:
- · Customer numbers.
- · Contract volumes.
- · Units sold.
- · Pricing.
- · Conversion rates.
- · Sales-cycle duration.
- · Customer retention.
- · Utilisation.
- · Capacity.
- · Commission or subscription structures.
- · Project-completion milestones.
- · Geographic or channel expansion.
The model should make it possible to determine which assumptions are responsible for revenue growth.
3. What it costs to deliver the revenue
A credible model distinguishes between revenue and economic contribution.
Management should understand:
- · Direct product or service costs.
- · Delivery and fulfilment costs.
- · Contractor costs.
- · Infrastructure requirements.
- · Distribution expenses.
- · Customer-support costs.
- · Implementation costs.
- · Payment charges.
- · Commissions.
- · Warranty or after-sales obligations.
- · Sector-specific operating costs.
This analysis allows management to determine whether growth improves profitability or merely increases activity.
4. Which assumptions are fixed and which are variable
The model should distinguish between:
- · Costs that increase directly with volume.
- · Costs that increase in steps.
- · Fixed overhead.
- · One-off implementation costs.
- · Capital expenditure.
- · Financing costs.
- · Contingency.
- · Inflation-sensitive expenditure.
- · Foreign-currency exposure.
Treating every cost as a fixed percentage of revenue can conceal the true operating requirements of the business.
5. How working capital affects cash
Profit is not the same as cash.
Management should be able to explain the timing of:
- · Customer invoicing.
- · Customer collection.
- · Supplier payments.
- · Inventory purchases.
- · Deposits.
- · Retentions.
- · Taxes.
- . Payroll.
- · Contract mobilisation.
- · Project certification.
- · Capital expenditure.
A company can appear profitable in the income statement while requiring significant additional cash to finance receivables, inventory or project delivery.
The model should therefore connect commercial activity to the actual timing of cash inflows and outflows.
6. Why capital expenditure is required
Capital expenditure should be connected to capacity, efficiency, compliance or revenue generation.
Management should be able to explain:
- · What will be purchased or developed.
- · When the expenditure will occur.
- · Whether it is essential or discretionary.
- · The capacity or benefit created.
- · The useful economic life.
- · Ongoing maintenance requirements.
- · Whether expenditure is denominated in foreign currency.
- · Whether further investment will be required.
Capital expenditure should not appear as a broad unexplained annual figure.
7. How the funding requirement has been calculated
The funding requirement should emerge from the model rather than being imposed on it.
The model should identify:
- · The opening cash position.
- · Operating cash generation or consumption.
- · Working-capital needs.
- · Capital expenditure.
- · Debt-service obligations.
- · Transaction costs.
- · Contingency.
- · Minimum liquidity.
- · The timing and size of the maximum cash deficit.
- · Any future funding rounds or refinancing requirements.
Management should also be able to explain what changes if less capital is secured than originally planned.
8. What happens when assumptions are weaker
A base case alone is insufficient for many material decisions.
The model should test the effect of changes in variables such as:
- · Customer conversion.
- · Pricing.
- · Sales delays.
- · Cost inflation.
- · Exchange rates.
- · Interest rates.
- · Project delays.
- · Utilisation.
- · Collection periods.
- · Capital expenditure.
- · Regulatory timing.
Scenario analysis should not be used to create an artificially attractive outcome. Its purpose is to show management where the business or project becomes vulnerable.
9. How historical performance informs the forecast
Where a business has an operating history, the forecast should be connected to actual performance.
Management should explain:
- · Which historical period was used.
- · Whether the figures are audited or management-prepared.
- · Material normalisation adjustments.
- · One-off revenue or expenditure.
- · Changes in accounting treatment.
- · Differences between historical and projected margins.
- · Reasons future performance is expected to improve.
- · Any limitations in the available data.
A forecast that materially departs from historical performance requires a clear commercial explanation.
10. Who owns and maintains the model
A model becomes unreliable when no one is responsible for updating, reviewing and reconciling it.
Management should establish:
- · A designated model owner.
- · Assumption owners.
- · Version-control procedures.
- · Review and approval responsibilities.
- · A regular update cycle.
- · Reconciliation with management accounts.
- · Change logs.
- · Protection of formula cells.
- · Clear distinction between inputs, calculations and outputs.
The management explanation test
Before presenting a model to a board, lender, investor or transaction adviser, management should be able to explain:
- 1. What drives revenue.
- 2. What drives margin.
- 3. What consumes cash.
- 4. When additional capital is required.
- 5. Which assumptions carry the greatest risk.
- 6. What happens under a downside case.
- 7. Which actions management can take if performance is weaker.
- 8. How the model will be monitored after approval.
Where these questions cannot be answered, the model may not yet be suitable for a material commercial decision.
NCDF Commercial perspective
NCDF Commercial develops and reviews financial models intended to support management decisions, commercial planning, project preparation, capital readiness and implementation monitoring.
The objective is not to create an optimistic spreadsheet. It is to establish a transparent financial representation of the assumptions, risks and decisions underlying the proposed course of action.