Fractional CFO, Profit First and bookkeeping for founder-led service businesses · Debbie DeKnight 630-402-6900 x100

Fractional CFO, planning

Financial Modeling and Annual Planning for a Service Business: What Goes In and How to Build It

For owners of service and trade businesses who want to test a decision on paper before they make it with real money.

Quick answer

A financial model for a service business links the few numbers that drive results, such as jobs won, average job value, delivery cost and overhead, to the revenue and profit they produce, so you can test a decision before it happens. Annual planning sets the year's targets and what it takes to reach them. At Right Way Profits, the Growth level of Debbie DeKnight's fractional CFO service includes both a living financial model and a full-day annual planning session. As a general starting point, work from reconciled books, test decisions in the model, then set a budget and check-in dates.

Last updated

What is a financial model for a service business?

A set of linked numbers that shows how the business turns work into profit.

It starts from the drivers, the few inputs that decide the results. Change one, and everything that depends on it moves too. That is what makes a model different from a spreadsheet of last year's totals: it can answer "what happens if?"

How is a model different from a budget or a forecast?

They answer different questions.

Financial modelBudgetCash flow forecast
AnswersWhat happens to profit if a driver changes?What do we plan to earn and spend this year?Will the money be in the bank when each bill is due?
Built fromDrivers linked to revenue, costs and profitTargets for each income and expense lineMoney in and out, by the date it clears or leaves
Used forTesting decisions and scenariosSetting limits and targetsCovering payroll and dated bills

The forecast is covered on its own page: cash flow forecasting for service businesses.

What goes into a service business model?

The drivers of your own business, with each number taken from your own books and operating records.

LineWhat it drivesWhere the number comes from
Leads or callsHow many chances there are to win workYour call log, booking system or CRM
Lead-to-estimate rateHow many leads become estimatesEstimates divided by leads, from your call log or CRM
Close rateHow many estimates turn into jobsJobs won divided by estimates given, from your own records
Average job valueRevenue per jobThe price of the work delivered, by service, divided by the jobs delivered
CapacityHow much booked work the crew can deliver in a periodCrew or technician hours available and the hours a typical job takes
Direct costsGross profit on each jobMaterials, subcontractors and the labor on the job, from the books
OverheadWhat it costs to keep the doors openRent, office payroll, insurance, software and vehicles, from the books
Owner draws and tax set-asideWhat the owner takes beyond any payroll wages, and what is held back for tax, shown below operating profitYour own plan and your accountant's estimate. Owner wages paid through payroll stay in the payroll lines, counted once

If you run Profit First, the allocations can sit in the model too. In Mike Michalowicz's method, the percentages apply to what he calls Real Revenue: income after materials and subcontractors, without subtracting your own employees' wages. So the model gives an estimate of how a change in Real Revenue changes each allocation. How much cash is actually there to allocate on a given date is a question for the cash flow forecast. The Profit First page covers the method.

How do you build one?

In five steps, starting from the books.

  1. Pull the last twelve months from current, reconciled books. Revenue by service, direct costs (with job labor) and overhead (with office payroll), plus the activity behind them: leads, estimates and jobs.
  2. Pick the drivers. Choose the few inputs that explain most of the results. For most service businesses that means some version of the lines in the table above.
  3. Link them. Estimates are leads times the lead-to-estimate rate, and jobs booked are estimates times the close rate. Capacity sets when that work can be delivered, with any backlog carried into the next period. Revenue for the period is the work delivered times average job value. Costs that rise with volume, such as materials, are sized by the same delivered work. Committed payroll and fixed overhead come from your staffing and the costs you have signed up for, so they stay in place when jobs slip, while job-linked labor such as overtime follows the hours worked, and a decision that adds capacity, such as a new hire, adds its payroll cost. That shows profit as it is earned. If your books are kept on a cash basis, expect timing differences against the model; when money actually lands or leaves, deposits and installments included, belongs in the cash flow forecast. Gross profit is revenue minus direct costs, and operating profit is gross profit minus overhead. Owner draws and money set aside for taxes are shown separately below that line; owner wages paid through payroll are already in the labor or overhead lines.
  4. Check it against what happened. Run last year's drivers through the model, using revenue earned and costs incurred from your job, invoice and expense records. If your books are on a cash basis, set aside the timing differences first. If a gap remains, find out which link is wrong before you trust it with next year.
  5. Test scenarios, then keep it current. Change one driver at a time and see what moves. Update the inputs as real results come in.

What does a scenario look like?

One driver changed, everything else held still. This is an illustration with made-up figures, not a client's numbers.

Current yearScenario: price up 5%, same work
Jobs1,0001,000
Average job value$2,000$2,100
Revenue$2,000,000$2,100,000
Direct costs$1,200,000$1,200,000
Gross profit$800,000$900,000
Overhead$600,000$600,000
Operating profit$200,000$300,000

