BusinessPlanHub

Free Contract Revenue Financial Model for Agencies and B2B Firms

The Contract Revenue financial model is a free Excel download where you forecast contract income month by month over 60 months. It shows what signed work does to your profit, balance sheet and cash.

Download the free model Book a free consultation

Free · Excel (.xlsx) · Imports into Google Sheets

Download the contract revenue financial model

Pick this if revenue comes from named contracts, not a steady customer count.

We use your email to send you the model and offer a free consultation. No spam.

Why is contract revenue harder to forecast than subscriptions?

Contract revenue arrives in lumps, and a lump can be late, small or cancelled. A subscription business can multiply customers by price. You cannot.

This model drops the customer-count engine. Instead you forecast contract revenue directly and set when it lands. The 60-month Financials tab then builds an income statement, balance sheet and statement of cash flows from those entries and from your costs.

That suits agencies, B2B service firms, construction and engineering companies, and staffing businesses. If you bill by the hour to many small clients, the service business model is the better fit.

Which numbers go on the Assumptions tab?

You enter contracts, payment terms, costs, people and funding.

BlockWhat you enter
Contract revenueEach contract’s value and when it lands
Cost of goods soldDirect delivery costs tied to the work
People plan25 rows of roles and salaries
Operating costsG&A, sales and marketing, professional fees
Payment termsAverage days receivable, average days payable
Balance sheetStarting cash, fixed assets
FundingRounds labelled Seed and Series A, plus income tax rate

If the file lets you label contracts, name each after a real client or target. “Contract 3” tells a reader nothing. “Council depot refit” tells them what you are betting on.

Should unsigned pipeline count as revenue?

No. Signed contracts are revenue you can point to. Pipeline is a hope.

A common mistake in an agency or contracting forecast is filling the contract slots with every proposal you have sent. A lender or investor will ask which contracts are signed. If most are not, the forecast is a sales target in a spreadsheet.

A cleaner approach is two versions of the file. One holds signed work only. The other adds pipeline at the share you honestly expect to win. Show both. The gap between them is your risk.

How do payment terms change your cash?

Late payment ties up cash. A contract worth the same on paper can bury you or carry you, depending on when the money moves.

Say a client pays 60 days after invoice, while you pay staff monthly. You fund two months of delivery from your own pocket. Average days receivable captures that. Average days payable captures the other side, where suppliers give you time.

The cash flow statement shows the result month by month. Look for the lowest point. That month tells you how much working capital you need, and it is often the figure a lender asks for.

What happens when a big contract ends?

Revenue drops by that contract’s whole value, while salaries stay. Costs rarely fall as fast as revenue does.

Test this on purpose. Delay your biggest contract by three months and read the cash line. Remove it entirely and see how long you last. This is the check a careful lender runs, so run it first.

Concentration matters too. If one client makes up most of your revenue, say so in the plan. What investors look for in a business plan covers why that risk gets attention.

How should you use the funding rounds?

Use them to show when outside money lands and why you need it. The file labels two rounds, Seed and Series A. Rename the logic in your head to whatever you are actually raising: a bank loan, owner capital, a grant.

Make the amount match the cash low point plus a cushion. A raise with no link to the cash flow looks arbitrary.

What next?

Swap out every placeholder. The example figures are there so the formulas calculate, and they say nothing about your sector.

Then see how similar firms lay out their projections in the construction, architecture and engineering sample plans or the IT, staffing and customer service sample plans. Those plans describe fictional businesses, so use them for structure only.

Stuck on payment terms or contract timing? Book a free 30-minute consultation and we will go through your model with you.

Sample business plans that fit this model

These are 6 of 48 sample plans for businesses that earn money the way this model does. Every sample plan is a fictional example, so use it for structure, not for figures.

Browse more: Construction, Architecture & Engineering business plans · IT, Staffing & Customer Service business plans

Contract Revenue financial model: common questions

How many contracts can the template hold?

Six. The Assumptions tab has six contract rows, each entered month by month. If you have more contracts than that, group the smaller ones or add rows yourself, and note what you did.

Should I include contracts I have not signed yet?

Keep signed contracts and pipeline separate in your thinking. Put signed work in as it is. Add pipeline work only at a probability you can defend, or leave it out of the base case.

Does the model include payment terms?

Yes. Average days receivable and average days payable move cash earlier or later than revenue and cost. Set them from how your clients and suppliers actually pay.

Can I open it in Google Sheets?

It is an .xlsx made for Excel. Google Sheets can import it through File > Import. Check that the formulas still calculate afterwards.