Business Financial Model: Template and Guide

Why a company genuinely needs a financial model

A financial model links a company's core metrics together and shows how a decision made today will play out a year from now. Without one, an owner relies largely on instinct and past data — looking in the rear-view mirror rather than at the road ahead.

In practice, a financial model solves three problems:

1. Planning: a 12-36 month forecast clarifies how much capital you need, when it will arrive, and what resources are required
2. Management: comparing plan against actuals shows where you are falling behind and whether the strategy needs adjusting
3. Raising capital: investors ask for the model first to gauge potential and risk

When an owner understands exactly where the company makes its money, they react to market shifts faster and make decisions on the numbers rather than on gut feel.

The core building blocks of a financial model

1. Revenue Forecast

This is the foundation of the entire model. Get it wrong, and your cost, profit, and cash calculations — however carefully done — will be built off a flawed base.

• For B2B: number of clients × average contract value × win probability. Example: 50 prospects × ₽500K × 30% probability = ₽7.5M per year
• For B2C: traffic × conversion × average order value. Example: 10,000 visitors × 5% × ₽2,000 = ₽1M per month
• For subscriptions: number of paying subscribers × subscription price × (1 - churn). Example: 1,000 subscribers × ₽5,000/year × (1 − 3% churn) = ₽4.85M per year
• Seasonality: account for monthly fluctuations (for example, retail grows 40% in December)
• Growth: conservatively, 5-10% per month for a stable business, 15-30% for fast-growing segments

2. Cost Structure

Costs fall into two categories, and each affects the model differently.

• Variable costs (COGS): rise with revenue — cost of goods, shipping, payment-processing fees. Example: at a 60% margin, COGS = 40% of revenue
• Fixed costs (OpEx): team salaries, office rent, insurance, licenses, tool subscriptions. In a typical company this runs 20-40% of revenue
• Depreciation: if you have invested in equipment or intangible assets, it affects profit (not cash flow)

An example structure for a SaaS company with ₽10M in annual revenue:

• Revenue: ₽10M
• COGS (hosting, support): ₽1M (10%)
• Salaries: ₽4M
• Marketing: ₽2M
• Office, tools: ₽1M
• Pre-tax profit: ₽2M (20% EBITDA margin)

3. EBITDA and Net Profit forecast

EBITDA reflects operating profit (revenue minus operating costs), before taxes and depreciation. Net Profit is what remains at the bottom line.

• EBITDA margin: EBITDA / Revenue. Benchmark: 20-40% for a healthy business
• Net margin: Net Profit / Revenue. Benchmark: 10-25%
• If EBITDA is negative, the business model is not working and urgent changes are needed

4. Cash Flow

For a company's survival, this matters more than profit. Profit on the statement and the balance in the account are not the same thing: you can be profitable on paper yet still be unable to make payroll.

• Operating cash flow: the cash a company generates from its core activities. Example: you issue an invoice for ₽1M, but the client pays in 60 days, so cash flow lags by two months
• Investing cash flow: cash for buying equipment and developing the product
• Financing cash flow: borrowed funds, investments, dividend payments
• Runway: how long the company survives on current cash if no new money comes in. Runway = cash / monthly expenses

Building the model step by step (using an e-commerce example)

Step 1: Identify the core metrics

What drives your revenue? Write down the current figures:

• Orders per month: 500
• Average order value: ₽5,000
• Revenue per month: ₽2.5M

Step 2: Build a 12-month revenue forecast

Apply a 10% monthly growth rate (conservative for a growing company):

• Month 1: ₽2.5M
• Month 2: ₽2.75M (2.5 + 10%)
• Month 3: ₽3.025M
• ... and so on
• Month 12: ₽7.13M (roughly 2.85x higher)

Over the year, revenue comes to about ₽53M (not simply 2.5 × 12, but factoring in growth).

Step 3: Set variable costs as a % of revenue

• Cost of goods: 40% of revenue
• Shipping: 8%
• Payment-processing fee: 2%
• Total variable: 50%

Step 4: List the fixed costs

• Salaries (owner + manager): ₽600K/month
• Warehouse rent: ₽200K/month
• Marketing: ₽300K/month
• Tools (CRM, analytics): ₽50K/month
• Total fixed: ₽1.15M/month

Step 5: Calculate profit

