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

Sample Template 2020, Years 2020 to 2024

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.

Sample template worksheets

Structure aligned to the sample financial model template (2020).

  • CoverModel title, entity name, version and base year
  • AssumptionsInputs and drivers: revenue, costs, growth, tax, working capital
  • Revenue build-upRevenue by stream or category, growth and volume/price
  • Opex build-upOperating expenses by category and % or fixed amounts
  • Working capitalReceivables, payables and inventory days and balances
  • DepreciationCapex, useful lives and D&A schedule
  • Debt scheduleBorrowings, interest and repayments
  • Income statementStatement of profit or loss (P&L)
  • Balance sheetStatement of financial position
  • Cash flowStatement of cash flows
  • SummaryKey metrics, ratios and dashboard
Assumptions guidelines

How to populate each assumption for the model.

Show guidelines
  • Base revenue (Year 0)(Currency)

    Use prior-year actual revenue or management’s budget for the first year. If using revenue lines, ensure the sum of all streams equals total revenue. Management view (CIMA-style planning): baseline for budgets and variance analysis.

  • Revenue growth %(%)

    Use management forecast, strategic plan, or industry benchmark. Consider volume and price; keep consistent with market and capacity. Supports long-range planning and scenario stress tests.

  • Cost of sales %(% of revenue)

    Historical gross margin or budget. Vary by product mix and input costs; benchmark against peers where relevant. Classify direct vs indirect costs for internal margin decisions (management accounting).

  • Operating expenses %(% of revenue)

    Sum of salaries, rent, marketing, admin, etc. Use budget or prior-year ratio; can be built from opex lines by category. Useful for controllable vs fixed-cost framing in management reports.

  • Finance cost %(% of revenue)

    Interest as % of revenue. Link to debt schedule and average borrowing rate; use drawn debt and applicable rate. Align with financing cash outflows in liquidity planning.

  • Tax rate %(%)

    Applicable statutory corporate tax rate (e.g. Uganda 30%). Adjust for incentives or losses if modelled separately. Statutory rate, distinct from transfer pricing and deferred tax (IAS 12) in full compliance work.

  • Depreciation % of revenue(% of revenue)

    Derive from capex, useful lives and opening PP&E. Keep aligned with depreciation supporting schedule. Ties to IAS 16-style charges in statutory accounts when policies match.

  • Capex % of revenue(% of revenue)

    Planned capital spend as % of revenue. Use budget or maintenance + growth capex; link to depreciation schedule. Cash planning for investing activities (IAS 7).

  • Receivables days(Days)

    Days sales outstanding (DSO). Use historical collection period or target; consider payment terms and credit policy. Core working-capital driver (CIMA performance).

  • Payables days(Days)

    Days payables outstanding (DPO). Use historical or supplier terms; align with working capital policy. Pairs with receivables and inventory days for the cash conversion cycle.

  • Inventory days(Days)

    Days inventory held. Use historical or target turnover; adjust for seasonality or supply chain changes. For IAS 2 inventory, management uses the same days for throughput planning.

  • Opening cash(Currency)

    Cash and cash equivalents at the start of Year 0. Use latest balance sheet or closing actuals. Opening position for the cash flow bridge.

  • Opening equity(Currency)

    Total equity at the start of Year 0. Use latest balance sheet; include share capital and retained earnings. Anchor for statement of changes in equity (IAS 1).

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(2020)Y2(2021)Y3(2022)Y4(2023)Y5(2024)
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
EBITDAKSh 2,000,000KSh 2,200,000KSh 2,420,000KSh 2,662,000KSh 2,928,200
Depreciation and amortisationKSh 300,000KSh 330,000KSh 363,000KSh 399,300KSh 439,230
EBIT / Operating profitKSh 1,700,000KSh 1,870,000KSh 2,057,000KSh 2,262,700KSh 2,488,970
Interest expenseKSh 200,000KSh 220,000KSh 242,000KSh 266,200KSh 292,820
Interest incomeKSh 0KSh 0KSh 0KSh 0KSh 0
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 after taxKSh 1,050,000KSh 1,155,000KSh 1,270,500KSh 1,397,550KSh 1,537,305
Statement of financial position
Line itemY1(2020)Y2(2021)Y3(2022)Y4(2023)Y5(2024)
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
Property, plant and equipmentKSh 0KSh 0KSh 0KSh 0KSh 0
Other non-current assetsKSh 0KSh 0KSh 0KSh 0KSh 0
Total 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
Short-term debtKSh 0KSh 0KSh 0KSh 0KSh 0
Other current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Total current liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853
Long-term debtKSh 0KSh 0KSh 0KSh 0KSh 0
Other non-current liabilitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Total liabilitiesKSh 452,055KSh 497,260KSh 546,986KSh 601,685KSh 661,853
Share 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
Line itemY1(2020)Y2(2021)Y3(2022)Y4(2023)Y5(2024)
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
Other operating adjustmentsKSh 0KSh 0KSh 0KSh 0KSh 0
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 investing activitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Cash from investing activitiesKSh -500,000KSh -550,000KSh -605,000KSh -665,500KSh -732,050
Proceeds / (repayment) of debtKSh 0KSh 0KSh 0KSh 0KSh 0
Dividends paidKSh 0KSh 0KSh 0KSh 0KSh 0
Other financingKSh 0KSh 0KSh 0KSh 0KSh 0
Cash from financing activitiesKSh 0KSh 0KSh 0KSh 0KSh 0
Net change in cashKSh -384,932KSh 1,261,507KSh 1,387,658KSh 1,526,423KSh 1,679,066