Financial modelling for property development in Kenya: what the numbers need to show

A development appraisal is the financial model of a proposed property development. It projects all costs and revenues across the development lifecycle — from land acquisition through construction completion and sale or rental — and calculates the return on capital invested. The primary metrics are development margin, return on cost, and (for larger projects) internal rate of return.

The development appraisal is the central decision-making tool for any developer considering a project. It answers three questions: Is this project viable? What can I afford to pay for the land? Which development programme (tenure mix, unit size distribution, specification level) maximises the return? The answers to these questions determine whether a site acquisition proceeds, at what price, and with what development intent.

In Kenya, many development decisions are made on the basis of an informal financial assessment: a rough calculation of construction cost per m² against an assumed sale price. This is not an appraisal. It is a back-of-envelope estimate that omits the majority of the costs and the time value of money. Projects built on informal assessments are the ones that run out of cash in mid-construction, discover they have overpaid for the land, or complete into a market where the sale price assumptions were never tested.

A credible development appraisal contains a specific set of components, uses real current data, and is stress-tested against adverse assumptions. This guide explains each component.

Every development appraisal is built on two primary pillars: Gross Development Value (GDV) and Total Development Cost (TDC). The difference between them, expressed as a percentage of GDV, is the development margin.

Gross Development Value (GDV) is the total revenue from the completed development — the aggregate value of all units sold, or the capitalised value of the rental income stream if the development is held for investment. For a sale development, GDV is the number of units multiplied by the expected sale price per unit. For a rental development, GDV is the net rental income divided by the capitalisation rate (yield) that the market applies to that asset class and location.

In Mombasa, current GDV benchmarks are: residential apartments in mid-market locations at KES 8,000–12,000 per m² of saleable area; high-specification residential and waterfront at KES 15,000–25,000 per m²; commercial at KES 60,000–90,000 per m² capitalised value. These are broad benchmarks — the GIS and market intelligence tools at `/market` provide parcel-specific values.

Total Development Cost (TDC) is the aggregate of all costs incurred in developing the project: land acquisition cost; professional fees (architecture, engineering, QS, project management); construction cost (main contract, M&E, external works); statutory costs (planning, NEMA, NCA registration); finance costs (interest during construction, loan arrangement fees); selling costs (agent fees, marketing); and contingency.

In Kenya, the most commonly underestimated TDC components are: professional fees (often budgeted at 5–8% when the correct figure for full professional team engagement is 12–18% of construction cost); finance costs (interest during construction is a real cost that must be modelled against the drawdown profile and the expected programme duration); and selling costs (agent commissions of 1.5–2.5% on a large residential development represent a significant sum).

Development margin is (GDV − TDC) / GDV × 100. Benchmark thresholds in Kenya for a viable project are: residential development above 15%; commercial development above 20%. Below these thresholds, the project does not generate sufficient margin to absorb programme risk, market risk, and cost overrun.

Residual land value (RLV) is the maximum price a developer should pay for a development site, derived by working backwards from the GDV: RLV = GDV − TDC (excluding land) − required profit.

This is the single most important calculation in development finance. It tells the developer whether the asking price for a site is justifiable given the development programme and expected returns. A site being offered at KES 80M that has a residual land value of KES 50M is either overpriced for the intended development, or requires a higher-density or higher-value development programme to support the asking price.

RLV is a dynamic number — it moves with construction costs, sale prices, and interest rates. A development that was viable at a KES 60M land price when construction costs were at 2023 levels may not be viable at the same land price now if construction costs have increased by 15–20%.

The RLV calculation is the mechanism for land price negotiation. A developer who can demonstrate the RLV to a landowner — with transparent assumptions — has a credible basis for negotiating the acquisition price. A developer who agrees a price without calculating the RLV is accepting risk that the model has not quantified.

For any site being considered for acquisition, running a feasibility check at `/feasibility` before committing to a price gives you the RLV, the development margin, and the sensitivity analysis in under 10 minutes.

A static development appraisal calculates the final margin at project completion. A cash flow model adds the time dimension: when is each cost incurred, when does each revenue arrive, and what is the maximum capital exposure at any point in the programme?

