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

3-year model — Years 2026 to 2028

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.

Sector

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.

From

Smart assumption helper

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

Seasons

Tell the model what to change

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.

Base revenue (Year 0)10,000,000

Revenue growth %10%

Cost of sales %55%

Operating expenses %25%

Finance cost %2%

Tax rate %30%

Capex % of revenue5%

Opening cash2,000,000

Revenue lines (Year 0)

Base revenue (Year 0)

Cost of sales lines (% of revenue)

Cost of sales %

Operating expense lines (% of revenue)

Operating expenses %

Revenue growth %

Cost of sales %

Finance cost %

Tax rate %

Depreciation % of revenue

Capex % of revenue

Receivables days

Payables days

Inventory days

Opening cash

Opening equity

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 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

Statement of financial position (IAS 1)

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

Statement of cash flows (IAS 7)

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