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

10-year model, Years 2026 to 2035

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)Y8(2033)Y9(2034)Y10(2035)
RevenueKSh 10,000,000KSh 11,000,000KSh 12,100,000KSh 13,310,000KSh 14,641,000KSh 16,105,100KSh 17,715,610KSh 19,487,171KSh 21,435,888KSh 23,579,477
Cost of salesKSh 5,500,000KSh 6,050,000KSh 6,655,000KSh 7,320,500KSh 8,052,550KSh 8,857,805KSh 9,743,586KSh 10,717,944KSh 11,789,738KSh 12,968,712
Gross profitKSh 4,500,000KSh 4,950,000KSh 5,445,000KSh 5,989,500KSh 6,588,450KSh 7,247,295KSh 7,972,025KSh 8,769,227KSh 9,646,150KSh 10,610,765
Operating expensesKSh 2,500,000KSh 2,750,000KSh 3,025,000KSh 3,327,500KSh 3,660,250KSh 4,026,275KSh 4,428,903KSh 4,871,793KSh 5,358,972KSh 5,894,869
Operating profitKSh 1,700,000KSh 1,870,000KSh 2,057,000KSh 2,262,700KSh 2,488,970KSh 2,737,867KSh 3,011,654KSh 3,312,819KSh 3,644,101KSh 4,008,511
Finance costsKSh 200,000KSh 220,000KSh 242,000KSh 266,200KSh 292,820KSh 322,102KSh 354,312KSh 389,743KSh 428,718KSh 471,590
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150KSh 2,415,765KSh 2,657,342KSh 2,923,076KSh 3,215,383KSh 3,536,922
Income tax expenseKSh 450,000KSh 495,000KSh 544,500KSh 598,950KSh 658,845KSh 724,730KSh 797,202KSh 876,923KSh 964,615KSh 1,061,076
Profit for the periodKSh 1,050,000KSh 1,155,000KSh 1,270,500KSh 1,397,550KSh 1,537,305KSh 1,691,036KSh 1,860,139KSh 2,046,153KSh 2,250,768KSh 2,475,845
Statement of financial position
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)Y6(2031)Y7(2032)Y8(2033)Y9(2034)Y10(2035)
Cash and cash equivalentsKSh 1,165,068KSh 1,931,575KSh 2,774,733KSh 3,702,206KSh 4,722,427KSh 5,844,669KSh 7,079,136KSh 8,437,050KSh 9,930,755KSh 11,573,831
Trade receivablesKSh 1,232,877KSh 1,356,164KSh 1,491,781KSh 1,640,959KSh 1,805,055KSh 1,985,560KSh 2,184,116KSh 2,402,528KSh 2,642,781KSh 2,907,059
InventoryKSh 904,110KSh 994,521KSh 1,093,973KSh 1,203,370KSh 1,323,707KSh 1,456,078KSh 1,601,685KSh 1,761,854KSh 1,938,039KSh 2,131,843
Other current assetsKSh 0KSh 0KSh 0KSh 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,938KSh 12,601,432KSh 14,511,575KSh 16,612,732
Non-current assetsKSh 0KSh 0KSh 0KSh 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,938KSh 12,601,432KSh 14,511,575KSh 16,612,732
Trade payablesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843KSh 880,927KSh 969,020KSh 1,065,922
Other current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total current liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843KSh 880,927KSh 969,020KSh 1,065,922
Non-current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Total liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853KSh 728,039KSh 800,843KSh 880,927KSh 969,020KSh 1,065,922
Equity / CapitalKSh 5,000,000KSh 5,000,000KSh 5,000,000KSh 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,530KSh 17,007,683KSh 19,258,451KSh 21,734,296
Other equityKSh 0KSh 0KSh 0KSh 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,530KSh 22,007,683KSh 24,258,451KSh 26,734,296
Statement of cash flows
Line itemY1(2026)Y2(2027)Y3(2028)Y4(2029)Y5(2030)Y6(2031)Y7(2032)Y8(2033)Y9(2034)Y10(2035)
Profit before taxKSh 1,500,000KSh 1,650,000KSh 1,815,000KSh 1,996,500KSh 2,196,150KSh 2,415,765KSh 2,657,342KSh 2,923,076KSh 3,215,383KSh 3,536,922
Depreciation and amortisationKSh 300,000KSh 330,000KSh 363,000KSh 399,300KSh 439,230KSh 483,153KSh 531,468KSh 584,615KSh 643,077KSh 707,384
Change in working capitalKSh -1,684,932KSh -168,493KSh -185,342KSh -203,877KSh -224,264KSh -246,691KSh -271,360KSh -298,496KSh -328,345KSh -361,180
Net cash from operating activitiesKSh 115,068KSh 1,811,507KSh 1,992,658KSh 2,191,923KSh 2,411,116KSh 2,652,227KSh 2,917,450KSh 3,209,195KSh 3,530,114KSh 3,883,126
Capital expenditureKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050KSh -805,255KSh -885,781KSh -974,359KSh -1,071,794KSh -1,178,974
Other investingKSh 0KSh 0KSh 0KSh 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,781KSh -974,359KSh -1,071,794KSh -1,178,974
Proceeds / (repayment) of borrowingsKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Dividends paidKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Other financingKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0
Net cash from financing activitiesKSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0KSh 0