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 a bank line of credit 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) | 5 years, year 1 monthly or quarterly | 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's 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's short-term credit line is wasted work, although an SBA-backed lender will ask for five years. 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's 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 doesn't 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 can't 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's a financial projections example for a pre-revenue SaaS startup raising a seed round. The company is fictional, and so is every number. This shows the format, the level of detail, and how to present assumptions. It also shows the three statements tying together, month 12 down to the dollar.
Assumptions Behind Every Number
| 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% net months 4-12, 10% net from month 13, rounded down to whole customers | Beta cohort: about 20% new sign-ups a month, minus cancellations |
| Average revenue per user | $89/month | Mid-market pricing, validated in beta |
| Monthly churn rate | 5% in year 1, already netted out of the growth rate | Beta cancellations |
| Cost of goods sold | $400/month hosting base, plus $9 per customer (hosting, support, card fees) | Hosting bills and support hours in beta |
| Operating expenses | Payroll $15,000, rising to $18,000 in month 9 (planned hire). Marketing $2,000, then $3,000 from month 4, $4,000 from month 6, $5,000 from month 9. Software $1,200, then $1,400 from month 6, $1,600 in month 12. Other $800. From month 13 on, operating expenses hold flat at the month-12 level of $25,600 | Hiring plan and signed contracts |
| Equipment | $7,200 of laptops in month 1, depreciated over 36 months ($200/month) | Purchase quotes |
| Funding and payment timing | $500,000 seed in month 1. Customers pay by card in the same month. Hosting and support vendors are paid the month after | Term sheet, vendor terms |
Notice what each assumption includes. A number, and where that number came from. "15% growth rate" is a guess. "15% net monthly growth, taken from our beta cohort's sign-ups minus cancellations" is a defensible assumption. Investors test assumptions, not formulas.
Projected Income Statement and Cash (Year 1, Monthly)
Every row below is customers × $89 for revenue, $400 + $9 per customer for COGS, and the operating expenses above (depreciation included) for OpEx.
| Month | Customers | Revenue (MRR) | COGS | Gross Profit | OpEx | Net Income | Gross Margin | Ending Cash |
|---|---|---|---|---|---|---|---|---|
| 1 | 0 | $0 | $400 | -$400 | $19,200 | -$19,600 | n/a | $473,800 |
| 2 | 0 | $0 | $400 | -$400 | $19,200 | -$19,600 | n/a | $454,400 |
| 3 | 0 | $0 | $400 | -$400 | $19,200 | -$19,600 | n/a | $435,000 |
| 4 | 15 | $1,335 | $535 | $800 | $20,200 | -$19,400 | 60% | $415,935 |
| 5 | 17 | $1,513 | $553 | $960 | $20,200 | -$19,240 | 63% | $396,913 |
| 6 | 19 | $1,691 | $571 | $1,120 | $21,400 | -$20,280 | 66% | $376,851 |
| 7 | 21 | $1,869 | $589 | $1,280 | $21,400 | -$20,120 | 68% | $356,949 |
| 8 | 24 | $2,136 | $616 | $1,520 | $21,400 | -$19,880 | 71% | $337,296 |
| 9 | 27 | $2,403 | $643 | $1,760 | $25,400 | -$23,640 | 73% | $313,883 |
| 10 | 31 | $2,759 | $679 | $2,080 | $25,400 | -$23,320 | 75% | $290,799 |
| 11 | 35 | $3,115 | $715 | $2,400 | $25,400 | -$23,000 | 77% | $268,035 |
| 12 | 40 | $3,560 | $760 | $2,800 | $25,600 | -$22,800 | 79% | $245,480 |
| Year 1 | $20,381 | $6,861 | $13,520 | $264,000 | -$250,480 | 66% | $245,480 |
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.
Look at month 1. The loss is $19,600, but cash drops by $26,200: $19,000 of expenses paid in cash (the $200 of depreciation isn't cash) plus the $7,200 of laptops. After that, each month's cash change is the loss minus the $200 of depreciation, adjusted for the hosting bill you owe, because every hosting bill gets paid the month after.
How the Three Statements Tie at Month 12
The year-one cash flow statement:
| Line | Amount |
|---|---|
| Net income | -$250,480 |
| Add back depreciation | +$2,400 |
| Increase in accounts payable (December's hosting bill, paid in January) | +$760 |
| Cash from operating activities | -$247,320 |
| Equipment purchased (investing) | -$7,200 |
| Seed round (financing) | +$500,000 |
| Change in cash (from $0 to ending cash) | +$245,480 |
The balance sheet at the end of month 12:
| Assets | Liabilities and Equity | ||
|---|---|---|---|
| Cash | $245,480 | Accounts payable | $760 |
| Equipment ($7,200 minus $2,400 depreciation) | $4,800 | Paid-in capital | $500,000 |
| Accumulated losses | -$250,480 | ||
| Total assets | $250,280 | Total liabilities and equity | $250,280 |
Both sides match, and the cash on the balance sheet is the ending cash from the monthly table. If yours don't match, a number is missing from one of the statements. Find it before an investor does.
Breakeven Analysis
Each customer brings $89 and costs $9 to serve, so each one contributes $80. Monthly costs that don't move with customers come to $26,000 once the month-12 team is in place ($25,600 of OpEx plus the $400 hosting base). Breakeven is $26,000 ÷ $80 = 325 customers, or $28,925 MRR.
At 10% net growth from 40 customers, the model reaches 322 customers in month 35 (a $240 loss) and 354 in month 36, the first profitable month.
That's the uncomfortable finding. The $500,000 seed runs out in month 25, and cash bottoms at -$88,883 in month 34. To reach breakeven with two months of expenses ($51,200) left as a floor, this company needs to raise about $640,000, not $500,000. Finding that gap in your own model is the point of building it.
The Financial Projection Template calculates the breakeven analysis automatically from your revenue and expense inputs.
Running a service business instead of software? Our business plan guide takes a fictional cleaning company, Bright Clean Co., through a full plan: $422,500 of year-one revenue, $93,650 of profit, and break-even at 37 households. The same logic applies, with a lender reading it instead of a VC.
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 (Stripe's standard US card rate is 2.9% + 30¢ per charge), 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 isn't revenue collected. This gap is where healthy-looking startups run out of cash.
Payment timing rules:
- SaaS with monthly billing: revenue collected in the same month
- B2B invoicing: you get paid on your invoice terms, often weeks after the work
- E-commerce: collected at purchase, then paid out on your processor's payout schedule
- Enterprise contracts: the longest payment terms, set in the contract
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.
BDC, the Canadian business development bank, gives the same rule: enter sales as cash only when you expect to get paid, and it notes that many entrepreneurs like to keep enough cash for 90 days of operations, in the bank or as room on a line of credit (BDC). If your model dips under that line, the fix is a bigger raise or a later hire, and it's cheaper to find that in a spreadsheet.
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's 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, business plans | Monthly year 1, quarterly years 2-3 | Angel investors, VCs |
| 5 years | Series B+, SBA-backed loans, strategic planning, acquisitions | Monthly or quarterly year 1, annual years 2-5 | Growth-stage VCs, SBA lenders, 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: For an early raise, a 3-year model with monthly detail in year 1 covers what most investors ask for. For a larger raise, build the 5-year model, but expect the conversation to focus on the near-term months.
Common Mistakes That Undermine Financial Projections
Investors and lenders see hundreds of projections. They spot the bad ones fast. Here's 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 40 beta sign-ups over our last three months" is ten times more credible than a round number with no citation.
2. The revenue line that only goes up. Every business loses customers. How many you lose each month is an assumption like any other, so state it and say where it came from. 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 $130K. Benefits, payroll taxes, equipment, and software add 25-35% on top of base salary. The Bureau of Labor Statistics puts it in the same range: for full-time private-industry workers in June 2026, benefits other than paid leave cost employers $12.63 an hour on top of $41.37 in wages and paid leave, about 31% (BLS). 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 haven't 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's now July and you've 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, Salesforce, HubSpot. The spreadsheets share one skeleton, and none of them fills in the assumptions for you.
The hard part isn't the spreadsheet. It's 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 helps. 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.
Questions People Ask About Financial Projections
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. A bank lending against a short-term need may ask for a shorter period, but the SBA tells loan applicants to show five years, with the first year in quarterly or monthly detail (SBA.gov). Ask your lender for their list first. 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 you give me an example of a financial projection?
The SaaS example above is one. A fictional startup launches in month 4 with 15 customers at $89 a month and grows to 40 by month 12. Year one brings $20,381 of revenue and a $250,480 loss, and $245,480 of a $500,000 seed is left. The model then shows breakeven at 325 customers in month 36 and a cash gap in month 25, which is why the raise needs to be about $640,000.
What is a 3 year financial projection?
It's the three statements (income, cash flow, balance sheet) projected 36 months ahead: monthly for year 1, then quarterly for years 2 and 3. It's the usual ask for seed and Series A investors. The first year is the part they'll hold you to, so it carries the most detail.
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.