For month 1:

• Revenue: ₽2.5M
• Variable costs (50%): ₽1.25M
• Fixed costs: ₽1.15M
• EBITDA: 2.5 - 1.25 - 1.15 = ₽0.1M (4% margin)

For month 12 (revenue ₽7.13M):

• Revenue: ₽7.13M
• Variable costs (50%): ₽3.57M
• Fixed costs: ₽1.15M (they do not grow with revenue!)
• EBITDA: 7.13 - 3.57 - 1.15 = ₽2.41M (34% margin)

The margin climbed from 4% to 34% on the same fixed-cost base: revenue rose while salaries, rent, and tools stayed put. That is operating leverage — the primary engine of profitability growth.

Step 6: Factor in taxes and determine net profit

• EBITDA in month 12: ₽2.41M
• Income tax (20%): ₽0.48M
• Net Profit: ₽1.93M (27% margin)

Step 7: Forecast cash flow

If the client pays in 7 days while you purchase goods and pay for shipping upfront:

• Cash outflow on day 1: cost of goods + shipping from the monthly volume
• Cash inflow with a 7-day lag: revenue
• During growth periods a "cash gap" can open up: you spend money before you receive it

For growing companies this is a critical issue. If you are growing 20% per month with a 30-day payment cycle, you need a cash cushion of at least 40-50% of monthly revenue.

Scenario analysis: base, optimistic, pessimistic

Do not rely on a single forecast. Build three scenarios:

• Base: 10% monthly growth, margins as planned
• Optimistic: 15-20% growth, COGS cut by 5%, cheaper marketing
• Pessimistic: 3-5% growth, 10% of clients lost to a competitor, COGS up 10%

Assign a probability to each scenario (for example, base — 50%, optimistic — 25%, pessimistic — 25%) and calculate the expected value. This helps you understand the range of possible outcomes.

What investors look for in a financial model

• Unit economics: an LTV/CAC ratio of at least 3:1, payback period under 12 months
• Path to profitability: when does EBITDA turn positive? In which month?
• Model sensitivity: how does the outcome change if price drops 10%? Or if 20% of clients leave?
• Capital requirement: how much money is needed, and over what period, to survive until cash-flow positive
• Economies of scale: does margin expand as revenue grows?

Common mistakes in building a model

• Forgetting taxes: build the model on an after-tax basis. Income tax (20%) and VAT (where applicable) are mandatory components
• Underestimating marketing: as you grow, marketing gets more expensive. Budget 10-20% of revenue
• An over-optimistic revenue forecast: if the market is growing 5% and you have planned for 50%, that is unrealistic. Even the best companies grow 15-30% per month early on
• Ignoring seasonality: B2C e-commerce grows 2-3x in December and falls in January. Overlook it, and your scaling preparations will be miscalibrated
• Forgetting cash flow: the profit model can be positive while the cash runs out, because clients pay late
• An overly detailed model: a three-year model accurate to the day is a waste of time. Monthly accuracy over a year is the norm

Tools for building a model

• Excel: the standard tool. Downsides: easy to make errors, hard to update. Upside: complete flexibility
• Google Sheets: better for collaboration, easy to share with investors for viewing
• Specialized tools: PlanGuru, LivePlan, Causal — built-in templates and updates, but more expensive
• Templates: look on the websites of investment funds (Sequoia, Y Combinator) or specialized financial-modeling services (PlanGuru, Causal). A template can save you 20-30 hours

Keeping the model up to date

A model built once and filed away quickly goes stale. Refresh it every month:

1. Compare planned figures against actuals (P&L, CAC, LTV)
2. If the variance exceeds 20%, investigate the cause
3. Update the revenue forecast for the coming months based on the new information
4. Refine the growth rate, conversion rates, and margins
5. Share the updated model with the team and investors (if you have any)

A financial model is a living document that helps you run the company in real time — not just a plan you left forgotten in a desk drawer.

Conclusion

The model is not for investors first and foremost — it is for the owner: it reveals the mechanics of the business and helps you plan growth. Even if you have no plans to raise capital, build one for yourself. A week in Excel, and you have a tool you will return to over the next two or three years at every major decision.

Start simple: define revenue, define costs, calculate profit. Then add cash flow, scenario analysis, and sensitivity. Over time the model becomes more accurate and more useful.