Revenue & Calc
Set capacity, utilization, seasonality, service shares, and hourly prices. Monthly calculations roll into annual forecasts.
This Excel Window Cleaning Service Financial Model converts technician capacity, utilization, service mix, hourly prices, and seasonality into monthly revenue and annual projections for a U.S. suburban low-rise mobile operator.
The illustrative 2026–2030 case uses one owned van, two salaried technicians, and a half-time owner-manager. It excludes high-rise and rope-access work; projections are estimates, not historical results or industry averages.
The workbook connects operating assumptions to monthly calculations, statements, funding schedules, and decision reports.
Set capacity, utilization, seasonality, service shares, and hourly prices. Monthly calculations roll into annual forecasts.
Plan revenue-linked supplies, route costs, overhead, technicians, and owner-manager payroll without double-counting compensation.
Record the van, equipment, startup purchases, and owner equity separately from operating expenses.
Review Income Statement, Cash Flow, Balance Sheet, Summary, and reconciliation checks.
Use Low, Base, and High scenarios, Returns, Valuation, and Charts to test decisions.
Revenue is built from a single pool of available technician hours, adjusted for utilization and monthly seasonality, then allocated among five services.
Available capacity is 320 technician hours monthly. Billable utilization rises from 55% in 2026 to 75% in 2030; monthly seasonality ranges from 0.80 to 1.15 and averages 1.00 annually.
Residential exterior uses 30% of billable hours at $70; inside-and-out residential uses 25% at $75; storefront routes use 20% at $65. Low-rise offices take 15% at $80, and restoration or detailing takes 10% at $90 per hour.
The Revenue Forecast organizes capacity, utilization, service mix, prices, and projected revenue. Calc applies launch timing and seasonality before adding five non-overlapping services into annual sales.
320 technician hours/month × 12 months × 55% utilization × $73.75 mix-weighted hourly price × 1.00 average seasonal factor = $155,760 revenue.
The five service shares total 100%, avoiding duplicated billable hours. The $73.75 mix-weighted rate comes from the entered prices and service allocation.
The expense forecast separates revenue-linked supplies and route costs from fixed monthly overhead and salaried staffing.
Direct COGS equal 3.5% of sales: 2.5% cleaning chemicals and disposables plus 1% pure-water filters and resin. Variable operating expenses equal 11.5%: fuel and parking 3.5%, payment processing 2.5%, recurring local marketing 5%, and rework or damage 0.5%.
Fixed expenses total $19,800 annually for storage, insurance, maintenance, software, connectivity, accounting, and administration. Storage and parking alone are $400 monthly.
The COGS and Operating Expenses forecast applies revenue-linked percentages and separately schedules monthly fixed costs. It shows how increasing utilization affects operating margins.
Salaried technicians are paid for nonbillable time, even when utilization falls. Compensation appears in Payroll once, not again in COGS or other expenses.
The Payroll Forecast plans two technician FTEs earning $42,000 annually each and 0.5 owner-manager FTE at a $50,000 full-time base. Total annual base payroll is $109,000.
Opening equipment purchases and capital requirements are tracked apart from annual cleaning-service operating costs.
Startup assets total $38,000: a $25,000 van, $9,000 pure-water systems, $2,500 ladders and tools, and $1,500 office and storage equipment. These are capital purchases, not annual EBITDA expenses.
Another $6,300 covers a refundable deposit, preopening marketing, setup, and training or base labor. Accounts receivable, payable, and inventory settings are 9, 0, and 30 days, respectively.
The Capital Expenditure Plan records van and equipment purchases, timing, and depreciation treatment. Its asset schedules support financial statements without booking startup investment as ordinary operating spending.
Estimated owner funding is $86,630, including about $4,289 working capital and a $38,041 reserve covering three months of first-year operating outflows. No external funding is committed.
The Sources and Uses of Funds report reconciles funding with assets, startup cash, working capital, and liquidity reserves. It separates owner contributions from operating revenue.
The Base case projects rising revenue and EBITDA as utilization improves while salaries remain fixed.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $155,760 | $152,164 | $3,596 |
| 2027 | $175,584 | $155,138 | $20,446 |
| 2028 | $192,576 | $157,686 | $34,890 |
| 2029 | $203,904 | $159,386 | $44,518 |
| 2030 | $212,400 | $160,660 | $51,740 |
Illustrative financial projections; displayed amounts are rounded to whole dollars, so calculations may differ slightly at display precision.
At 55% utilization, 2026 revenue is $155,760 and EBITDA is $3,596. At 75% utilization in 2030, revenue is $212,400 and EBITDA $51,740, with $109,000 payroll and $19,800 fixed overhead unchanged.
The Projected Income Statement links sales, direct and variable costs, payroll, and overhead to operating margins and EBITDA. Although the workbook calculates below-EBITDA accounting lines, these inputs do not establish net profit.
EBITDA excludes depreciation, interest, and taxes and is not owner cash. Collections, inventory, CAPEX, debt, and equity can affect liquidity differently from operating profit.
The Cash Flow Forecast reconciles monthly operating, investing, and financing movements to closing cash. Review receipts, equipment purchases, owner contributions, and possible debt activity separately from EBITDA.
The Returns and scenario tools help test whether a particular schedule of jobs, costs, and financing assumptions supports owner decisions.
The Returns report separates sales break-even, cash break-even, investment payback, and annual ROIC. These measure operating coverage, liquidity timing, capital recovery, and returns relative to capital employed.
The Returns analysis calculates break-even, payback, and ROIC from supporting schedules. No specific payback month or annual ROIC percentage is established for this example.
Dashboard Low, Base, and High controls vary revenue and major cost groups. Debt schedules support financing choices, and Valuation offers DCF sensitivities; no loan terms or valuation outcome is assumed.
The template fits owners planning a small, van-based residential and low-rise commercial cleaning operation.
Test utilization, route mix, prices, seasons, and salaries before changing staffing or marketing. Lenders and advisors can examine statements and funding assumptions rather than sales alone.
The example excludes high-rise services, benefits, and employer payroll taxes. Adapt estimated labor, insurance, travel, and customer inputs to local conditions before making decisions.
These answers clarify how the documented operating model and workbook reports are intended to be used.
Yes. Edit monthly technician capacity, annual billable utilization, service allocation, realized hourly rates, and seasonality to recalculate the revenue forecast.
Yes. The five modeled streams include residential exterior, residential inside-and-out, storefront routes, low-rise offices, and restoration or detailing.
No. The illustrated technicians receive fixed salaries, including during nonbillable time, making utilization a key driver of operating EBITDA.
Yes. It includes projected Income Statement, Cash Flow, Balance Sheet, and combined reporting; this illustrated case is documented through EBITDA.
No. Owner contributions fund assets, opening cash, working capital, and reserve requirements. They are separate from service revenue and operating EBITDA.
No. Returns reports calculate modeled break-even, payback, and ROIC, not a guaranteed investment outcome.
Yes. Dashboard controls provide Low, Base, and High cases for revenue and major cost categories, alongside comparative profitability reporting.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
This template showed me exactly what investors expect to see, so I stopped guessing about structure and outputs. It made my deck review much easier and helped me walk into the meeting with clearer assumptions.
I didn’t have to start from an empty spreadsheet, which honestly was the hardest part for me. The ready-made layout got me from idea to first draft in one afternoon.
Building the revenue, expenses, and cash flow by hand would’ve taken me days. This model cut that down by about 8 hours and left me with a cleaner file to share.