Revenue and Calc
Enter technician count, service days, daily route hours, utilization, service mix, and realized hourly yields. Monthly calculations allocate the same route-hour pool across the five cleanup categories.

This pet waste removal financial model is an Excel template for planning a residential dog-waste cleanup route in Houston, Texas. It connects the hours one technician can sell, the allocation across five services, realized hourly yields, operating expenses, and staffing to monthly and annual financial projections for 2026–2030.
The case uses one vehicle, a paid owner-technician, and part-time scheduling support. Waste is double-bagged into the customer’s outdoor bin; hauling, commercial stations, dog walking, landscaping, and deodorizer upsells are excluded.
The template links route operations and configurable business assumptions to financial statements, funding schedules, and management reports.
Enter technician count, service days, daily route hours, utilization, service mix, and realized hourly yields. Monthly calculations allocate the same route-hour pool across the five cleanup categories.
Set direct costs, payment and advertising rates, fixed monthly overhead, and staffing assumptions. The Payroll schedule keeps the working owner’s salary and assistant compensation separate from other operating costs.
Plan vehicle and tool purchases, equity funding, and optional financing. Dashboard debt controls support up to four facilities, while Sources & Uses and Cash Flow distinguish funding from operating revenue.
Review Income Statement, Cash Flow, Balance Sheet, Scenarios, Returns, Valuation, and Checks reports. The illustrated numeric projections here are documented through EBITDA only.
Revenue comes from sold route hours multiplied by the realized hourly yield of each mutually exclusive service category.
With one technician, 20 route days per month, and eight hours per day, available capacity is 160 route hours monthly. These hours include onsite cleanup and attributable between-stop travel, rather than billable hourly customer invoices.
Utilization increases annually from 45% to 55%, 65%, 72%, and 80%. Sold hours are allocated once among categories, without duplicating capacity or forecasting separate customer demand.
The Revenue Forecast translates route capacity, sold-hour utilization, category allocation, and realized hourly yields into monthly and annual service revenue. Editing any driver changes the revenue contribution of the five cleanup offerings.
| Cleanup service | Sold-hour share | Yield per hour |
|---|---|---|
| Weekly, one dog | 40% | $60 |
| Weekly, two dogs | 25% | $75 |
| Twice weekly, one dog | 15% | $45 |
| Biweekly, one dog | 15% | $60 |
| One-time, one dog | 5% | $75 |
The allocations total 100%; their weighted realized yield is $62.25 per sold route hour. These yields are not stated customer visit prices.
1 technician × 20 days/month × 8 hours/day × 45% utilization × 12 months × $62.25 weighted yield = $53,784.
The launch is active for the full January 2026 modeling month despite the January 31 setup date. Revenue is earned when cleanup work is performed, excluding sales taxes and customer prepayments for services not yet delivered.
The operating budget separates revenue-linked service costs, recurring fixed overhead, and salaries so each expense is counted once.
Estimated direct costs are 3% of revenue for bags, gloves, and disinfectant, plus 5% for vehicle fuel. Variable expenses add 3.5% for payment processing and 4% for booking-linked advertising, producing a combined revenue-linked cost rate of 15.5%.
Annual fixed expenses are $10,620 for storage, insurance, maintenance, software, communications, bookkeeping, permits, and baseline marketing. Each fixed line can be edited.
The COGS and Operating Expenses forecast separates supplies and fuel from transaction-related spending and fixed monthly overhead. Those inputs feed the projected operating margins without including salaries a second time.
Payroll assumes one paid owner-technician at a $42,000 annual base and 0.25 annual-average FTE scheduling assistant at a $44,000 full-time salary. The assistant therefore costs $11,000 in annual base pay, making combined modeled payroll $53,000 per year.
The Payroll Forecast tracks roles, annual FTE, compensation, and their monthly personnel expense impact. It allows the owner route role and part-time administrative support to be evaluated independently of fuel, supplies, and overhead.
The case separates durable equipment, distinct preopening spending, initial working capital, and a cash reserve from ongoing operating results.
Startup equipment totals $17,450: a $16,000 used service vehicle, $450 for durable scoops and wash gear, and $1,000 for a business laptop and phone. These opening asset purchases are not repeated as annual operating expenses.
The Capital Expenditure Plan organizes durable vehicle, tool, and technology purchases by spending date and depreciation treatment. It distinguishes the initial investment in operating equipment from supplies and maintenance consumed in daily service.
| Startup use | Amount |
|---|---|
| Durable startup assets | $17,450 |
| Distinct preopening cash | $3,000 |
| Opening working capital | $133 |
| Three-month cash reserve | $17,989 |
| Total owner funding | $38,572 |
Amounts are rounded from source assumptions. The budget has not been tested as the peak cash-funding requirement.
Preopening cash covers formation and professional setup, the initial website and launch campaign, and training and route setup. Receivable and payable days are both zero; inventory is set to 11 days, affecting opening working-capital assumptions.
The $38,572 rounded opening funding amount is an assumed owner equity contribution, not customer revenue or evidence of approved borrowing. No external financing was confirmed for the illustrative case.
The Sources and Uses of Funds report separates equity and any entered debt from operating receipts, investment purchases, financing payments, and retained cash. It helps trace how startup resources are allocated without treating owner funding as earnings.
The specified capacity and cost assumptions produce growing annual revenue and a move from negative to positive EBITDA in 2028.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $53,784 | $71,957 | -$18,173 |
| 2027 | $65,736 | $73,809 | -$8,073 |
| 2028 | $77,688 | $75,662 | $2,026 |
| 2029 | $86,054 | $76,958 | $9,096 |
| 2030 | $95,616 | $78,440 | $17,176 |
Illustrative forecast, not historical performance. Values are rounded to whole dollars; EBITDA equals revenue minus the unrounded modeled operating expenses.
Revenue expands as sold-hour utilization increases against the same one-technician route capacity. In the 2030 base case, 80% utilization gives 128 sold route hours monthly and $95,616 in annual service revenue at the unchanged weighted yield.
The example’s operating expenses rise from approximately $71,957 to $78,440 because revenue-linked costs increase while modeled fixed overhead and base payroll remain constant. Positive EBITDA does not establish positive net profit, excess cash, or a recovered startup investment.
The Cash Flow Forecast distinguishes service receipts and operating payments from the purchase of equipment, equity contributions, and optional debt transactions. It supports a liquidity review that cannot be replaced by the EBITDA values shown in the annual table.
Returns and scenario tools support distinct decisions about covering operating costs, funding the business, and recovering invested capital.
Returns distinguishes sales break-even, cash break-even, cumulative project cash flow, investment payback, and annual ROIC. These metrics are not interchangeable with EBITDA.
Dashboard Scenario Controls apply Low, Base, and High multipliers to revenue, direct costs, variable and fixed expenses, and payroll. They test sensitivities without promising base-case outcomes.
The Returns analysis combines sales break-even, project cash-flow payback, and annual ROIC reporting. The illustrated inputs do not establish a payback date or numerical return, so those metrics must be reviewed after the buyer configures the model.
Valuation and sensitivity reports are available for reviewing model-based enterprise and equity value assumptions, while Checks flags model inconsistencies. The supplied case does not document a business valuation, financing terms, IRR, or the point of cash break-even.
The template is designed for operators and advisers who need an editable single-route residential pet waste cleanup forecast.
Adjust route hours, utilization, service mix, yields, supplies, fuel, marketing, and staffing, then compare operating EBITDA with cash flow and funding impacts.
This Houston residential-route example is not observed performance or an industry average. Commercial services and offsite disposal require different assumptions.
These answers clarify the example’s operating assumptions, editable inputs, and limits.
Technicians × monthly route days × daily route hours × sold-hour utilization, with those sold hours allocated across five services and multiplied by their realized hourly yields.
No. The $45, $60, and $75 amounts are realized revenue per sold route hour, including the effect of travel and onsite time.
Yes. Route utilization, category hour shares, hourly yields, working days, and route hours are revenue inputs that can be adjusted for a different operating plan.
No. The illustrated service double-bags waste and puts it in the customer’s designated outdoor bin; hauling and commercial stations are outside the modeled scope.
No. The $2,026 projected 2028 EBITDA is an operating measure, not evidence of positive net profit, investment payback, or cash break-even.
No. The estimated $38,572 owner-funding budget includes a reserve, but it is not a tested maximum funding need or a confirmed loan commitment.
No. The illustrative pass-through business excludes personal income taxes, employer payroll taxes, and benefits; the workbook has broader statement and tax controls.
Yes. Dashboard controls support up to four financing facilities and Low, Base, and High scenario multipliers; the provided base case assumes no confirmed outside financing.
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 gave me the exact structure I needed for our investor deck, so I stopped guessing what to include. It saved me about 6 hours and made the numbers much easier to walk through in meetings.
I had pricing, labor, and growth ideas all over the place, and this model pulled them into one clean setup. It cut my planning time by an afternoon and made the assumptions easy to update.
The margin and break-even tabs made it easy to see when the business starts paying for itself. I could spot the weak spots right away and tighten the plan before sharing it.