Financial Projections for a Business Plan: Step-by-Step Guide

Financial projections for a business plan translate your idea or expansion plan into numbers that a bank, investor or your own team can test. Good projections answer three questions: how much revenue and profit can this business make, how much cash will it need before it becomes self-sustaining, and what has to be true for the plan to work. Weak projections, built top-down from optimistic market percentages, are one of the main reasons loan applications and investor pitches stall. This guide walks through a complete three-year projection for a hypothetical startup, from assumptions to P&L, working capital, cash flow and funding need, and explains what reviewers look for.

The Building Blocks

1. Assumptions sheet: every driver in one place, with its source
2. Revenue model: volume x price, built bottom-up
3. Cost model: variable costs per unit and fixed costs line by line
4. Headcount plan: roles, joining dates, salaries
5. Capex and depreciation schedule
6. Financing schedule: loans, interest, repayments, equity
7. Projected P&L
8. Working capital schedule: receivables, inventory, payables
9. Projected cash flow and funding need
10. Projected balance sheet (needed for bank loans)
11. Scenarios and break-even

Step 1: Write Down Assumptions First

Consider a hypothetical Indore startup making packaged spice blends for restaurants and retailers. Its key assumptions:

Assumption	Year 1	Year 2	Year 3	Basis
Revenue (₹ lakh)	120	240	360	Customer pipeline and capacity; see below
Gross margin	35%	37%	38%	Recipe costing; better purchasing with scale
Salaries (₹ lakh)	30	45	60	Headcount plan
Rent (₹ lakh)	9	9	12	Lease, larger unit in year 3
Marketing (₹ lakh)	12	18	24	Trade activations and samples
Other overheads (₹ lakh)	6	9	12	Estimates
Capex (₹ lakh)	40	0	0	Machinery quotations
Term loan (₹ lakh)	30			At 10.5%, 5 years
Debtor days	60	60	60	Trade norms for restaurant and distributor customers
Inventory days (on COGS)	45	45	45	Raw spice buying cycles
Creditor days (on COGS)	30	30	30	Supplier terms

Build revenue bottom-up

Year 1 revenue of ₹120 lakh, or ₹10 lakh a month on average, might come from 60 restaurant customers ordering ₹8,000 a month (₹4.8 lakh) plus 4 distributors buying ₹1.3 lakh a month each (₹5.2 lakh). Each of those numbers can be checked against sales capacity, trial orders and pricing. A projection that says "1% of a ₹10,000 crore market" cannot.

Headcount plan behind the salary line

Role (year 1)	Number	Annual cost (₹ lakh)
Production supervisor	1	4.8
Production and packing staff	4	12.0
Sales executive	1	4.8
Accounts and admin	1	3.6
Founders' modest salaries	2	4.8
Total	9	30.0

Including founders' salaries, even modest ones, makes the projection honest. A plan that only works if founders draw nothing for three years is fragile.

Step 2: Projected Profit and Loss

₹ lakh	Year 1	Year 2	Year 3
Revenue	120.0	240.0	360.0
Cost of goods sold	(78.0)	(151.2)	(223.2)
Gross profit	42.0	88.8	136.8
Salaries	(30.0)	(45.0)	(60.0)
Rent	(9.0)	(9.0)	(12.0)
Marketing	(12.0)	(18.0)	(24.0)
Other overheads	(6.0)	(9.0)	(12.0)
EBITDA	(15.0)	7.8	28.8
Depreciation (₹40 lakh over 10 years)	(4.0)	(4.0)	(4.0)
Interest on term loan (approximate)	(3.0)	(2.4)	(1.7)
Profit before tax	(22.0)	1.4	23.1

The business loses ₹22 lakh in year 1, roughly breaks even in year 2 and earns ₹23.1 lakh before tax in year 3. Losses carried forward reduce tax in year 3, subject to the tax law conditions applicable to the entity. Interest declines as the loan is repaid. Depreciation here is simplified straight-line; tax depreciation follows different rules.

Step 3: Working Capital Schedule

This is the step most first-time projections skip, and it is often the largest use of cash.

• Receivables = Revenue x 60 / 365
• Inventory = COGS x 45 / 365
• Payables = COGS x 30 / 365

₹ lakh	Year 1	Year 2	Year 3
Receivables	19.7	39.5	59.2
Inventory	9.6	18.6	27.5
Payables	(6.4)	(12.4)	(18.3)
Net working capital	22.9	45.7	68.4
Increase in the year	22.9	22.8	22.7

Every year of growth absorbs about ₹23 lakh into working capital. Our explainer on working capital covers the concept in depth.

Step 4: Cash Flow and Funding Need

₹ lakh	Year 1	Year 2	Year 3
EBITDA	(15.0)	7.8	28.8
Increase in working capital	(22.9)	(22.8)	(22.7)
Capex	(40.0)	0.0	0.0
Interest paid	(3.0)	(2.4)	(1.7)
Loan principal repaid	(6.0)	(6.0)	(6.0)
Tax paid (assumed minimal due to carried-forward losses)	0.0	0.0	(0.6)
Net cash flow before funding	(86.9)	(23.4)	(2.2)
Term loan drawn	30.0	0.0	0.0
Gap to fund from equity or other sources	(56.9)	(23.4)	(2.2)