The cash flow model is essential for projects using bank finance, because lenders require it to size the loan and set the drawdown schedule. It is also essential for developers using their own capital, because the maximum capital exposure defines the equity commitment and the point at which cash runs out if sales are slower than projected.

Interest during construction (IDC) is one of the most significant costs in the development appraisal that informal models omit. On a KES 200M construction programme over 18 months, with a construction loan at 15% per annum, the interest cost is approximately KES 22.5M — over 11% of the construction cost. Omitting this from the appraisal overstates the development margin by a material amount.

The cash flow model should also include the pre-development costs incurred before construction begins: land acquisition, professional fees for the pre-construction stages, planning and statutory fees, and the sales and marketing spend to achieve pre-sales before construction commences. For a project requiring 30% pre-sales to satisfy the lender's conditions precedent, the marketing spend to achieve those pre-sales is a real cost incurred before any construction finance is drawn.

Standard Kenyan bank construction finance terms that the model should reflect: loan-to-cost of 60–70% (the developer must fund 30–40% from equity or pre-sales); interest rate of 13–17% per annum depending on the institution and the developer's covenant; arrangement fee of 1–1.5% of the loan amount; and a valuation monitoring fee charged by the bank's monitoring surveyor (typically 0.25–0.5% of the loan).

Every development appraisal should be run in at least three scenarios: the base case (most likely assumptions), a downside case (adverse but plausible assumptions), and a stress case (testing the break-even point).

The variables that most commonly break development models in Kenya are: construction cost overrun (10–20% above base); programme extension (3–6 months beyond the expected construction period, extending interest cost); sale price shortfall (10–15% below the assumed price, which may be the actual achieved price versus the optimistic asking price); and sales absorption rate (units taking 12–18 months longer to sell than assumed, which significantly increases holding costs).

A project that only works at the base case is not a viable project — it is a project that works if nothing goes wrong. A project that remains viable under the downside case (positive margin, sufficient to service the debt) with acceptable equity returns is the appropriate threshold for a development decision.

The sensitivity table — showing how the development margin changes as a single variable (construction cost, sale price, programme) moves away from the base case — is one of the most useful outputs of the appraisal. It tells the developer which variable is the most dangerous: on most projects, it is the sale price, not the construction cost.

The REDM feasibility tool at `/feasibility` runs sensitivity analysis automatically, showing the development margin across a range of construction cost and sale price scenarios, based on real parcel data from the PostGIS database.

A professionally prepared development appraisal — built to the standard required for bank financing, equity partner presentation, or formal investment committee review — requires engagement of the project's QS (for construction cost benchmarks) and the architect (for development quantum assumptions), in addition to the financial modelling exercise itself.

As a standalone service, a development financial model for a project in the KES 100M–500M range is typically priced at KES 200,000–500,000, depending on the complexity of the programme and the number of scenario runs required.

For projects where feasibility is being assessed as part of the REDM pipeline — running the full `gis → finance → docs → erp → security` pipeline — the financial model is produced as part of the feasibility study package. The feasibility study fee covers GIS site analysis, financial modelling, and the formal feasibility report.

For developers who want a rapid first-pass assessment before commissioning a full feasibility study, the REDM feasibility tool at `/feasibility` provides a development appraisal using real construction benchmarks and parcel-specific market data. It is not a substitute for a professionally prepared appraisal but it answers the primary viability question: is this project worth pursuing further?

For projects structured as Musharakah partnerships rather than bank-financed developments, the financial model shifts from debt-service coverage to equity waterfall tiers: return of capital, preferred return to cash partners (conditional on profit), and promote split to the operator. The key metrics become equity IRR and equity multiple — the same concepts used in conventional real estate, expressed in partnership language rather than interest schedules.

A Musharakah model treats land as a capital class (valued at market), cash as a capital class (with potential preferred return), and operator services as a promote tier (earned from remaining profit). Each class has a different risk profile and return expectation. The model should show base, moderate, and optimistic profit scenarios so partners see how the waterfall compresses or expands. Read the Musharakah waterfall article for the full tier logic and halal audit points before setting up the spreadsheet. The REDM feasibility wizard models these tiers directly from parcel data and cost benchmarks.