Business Plan Template in Excel: Build the Financial Plan Lenders Actually Read
How to build the financial side of a business plan in Excel: assumptions, startup costs and funding, a three-year profit and loss projection, a monthly cash flow forecast, break-even analysis and scenarios, with a worked landscaping startup example.
A business plan template in Excel is mainly the financial plan behind your business plan: one workbook with your assumptions, startup costs and how they are funded, a profit and loss projection for three years, a monthly cash flow forecast for the first year and a break-even analysis. The written parts (market, competition, team, marketing) usually live in a document, but the numbers belong in a spreadsheet where every result is linked to its assumptions. Change one assumption and the whole plan updates. This guide shows the structure, the key formulas and a worked example.
The tabs
| Tab | What it holds | Question it answers |
|---|---|---|
| Assumptions | Prices, volumes, growth, direct cost %, wages, rent, payment terms | What is everything based on? |
| Startup costs | Equipment, vehicles, deposits, licenses, branding, working capital | How much do we need to open? |
| Funding | Owner equity, loans, investors, grants | Where does the money come from? |
| Profit and loss | Three years, monthly for year one | Is the business profitable? |
| Cash flow | Cash in and out by month, including loan principal and purchases | Do we run out of cash at any point? |
| Break-even | Fixed costs and contribution margin | How much must we sell to cover costs? |
The rule that keeps the model honest: type numbers only on the Assumptions and Startup costs tabs. Everything else is formulas.
Step 1: assumptions you can defend
Next to each assumption, note its source: supplier quotes, a lease, competitor prices, industry data or your own experience. Build revenue from drivers (customers × average sale, billable hours × rate, units × price) rather than typing a sales total, and ramp up gradually in the first months. The U.S. Small Business Administration’s business plan guidance is a useful checklist for what lenders expect to see.
Step 2: startup costs and funding
List everything you must pay before and just after opening, plus working capital to cover expenses until revenue catches up. Check that funding equals the need:
=IF(ABS(TotalFunding-TotalStartupCosts)<1,"Balanced","Check funding")
A loan payment is =PMT(Rate/12,Years*12,-Amount). Remember that only the interest goes on the profit and loss; the principal repayment shows up in the cash flow.
Step 3: profit and loss projection
Use the structure of a normal income statement: revenue, direct costs, gross profit, operating expenses (rent, insurance, software, marketing, salaries including a fair owner’s salary), depreciation of equipment, interest and pre-tax profit. Equipment purchases are not expenses in the year you buy them; they are depreciated over their useful life. The business budget template uses the same line structure once you are operating, so you can compare plan with actual.
Step 4: monthly cash flow
Cash flow shows whether there is money in the bank each month. Ending cash = opening cash + cash received − cash paid, where cash paid includes loan principal and equipment purchases. Seasonal businesses in particular can be profitable over a year and still run short for several months. The 13-week cash flow forecast template is the tool to switch to once the business is running.
Worked example: a landscaping startup
| Item | Year 1 |
|---|---|
| Startup costs: used truck $28,000, trailer and equipment $14,500, insurance deposit and licenses $2,200, branding and website $1,800, working capital $8,500 | $55,000 |
| Funding: owner $20,000, equipment loan $35,000 | $55,000 |
| Revenue: 45 maintenance clients × $160 × 9 months, plus $38,000 of projects | $102,800 |
| Direct costs: fuel, materials, disposal, seasonal labor (38%) | −$39,064 |
| Gross profit | $63,736 |
| Insurance, phone and software, marketing | −$9,900 |
| Owner’s salary | −$36,000 |
| Depreciation and loan interest | −$9,600 |
| Pre-tax profit | $8,236 |
With a 62% contribution margin and $55,500 of fixed costs (including depreciation and interest), break-even revenue is about $55,500 ÷ 0.62 ≈ $89,500, roughly 87% of the planned revenue. The margin of safety is thin, and three winter months with little income make the monthly cash flow the page a lender will study most. Snow removal contracts or prepaid spring packages would be the first ideas to test. The break-even analysis in Excel explains the calculation in detail.
Scenarios
Add a scenario cell (1 = conservative, 2 = base, 3 = optimistic) and three values for the most uncertain assumptions, such as client count and project revenue. =CHOOSE(Scenario,Conservative,Base,Optimistic) recalculates the whole plan. A plan that survives the conservative case is more convincing than one with only attractive numbers.
Supporting the numbers
Pricing assumptions are stronger when they come from your competitor analysis and your margins from the profit margin calculator. After the first year, the plan becomes the baseline for your balance sheet and budget. More guides are in Small Business Finance.
Limits
A financial plan is an estimate. Taxes, payroll costs and loan terms depend on your business structure and location, so review them with an accountant or a local small business development center before relying on the plan.
Frequently asked questions
How many years should a business plan forecast?
Usually three years, with the first year by month. Larger loans may require five.
What do lenders look at first?
Monthly cash flow, the ability to repay, how much the owner is investing and how well the revenue assumptions are supported.
Should I include my own salary?
Yes. If you work in the business, include a realistic salary; otherwise the profit figure hides the cost of your time.
Can I build this in Google Sheets?
Yes. PMT, CHOOSE and IF work the same, and sharing with a partner or adviser is easy.