A bankable financial model is a decision tool, not a decorative spreadsheet. It must explain how a project earns revenue, meets operating obligations, services debt and absorbs downside risk. For East African infrastructure developers, the model also needs to make currency, inflation, construction and regulatory assumptions transparent to local and international lenders.
Begin with a clear commercial architecture
Map the contractual relationships before building formulas: sponsor equity, lenders, customers or offtakers, engineering and construction contractors, operators, government counterparties and insurers. Revenue, costs and risk allocation should follow those contracts. If the commercial structure is unsettled, the model should identify assumptions that still require negotiation.
Separate inputs, calculations and outputs. Use consistent units, dates, signs and colour conventions. Include checks for balance-sheet integrity, sources and uses, cash waterfalls and debt roll-forward. A reviewer should be able to trace a key output back to its source without reverse-engineering the workbook.
Model construction and operations separately
Construction models should capture drawdown timing, equity contributions, interest during construction, fees, taxes, contingencies and delay. Operational forecasts should connect physical drivers—volume, availability, capacity or customers—to tariffs and revenue. Costs should distinguish fixed, variable, lifecycle and pass-through items.
A single annual assumption can hide seasonal cash deficits. Monthly or quarterly periods are often necessary during construction, ramp-up and early debt service, with a carefully controlled transition to longer periods if appropriate.
Use DSCR as a diagnostic, not only a covenant output
Debt Service Coverage Ratio compares cash available for debt service with scheduled principal and interest for the relevant period. The definition must match the proposed financing documents. Clearly show how tax, working capital, reserve accounts and permitted distributions affect cash available.
Review minimum and average coverage, the timing of weak periods and the assumptions driving them. Sculpting debt to a target ratio may improve the profile, but it does not repair weak project economics. Lenders will still test the resilience of revenue, cost and completion assumptions.
Make currency exposure visible
Many regional projects earn revenue in Kenyan shillings, Tanzanian shillings or Ugandan shillings while carrying US-dollar or euro debt and imported costs. The model should identify the currency of every major cash flow, state exchange-rate and inflation assumptions, and show whether tariffs adjust.
Test devaluation, convertibility constraints, delayed tariff indexation and hedge costs. Where the project has no natural hedge, the financing strategy may need local-currency debt, blended capital, guarantee support, reserve mechanisms or contractual adjustment.
Design scenarios around real risks
A base, upside and downside case are useful only when their assumptions are coherent. Create scenarios for construction delay, cost overrun, slower ramp-up, lower demand, operating underperformance, higher interest rates and currency movement. Combine correlated risks rather than changing one cell at a time.
Present the effect on funding needs, completion date, DSCR, debt tenor, equity return and covenant headroom. Sensitivities should lead to decisions about contingency, contracts, pricing or capital structure.
Prepare the model for independent review
Keep an assumptions register and source evidence. Reconcile the model to the business plan, technical studies, E&S action costs and transaction documents. Lock version control, document changes and provide a concise user guide. These disciplines reduce review cycles and help management answer lender questions consistently.
Point Capital provides project finance modelling and investment readiness advisory across East Africa. Contact us to review or develop a lender-ready model.