In this illustration a 5% price rise, with the same jobs, the same mix of work and the same costs, takes operating profit from $200,000 to $300,000. The illustration stops at operating profit, before owner draws and the tax set-aside. A real scenario would also ask whether the higher price changes the close rate, which is the next driver to test.

What is annual planning, and how does it work?

Setting the year's targets and deciding what has to happen to hit them.

A general annual plan has five parts:

  1. Look back. What happened last year, by driver, and why.
  2. Set targets. Revenue and profit for the coming year.
  3. Test the path. Run the main decisions, such as a hire, a price change or a new service, as scenarios.
  4. Turn it into a budget and priorities. The chosen path becomes the spending limits, the income targets and a short list of things that have to get done.
  5. Set check-in dates. Compare results with the plan during the year and adjust.

When is it time to get help?

When the biggest decisions are being made on gut feel and the bank balance.

Debbie names that pattern on her fractional CFO page: owners making the biggest calls in the business, "what to charge, who to hire, what to buy", on gut feel and the bank balance. Other signs she lists:

  • You're not sure you can afford the next hire, so you guess.
  • You're growing, but you're not keeping more.

A model is only as good as the books under it, which is why clean books come before any CFO advice. If yours are behind, start with bookkeeping.

How does Right Way Profits help with modeling and planning?

Through the Growth level of its fractional CFO work, for founder-led service and trade businesses doing roughly $3M to $15M a year. In Debbie's words, it adds "a living financial model that connects your business decisions to your actual economics, so you stop managing by feeling and start leading by evidence."

  • The model: in her words, "Every ninety days, the model gets updated, the priorities reset, and the business advances against a plan rather than improvising against circumstances."
  • The annual planning session: "a full-day working session that produces a specific, financially grounded plan for the year ahead."
  • Value: she describes the aim as understanding "what your business is worth financially and what it would take to double it." That is her description; the published Growth description does not call it a formal valuation. The drivers that tend to raise value are on the page about increasing the value of a home service business.
  • Pricing: fractional CFO pricing is set on the call.
  • Not published: the published Growth description leaves the planning-day agenda, model format and software unspecified. The steps on this page are general practice. Ask on the call.

The Scale level, for $15M to $50M businesses, includes everything in Growth. The fractional CFO page for $3M to $15M businesses sets out the Growth level in full. Debbie DeKnight leads Right Way Profits and is a Master Certified Profit First Professional. The Profit First Professionals podcast page about her says she brings over 30 years of accounting experience and calls her a Profit First Master certified coach. For what clients say, read the client testimonials.

Frequently asked questions

What is a financial model for a service business?

A set of linked numbers that shows how the business makes money. It starts from the few inputs that drive results, such as how many jobs you win, what each job is worth, what it costs to deliver and what the business spends to run, and works out revenue, gross profit, overhead and profit from them. Change one input and the results move with it, so you can test a decision before you make it.

How is a financial model different from a budget or a cash flow forecast?

A budget sets the spending and income targets for the year. A cash flow forecast lists the money expected in and out of the bank by date, so you can see whether each bill will be covered. A financial model explains why the numbers come out the way they do, by linking them to their drivers, and lets you test changes such as a price rise or a new hire. They work together: the model tests the choices, and the budget records the one you pick.

What numbers do I need to build a financial model?

Your own history, ideally the last twelve months from current, reconciled books: revenue by service, the cost of materials, subcontractors and job labor, overhead (including office payroll), and the activity behind the revenue, such as leads, estimates given, jobs won and the average value of a job. If the books are behind, catch them up first, because a model built on wrong numbers gives wrong answers.

What is annual planning?

Setting the targets for the coming year and deciding what has to happen to reach them. A general annual plan looks back at the year just finished, sets revenue and profit targets, tests the main decisions as scenarios, turns the chosen path into a budget and a set of priorities, and sets dates to check progress during the year.

How often should a financial model be updated?

As general practice, often enough that it still matches the business: on a set rhythm, and before a big decision. In Debbie DeKnight's Growth level, in her words, "Every ninety days, the model gets updated, the priorities reset, and the business advances against a plan rather than improvising against circumstances."

Does Right Way Profits help with financial modeling and annual planning?

Yes, in the Growth level of its fractional CFO work, for businesses of about $3M to $15M a year. It includes a living financial model, a model update every 90 days and a full-day working session that produces a plan for the year ahead. Debbie DeKnight leads Right Way Profits, which serves founder-led service and trade businesses across the US. Fractional CFO pricing is set on the call, and at the end of the 45-minute discovery call you will know whether Debbie can help.

Want to test next year before you live it?

Book a 45-minute discovery call. At the end you will know whether Debbie can help.

Call Book a call