How to Create Financial Projections for a Business Plan
A business plan can describe an exciting opportunity.
But eventually, someone will ask:
"What do the numbers look like?"
Financial projections help answer that question.
They translate your assumptions about customers, prices, sales, costs, investment and growth into numbers that show how the business could perform financially.
For an entrepreneur, financial projections aren't just something to include in a business plan for investors.
They are a tool for answering much more important questions:
How much money do I need to start?
How much will the business cost to operate?
How much do I need to sell to break even?
When could the business become profitable?
Will I have enough cash to keep operating?
Can the business support a loan?
What happens if sales are lower than expected?
This guide explains how to create realistic financial projections for a business plan.
What Are Financial Projections?
Financial projections are estimates of a business's future financial performance based on assumptions about:
Sales
Pricing
Costs
Investment
Staffing
Production
Working capital
Growth
A typical business plan may include projections for three to five years, although the appropriate period depends on the business and purpose of the plan.
Financial projections commonly include:
Sales forecast
Cost of goods sold
Profit and loss statement
Cash-flow projection
Balance sheet projection
Break-even analysis
Startup and funding requirements
The quality of the projections depends heavily on the quality of the assumptions behind them.
Why Financial Projections Matter
- They test whether the business makes financial sense
An idea may sound attractive until you put the numbers together.
You may discover that:
The margins are too low.
Startup costs are higher than expected.
Sales volume required for profitability is unrealistic.
Working capital requirements are too large.
Finding these problems early is valuable.
- They help determine how much funding you need
A business might require $200,000 to launch but another $100,000 to operate until it generates enough cash.
Without a cash-flow projection, you may underestimate your actual funding requirement.
- They help investors and lenders evaluate the opportunity
Investors want to understand the potential return.
Lenders want to know whether the business can repay the loan.
Neither should rely solely on your revenue projections.
They will want to understand the assumptions behind them.
Start With Assumptions
One of the biggest financial modelling mistakes is starting by typing numbers into a spreadsheet.
Start with the assumptions.
For example:
Sales assumptions
Number of customers
Units sold
Selling price
Purchase frequency
Growth rate
Cost assumptions
Raw-material cost
Labour
Rent
Utilities
Transportation
Marketing
Taxes
Maintenance
Operational assumptions
Production capacity
Capacity utilisation
Number of employees
Working days
Supplier payment terms
Customer payment terms
Your projections should be the mathematical result of these assumptions.
Step 1: Forecast Your Sales
Sales are usually the starting point.
A simple formula is:
Revenue = Number of units sold × Selling price
For example:
Suppose a business sells 1,000 units per month at $50 each.
1,000 × $50 = $50,000 monthly revenue
Annual revenue would be:
$50,000 × 12 = $600,000
But don't stop there.
The important question is:
Why do you believe you can sell 1,000 units per month?
That assumption should be supported by something.
For example:
Existing customers
Market research
Distributor commitments
Historical sales
Production capacity
Customer interviews
Pre-orders
Comparable businesses
Don't Confuse Capacity With Sales
Suppose your factory can produce:
10,000 units per month.
That doesn't mean you should project:
10,000 units sold per month.
Production capacity is not demand.
You might realistically sell:
2,000 units in Year 1
4,000 in Year 2
6,000 in Year 3
Your projections should reflect the market, not simply what your machinery can produce.
Step 2: Forecast Your Costs
Costs generally fall into two broad categories.
Variable costs
These change as sales or production volume changes.
Examples:
Raw materials
Packaging
Sales commissions
Transaction fees
Delivery costs
Fixed costs
These generally remain relatively stable regardless of short-term sales volume.
Examples:
Rent
Salaries
Insurance
Software
Security
Administrative expenses
Understanding the difference is important because it affects your margins and break-even point.
Step 3: Calculate Cost of Goods Sold
For businesses that sell physical products, calculate the direct cost associated with producing or purchasing the products sold.
For example:
Selling price: $100
Direct production costs:
Raw materials: $35
Packaging: $5
Direct labour: $5
Production energy: $3
Total direct cost:
$48
Gross profit per unit:
$100 − $48 = $52
Gross margin:
$52 ÷ $100 × 100 = 52%
Gross margin is an important indicator of the underlying economics of the product.
Step 4: Build Your Profit and Loss Projection
The profit and loss statement shows whether the business is expected to generate a profit.
A simplified structure is:
Revenue
− Cost of goods sold
= Gross profit
− Operating expenses
= Operating profit
− Interest and other expenses
= Profit before tax
− Taxes
= Net profit
For example:
Item Annual Amount
Revenue $1m Cost of goods sold $550k Gross profit $450k Operating expenses $250k Operating profit $200k Interest $30k Profit before tax $170k Tax $40k Net profit $130k
These numbers are illustrative. Your projections should be based on your actual business assumptions.
Step 5: Create a Cash-Flow Projection
This is one of the most important parts of the financial model.
Profit is not the same as cash.
A business can report a profit while struggling to pay its bills.
For example:
You make $100,000 in sales on credit.
The sale appears as revenue.
But your customer doesn't pay for 60 days.
Meanwhile, you must pay:
Employees
Suppliers
Rent
Electricity
Transport
You may be profitable on paper but short of cash.
That's why cash flow matters.
A Simple Cash-Flow Structure
Cash coming in
Customer payments
Loans
Investment
Other income
Cash going out
Raw materials
Salaries
Rent
Utilities
Marketing
Transportation
Loan repayments
Equipment purchases
Then calculate:
Opening cash + Cash inflows − Cash outflows = Closing cash
Your projection should ideally show that the business maintains sufficient cash throughout the period.
Step 6: Calculate Working Capital
Working capital is the money required to keep the business operating while cash moves through the business cycle.
A simple formula is:
Working Capital = Current Assets − Current Liabilities
For planning purposes, pay particular attention to:
Inventory
Accounts receivable
Accounts payable
Cash
Consider a manufacturing business.
You may purchase raw materials today.
Produce the goods next month.
Sell them the following month.
The customer may pay you 30 days later.
That's several months between spending money and receiving cash.
Your financial model needs to account for that timing.
Step 7: Calculate Your Break-Even Point
Break-even tells you how much you need to sell before the business covers its fixed costs.
The basic formula is:
Break-even units = Fixed costs ÷ Contribution per unit
Suppose:
Fixed costs = $50,000 per month
Selling price = $100
Variable cost = $60
Contribution per unit:
$100 − $60 = $40
Break-even:
$50,000 ÷ $40 = 1,250 units
You therefore need to sell approximately 1,250 units per month to cover the fixed costs under these assumptions.
This is a very useful number.
It tells you how much sales volume the business needs before it starts generating operating profit.
Step 8: Project Your Startup Costs
Startup costs are different from ongoing operating expenses.
They may include:
Business registration
Equipment
Facility setup
Renovation
Furniture
Vehicles
Technology
Initial inventory
Licences
Professional fees
Branding
Pre-launch marketing
Separate these from recurring costs.
This helps you determine how much capital is required before launch.
Step 9: Determine Your Funding Requirement
Now combine your startup costs and working-capital needs.
For example:
Startup investment
Equipment: $200k Facility: $100k Initial inventory: $50k Technology: $20k Other setup costs: $30k
Total startup cost: $400k
Then determine the amount required to operate until the business becomes sufficiently cash-generative.
Suppose working capital required is:
$150k
Total funding requirement:
$550k
This is far more useful than simply saying:
"We need $550,000."
Your financial model should explain why you need it.
Step 10: Create Different Scenarios
Never rely on one projection.
Create at least three scenarios:
Conservative
Lower sales, higher costs and slower growth.
Base case
Your most realistic expectations.
Optimistic
Strong sales and favourable operating conditions.
For example:
Scenario Year 1 Revenue Net Profit
Conservative $600k $30k Base $800k $100k Optimistic $1m $180k
The purpose isn't to make the optimistic case look impressive.
It's to understand how sensitive the business is to changes in assumptions.
Step 11: Stress-Test Your Business
Go beyond three scenarios.
Ask:
What if sales are 30% lower?
Can the business survive?
What if raw-material prices increase 20%?
Do margins remain acceptable?
What if customers pay 60 days late?
Will you have enough cash?
What if the launch is delayed?
How much additional capital will you need?
What if your largest customer leaves?
Can the business survive?
This is called sensitivity or scenario analysis.
It can reveal weaknesses that a single projection hides.
Step 12: Be Realistic About Growth
A common mistake is projecting explosive growth simply because the entrepreneur wants the business to grow.
For example:
Year 1: $100k Year 2: $500k Year 3: $2m Year 4: $5m
Such growth may be possible.
But you need to explain what causes it.
Does it come from:
New locations?
New products?
More production capacity?
New distributors?
Increased marketing?
Export markets?
Additional employees?
Growth should have an operational explanation.
Step 13: Calculate Important Financial Ratios
Some useful metrics include:
Gross margin
Gross profit ÷ Revenue × 100
Shows how much revenue remains after direct costs.
Net profit margin
Net profit ÷ Revenue × 100
Shows how much of revenue remains after expenses.
Return on investment
Profit ÷ Investment × 100
Provides an indication of the return generated on invested capital.
Current ratio
Current assets ÷ Current liabilities
Provides an indication of short-term financial strength.
Debt service coverage
For businesses with significant debt, this helps assess whether operating cash flow can support debt payments.
The exact ratios that matter depend on the business.
Common Financial Projection Mistakes
- Overestimating revenue
This is probably the most common mistake.
A projection isn't a wish.
It is an argument supported by assumptions.
- Underestimating costs
Don't forget:
Maintenance
Taxes
Logistics
Marketing
Repairs
Insurance
Software
Working capital
Unexpected expenses
- Ignoring cash flow
Profitability doesn't guarantee liquidity.
- Assuming 100% capacity
Very few new businesses operate at full capacity immediately.
- Using unrealistic growth rates
Growth should be supported by an expansion strategy.
- Mixing personal and business finances
Keep them separate.
- Hiding assumptions
A financial model becomes more credible when assumptions are clearly stated.
- Making the numbers look good
A realistic projection showing challenges is more useful than an unrealistic projection showing enormous profits.
How Long Should Financial Projections Be?
For many business plans:
3–5 years is a reasonable planning horizon.
But the level of detail can vary.
A practical approach is:
Year 1
Monthly projections.
Years 2–3
Monthly or quarterly, depending on the business.
Years 4–5
Annual projections.
The first year deserves more detail because that's when cash-flow problems are most likely to occur.
A Simple Financial Projection Structure
At minimum, your model should contain:
Revenue model
Customers
Units
Prices
Growth
Cost model
Variable costs
Fixed costs
Staffing
Operating expenses
Startup model
Capital expenditure
Setup costs
Initial working capital
Profit & loss
Revenue
COGS
Gross profit
Operating expenses
Net profit
Cash flow
Cash inflows
Cash outflows
Opening cash
Closing cash
Balance sheet
Assets
Liabilities
Equity
Break-even
Fixed costs
Contribution margin
Break-even volume/revenue
Scenarios
Conservative
Base
Optimistic
Your Financial Model Should Tell a Story
A good financial model isn't simply a spreadsheet full of numbers.
It should tell a logical story.
For example:
We target 10,000 customers.
↓
Each customer generates an average of $200 annually.
↓
This produces $2 million in revenue.
↓
Direct costs represent 45%.
↓
Gross profit is $1.1 million.
↓
Operating expenses are $700,000.
↓
Operating profit is $400,000.
Each number should connect to something in the actual business.
If someone asks:
"Why is revenue $2 million?"
You should be able to explain exactly where it came from.
Final Thoughts
Financial projections aren't about predicting the future with perfect accuracy.
Nobody can do that.
They are about turning your assumptions into a structured model that allows you to ask:
Does this business make financial sense?
How much capital does it require?
What level of sales is necessary?
When could it become profitable?
How much cash will it need?
What happens if things don't go according to plan?
The best financial model isn't necessarily the one with the biggest projected revenue.
It is the one that gives you the clearest understanding of the business.
Before presenting your numbers to an investor or lender, make sure you can explain every major assumption behind them.
Don't build financial projections to impress people. Build them to make better decisions.
LoDuko guides entrepreneurs through the business questions that feed into their market, operational and financial thinking, then turns that information into professional feasibility reports, business plans and pitch decks.
Better numbers begin with better business assumptions.
Explore LoDuko →