How to Build Financial Projections for Your Startup

Financial projections feel intimidating because most founders think they need to be precise. They don't. Projections aren't predictions — they're structured assumptions that show you understand the economics of your business.

Banks want to see that you can repay a loan. Investors want to see that the math works at scale. And you need to see how much runway you have before the money runs out. This guide shows you how to build all three without a finance degree.

What Financial Projections Actually Are

Financial projections are a forward-looking model of your business's money: how much comes in, how much goes out, and what's left over. For most startups, you need three things:

A Profit and Loss statement (P&L) that shows revenue minus costs equals profit (or loss) for each month.

A Cash Flow statement that tracks your actual bank balance month by month — because you can be profitable on paper and still run out of cash.

An Assumptions sheet that documents every number you plugged in and why. This is what separates a credible model from fiction.

Start With Assumptions, Not Revenue

The biggest mistake founders make is starting with a revenue target and working backwards. "I want to make $500K in Year 1" isn't a projection — it's a wish.

Instead, start with the inputs you can actually estimate:

Revenue assumptions:

• How many customers can you realistically acquire per month?
• What will you charge them?
• What's a reasonable monthly growth rate?

For a new business with no existing audience, 5-15% monthly growth is ambitious but achievable. For a business with an existing audience or strong distribution channel, 15-25% is possible. Anything above 30% month-over-month needs a very good explanation.

Cost assumptions:

• What are your fixed costs? (Rent, software, insurance — things you pay regardless of sales)
• What are your variable costs? (Cost of goods sold, transaction fees, shipping — things that scale with revenue)
• How much will you spend on marketing, and how fast will that grow?
• How much will you pay yourself and any employees?

Document every assumption. When an investor or lender asks "where does this number come from?" you need an answer better than "I guessed."

Building the P&L (Month by Month)

Your Profit and Loss statement has three sections:

Revenue

Start with your Month 1 revenue assumption and apply your monthly growth rate. If you're projecting $5,000 in Month 1 with 10% monthly growth, Month 2 is $5,500, Month 3 is $6,050, and so on.

If you have multiple revenue streams, model each one separately and sum them.

Cost of Goods Sold (COGS)

These are the direct costs of delivering your product or service. For a product business, this is the cost of materials and manufacturing. For a SaaS company, it might be hosting and support costs. For a service business, it's the cost of labour to deliver the service.

Express COGS as a percentage of revenue. This makes the model dynamic — as revenue grows, COGS scales proportionally. Typical COGS percentages vary by industry: 25-40% for product businesses, 10-20% for software, 40-60% for services.

Revenue minus COGS gives you Gross Profit. Track your gross margin percentage — it tells you how much of each dollar you keep before overhead.

Operating Expenses

These are your fixed costs — the ones you pay regardless of how much you sell:

• Salaries and wages (including your own)
• Rent and utilities
• Marketing and advertising
• Software and tools
• Insurance
• Professional services (accounting, legal)
• Miscellaneous

Some of these grow over time (salaries as you hire, marketing as you scale), so apply growth rates where appropriate.

Gross Profit minus Operating Expenses gives you EBITDA (earnings before interest, taxes, depreciation, and amortization). This is your operating profit — the clearest measure of whether the business works.

Subtract estimated taxes (only on profitable months) and you get Net Profit.

Building the Cash Flow Statement

Here's where many founders get tripped up. Your P&L can show a profit while your bank account hits zero. How? Because:

• You might pay suppliers before customers pay you
• You might invest in inventory before making sales
• You might have large upfront costs (equipment, deposits) that don't appear on the P&L as monthly expenses

The cash flow statement is simpler than the P&L. It tracks three things each month:

Beginning cash: Your bank balance at the start of the month.

Cash in minus cash out: Revenue collected minus all costs paid (COGS + operating expenses + taxes).

Ending cash: Beginning cash plus net cash flow. This becomes next month's beginning cash.

Watch for months where ending cash dips below zero. That's when you run out of money. If your model shows negative cash in Month 4, you know you need more starting capital, lower costs, or faster revenue growth.

The Assumptions Sheet

This is arguably the most important part of your model. It's where every input lives in one place, making it easy to adjust scenarios.

A good assumptions sheet includes:

• Starting monthly revenue
• Monthly revenue growth rate
• Average price per unit or customer
• COGS as a percentage of revenue
• Each operating expense category with its starting amount and growth rate
• One-time startup costs
• Tax rate

When all your formulas reference the assumptions sheet, you can change one number and watch the entire model update. This is how you run scenarios: "What if growth is 8% instead of 12%?" "What if we hire two months later?" "What if marketing costs double?"

Common Projection Mistakes

Being too optimistic on revenue. Most first-time founders overestimate revenue by 2-3x. Be conservative. It's better to beat your projections than to miss them.

Being too optimistic on costs. Everything costs more and takes longer than you think. Add a 10-20% buffer to your expense estimates.

Ignoring seasonality. Many businesses have slow months and busy months. A flat growth curve looks clean but isn't realistic for most industries.

Forgetting about cash timing. If you invoice net-30, you won't see that cash for a month after the sale. If you prepay for inventory, that cash leaves weeks before revenue arrives.

Not modeling different scenarios. Build three versions: conservative (things go slower than expected), base case (your realistic plan), and optimistic (things go better than expected). Present the base case and keep the others ready for questions.

What Investors and Lenders Look For

Investors care about growth trajectory and scalability. They want to see revenue growing fast, margins improving over time, and a path to a large outcome. They're comfortable with losses in the early months if the unit economics work.

Banks and lenders care about repayment ability. They want to see positive cash flow, manageable debt-to-income ratios, and enough cash reserves to weather a bad month. They're less interested in Year 3 hockey-stick growth and more interested in Year 1 survival.

Tailor your emphasis accordingly.

How Long Should Projections Cover?

For a startup business plan: 12 months of monthly projections, then annual figures for Years 2 and 3.

For an investor pitch: 3-5 year annual projections with monthly detail for Year 1.

For a bank loan: 12 months of monthly projections minimum, with a clear path to repayment.

Skip the Spreadsheet Setup

The hardest part of building financial projections isn't the thinking — it's the formatting, formulas, and structure. If you'd rather jump straight to entering your numbers, our 12-Month Financial Projections Model comes with 271 pre-built formulas across three tabs: Assumptions, Profit & Loss, and Cash Flow. Edit the assumptions and everything updates automatically.

Hillcrest Media creates professional business templates and tools for founders, freelancers, and growing teams. Browse our full template library at hillcrestmediaproductions.com.