Skip to main content
ClariFi
Checking sign-in…
Financial statements/Financial modelling

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.

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

7-year model, Years 2026 to 2032

Industry preset

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.

Link to actuals

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.

Statement of profit or loss
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)Y6(2031)Y7(2032)
RevenueKSh 10,000,000KSh 11,000,000KSh 12,100,000KSh 13,310,000KSh 14,641,000KSh 16,105,100KSh 17,715,610
Cost of salesKSh 5,500,000KSh 6,050,000KSh 6,655,000KSh 7,320,500KSh 8,052,550KSh 8,857,805KSh 9,743,586
Gross profitKSh 4,500,000KSh 4,950,000KSh 5,445,000KSh 5,989,500KSh 6,588,450KSh 7,247,295KSh 7,972,025
Operating expensesKSh 2,500,000KSh 2,750,000KSh 3,025,000KSh 3,327,500KSh 3,660,250KSh 4,026,275KSh 4,428,903
Operating profitKSh 1,700,000KSh 1,870,000KSh 2,057,000KSh 2,262,700KSh 2,488,970KSh 2,737,867KSh 3,011,654
Finance costsKSh 200,000KSh 220,000KSh 242,000KSh 266,200KSh 292,820KSh 322,102KSh 354,312
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150KSh 2,415,765KSh 2,657,342
Income tax expenseKSh 450,000KSh 495,000KSh 544,500KSh 598,950KSh 658,845KSh 724,730KSh 797,202
Profit for the periodKSh 1,050,000KSh 1,155,000KSh 1,270,500KSh 1,397,550KSh 1,537,305KSh 1,691,036KSh 1,860,139
Statement of financial position
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)Y6(2031)Y7(2032)
Cash and cash equivalentsKSh 1,165,068KSh 1,931,575KSh 2,774,733KSh 3,702,206KSh 4,722,427KSh 5,844,669KSh 7,079,136
Trade receivablesKSh 1,232,877KSh 1,356,164KSh 1,491,781KSh 1,640,959KSh 1,805,055KSh 1,985,560KSh 2,184,116
InventoryKSh 904,110KSh 994,521KSh 1,093,973KSh 1,203,370KSh 1,323,707KSh 1,456,078KSh 1,601,685
Other current assetsKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total current assetsKSh 3,302,055KSh 4,282,260KSh 5,360,486KSh 6,546,535KSh 7,851,188KSh 9,286,307KSh 10,864,938
Non-current assetsKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total assetsKSh 3,302,055KSh 4,282,260KSh 5,360,486KSh 6,546,535KSh 7,851,188KSh 9,286,307KSh 10,864,938
Trade payablesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843
Other current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total current liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843
Non-current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843
Equity / CapitalKSh 5,000,000KSh 5,000,000KSh 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,355KSh 13,101,390KSh 14,961,530
Other equityKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total equityKSh 11,050,000KSh 12,205,000KSh 13,475,500KSh 14,873,050KSh 16,410,355KSh 18,101,391KSh 19,961,530
Statement of cash flows
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)Y6(2031)Y7(2032)
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150KSh 2,415,765KSh 2,657,342
Depreciation and amortisationKSh 300,000KSh 330,000KSh 363,000KSh 399,300KSh 439,230KSh 483,153KSh 531,468
Change in working capitalKSh -1,684,932KSh -168,493KSh -185,342KSh -203,877KSh -224,264KSh -246,691KSh -271,360
Net cash from operating activitiesKSh 115,068KSh 1,811,507KSh 1,992,658KSh 2,191,923KSh 2,411,116KSh 2,652,227KSh 2,917,450
Capital expenditureKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050KSh -805,255KSh -885,781
Other investingKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Net cash from investing activitiesKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050KSh -805,255KSh -885,781
Proceeds / (repayment) of borrowingsKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Dividends paidKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Other financingKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Net cash from financing activitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0