Dashboard/Financial statements/Financial modelling

Financial modelling templates

Multi-year projection models (1, 3, 5, 7 and 10 years) with the same statement structure as IAS 1 and IAS 7-style cash flows. Sector presets set management-planning assumptions (CIMA-style 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.

Smart Forecast
1-year model

Annual projection for the current year. Useful for budgeting and short-term planning.

1 year

3-year model

Three-year rolling forecast. Common for strategic plans and lender reviews.

3 years

5-year model

Five-year financial model. Standard for business plans and investment cases.

5 years

7-year model

Seven-year projection. Suited to medium-term debt and project finance.

7 years

10-year model

Ten-year strategic model. Used for long-term valuation and scenario analysis.

10 years

Sample Template 2020

Sample Template Financial Model 2020 V2 structure. Five-year model from 2020.

5 years

5-year model — Years 2026 to 2030

Industry preset

The three statements use the same IAS 1 / IAS 7-style layout for every sector. Industry presets only set default drivers for planning and sensitivity (management accounting — similar to CIMA cost and working-capital thinking), not audited statutory 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.

Link to actuals

Load assumptions from your financial statements (trial balance / P&L / SFP / cash flow) for a period. Same period as in Financial statements.

Smart assumption helper

ClariFi can suggest ideas or turn plain language into driver changes. Requires OPENAI_API_KEY and advisor access.

Assumptions

Edit any input — the model updates as you type. Use ± to nudge values. Add revenue, cost of sales, or operating expense lines for a breakdown by category.

Year 1 revenue (2026): 10,000,000Year 1 profit after tax: 1,050,000

Key drivers

Slide to adjust — values stay in sync with the fields below.

10,000,000
10%
55%
25%
2%
30%
5%
2,000,000
%
%
%
%
%
%
%
%
Model auto-updates as you type (500 ms delay).

Projected statements use IAS 1-style P&L and SFP labels and an IAS 7-style cash flow layout; amounts are model outputs from your assumptions, not prepared financial statements.

Statement of profit or loss (IAS 1)
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)
RevenueKSh 10,000,000KSh 11,000,000KSh 12,100,000KSh 13,310,000KSh 14,641,000
Cost of salesKSh 5,500,000KSh 6,050,000KSh 6,655,000KSh 7,320,500KSh 8,052,550
Gross profitKSh 4,500,000KSh 4,950,000KSh 5,445,000KSh 5,989,500KSh 6,588,450
Operating expensesKSh 2,500,000KSh 2,750,000KSh 3,025,000KSh 3,327,500KSh 3,660,250
Operating profitKSh 1,700,000KSh 1,870,000KSh 2,057,000KSh 2,262,700KSh 2,488,970
Finance costsKSh 200,000KSh 220,000KSh 242,000KSh 266,200KSh 292,820
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150
Income tax expenseKSh 450,000KSh 495,000KSh 544,500KSh 598,950KSh 658,845
Profit for the periodKSh 1,050,000KSh 1,155,000KSh 1,270,500KSh 1,397,550KSh 1,537,305
Statement of financial position (IAS 1)
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)
Cash and cash equivalentsKSh 1,165,068KSh 1,931,575KSh 2,774,733KSh 3,702,206KSh 4,722,427
Trade receivablesKSh 1,232,877KSh 1,356,164KSh 1,491,781KSh 1,640,959KSh 1,805,055
InventoryKSh 904,110KSh 994,521KSh 1,093,973KSh 1,203,370KSh 1,323,707
Other current assetsKSh 0KSh 0KSh 0KSh 0KSh 0
Total current assetsKSh 3,302,055KSh 4,282,260KSh 5,360,486KSh 6,546,535KSh 7,851,188
Non-current assetsKSh 0KSh 0KSh 0KSh 0KSh 0
Total assetsKSh 3,302,055KSh 4,282,260KSh 5,360,486KSh 6,546,535KSh 7,851,188
Trade payablesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853
Other current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Total current liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853
Non-current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Total liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853
Equity / CapitalKSh 5,000,000KSh 5,000,000KSh 5,000,000KSh 5,000,000KSh 5,000,000
Retained earningsKSh 6,050,000KSh 7,205,000KSh 8,475,500KSh 9,873,050KSh 11,410,355
Other equityKSh 0KSh 0KSh 0KSh 0KSh 0
Total equityKSh 11,050,000KSh 12,205,000KSh 13,475,500KSh 14,873,050KSh 16,410,355
Statement of cash flows (IAS 7)
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150
Depreciation and amortisationKSh 300,000KSh 330,000KSh 363,000KSh 399,300KSh 439,230
Change in working capitalKSh -1,684,932KSh -168,493KSh -185,342KSh -203,877KSh -224,264
Net cash from operating activitiesKSh 115,068KSh 1,811,507KSh 1,992,658KSh 2,191,923KSh 2,411,116
Capital expenditureKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050
Other investingKSh 0KSh 0KSh 0KSh 0KSh 0
Net cash from investing activitiesKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050
Proceeds / (repayment) of borrowingsKSh 0KSh 0KSh 0KSh 0KSh 0
Dividends paidKSh 0KSh 0KSh 0KSh 0KSh 0
Other financingKSh 0KSh 0KSh 0KSh 0KSh 0
Net cash from financing activitiesKSh 0KSh 0KSh 0KSh 0KSh 0
ClariFi | Plan. Measure. Perform.