This Excel financial model is designed for a startup that collects empty delivery boxes and other recyclable materials from residential and commercial customers. It can be used to evaluate an initial launch, test the economics of individual regions, and plan expansion into as many as five regions over a ten-year period.
After purchase, the template will be immediately available to download and is also included in the industry-specific models bundle and the Super Smart Bundle.
The model contains 120 months of detailed projections, along with annual summaries, financial statements, valuation analysis, and an executive dashboard. This is built for the user to input their own data (shaded cells with blue text) and see if the scenario is feasible.
Revenue and Customer Modeling
Revenue can be generated from four primary sources:
- Residential subscriptions
- Recurring commercial accounts
- On-demand pickup fees
- Sales of recovered or reusable materials
Residential and commercial customer counts are projected using lead generation, conversion rates, churn, market size, and maximum market-share assumptions. Each new region follows an editable ramp-up period, allowing the model to reflect the time required to build route density and customer awareness.
Regional launch timing, addressable households, addressable businesses, and local demand assumptions can all be changed.
Pickup and Material Recovery Economics
Customer counts are converted into pickup volume based on service frequency. The model then calculates:
- Total pickups
- Pounds collected
- Recovered material tons
- Residual disposal tons
- Material recovery revenue
- Revenue and cost per pickup
- Contribution profit and contribution margin
Recovered materials can be divided between cardboard, mixed paper, plastic film, and reusable or other materials. Each category has its own share of recovered volume and estimated value per ton.
Fleet and Facility Capacity
The model automatically estimates the number of vehicles required based on monthly pickup volume, stops per vehicle per day, operating days, and productive utilization.
It also calculates:
- Vehicle utilization
- New vehicle purchases
- Facility capacity requirements
- New facility openings
- Facility utilization
- Driver requirements
- Sorting labor requirements
- Route and processing costs
These schedules help identify when the company needs to add vehicles, employees, or facility capacity as it grows.
Headcount and Operating Expenses
The staffing schedule includes both direct field labor and indirect operating support. Headcount can scale based on active regions, customers, and vehicles.
Positions modeled include:
- Drivers and sorting employees
- Regional managers
- Dispatchers
- Mechanics and fleet technicians
- Safety and quality assurance staff
- Sales representatives
- Executive management
- Finance and administrative employees
- Marketing employees
- Technology employees
Payroll taxes, benefits, wage inflation, software, professional fees, facility rent, utilities, customer acquisition costs, and other operating expenses are also included.
Capital Expenditures and Financing
The model includes detailed schedules for:
- Vehicle purchases
- Facility equipment
- Regional launch equipment
- Technology platform development
- Maintenance capital expenditures
- Depreciation and amortization
- Debt draws
- Interest expense
- Principal repayment
- Initial and follow-on equity funding
This makes it possible to estimate how much funding the company may require and when additional capital may need to be raised.
Integrated Financial Statements
The workbook contains fully connected monthly financial statements, including:
- Income statement
- Balance sheet
- Cash flow statement
- Working capital
- Net operating loss carryforward
- Debt balances
- Retained earnings
- Cash balances
The financial statements roll into a ten-year annual summary showing revenue, gross profit, EBITDA, net income, cash flow, capital expenditures, debt, and key operating metrics.
Scenarios, Valuation, and Sensitivities
The model includes Downside, Base, and Upside scenarios. Changing the selected scenario adjusts demand, pricing, churn, recovered-material values, fuel costs, labor costs, and capital costs throughout the workbook.
Valuation tools include:
- Discounted cash flow analysis
- Gordon Growth terminal value
- Exit EBITDA multiple
- Enterprise value
- Equity value
- Equity multiple
- Estimated investor return
Sensitivity tables show how valuation changes based on WACC, terminal growth, exit multiples, and Year 10 EBITDA. A separate pricing analysis shows how residential contribution changes at different subscription prices and pickup frequencies.
What the Model Can Be Used For
The template can be used to:
- Evaluate whether the initial business concept is financially viable
- Determine appropriate subscription prices and service frequency
- Estimate revenue and contribution margin per pickup
- Plan the timing of regional expansion
- Forecast vehicle, facility, and staffing requirements
- Estimate startup capital and follow-on funding needs
- Identify cash-flow shortfalls before they occur
- Compare downside, base, and upside outcomes
- Test how route density and customer retention affect profitability
- Prepare financial projections for investors, lenders, or internal planning
- Estimate the potential value of the business over time
All major assumptions are editable and clearly identified using yellow cells with blue text. The template includes illustrative starting assumptions, but users should replace them with their own pricing, market research, operating data, vendor quotes, and financing terms.
Similar Templates:
