Financial projections: How to create them for your small business

Published Friday 3 July 2026

Table of contents

• What are financial projections?
• Financial projections vs financial forecasts
• Why financial projections matter
• What goes into a financial projection?
• How to create financial projections
• Creating financial projections for a startup
• Is there a financial projections template?
• Build projections with confidence using Xero
• FAQs on financial projections

Key takeaways

• Financial projections combine a projected income statement, cash flow statement, and balance sheet to show profit, cash position, and runway over the next 12–36 months.
• Start with a few revenue drivers like units sold or client contracts, map costs monthly, and model cash timing to see when money comes in and goes out.
• Document your core assumptions and run best-case, base-case, and worst-case scenarios to test your plan against different market conditions.
• Use a simple financial projections template to update numbers quickly and share clear, lender-ready projections with banks or investors.

What are financial projections?

Financial projections are forward-looking estimates of your business's future revenue, costs, profit, cash, assets, and liabilities. They show what you expect to happen financially over a set period, usually monthly for year one and annually for years two through five.

Unlike a financial forecast, which often updates based on real-time data and recent trends, projections are built from assumptions about growth, pricing, and spending. They give you a structured view of where your business is headed so you can plan hiring, inventory, equipment purchases, and funding needs.

A complete set of business financial projections includes three core statements: a projected income statement (also called a profit and loss statement), a cash flow projection, and a projected balance sheet. Together, these documents show whether you'll be profitable, whether you'll have enough cash to operate, and how your assets and liabilities will change over time.

Small businesses use projections to answer questions like: Can I afford to hire next quarter? Will I need a loan to cover a seasonal dip? When will I break even? By building projections early and updating them regularly, you turn uncertainty into a testable plan.

Financial projections vs financial forecasts

While the terms are often used together, financial projections and financial forecasts serve different purposes. Understanding the difference helps you create the right report for the right situation.

A financial projection is a forward-looking model built on assumptions about how your business could perform. You set the inputs, such as growth rates and hiring plans, and the model shows the likely outcome. Projections are typically used for strategic planning, loan applications, and investor decks, where you need to demonstrate a plausible financial future.

A financial forecast is a shorter-term, data-driven prediction that updates regularly based on your actual results. Forecasts rely on recent performance and trends, making them more useful for operational decisions like managing inventory, staffing, and short-term cash flow.

In practice, most small businesses use both. You can start with projections to set your plan and secure funding, then use forecasts to track performance against that plan and adjust as conditions change.

Why financial projections matter

Business financial projections help you make decisions with clear, testable numbers instead of guesswork. They show you when cash might run short, when you can afford to invest in growth, and whether your business model is sustainable.

Lenders and investors expect to see projections before they commit capital. A bank reviewing a loan application wants proof that you can repay the loan from future cash flow. An investor wants to see that your revenue will grow faster than your costs. Projections give them the evidence they need.

Internally, projections guide your hiring, inventory, and spending plans. If your projections show a cash shortfall in month six, you can delay a purchase, negotiate payment terms, or secure a line of credit before the problem hits. If projections show strong margins, you can confidently invest in marketing or equipment.

Projections also help you test assumptions. What happens if sales grow 20% slower than expected? What if a key supplier raises prices? By running scenarios, you identify risks early and build contingency plans.

For startup business financial projections, the exercise is even more critical. Startups have no history to rely on, so projections become the business plan's financial backbone. They show whether the idea is viable, how much funding you need, and when you'll reach profitability.

What goes into a financial projection?

A complete financial projection includes three core statements and two supporting documents. Each piece connects to the others, so changes in one area flow through the entire model.

Projected income statement

The projected income statement lists your expected revenue, cost of goods sold (COGS), operating expenses, and net income. It shows whether your business will be profitable over the projection period.

Start with revenue projections based on drivers like units sold, average sale price, or number of clients. Subtract COGS to get gross profit, then subtract operating expenses like payroll, rent, marketing, and software to arrive at net income.

Include seasonality if your business has predictable highs and lows. A retail business might project higher revenue in November and December, while a landscaping business might see stronger sales in spring and summer.

Cash flow projection

Cash flow projections show the timing of cash in and cash out. Revenue doesn't always mean cash – if you invoice a client in January but don't get paid until March, your cash flow lags your income statement.

Start with your projected net income, then adjust for non-cash items like depreciation. Add back any expenses that don't require cash this period, and subtract cash spent on inventory, equipment, or loan principal. Factor in payment terms: if customers pay in 30 days and suppliers expect payment in 15, your cash timing matters.

A cash flow projection answers the question: Will I have enough cash in the bank to cover payroll, rent, and bills each month? It's the most important statement for day-to-day operations.

For a detailed walkthrough of building cash flow projections, see Xero’s cash flow projection guide.

Projected balance sheet

The projected balance sheet summarizes your assets, liabilities, and equity at the end of each period. It shows what you own (cash, inventory, equipment), what you owe (loans, payables), and what's left for owners (also called your equity).

Each month's balance sheet ties to the cash flow statement. If your cash flow projection shows $10,000 in net cash generated, your balance sheet cash account increases by $10,000. If you buy $5,000 in inventory, your inventory asset goes up and cash goes down.

The balance sheet ensures your projections are internally consistent. Assets must equal liabilities plus equity every month. If they don't, you've made an error in your modeling.

Break-even analysis

Break-even analysis calculates the sales volume or revenue needed to cover all your costs – both fixed costs like rent and variable costs like materials. Once you know your break-even point, you can set realistic sales targets and measure progress.

To calculate break-even, divide your fixed costs by your contribution margin (revenue minus variable costs per unit). The result tells you how many units you need to sell, or how much revenue you need to generate, before you start making a profit.

Assumptions sheet

The assumptions sheet records the inputs behind your projections: pricing, unit volume, growth rates, seasonality, payment terms, and funding plans. It's the foundation of your model.

Document assumptions like: "We expect to sell 500 units per month in Q1, growing 10% per quarter. Average sale price is $50. Customers pay in 30 days. We'll hire one salesperson in month six at $4,000 per month."

Clear assumptions make it easy to update projections, run scenarios, and explain your numbers to lenders or investors. When assumptions change, you can quickly see how the change flows through your income, cash, and balance sheet.

How to create financial projections

Building financial projections doesn't require complex software or advanced accounting skills. Follow these steps to create a simple, reliable model.

1. Gather your data and clean your history

Start by collecting the past 12–24 months of financial data if you're an existing business. Pull profit and loss statements, balance sheets, and cash flow statements from your accounting software. Reconcile your accounts so the numbers are accurate.

Group accounts into consistent categories, like revenue, costs of goods sold (COGS), payroll, rent, marketing, and so on. Look for trends: Are sales growing? Are margins stable? Do costs spike in certain months?

If you're a startup, gather data from comparable businesses, industry benchmarks, or market research. Talk to other business owners in your space to understand typical costs, pricing, and growth rates.

Clean data makes projections easier to build and more reliable. If your historical numbers are messy, spend time fixing them before you project forward.

2. Forecast revenue with simple drivers

Revenue projections start with a small set of drivers. For a product business, drivers might be units sold and average price. For a service business, drivers might be billable hours and hourly rate. For a subscription business, drivers might be new customers, churn rate, and average contract value.

Choose drivers that match your sales and marketing plans. If you're launching a new product, estimate how many units you'll sell based on your marketing budget, conversion rates, and sales cycle. If you're adding a salesperson, estimate how many deals they'll close per month.

Include seasonality if your business has predictable patterns. Retail businesses often see higher sales in the fourth quarter. Landscaping businesses see higher sales in spring and summer. Accounting firms see spikes around tax deadlines.

Model payment terms to reflect when cash actually arrives. If you invoice clients and they pay in 30 days, your cash flow lags your revenue by a month. If you sell online and customers pay immediately, cash and revenue align.

3. Estimate cost of goods sold and margins

Use recent gross margins as a baseline, then adjust for expected changes in pricing, supplier terms, or product mix. If you're launching a new product with higher margins, factor that in. If a supplier is raising prices, increase your COGS accordingly.

For inventory-based businesses, plan inventory purchases in both expense and cash timing. If you buy $10,000 in inventory in January but sell it in March, your cash goes out in January and your revenue comes in March.

Track margin trends over time. If you see margins change, look at drivers such as supplier costs, pricing, or product mix, and adjust your plan.

4. Map operating expenses with monthly detail

Separate fixed and variable costs. Fixed costs like rent, insurance, and software subscriptions stay the same each month. Variable costs like shipping, transaction fees, and commissions change with sales volume.

Include payroll and benefits with realistic timing. If you plan to hire a new employee in month six, add their salary, payroll taxes, and benefits starting in that month. Don't forget to include your own salary if you're paying yourself.

Align expense timing with expected cash outflows. Rent is usually due on the first of the month. Payroll might be bi-weekly. Supplier invoices might have 15- or 30-day terms. Model when cash actually leaves your account, not just when you incur the expense.

Add a buffer for unexpected costs. Equipment breaks, software prices increase, and marketing campaigns don't always deliver expected results. A 5–10% contingency line gives you room for surprises.

5. Build your projected profit and loss

Combine revenue, COGS, and operating expenses to create a clear projected income statement. Start with revenue at the top, subtract COGS to get gross profit, then subtract operating expenses to arrive at net income.

Check margin trends month by month. Is gross margin consistent? Are operating expenses growing faster than revenue? If net income turns negative, identify which months and why.

