Expense Projection Template: Two-Year Income & Expenses

Quick Answer: A two-year projection of business income and expenses is a forecast profit and loss: 12 monthly columns for year one, then four quarterly columns for year two. Build revenue from drivers (customers × average sale), split expenses into fixed and variable, and keep every assumption on its own tab. If you are already trading, set the opening months from your actual bank statement history.

An expense projection template for a business plan or loan request needs three parts: an assumptions tab, a monthly projection for year one, and a quarterly projection for year two. Revenue comes from a small number of drivers, variable costs are a percentage of that revenue, and fixed costs are listed line by line. Actual bank history keeps the starting figures honest.

What lenders and plan readers expect

The SBA's guide to writing a business plan (read on 27 October 2026) asks for financial projections that "convince the reader that your business is stable and will be a financial success." It suggests a five-year outlook including forecasted income statements, balance sheets, cash flow statements and capital expenditure budgets, and adds: "For the first year, be even more specific and use quarterly — or even monthly — projections. Make sure to clearly explain your projections, and match them to your funding requests."

Many plan templates and some lenders ask for a two-year version instead. The same principles apply at that length: detail where the near term is knowable, less detail further out, and every number traceable to an assumption. Established businesses should also expect to show historical statements; the SBA mentions income statements, balance sheets and cash flow statements for the last three to five years.

The workbook layout

Give the rows the same order on Year 1, Year 2 and Summary, so the totals line up and a reader can compare them at a glance.

How do you project revenue from drivers?

Pick the two or three numbers that actually make the revenue, not a single growth rate applied to a guess. Examples:

• Café: customers per day × average ticket × trading days.
• Subscription software: paying accounts at the start of the month + new accounts − cancellations, × monthly price.
• Contractor: jobs per month × average job value.
• Online shop: site visits × conversion rate × average order value.

On the Assumptions tab, name each driver. A café model might have Customers_M1 = 60, Ramp = 0.08 (monthly growth until a cap), Cap = 140, Ticket = 9.50 and Days = 26. In Year 1, row 5 holds customers per day:

• B5: =Customers_M1
• C5: =MIN(B5*(1+Ramp), Cap), filled right to M5

Revenue in row 6 is then =B5*Ticket*Days, filled right. Month 1 comes to 60 × 9.50 × 26 = 14,820.

For year two, the quarterly column takes three months at the year-two rate. If customers sit at the cap, Q1 revenue is =Cap*Ticket*Days*3, and any year-two price change goes in as its own assumption (Ticket_Y2) rather than being typed into the formula.

Fixed versus variable expenses

Split every cost into one of two groups:

Variable (move with sales): ingredients or materials, packaging, shipping, card processing fees, sales commissions. Express each as a percentage of revenue on the Assumptions tab, e.g. COGS_pct = 0.31, Card_fee_pct = 0.027, then =B6*COGS_pct.

Fixed (paid whether you sell or not): rent, insurance, software, phone and internet, accounting, loan interest, base wages. Enter them as amounts per period on the Assumptions tab. A rent of 3,200 for each month becomes =Rent in every Year 1 column and =Rent*3 in each Year 2 quarter.

Step costs sit in between. A second employee hired in month 7 is a fixed cost that starts partway: =IF(COLUMN()-COLUMN($B$1)+1>=Hire2_month, Wage2, 0). Add employer payroll taxes as a percentage of wages; they are the line most often missing.

Gross profit is revenue minus variable costs, operating expenses are the fixed lines, and net income is gross profit minus operating expenses. Put a check row at the bottom that turns red (conditional formatting) whenever net income is negative, so the months that need funding are obvious.

Can you anchor the projection to real bank history?

If the business is already trading, yes, and it's the best defense when a lender asks "where does this number come from?" Take six to twelve months of business bank and card statements, put the transactions in a spreadsheet, and total them by category on the History tab. Banks often limit CSV downloads to recent activity; QuickBankConvert can turn older PDF statements into rows with date, description and signed amount. Then:

1. Remove transfers between your own accounts, owner draws and loan principal; they aren't expenses.
2. Pivot by category and month. Our guide to a small business spreadsheet for income and expenses shows a category list that maps well onto projection rows.
3. Average the fixed lines for the baseline and read the variable lines as a percentage of the same months' revenue.
4. Flag one-offs (a repair, an annual insurance premium) and spread or exclude them deliberately.

Month 1 of the projection should then look like a normal recent month, adjusted only for changes you can name, such as a new lease or a price rise.

For a business that hasn't opened, the launch costs belong on a separate schedule; our startup cost template covers that list.

The assumptions tab is half the deliverable

A reader skims the totals and then reads the assumptions. Make each line answer three questions: what the number is, the unit, and why you believe it. "Average ticket 9.50: menu prices weighted by the last three months of till reports" persuades. "Revenue growth 10%" with no source does not. Keep a short sensitivity block too: revenue at 80% of plan with costs unchanged, so the reader sees how long the cash lasts if sales start slowly.

Pairing it with a cash flow forecast

A projection of income and expenses shows profit; it doesn't show cash. Equipment you buy is a cash outflow but only partly an expense in year one. Loan proceeds and repayments of principal move cash but are not income or expense. Customers on 30-day terms push cash a month behind sales. Lenders usually want both views, which is why SBA lists cash flow statements alongside income statements.

Build the cash flow forecast on its own tab, starting from the projection's net income and adjusting for those timing items. Our cash flow budget template has a monthly layout that links cleanly to Year 1 here, and the small business budget template covers tracking actuals against the plan once the year starts.

Related guides

• Small business budget template
• Startup cost template for Excel
• Cash flow budget template
• Small business spreadsheet for income and expenses