Even though the business is profitable by year 3, it still does not generate surplus cash in year 3 because growth keeps absorbing working capital. The founders need about ₹82.5 lakh of equity or other funding over three years (56.9 + 23.4 + 2.2) on top of the ₹30 lakh loan, plus a buffer of perhaps 15% to 20% for delays: roughly ₹95 lakh to ₹1 crore. A working capital limit from a bank, once the business has a track record, could fund part of the receivables and inventory and reduce the equity need. Our comparison of cash credit, overdraft and working capital loans explains the options.

The principal repayment of ₹6 lakh a year assumes equal annual principal instalments on the ₹30 lakh loan over five years, a simplification for illustration.

Step 5: Break-Even and Scenarios

Break-even revenue

In year 2, fixed costs (salaries, rent, marketing, other overheads, depreciation and interest) total 45 + 9 + 18 + 9 + 4 + 2.4 = ₹87.4 lakh. At a 37% gross margin, break-even revenue is 87.4 / 0.37 = about ₹236 lakh. Projected revenue of ₹240 lakh is only just above it, which matches the thin year 2 profit. See how to calculate break-even point.

Scenarios

Scenario	Change	Year 3 PBT (₹ lakh, approx.)
Base	As above	23.1
Revenue 20% lower	₹288 lakh in year 3	about minus 4.3
Gross margin 3 points lower	35% in year 3	about 12.3

With revenue 20% lower, gross profit falls by ₹27.4 lakh (72 x 38%), turning year 3 PBT to about minus ₹4.3 lakh if costs do not flex. A 3-point margin drop on ₹360 lakh removes ₹10.8 lakh. Reviewers will ask how the plan responds in these cases, for example by delaying hires or marketing spend.

Step 6: The Projected Balance Sheet

For bank loans, you will also need projected balance sheets. They are built from the schedules you already have:

• Fixed assets: capex minus accumulated depreciation (₹40 lakh minus ₹4 lakh = ₹36 lakh at the end of year 1)
• Current assets: receivables and inventory from the working capital schedule, plus closing cash
• Current liabilities: payables, plus the current portion of the term loan
• Term loan: opening balance plus drawdowns minus repayments (₹30 lakh minus ₹6 lakh = ₹24 lakh at the end of year 1)
• Equity: capital introduced plus cumulative profits or minus cumulative losses

If the balance sheet does not balance, there is an error in one of the schedules; usually a cash flow item that was not reflected elsewhere. A balancing check is the simplest test of a model's integrity.

Presenting Projections

Lead with a one-page summary: revenue, EBITDA, profit, cash need and key ratios for each year, followed by the five or six assumptions that matter most. Put detailed schedules in an appendix. State clearly which numbers are commitments (signed orders, sanctioned loans) and which are estimates. Reviewers trust projections that are transparent about uncertainty more than those that look precise.

What Banks and Investors Check

• Assumptions with evidence: pipeline, trial orders, quotations, industry norms
• Internal consistency: revenue growth matched by capacity, headcount and working capital
• Cash, not just profit: funding need and timing
• Debt service coverage: for loans, DSCR comfortably above 1 in each year after any moratorium; see financial KPIs
• Promoter contribution: how much of their own money founders are putting in
• Sensitivity: what happens if sales are slower or margins thinner

Common Mistakes

• Top-down market share revenue instead of bottom-up customer models
• Hockey-stick growth with flat headcount and costs
• No working capital schedule, understating funding needs
• Including GST in revenue and costs
• Ignoring loan principal repayments in cash flow
• Single scenario with no downside case
• Assumptions buried inside formulas rather than in one visible sheet

From Projections to Actuals

Projections are most valuable when you compare them against actual results every month. Fininvo ERP's budgets and cost centres let you load your projection as a budget, and comparative financial reports show variances as the year unfolds. See pricing. This article is general information, not financial or investment advice.

Frequently Asked Questions

How many years should financial projections cover?

Three years is common for small business plans; banks often ask for projections covering the loan tenure, which may be five years or more.

Do I need a projected balance sheet?

For bank loans, usually yes, because lenders calculate ratios such as current ratio, debt to equity and DSCR from projected balance sheets and P&Ls.

How detailed should revenue assumptions be?

Detailed enough to be checked: customers or channels, volumes and prices by month for year 1, and by quarter or year thereafter.

Why is my projected business profitable but still needing cash?

Growth absorbs cash into receivables and inventory, and loan principal and capex are cash outflows not shown as expenses in the P&L.

Should projections be conservative or optimistic?

Present a realistic base case supported by evidence, with a clearly labelled downside scenario. Overly optimistic projections reduce credibility with lenders and investors.