Module 2: Revenue, Margins, and Driver-Based Forecasting
Learning objectives and prerequisites
By the end of this lesson, you should be able to build revenue from customers, prices and available capacity. Prerequisite knowledge: Module 1 and basic multiplication of volume by price. Work from assumptions to equations, explain the acquisition consequence, and record the evidence needed to rely on the answer.
Units: $000 unless a section explicitly states otherwise.
Learning objectives: Translate commercial evidence into a forecast, distinguish price from volume, and connect growth to capacity and margins. Study time: 2 hours.
Forecast the mechanism, not a percentage
A blanket growth rate hides why sales should happen. Divide Harbor's revenue into recurring maintenance and project work. For recurring revenue, forecast opening contracts, retention, new wins, and annual revenue per contract. For projects, forecast jobs completed multiplied by average realized price. Separate quoted prices from discounts and actual invoices. Contract backlog is evidence of potential work, not cash already earned.
For a service business, capacity constrains growth. Estimate productive technicians, paid hours, utilization, and realized billing rate. If the sales forecast implies more billable hours than employees can deliver, add hiring, overtime, subcontracting, or a capacity limit. Include recruiting lead time and the reduced productivity of new employees. Revenue growth without these costs creates an artificial margin expansion.
Worked operating forecast
Harbor starts with 100 maintenance contracts at annual revenue of 30 each. Assume 90% retention, ten new contracts, and a 3% price increase. For this simplified annual exercise, all new contracts contribute a full year:
Retained contracts = 100 × 90% = 90
Ending contracts = 90 + 10 = 100
Annual revenue per contract = 30 × 1.03 = 30.9
Maintenance revenue = 100 × 30.9 = 3,090
Project revenue = 200 jobs × 10.5 = 2,100
Total revenue = 5,190
If contracts arrive evenly through the year, use approximately half a year's revenue for new wins instead. That timing difference reduces maintenance revenue by 154.5 here. Model beginning and ending contracts explicitly so the next year starts from the correct installed base.
Suppose direct labor and materials consume 58% of sales, fixed operating expenses are 1,200, and incremental recruiting costs are 80. Gross profit is 2,179.8 and EBITDA is 899.8. Compare this result to the historical 800. Explain the improvement using price, mix, utilization, and cost changes rather than accepting the output because it looks plausible.
Evidence and scenario design
Request customer-level invoices, cancellations, signed contracts, backlog, technician rosters, wage rates, and vendor pricing. Reconcile segment revenue to the general ledger before trusting segment margins. A top customer growing quickly can make total growth look healthy while concentration worsens.
Build a downside case with lower retention, fewer jobs, and wage pressure together. Some expenses vary immediately with sales; others remain fixed until staffing or lease decisions change. Separate variable cost percentages from fixed dollars. Do not reduce all expenses mechanically when revenue falls.
Forecast nominal revenue and nominal costs if the discount rate is nominal. Price inflation does not automatically increase real profitability when wages and materials rise too. Keep customer churn and price increases independent so a price rise can trigger lost volume.
Spreadsheet implementation
Create rows for beginning contracts, lost contracts, wins, ending contracts, average active contracts, and revenue per contract. Put project volume and realized price in separate rows. Add checks that retention is between 0% and 100%, contract counts are nonnegative, and implied utilization is physically achievable. Add a historical-to-forecast bridge for revenue and EBITDA.
Practice and answer key
A business retains 85 of 100 contracts, adds 12 full-year contracts, and charges 32 per contract. Project revenue is 1,800. Direct costs are 60% of revenue and fixed expenses 1,100. Find revenue and EBITDA.
Solution moved to the separate instructor key.
Deliverable: A five-year driver forecast with a capacity check and written support for retention, price, wage inflation, and new-customer assumptions.
Forecast timing is a cohort problem
The original contract example assumes every new customer contributes a full year. That convention is useful for isolating price and volume, but is usually optimistic for a business that signs contracts throughout the year. Separate beginning customers, retained beginning customers, new customers and churn. Apply the appropriate fraction of a year to each cohort rather than multiplying ending contracts by annual price automatically.
If Harbor retains 90 beginning contracts at 30.9 each and adds ten evenly during the year, retained revenue is 2,781 and new-customer revenue is 154.5. Total recurring revenue is 2,935.5, not 3,090. With the same 2,100 project revenue, total sales become 5,035.5. At a 42% contribution margin, before any staffing response, this timing change reduces EBITDA by 64.89. A small-looking timing assumption can move debt coverage and the bid materially.
Do not apply another half-year discount to the same new-customer revenue in the DCF after already recognizing only half-year service. Recognition timing and the convention used to discount collected cash are related but separate. The operating forecast should measure what is earned and collected; the discounting convention should describe when those cash flows are available.
Convert growth into productive capacity
Suppose each technician supplies 2,000 paid hours, of which 70% are billable, and customers realize 150 dollars per billable hour. One technician supports 210,000 dollars annual labor revenue. Ten technicians therefore support 2.1 million dollars before parts or other separately modeled billings. If the forecast requires 2.4 million on those assumptions, the model must add capacity, improve supported utilization or pricing, or reduce the sales forecast.
This calculation does not establish a universal industry productivity standard. Training, travel, callbacks, holidays and scheduling affect available hours. Ask for time sheets, dispatch records and billed hours. A model that increases utilization without accounting for travel can create revenue that staff cannot deliver. A newly hired technician may operate below the mature utilization rate for several months, so hiring adds costs before it produces the full forecast benefit.
Derive a margin bridge
Gross margin measures sales remaining after the chosen direct-cost definition. EBITDA additionally subtracts recurring operating overhead. Maintain a consistent classification: moving dispatch wages from direct costs to overhead changes reported gross margin but should not change EBITDA. A buyer who compares gross margins across two businesses must first align cost classifications.
Build an EBITDA movement bridge with separate effects for retained volume, new business, price, materials, wages, staffing and fixed occupancy. State which costs respond immediately to sales and which require an operating decision. If sales decline 10% but the workforce and lease remain in place, expenses cannot all decline 10%. This is operating leverage, and it explains why a modest revenue decline can sharply reduce acquisition cash generation.
Model assignment: reconstruct and challenge the drivers
Create annual columns for beginning contracts, retention, wins, service fraction, price, project jobs, realized project price, technician hours and available capacity. Calculate three independent checks: customer roll-forward, revenue tie-out and required versus available hours. Then run a combination of 85% retention, lower realized project pricing and wage pressure. Explain which assumptions can be verified before closing and which represent the buyer's operating plan.
Keep the five-year capstone's simplified 4% growth assumption separate. The purpose of this lab is to learn how to challenge that shorthand from underlying evidence, not to claim that the standalone cohort inputs are the capstone's source data.
Spreadsheet construction and audit lab
Enter beginning contracts, retention, wins, annual pricing and the fraction of the year served. Calculate project volume independently. Link variable costs to the relevant sales pool, and fixed costs to staffing and facilities.
Use named row labels and explicit units. Blue-font inputs should contain assumptions or source data; black-font formulas should calculate results from those inputs. Reproduce the worked example first, then change one economically important assumption and predict the direction of the result before recalculating. Save a base case and a dated challenge case rather than silently replacing assumptions. A zero arithmetic check does not establish an executable deal.
Learning summary and further reading
Build revenue from customers, prices and available capacity. The acquisition decision depends on the bridge between source evidence, modeled cash and the claim being valued. Explain what the model includes, what it omits, and which outstanding evidence could reverse your conclusion. Consult the source and alignment references for attributed public reading; fictional case assumptions are not market observations or legal approvals.
Previous module · Next module · Sources and CFI alignment
Independent assessment
Complete the student assignment before consulting the separate instructor key. The chapter's worked examples teach the method; the assignment uses independent inputs.