Free Financial Projections Template (Excel): 3-Year Forecast for Startups
In This Article
- SBA lenders require income statements, cash flow, balance sheets, and break-even analysis
- All 8 sheets auto-update from a single Assumptions input sheet
- Month-by-month detail for Year 1 with annual summaries for Years 2 and 3
- Every projection needs a documented, realistic assumption behind it
Free Financial Projections Template (Excel): 3-Year Forecast for Startups
This free Excel financial projections template gives you 8 interconnected sheets with 1,879 pre-built formulas covering revenue, expenses, cash flow, and balance sheets for 36 months. SBA lenders and investors require detailed financial projections with documented assumptions, and this template structures everything they expect to see. Download the .xlsx file, fill in the teal input cells, and every sheet updates automatically.
What's Included
What's Inside the Template
The Dashboard Sheet
Shows 8 key KPIs at a glance including Monthly Revenue, Gross Margin %, Net Income, Cash Runway, Monthly Burn Rate, Month-over-Month Growth %, Customer Acquisition Cost, and Lifetime Value. Four pre-built charts update automatically from the other sheets.
Revenue Projections
Breaks down monthly revenue across up to 5 product or service lines for 36 months. Includes quarterly rollup columns, annual totals, and month-over-month growth rate formulas so lenders can see exactly how you expect revenue to scale.
COGS (Cost of Goods Sold)
Calculates variable costs per revenue line including direct labor, materials, shipping, and transaction fees. Automatically links to the Revenue Projections sheet to compute gross profit and gross margin percentage.
Operating Expenses
Covers fixed and variable monthly expenses for 36 months across pre-categorized rows for salaries, rent, software, marketing, insurance, legal fees, travel, and miscellaneous. Includes headcount planning rows for staffing projections.
P&L Statement (Income Statement)
Auto-calculates your monthly income statement by pulling from Revenue, COGS, and Operating Expenses sheets. Shows Gross Profit, EBITDA, and Net Income before and after tax with annual summary columns.
Cash Flow Statement
Tracks operating, investing, and financing cash flows for 36 months with beginning and ending cash balances. Includes a runway calculator showing months until cash-out and funding injection rows for seed rounds and Series A.
Balance Sheet
Provides a snapshot of Assets (cash, accounts receivable, inventory, fixed assets), Liabilities (accounts payable, short-term and long-term debt), and Equity (paid-in capital, retained earnings). Updates automatically from the other sheets.
Assumptions Sheet
The master input sheet where all key variables live. Revenue growth rates, pricing, COGS percentages, headcount ramp schedules, salary by role, OpEx growth, tax rate, and funding round timing all cascade through the other 7 sheets when changed.
Who Needs This Template
- You are applying for an SBA loan and need 3-year financial projections with documented assumptions
- You are pitching angel investors or VCs and need professional-grade financial models
- You are a pre-revenue startup building projections from scratch with no historical data
- You have an operating business and need to forecast expansion costs for a bank loan
- You are preparing a business plan and need connected financial statements that update automatically
- You need to calculate your cash runway and monthly burn rate before your next funding round
Before You Download
Gather these items before filling in the template:
- List every revenue stream with specific unit pricing and expected monthly volumes
- Gather your actual or estimated cost of goods sold per product or service line
- Document every fixed monthly expense including rent, salaries, insurance, and software
- Define your hiring plan with specific roles, start dates, and salary ranges for Year 1
- Research your industry average gross margin to benchmark your COGS assumptions
- Calculate your customer acquisition cost from existing marketing spend or competitor benchmarks
- Determine your tax rate by confirming your business entity type with a CPA
- Set your revenue growth rate assumptions with supporting evidence from your market analysis
- Identify the exact funding amount you need and how it breaks down by use category
- Prepare historical financial statements if your business has been operating for 1 or more years
What This Financial Projections Template Does for You
This Excel workbook contains 8 interconnected sheets with 1,879 pre-built formulas that generate a complete 3-year financial forecast. You fill in your assumptions (pricing, growth rates, headcount, expenses) in the teal-highlighted input cells, and every income statement, cash flow statement, balance sheet, and dashboard metric updates automatically.
SBA lenders, banks, and investors all require financial projections as part of any funding application. The SBA specifically requires projected income statements, cash flow statements, balance sheets, break-even analysis, and documented assumptions. This template structures all five of those requirements into a single workbook.
Whether you are completing your business plan template for an SBA loan or building a financial model for a pitch deck, these projections plug directly into both. The Dashboard sheet gives you an investor-ready snapshot you can screenshot and drop into any presentation.
How to Use This Excel Workbook
Start with the Assumptions sheet (the last tab). This is the master control panel for the entire workbook. Enter your revenue growth rate by year, pricing per product or service, COGS percentage by line, headcount ramp schedule, salary by role, OpEx growth rate, tax rate, and funding round timing. Every number you enter here cascades through all 7 other sheets automatically.
Next, move to the Revenue Projections sheet and confirm that your monthly unit volumes and pricing tiers look correct for each of your product or service lines (up to 5). The teal input cells are the only cells you should edit. Gray cells contain formulas that will break if overwritten. From there, review COGS, Operating Expenses, and confirm the P&L, Cash Flow, and Balance Sheet outputs match your expectations.
The Dashboard sheet is your final check. It displays 8 KPIs (Monthly Revenue, Gross Margin %, Net Income, Cash Runway in months, Monthly Burn Rate, Month-over-Month Growth %, CAC, and LTV) with 4 auto-updating charts. If any metric looks off, trace it back to the Assumptions sheet and adjust your inputs. Lenders and investors will see this page first, so make sure it tells a clear, defensible story.
The Number One Rule for Financial Projections
Every single number in your projections needs a documented assumption behind it. Instead of writing "we expect $50,000 in monthly revenue by Month 12," write "we project $50,000 in monthly revenue by Month 12 based on 500 units at $100 per unit, with a 5% month-over-month growth rate derived from our 3-month pilot conversion data." Lenders reject projections that lack this level of specificity. Use the Assumptions sheet to record the logic behind every input.
How to Fill Out the Template
- 1
Complete the Assumptions Sheet First
Enter your revenue growth rates, product pricing, COGS percentages, headcount plan, salary by role, OpEx growth rate, tax rate, and funding round timing. This sheet drives every other calculation in the workbook. Spend the most time here because every downstream number depends on these inputs.
- 2
Build Your Revenue Projections by Product Line
For each of your product or service lines (up to 5), enter your monthly unit volumes and confirm that the pricing pulled from the Assumptions sheet is correct. Review the quarterly rollup columns and annual totals. The month-over-month growth rate formulas should reflect realistic ramp patterns, not hockey-stick curves.
- 3
Input Your Cost of Goods Sold
Enter your variable costs per revenue line including direct labor, materials, shipping, and transaction fees. The sheet automatically calculates gross profit and gross margin percentage by pulling from your Revenue Projections. Compare your gross margin to industry benchmarks to confirm your numbers are defensible.
- 4
Fill in Your Operating Expenses
Enter fixed and variable monthly expenses across the pre-categorized rows for salaries, rent, software, marketing, insurance, legal, travel, and miscellaneous. Use the headcount planning rows to map when each new hire starts and at what salary. Be specific with amounts rather than rounding to the nearest thousand.
- 5
Review the Auto-Generated P&L and Cash Flow Statements
These sheets pull automatically from Revenue, COGS, and OpEx. Check that Gross Profit, EBITDA, and Net Income look reasonable. On the Cash Flow sheet, verify your beginning and ending cash balances and check the runway calculator to see how many months of cash you have before running out.
- 6
Verify the Balance Sheet and Add Funding Rounds
Confirm that Assets, Liabilities, and Equity reflect your actual or expected financial position. Use the funding injection rows on the Cash Flow sheet to model seed round or Series A timing. The Balance Sheet will update Equity and Cash balances based on those entries.
- 7
Audit the Dashboard and Stress-Test Your Assumptions
Review all 8 KPIs and 4 charts on the Dashboard. If your cash runway shows fewer than 6 months, revisit your burn rate or funding timing. Try reducing your revenue growth rate by 20% to see if your business still survives. Lenders expect you to know what happens when things go slower than planned.
What Lenders and Investors Actually Look for in Your Projections
SBA lenders require five non-negotiable components in your financial projections according to First Business Bank's SBA lending guidance: projected income statements, projected cash flow statements, projected balance sheets, break-even analysis, and detailed documented assumptions. Missing any one of these can delay or kill your application. If your business has been operating for 3 to 5 years, lenders also want to see historical financial statements for that same period alongside your forward projections.
The SBA requires a minimum 10% equity injection (your own money in the deal), though most lenders prefer 20% down to ensure you maintain operational reserves. Your projections need to show exactly where that equity appears and how loan repayment fits into your monthly cash flow. Revenue minimums vary by lender type: NerdWallet reports that online lenders often require $100,000+ in annual revenue, while Bank of America secured loans require $250,000+.
For investors reviewing your pitch deck template, the focus shifts to growth metrics and unit economics. They want to see your Customer Acquisition Cost, Lifetime Value, LTV-to-CAC ratio, and monthly burn rate. Your Dashboard sheet calculates all of these. If you are pursuing pre-seed funding or pitching angel investors, a clear path to break-even with specific monthly milestones matters more than showing massive profitability in Year 3.
Three Mistakes That Get Projections Rejected
Overestimating revenue without market evidence. Writing "we will capture 5% of a $10 billion market" without showing how you will acquire each customer is the fastest way to lose credibility. Lenders and investors want bottom-up projections built from unit volumes and pricing, not top-down market share guesses.
Forgetting to document your assumptions. Every growth rate, pricing decision, and expense estimate must trace back to a specific source or calculation. The Assumptions sheet exists for this reason. Leaving it blank (or filling it with round numbers) signals that you guessed.
Ignoring cash flow timing. Your P&L can show profit while your bank account hits zero. If customers pay on 60-day terms but your suppliers demand payment in 15 days, your cash flow statement will show a gap that kills your business. Model actual payment timing in the Cash Flow sheet, not just revenue recognition.
Frequently Asked Questions
About the Author
Senior Finance & Banking Editor
Richard is the veteran anchor of the site's financial content. Raised in the Midwest and starting his career in Chicago's commercial banking sector, he spent over a decade underwriting small business loans before moving into financial journalism. He doesn't get swept up in startup hype; he cares about unit economics, APYs, and fee structures.
Was this article helpful?
This template is provided for informational and planning purposes only and does not constitute financial, legal, or investment advice. Financial projections are forward-looking estimates and are not guarantees of future results. Consult a licensed financial advisor, CPA, or attorney before making financial or business decisions.