Financial modelling templates
Multi-year projection models (1, 3, 5, 7 and 10 years) with the same statement structure as your financial statements and cash-flow reports. Sector presets set management-planning assumptions (cost and working-capital drivers). Select a time horizon to open the model.
Presentation follows common IFRS-style structures (for example IAS 1 for the primary statements and IAS 7 for cash flows) when your chart of accounts and line mappings are set up for that purpose. Outputs depend on your data, mappings, and judgments; they are not audited financial statements and are not a substitute for professional accounting advice.
Annual projection for the current year. Useful for budgeting and short-term planning.
1 year
Three-year rolling forecast. Common for strategic plans and lender reviews.
3 years
Five-year financial model. Standard for business plans and investment cases.
5 years
Seven-year projection. Suited to medium-term debt and project finance.
7 years
Ten-year strategic model. Used for long-term valuation and scenario analysis.
10 years
Sample Template Financial Model 2020 V2 structure. Five-year model from 2020.
5 years
3-year model, Years 2026 to 2028
The three statements use the same balance sheet, profit and loss, and cash flow layout for every sector. Industry presets only set default drivers for planning and sensitivity (management accounting for cost and working capital), not audited filing numbers. Data prepopulated from "General" preset.
Presentation follows common IFRS-style structures (for example IAS 1 for the primary statements and IAS 7 for cash flows) when your chart of accounts and line mappings are set up for that purpose. Outputs depend on your data, mappings, and judgments; they are not audited financial statements and are not a substitute for professional accounting advice.
Load assumptions from your financial statements (trial balance, profit and loss, balance sheet, cash flow) for a period. Same period as in Financial statements.
Projected statements use standard profit and loss, balance sheet, and cash flow layouts; amounts are model outputs from your assumptions, not prepared financial statements.
| Line item | Y1(2026) | Y2(2027) | Y3(2028) |
|---|---|---|---|
| Revenue | KSh 10,000,000 | KSh 11,000,000 | KSh 12,100,000 |
| Cost of sales | KSh 5,500,000 | KSh 6,050,000 | KSh 6,655,000 |
| Gross profit | KSh 4,500,000 | KSh 4,950,000 | KSh 5,445,000 |
| Operating expenses | KSh 2,500,000 | KSh 2,750,000 | KSh 3,025,000 |
| Operating profit | KSh 1,700,000 | KSh 1,870,000 | KSh 2,057,000 |
| Finance costs | KSh 200,000 | KSh 220,000 | KSh 242,000 |
| Profit before tax | KSh 1,500,000 | KSh 1,650,000 | KSh 1,815,000 |
| Income tax expense | KSh 450,000 | KSh 495,000 | KSh 544,500 |
| Profit for the period | KSh 1,050,000 | KSh 1,155,000 | KSh 1,270,500 |
| Line item | Y1(2026) | Y2(2027) | Y3(2028) |
|---|---|---|---|
| Cash and cash equivalents | KSh 1,165,068 | KSh 1,931,575 | KSh 2,774,733 |
| Trade receivables | KSh 1,232,877 | KSh 1,356,164 | KSh 1,491,781 |
| Inventory | KSh 904,110 | KSh 994,521 | KSh 1,093,973 |
| Other current assets | KSh 0 | KSh 0 | KSh 0 |
| Total current assets | KSh 3,302,055 | KSh 4,282,260 | KSh 5,360,486 |
| Non-current assets | KSh 0 | KSh 0 | KSh 0 |
| Total assets | KSh 3,302,055 | KSh 4,282,260 | KSh 5,360,486 |
| Trade payables | KSh 452,055 | KSh 497,260 | KSh 546,986 |
| Other current liabilities | KSh 0 | KSh 0 | KSh 0 |
| Total current liabilities | KSh 452,055 | KSh 497,260 | KSh 546,986 |
| Non-current liabilities | KSh 0 | KSh 0 | KSh 0 |
| Total liabilities | KSh 452,055 | KSh 497,260 | KSh 546,986 |
| Equity / Capital | KSh 5,000,000 | KSh 5,000,000 | KSh 5,000,000 |
| Retained earnings | KSh 6,050,000 | KSh 7,205,000 | KSh 8,475,500 |
| Other equity | KSh 0 | KSh 0 | KSh 0 |
| Total equity | KSh 11,050,000 | KSh 12,205,000 | KSh 13,475,500 |
| Line item | Y1(2026) | Y2(2027) | Y3(2028) |
|---|---|---|---|
| Profit before tax | KSh 1,500,000 | KSh 1,650,000 | KSh 1,815,000 |
| Depreciation and amortisation | KSh 300,000 | KSh 330,000 | KSh 363,000 |
| Change in working capital | KSh -1,684,932 | KSh -168,493 | KSh -185,342 |
| Net cash from operating activities | KSh 115,068 | KSh 1,811,507 | KSh 1,992,658 |
| Capital expenditure | KSh -500,000 | KSh -550,000 | KSh -605,000 |
| Other investing | KSh 0 | KSh 0 | KSh 0 |
| Net cash from investing activities | KSh -500,000 | KSh -550,000 | KSh -605,000 |
| Proceeds / (repayment) of borrowings | KSh 0 | KSh 0 | KSh 0 |
| Dividends paid | KSh 0 | KSh 0 | KSh 0 |
| Other financing | KSh 0 | KSh 0 | KSh 0 |
| Net cash from financing activities | KSh 0 | KSh 0 | KSh 0 |