Build a financial model explained: this guide covers what it means, who it applies to, the step-by-step process, documents required, fees, due dates and penalties in India — so you can stay compliant with confidence and avoid costly mistakes.
A financial model is a set of linked calculations that turns a few stated assumptions into projected profit, cash and balance sheet. Its value is in the structure: if the assumptions sit in one place and everything else flows from them, the owner can change one number and see the whole business respond. This guide is about that structure, not about any one statement.
A sound model has four layers: inputs (every assumption, labelled, on one sheet), workings (revenue, cost, asset and debt schedules driven by the inputs), outputs (profit and loss, balance sheet, cash flow, linked) and checks (the balance sheet balances, cash agrees, no typed-in numbers in the workings). A scenario switch on the input sheet should change base, optimistic and pessimistic cases without touching anything else.
What a model is for
An owner uses a model to decide how much to borrow, how much cash to hold, what price to charge and what happens if sales fall short. An investor or lender uses it to test whether the story hangs together. The first things they test are the assumptions, the cash position in the weak months and whether the statements agree with each other. If you need a model built for a loan, an investor round or a budget, our financial modeling service structures it in this way.
The four layers
| Layer | What it holds | Rule |
|---|---|---|
| Inputs | Prices, volumes, cost percentages, days of working capital, capital expenditure, loan terms, tax rate, scenario selector | Every assumption on one sheet; each labelled with its unit and source |
| Workings | Revenue build, cost build, staff plan, fixed asset and depreciation schedule, loan schedule, working capital | Formulae only; no typed numbers |
| Outputs | Profit and loss, balance sheet, cash flow, summary dashboard | Linked; built from the workings |
| Checks | Balance sheet balances, closing cash agrees to the cash flow, totals agree across sheets | Show one clear pass or fail cell |
How the statements link
Profit after tax from the profit and loss flows into the retained earnings of the balance sheet. Depreciation reduces fixed assets and is added back in the cash flow. Capital expenditure raises fixed assets and appears as an outflow. Loan repayments reduce the loan on the balance sheet and appear in the cash flow; interest runs through the profit and loss. Closing cash from the cash flow becomes the cash on the balance sheet. When every flow is linked in both directions, the balance sheet balances without any forcing figure. The line-by-line build of the three statements for a bank loan is in projected financial statements for a bank loan and is not repeated here.
Steps
- List the drivers: what moves revenue (customers, price) and what moves cost (a percentage of sales, a fixed monthly amount).
- Put them on the input sheet with units, and add a scenario selector.
- Build the workings from the inputs only.
- Build the three statements from the workings.
- Add the checks.
- Run the scenarios and read the cash in the weakest period.
- Document the assumptions and the version.
Worked example: a start-up restaurant
Spice Lane Kitchen (invented) plans a 40-seat restaurant. All figures are assumed. The model is annual, in ₹ thousand, with a 360-day year. Fixed costs per year: rent 1,800, staff 2,520, utilities and other 720 = 5,040. Depreciation is 600. The loan is ₹3,000 thousand at an assumed 11 per cent, so interest is 330, with ₹500 thousand of principal repaid in the year. Tax is an assumed 25 per cent on a profit, and nil on a loss. Figures are rounded to the nearest thousand and each total is the sum of the rounded lines.
The input sheet: scenario drivers
| Driver | Pessimistic | Base | Optimistic |
|---|---|---|---|
| Customers served per day | 70 | 90 | 110 |
| Average bill (₹) | 330 | 350 | 370 |
| Food and beverage cost, % of sales | 35% | 32% | 30% |
First-year results (₹ thousand)
| Pessimistic | Base | Optimistic | |
|---|---|---|---|
| Customers in the year (per day × 360) | 25,200 | 32,400 | 39,600 |
| Sales (customers × bill) | 8,316 | 11,340 | 14,652 |
| Food and beverage cost | (2,911) | (3,629) | (4,396) |
| Gross profit | 5,405 | 7,711 | 10,256 |
| Fixed costs | (5,040) | (5,040) | (5,040) |
| EBITDA | 365 | 2,671 | 5,216 |
| Depreciation | (600) | (600) | (600) |
| EBIT | (235) | 2,071 | 4,616 |
| Interest | (330) | (330) | (330) |
| Profit before tax | (565) | 1,741 | 4,286 |
| Tax at 25% | nil | (435) | (1,072) |
| Profit after tax | (565) | 1,306 | 3,214 |
| Add back depreciation | 600 | 600 | 600 |
| Less loan principal repaid | (500) | (500) | (500) |
| Cash after debt service | (465) | 1,406 | 3,314 |
Checks on the base case: sales 90 × 360 = 32,400 customers × ₹350 = ₹11,340 thousand; food and beverage cost 32 per cent of 11,340 = 3,628.8, shown as 3,629; gross profit 11,340 − 3,629 = 7,711; EBITDA 7,711 − 5,040 = 2,671; EBIT 2,671 − 600 = 2,071; profit before tax 2,071 − 330 = 1,741; tax 25 per cent of 1,741 = 435.25, shown as 435; profit after tax 1,741 − 435 = 1,306; cash 1,306 + 600 − 500 = 1,406. The same chain holds in the other columns: pessimistic sales 25,200 × 330 = 8,316 and food and beverage cost 35 per cent = 2,910.6, shown as 2,911; optimistic sales 39,600 × 370 = 14,652, cost 30 per cent = 4,395.6, shown as 4,396, and tax 25 per cent of 4,286 = 1,071.5, shown as 1,072.
Answer: first-year profit after tax is ₹(565) thousand in the pessimistic case, ₹1,306 thousand in the base case and ₹3,214 thousand in the optimistic case; cash after debt service is ₹(465), ₹1,406 and ₹3,314 thousand.
What the owner reads from it
In the pessimistic case the restaurant loses money and its cash falls short by ₹465 thousand after repaying the loan: the owner needs that much in reserve or a way to defer repayment. In the base case, the business needs about 70 customers a day to cover fixed costs, depreciation and interest before tax: contribution per customer is 350 × (1 − 0.32) = ₹238, and (5,040 + 600 + 330) × 1,000 ÷ 238 = 25,084 customers a year, which is 25,084 ÷ 360 = 69.7 a day. That is a thin margin of safety against 90, and the owner should ask what ensures 90 customers a day in the first year. The technique for testing assumptions one at a time is in sensitivity and scenario analysis. This simple model ignores working capital and capital expenditure within the year; a full model adds them.
Checks and good practice
- Balance check: assets minus liabilities and equity equals zero in every period.
- Cash check: closing cash on the balance sheet equals closing cash in the cash flow.
- No hard-coding: no typed number inside a working; every figure traces to an input.
- Sign and unit check: costs carry one sign convention and units are consistent.
- Version note: date, author and the scenario in use are shown on the summary.
- Independent review: a second person tests the formulae and the logic; a forecast shown to outsiders should be read with its assumptions, as the guide on examining prospective financial information explains.
Common mistakes
- Spreading assumptions across sheets so that nobody knows what drives what.
- Typing a number into a working to make the balance sheet balance.
- Modelling revenue as a growth percentage with no link to customers and price.
- Ignoring the timing of cash, especially in the first year.
- Showing only the base case.
- Leaving out loan repayments from the cash view.
How a model's first cut is built from a business model is covered in business model types and unit economics. Cash flow forecasts also feed DCF valuation, and the repayment cover a lender looks at is in term loan appraisal and DSCR.
Need help building a financial model?
A model that an investor or lender will trust has its assumptions on one sheet, its checks visible and its scenarios switchable. Our financial modeling team can build it from your data and hand it over with the input guide.
Key takeaways
- Four layers: inputs, workings, outputs, checks.
- Every assumption sits on one labelled input sheet.
- The three statements link both ways; the balance sheet must balance without forcing.
- One scenario switch should run base, optimistic and pessimistic cases.
- Read the cash in the weakest case first.
Read next
- Business model types and unit economics
- Discounted cash flow (DCF) valuation of an unlisted company
- Projected financial statements for a bank loan
- Sensitivity and scenario analysis
Disclaimer: The figures, rates, multiples and names in the worked example are invented for illustration and are not market data. Where the article refers to law, it is based on the Companies Act, 2013 (MCA consolidated text) and the rules and live guides linked, as consulted on 6 October 2026; valuation for income-tax and FEMA purposes follows its own rules. This article is general information, not valuation, lending or legal advice; check the official text before acting.