A well-structured income statement shows whether your business model is profitable. If your projections do not show a profit, adjust your pricing, costs, or growth plans until they do.

For more context on budgeting and planning, see this guide on how to create a small business budget.

6. Prepare your cash flow projection

Start from net income on your projected income statement, then adjust for timing differences between income and cash. Add back non-cash expenses like depreciation, and subtract cash spent on inventory, equipment, and loan principal.

Adjust for receivables and payables. If customers pay in 30 days, subtract the increase in accounts receivable. If you pay suppliers in 15 days, add the increase in accounts payable.

Include all cash inflows, like customer payments, loans, equity investments, and tax refunds. Include all cash outflows: supplier payments, payroll, taxes, loan payments, and capital purchases.

The result is your projected cash balance at the end of each month. To keep your cash balance positive, secure a line of credit, adjust spending, or speed up collections before a shortfall appears.

7. Build your projected balance sheet

Link your cash, receivables, inventory, payables, debt, and equity so assets equal liabilities plus equity every month. Start with your current balance sheet (or a simple starting point if you're a startup), then update each account based on your income statement and cash flow projection.

If your cash flow projection shows $5,000 in net cash generated, increase your cash account by $5,000. If you buy $3,000 in inventory, increase inventory and decrease cash. If you take out a $20,000 loan, increase cash and increase long-term debt.

The balance sheet is the final check that your projections are internally consistent. Assets must equal liabilities plus equity every month, so review your income statement and cash flow for errors to keep the balance sheet in line.

8. Run scenarios and find your break-even point

Create best-case, base-case, and worst-case scenarios to test your assumptions. In the best case, revenue grows faster than expected and costs stay low. In the worst case, revenue grows slower and costs increase.

Adjust key assumptions in each scenario – growth rates, pricing, hiring plans, supplier costs – and see how the changes flow through your income, cash, and balance sheet. This exercise shows you which assumptions matter most and where you might be more vulnerable than you’d like.

Calculate your break-even point by dividing fixed costs by contribution margin (which is revenue minus variable costs). The result tells you how much revenue you need to cover all costs. Then, track progress toward break-even month by month.

Scenario planning turns projections into a decision-making tool. Instead of one rigid forecast, you have a range of outcomes and a plan for each.

9. Avoid these common projection errors

Even experienced business owners make mistakes when building projections. Here are the most common errors and how to avoid them:

• Use drivers that match your sales and marketing plans. For example, don't project 50% revenue growth if you're not investing in marketing or hiring salespeople. Make sure your revenue assumptions are grounded in realistic actions.
• Reflect cash timing for receivables, inventory, payroll, taxes, and capital spends. Revenue doesn't equal cash. Model when cash actually moves in and out of your business.
• Include payroll taxes, benefits, and payment processing fees. These costs add 20–30% to base salaries and 2–3% to revenue. Forgetting them makes projections too optimistic.
• Update monthly and run scenarios before big decisions. You need to review and update your projections regularly. Review actuals versus projections each month, adjust assumptions, and re-run scenarios before making major investments.

Creating financial projections for a startup

Startup financial projections follow the same structure as those for an established business, but without historical data to anchor your numbers. In effect, this may change how you build your assumptions, and which data you choose.

Here is how to approach projections when starting from scratch:

1. Research industry benchmarks

Use trade associations, industry reports, and publicly available data to find typical revenue ranges, gross margins, and cost structures for businesses like yours. These benchmarks replace the historical data you do not yet have.

Look for industry-specific metrics that apply to your business model. A software startup might focus on customer acquisition cost and monthly recurring revenue, while a retail business might look at inventory turnover and gross margin per square foot. Government databases, trade publications, and industry associations often publish this data for free.

2. Build from the bottom up

Rather than projecting a top-line revenue number and working down, start with the specific actions that generate revenue. Consider how many customers you can realistically reach, your expected conversion rate, and your average sale value. Multiply these drivers to arrive at a revenue figure grounded in real activity.

For example, if you plan to make 100 sales calls per month with a 10% conversion rate and an average sale of $500, your monthly revenue projection would be $5,000. This approach forces you to think through the actual mechanics of generating sales rather than hoping for a round number.

3. Use conservative assumptions

Overestimating revenue and underestimating costs is the most common startup projection mistake. Set your base case below what you hope for, then model an optimistic scenario separately to see what is possible under ideal conditions.

Build in extra time for product development, customer acquisition, and hiring. Most startups take longer to reach milestones than founders initially expect, and conservative projections help you plan for realistic timelines and funding needs.

4. Project monthly for the first 24 months

Cash moves fast in the early stages. Monthly projections show exactly when you might need to raise capital, cut costs, or accelerate sales before a shortfall becomes a crisis.

After the first two years, you can switch to quarterly or annual projections as your business model stabilizes and cash flow becomes more predictable. The key is having enough detail in the critical early period when every month matters.

Is there a financial projections template?

A financial projections template speeds up the setup process, helps you share a financial projections example with lenders or investors, and keeps your numbers consistent across a 12-month detailed view plus a 3-year financial projections summary.

What to include in your template

A good template includes structured tabs for assumptions, revenue drivers, projected income statement, cash flow, balance sheet, and break-even analysis. Each tab links to the others so changes in assumptions automatically update all three financial statements.

• Assumptions tab: List growth rates, pricing, unit volume, payment terms, hiring plans, and capital spends. Think of this as the control panel for your entire model.
• Revenue drivers tab: Calculate revenue from units, pricing, and seasonality. Link these drivers to your income statement.
• Projected income statement tab: Show revenue, COGS, operating expenses, and net income month by month for year one, then annually for years two and three.
• Cash flow tab: Start from net income, adjust for timing, and calculate ending cash each month.
• Balance sheet tab: Show assets, liabilities, and equity at the end of each period.
• Break-even tab: Calculate the revenue or unit volume needed to cover fixed costs.

Keep inputs simple and outputs clear

Design your template so inputs are easy to find and change. Use color coding or separate sections for assumptions so you don't accidentally overwrite formulas.

Add scenario toggles, like best, base and worst, so you can test sensitivity quickly. A simple dropdown or checkbox lets you switch between scenarios and see how the numbers change.

Show outputs clearly with charts for revenue, expenses, profit, and cash runway. A visual dashboard makes it easier to spot trends and explain projections to others.

Save a startup version with monthly detail

For startup business financial projections, monthly detail in years one and two is critical. Startups burn through cash quickly, and monthly projections help you see exactly when you'll need to raise capital or cut costs.

After year two, annual projections are usually sufficient. The further out you project, the less accurate the numbers become, so focus your effort on the near term.

Download a free cash flow forecast template to get started, or build your own in a spreadsheet using the same tabs and links described in this section.

Build projections with confidence using Xero

Financial projections turn uncertainty into a plan you can test and update. By combining an income statement, cash flow, and balance sheet, you get a clear view of profit, cash, and runway over the next 12–36 months.

Start with clean data, simple revenue drivers, and monthly costs. Run a few scenarios, then update regularly as actuals come in.

Xero keeps your books up to date with automated bank feeds, invoicing, and reliable reports - so you can update projections in minutes, not hours. Get one month free and see how much easier planning can be.

FAQs on financial projections

Here are answers to common questions about building, using, and updating financial projections for your small business.

What is the difference between financial projections and a financial forecast?

Financial projections are forward-looking estimates built from assumptions about growth, pricing, and spending. They're typically used for business planning, fundraising, and loan applications, and they cover 12–36 months with monthly or annual detail.

A financial forecast is a more dynamic, short-term prediction that updates frequently based on recent trends and real-time data. Forecasts are often used for operational decisions like inventory planning or staffing, and they may be updated weekly or monthly.

Both tools help you plan for the future, but projections are broader and more assumption-driven, while forecasts are narrower and more data-driven.

How far out should I project my finances?

For most small businesses, monthly projections for year one and annual projections for years two and three are sufficient. Lenders and investors typically want to see at least three years of projections to understand long-term viability.

Startups should focus on monthly detail for the first 12–24 months, since cash flow is tight and timing matters. Established businesses with stable revenue can use quarterly or annual projections for years two and three.

The further out you project, the less accurate the numbers become. Focus your effort on the near term, and update projections regularly as new information becomes available.

How do I create financial projections for a startup with no history?

Startups build projections using industry benchmarks, market research, and comparable business data. Start by researching typical revenue ranges, gross margins, and cost structures for businesses like yours through trade associations, industry reports, and government databases.

Build your revenue projections from the bottom up by estimating how many customers you can realistically reach, your expected conversion rate, and your average sale value. Use conservative assumptions to avoid over-optimistic projections, and focus on monthly detail for the first 24 months when cash flow timing is critical.

What is a 5-year financial projection and when do you need one?

A 5-year financial projection extends your planning horizon to show long-term growth potential and business viability. It typically includes annual projections for years three through five, with less detail than your monthly projections for year one.

You need 5-year projections when seeking significant funding from investors or lenders who want to see long-term returns. They're also useful for strategic planning, especially if you're considering major investments in equipment, facilities, or market expansion that will take several years to pay off.

What if my projections show I'll run out of cash?

If your projections show negative cash in a future month, you have several options. You can delay non-essential spending, accelerate collections by tightening payment terms or offering early-payment discounts, negotiate longer payment windows with suppliers, or secure a line of credit before you need it.

If the shortfall is structural rather than seasonal, you may need to raise equity or debt capital to fund operations until you reach profitability. The earlier you identify a cash shortfall through projections, the more options you have to solve the problem before it becomes a crisis.