Most financial projection templates give you the spreadsheet but not the assumptions. You get rows for revenue, expenses, and cash flow. You stare at the empty cells. Then you type numbers that feel right, which is how startups build projections that fall apart the first time an investor asks "where did this growth rate come from?"
A financial projection is only as credible as the assumptions behind it. The template structure is the easy part. Knowing what numbers to put in, how to justify them, and which format your audience expects is what separates business financial projections that get funded from ones that get ignored. Every competitor on the first page of Google offers a download. None of them show you how to fill it in.
Below is the walkthrough that every Excel download on page one of Google skips: how to create financial projections with assumptions you can defend, real examples with real numbers, and guidance on which format your specific audience expects. All templates linked here are free and work in ChatGPT, Claude, Gemini, or whatever tool you already have open.
Which Financial Projection Template Fits Your Situation
A pre-revenue startup building an investor deck and a plumber applying for an SBA loan need completely different projections. Using a 5-year three-scenario model for a bank that just wants 12 months of cash flow is like bringing a business plan to a first date. Wrong format, wrong audience, wrong impression.
| Situation | Right Template | Projection Period | Key Output |
|---|---|---|---|
| Startup fundraising (pre-revenue) | Financial Projection Template (Startup Pre-Revenue) | 3-5 years | Three-scenario model, burn rate, runway |
| Startup fundraising (early revenue) | Financial Projection Template (Startup Early Revenue) | 3 years | Unit economics, growth trajectory, path to profitability |
| SBA loan or bank financing | Financial Projection Template (Small Business) | 12-24 months | Monthly cash flow, debt service coverage ratio |
| Board presentation | Financial Projection Template (Growing Business) | 12 months | Budget vs. actual, variance analysis |
| Cash flow management | Cash Flow Projection Template | 3-12 months | Weekly/monthly inflows and outflows, runway |
| Revenue planning | Revenue Forecast Template | 12-36 months | Multi-stream revenue, seasonal adjustments |
| Pre-launch budgeting | Startup Costs Template | One-time | Total funding needed, cost categories |
The biggest mistake people make is not picking the wrong numbers. It is picking the wrong template. Banks care about one thing: can you repay the loan? Investors care about a different thing: how big can this get? A 5 year financial projection template aimed at a bank is wasted work. A 12-month cash flow model aimed at a VC looks unambitious. Match the projection to the person reading it.
The Three-Statement Model: What Every Financial Projection Includes
A complete startup financial model connects three financial statements. Miss one and your projections have a gap that your audience will find.
Income Statement (Profit and Loss)
Shows whether the business makes money over a period. Revenue minus expenses equals net income. This is where most people start, and it is the least useful statement on its own.
Key lines in the income statement:
- Revenue by stream (subscriptions, one-time sales, services)
- Cost of Goods Sold (COGS) directly tied to delivering the product
- Gross Profit = Revenue minus COGS
- Operating Expenses broken into categories (payroll, marketing, rent, software)
- Operating Income = Gross Profit minus Operating Expenses
- Net Income = Operating Income minus interest and taxes
The income statement tells you profitability. It does not tell you whether you have cash in the bank. A business can be profitable on paper and still run out of money if customers pay in 90 days but expenses are due in 30.
Cash Flow Statement
Shows when money actually moves. This is the statement that kills startups. You can survive negative net income for years with enough funding. You cannot survive negative cash flow for more than a few months.
A cash flow projection template breaks cash movement into three sections:
Operating activities. Cash from customers minus cash paid to suppliers and employees. Adjusts for timing differences between when you book revenue and when you collect it.
Investing activities. Cash spent on equipment, technology, or acquisitions. Cash received from selling assets.
Financing activities. Cash from investors or loans. Cash paid for debt repayment, dividends, or distributions.
The Cash Flow Projection Template builds all three sections with risk scenario modeling and sensitivity analysis. It flags any period where your cash balance drops below two months of operating expenses.
Balance Sheet
Shows what the business owns (assets), owes (liabilities), and is worth to owners (equity) at a single point in time. Most early-stage financial projections for startups skip the balance sheet. Investors notice.
For a startup, the key balance sheet items are: cash on hand, accounts receivable, equipment, accounts payable, loans, and equity (investor contributions minus accumulated losses).
The three statements connect. Net income from the income statement flows into the cash flow statement. Ending cash from the cash flow statement appears on the balance sheet. If one statement changes, the others must update. This is why pro forma financial statements matter. They show the interconnected picture.
Financial Projections Example: SaaS Startup
Here is a financial projections example for a pre-revenue SaaS startup raising a seed round. This shows the format, the level of detail, and how to present assumptions.
Revenue Assumptions
| Assumption | Value | Source |
|---|---|---|
| Launch month | Month 4 (3 months of development) | Product roadmap |
| Starting customers | 15 (beta waitlist conversions) | Waitlist of 120, 12.5% conversion |
| Monthly growth rate | 15% months 4-12, 10% months 13-24 | Industry benchmark for B2B SaaS |
| Average revenue per user | $89/month | Mid-market pricing, validated in beta |
| Annual churn rate | 5% monthly for first year, 3% after | Industry average for SMB SaaS |
Notice what each assumption includes. A number, and where that number came from. "15% growth rate" is a guess. "15% monthly growth rate based on B2B SaaS median for post-launch" is a defensible assumption. Investors test assumptions, not formulas.
Projected Income Statement (Year 1, Monthly)
| Line Item | Month 1-3 | Month 4 | Month 6 | Month 9 | Month 12 |
|---|---|---|---|---|---|
| Revenue | $0 | $1,335 | $2,044 | $3,129 | $4,789 |
| COGS (hosting, support) | $500 | $667 | $811 | $1,065 | $1,436 |
| Gross Profit | -$500 | $668 | $1,233 | $2,064 | $3,353 |
| Payroll (2 founders + 1 eng) | $15,000 | $15,000 | $15,000 | $18,000 | $18,000 |
| Marketing | $2,000 | $3,000 | $4,000 | $5,000 | $5,000 |
| Software/Infra | $1,200 | $1,200 | $1,400 | $1,400 | $1,600 |
| Other OpEx | $800 | $800 | $800 | $800 | $800 |
| Net Income | -$19,500 | -$19,332 | -$19,967 | -$23,136 | -$22,047 |
| Key Metrics | Month 4 | Month 6 | Month 9 | Month 12 |
|---|---|---|---|---|
| Customers | 15 | 23 | 35 | 54 |
| MRR | $1,335 | $2,044 | $3,129 | $4,789 |
| Gross Margin | 50% | 60% | 66% | 70% |
| Monthly Burn | $19,332 | $19,967 | $23,136 | $22,047 |
This is what business financial projections look like when they tell a story. The gross margin improves as fixed hosting costs spread across more customers. Burn rate increases in month 9 because of a planned hire. Every number connects to an assumption in the table above.
Breakeven Analysis
At $89/month ARPU with 70% gross margin at scale, breakeven requires approximately 354 customers generating $31,500 MRR. At 15% monthly growth from 15 customers, that is roughly month 22 to 24. The Financial Projection Template calculates the breakeven analysis automatically from your revenue and expense inputs.
How to Create Financial Projections: Step by Step
Step 1: Start with Revenue, Not Expenses
Most guides tell you to list expenses first. This is backwards for startups. Revenue assumptions drive everything else. Your hiring plan, marketing spend, and infrastructure costs all depend on how fast you expect to grow.
Build revenue from the bottom up:
- Define your revenue streams (subscriptions, one-time, services)
- Set your pricing per stream
- Estimate your starting customer count with justification
- Project growth rate by month or quarter with a source for the rate
- Calculate revenue = customers x price, adjusted for churn
For a revenue projection template that handles multiple streams, seasonal adjustments, and growth modeling, use the Revenue Forecast Template. It builds the bottom-up model from your inputs.
Step 2: Map Expenses to Your Revenue Timeline
Expenses fall into three buckets:
Fixed costs. Same amount regardless of revenue. Rent, salaries, insurance, software subscriptions. These are your baseline burn rate.
Variable costs. Scale with revenue. Payment processing fees (2.9% of revenue), hosting costs that increase with users, sales commissions, cost of goods sold.
Step-function costs. Fixed until a threshold, then jump. Your first server handles 1,000 users. User 1,001 requires a second server. Your team of 3 handles 50 customers. Customer 51 requires hire number 4.
Map each expense to the month it starts and whether it scales with revenue. A startup budget template helps with pre-launch costs. The Startup Costs Template separates one-time from recurring costs across every category.
Step 3: Build the Cash Flow Projection
Revenue booked is not revenue collected. This disconnect kills more startups than bad products do.
Payment timing rules:
- SaaS with monthly billing: revenue collected in the same month
- B2B invoicing: typically 30-60 day collection cycle
- E-commerce: collected at purchase minus payment processing delay (2-5 days)
- Enterprise contracts: often 45-90 day payment terms
Your cash flow projection template must account for this gap. If you invoice $10,000 in March with net-60 terms, that cash arrives in May. Your March cash position shows zero from that sale.
The Cash Flow Projection Template models collection timing, separates operating from investing from financing cash flows, and flags cash shortfall periods.
Step 4: Run Three Scenarios
Investors expect three scenarios. Banks expect one conservative scenario. Know your audience.
| Scenario | Revenue Assumption | Expense Assumption | Purpose |
|---|---|---|---|
| Conservative | 50-70% of base growth | 110-120% of base costs | Shows you survive the downside |
| Base | Your best estimate | Your best estimate | The plan you execute against |
| Optimistic | 130-150% of base growth | Base costs (economies of scale) | Shows the upside if things go right |
Never present only the optimistic scenario. Investors have seen thousands of hockey-stick projections. The conservative scenario is where credibility lives. If your conservative case still shows a path to profitability, your model is strong.
The Financial Projection Template generates all three scenarios side by side from a single set of inputs, with notes explaining what differs between them.
Step 5: Add the Key Metrics Dashboard
Raw financial statements are necessary but not sufficient. Decision-makers want metrics that summarize the story.
For startups:
- Monthly Recurring Revenue (MRR) and growth rate
- Customer Acquisition Cost (CAC)
- Lifetime Value (LTV) and LTV:CAC ratio
- Gross margin percentage
- Monthly burn rate and cash runway in months
- Months to breakeven
For small businesses:
- Revenue growth (month over month, year over year)
- Gross margin and net margin
- Debt service coverage ratio (for loan applications)
- Working capital ratio
- Days sales outstanding (collection speed)
Projection Period: 3-Year vs. 5-Year
A 3 year financial projection template is the right default for most startups. Here is when to use each period.
| Period | When to Use | Granularity | Who Asks for It |
|---|---|---|---|
| 12 months | Bank loans, bridge rounds, operational planning | Monthly | Banks, board, management |
| 3 years | Seed and Series A, SBA loans, business plans | Monthly year 1, quarterly years 2-3 | Angel investors, VCs, SBA |
| 5 years | Series B+, strategic planning, acquisitions | Monthly year 1, annual years 2-5 | Growth-stage VCs, acquirers |
A 5 year financial projection template for a pre-revenue startup is largely fiction after year 2. VCs know this. They use years 3 through 5 to understand your ambition and market sizing, not as a reliable forecast. Year 1 is your operating plan. Year 2 is your growth plan. Years 3 through 5 are your vision.
Rule of thumb: If you are raising less than $2M, a 3-year model with monthly detail in year 1 is the standard. If you are raising more than $5M, build the 5-year model but expect the conversation to focus on months 1 through 18.
Common Mistakes That Undermine Financial Projections
Investors and lenders see hundreds of projections. They can spot the bad ones in under a minute. Here is what gets your model dismissed before anyone reads page two.
1. The "trust me" growth rate. "20% month-over-month growth" without a source is not a projection. It is a wish. Where did 20% come from? Beta conversion data? Comparable companies? A benchmark report? "Based on Mailchimp's first-year growth data" is ten times more credible than a round number with no citation.
2. The revenue line that only goes up. Every business loses customers. SaaS companies lose 3-8% monthly in the early stages. Retail loses more. A revenue chart with no churn built in tells investors you either do not understand your business or you are hiding something. Neither is good.
3. The $100K employee who actually costs $140K. Benefits, payroll taxes, equipment, and software add 25-35% on top of base salary. Founders who budget $100K for a hire and then wonder where the money went are making this mistake. The Financial Projection Template applies loaded rates automatically so you do not have to remember.
4. The profitable company with no cash. Your income statement says you made $50,000 this month. Your bank account says $8,000. Both are correct. Revenue recognition and cash collection are different events. This confusion has killed more startups than bad products.
5. The hockey stick with no downside. A single optimistic scenario tells investors exactly one thing: you have not thought about what happens when things go wrong. Build three scenarios. The conservative case is where your credibility lives.
6. The projection that never gets updated. You built a beautiful model in January. It is now July and you have never compared projections to actuals. That model is fiction. The best financial model template is the one you update monthly, not the one with the prettiest formatting.
Financial Projection Template Excel vs. AI-Generated
Every financial projection template excel download on the internet gives you the same thing: linked cells, auto-calculating totals, and a blank canvas that assumes you already know what numbers to put in. SCORE, Smartsheet, Microsoft, Mass.gov. Identical skeleton, zero guidance on the hard part.
The hard part is not the spreadsheet. It is deciding whether 15% or 25% growth is realistic for your market. Whether hosting belongs in COGS or operating expenses. What collection period to use when you have zero historical data. The financial projection template excel file cannot answer those questions. It just gives you a pretty place to be wrong.
This is where AI is genuinely useful. Not because it invents numbers for you, but because it populates industry-appropriate defaults you can then adjust. Describe your business and stage, and you get an assumptions table, a connected three-statement model, scenario analysis, and a breakeven analysis. You still have to verify everything. But you start from a populated model instead of an empty one.
The Financial Projection Template works in ChatGPT, Claude, Gemini, or the Dock Editor. Seven business types, twelve industries, three-scenario modeling. Every financial projections template free elsewhere gives you the skeleton. This one gives you a first draft with actual assumptions you can interrogate.
Related financial tools:
- Cash Flow Projection Template for liquidity planning with risk scenarios
- Revenue Forecast Template for multi-stream revenue modeling
- Startup Costs Template for pre-launch budgets
All free. Open any in the Dock Editor if you want to generate and edit in the same place.
FAQ
How do you write a financial projection?
Start with revenue assumptions built from the bottom up: number of customers, average revenue per customer, and growth rate with a cited source. Map expenses into fixed, variable, and step-function costs. Build three connected statements: income statement, cash flow statement, and balance sheet. Add a breakeven analysis showing when cumulative revenue exceeds cumulative costs. Run conservative, base, and optimistic scenarios. Update monthly by comparing projections to actuals.
What should a startup financial projection include?
A startup financial projection needs revenue assumptions with sourced growth rates, an income statement showing the path from loss to profitability, a cash flow projection that accounts for collection timing and burn rate, key metrics (MRR growth, CAC, LTV, runway), a breakeven analysis, and three scenarios (conservative, base, optimistic). For fundraising, include a balance sheet and a clear statement of how much funding you need and how long it lasts.
How far out should financial projections go?
Match the period to your audience. Banks and SBA loans typically want 12 to 24 months of monthly projections. Seed and Series A investors expect 3 years with monthly detail in year 1. Series B and later rounds expect 5 years. For any projection beyond 2 years, year 1 is your operating plan, year 2 is your growth plan, and years 3 through 5 show your market ambition rather than reliable forecasts.
Can ChatGPT or AI create a financial model?
Yes. AI tools can generate the structure, formulas, assumptions, and narrative for financial projections. The advantage over static templates is that AI adapts the model to your specific business type, industry, and stage. You describe your situation in plain language and get a complete three-statement model with scenarios. The output still requires your review: verify assumptions against your actual data, adjust growth rates to your market, and update regularly as actuals come in.
What is the difference between a financial projection and a financial forecast?
A financial projection models what could happen under specific assumptions, often including multiple scenarios. A financial forecast predicts what will happen based on historical trends and current data. In practice, startups build projections (assumption-driven, forward-looking) while established businesses build forecasts (data-driven, trend-based). The financial forecast template and financial projection template share the same three-statement structure. The difference is in how the inputs are derived.
What is a pro forma financial statement?
Pro forma financial statements are forward-looking versions of the three core financial statements: income statement, balance sheet, and cash flow statement. "Pro forma" literally means "as a matter of form." These are projections presented in standard accounting format, showing what the financials would look like under your stated assumptions. Investors and lenders use pro forma statements to evaluate future performance before committing capital.