Revenue & Calc
Enter processing capacity, operating days, utilization, commodity allocation and prices; the monthly calculations build volume and sales for each material.
Recycling Facility Financial Model and Projections Template
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Recycling Facility Financial Model is an Excel template for planning the volumes, commodity sales, operating costs, staffing, and financial statements of a source-separated commercial recycling center. Its capacity-based revenue forecast links processing time and utilization to six individually priced material streams.
The illustrative case is a 12,000-square-foot facility in the outer Chicago industrial corridor, processing and baling materials for commodity shipment. It models 2026 through 2030, starting January 31, 2026, using editable US-dollar assumptions rather than a signed lease, secured supply contracts, or observed results.
- Forecast
- 5annual forecast years
- Material streams
- 6revenue categories
- Net throughput
- 4short tons per hour
WORKBOOK CONTENTS
What Is Included in This Financial Model?
The workbook connects recycling-specific operating assumptions to monthly projections and supporting financial reports.
COGS & OPEX and Payroll
Edit material purchases, freight, processing costs, fixed site expenses, staffing levels and base compensation without counting salaries twice.
CAPEX and Funding
Schedule equipment purchases and depreciation, record owner equity and optional debt, and examine sources and uses of funds.
Financial Statements
Review the Income Statement, Cash Flow Statement, Balance Sheet and Summary as distinct views of earnings, liquidity and financial position.
Analysis and Checks
Use Dashboard scenario controls, Returns, Valuation, Ratios, Benchmarks and reconciliation checks to explore decisions and inspect model consistency.
REVENUE FORECAST
How Is Recycling Revenue Calculated?
Annual sales equal one pool of net saleable short tons multiplied by the selected commodity mix and the selling price of each allocated stream.
The modeled line handles 4 net saleable short tons per processing hour, with 8 processing hours per day and 22 operating days per month. That produces 704 short tons of monthly saleable capacity before applying productive utilization; normal reject loss is already excluded.
Utilization is estimated at 45% in 2026, then 55%, 65%, 72% and 78% through 2030. Total outgoing tonnage is allocated once: 50% cardboard, 20% office paper, 10% steel, 10% PET, 2% natural HDPE and 8% aluminum cans.
Revenue Forecast
The Revenue Forecast shows how scheduled processing capacity, productive utilization, commodity mix and prices generate volume and sales by stream. Monthly calculations feed the annual revenue projections and allow different utilization plans to be compared.
Illustrative 2026 capacity-to-sales calculation
704 short tons/month × 45% utilization × 12 months = 3,801.6 saleable short tons; at a $251 mix-weighted price per ton, revenue is approximately $954,202.
Selected prices per short ton are $70 for cardboard, $120 for office paper, $190 for steel, $50 for PET, $1,200 for natural HDPE and $1,800 for aluminum. These are estimated model inputs, not verified transaction prices.
All streams remain zero before the single launch date. The January 2026 launch month is treated as a normal full month, with no seasonal multiplier or separate income from municipal mixed waste, glass, e-waste or bottle deposits.
OPERATING COSTS
How Are Expenses and Payroll Forecast?
The model separates commodity-related direct costs, variable processing costs, monthly facility expenses and fixed base pay by employee role.
COGS and Operating Expenses
The COGS and Operating Expenses forecast applies material purchases, freight, baling supplies and reject disposal as direct costs. It separately models revenue-linked processing power and brokerage costs, plus monthly site expenses such as rent, insurance and equipment maintenance.
In the selected case, purchases are 45% of revenue, outbound freight 7%, baling consumables 1.5% and reject disposal 1.5%. These direct costs total 55% of revenue; processing power and fuel at 2% plus buyer brokerage at 1% add variable costs of 3%.
Monthly fixed expenses cover base rent, property pass-throughs, insurance, maintenance, utilities and security, administration, permits and monitoring. Facility rent begins at $8,000 per month in 2026 and rises in the planning assumptions; these fixed costs do not include the listed employee salaries.
Payroll Forecast by Staff Role
The Payroll Forecast plans staffing in full-time-equivalent terms by role and annual base salary. Facility management, sorting, loader and baler operations, and scale-office coverage produce monthly personnel costs separately from COGS and other operating expense categories.
Illustrative 2026 annual base payroll
$70,000 manager + 3 × $42,000 sorting operators + $48,000 loader/baler operator + 0.5 × $44,000 clerk = $266,000.
The staffing plan grows from 5.5 average FTE in 2026 to 7.5 in 2030, when modeled annual base payroll is $354,000. Employer payroll taxes, benefits and personal taxes are excluded from this illustrative operating case, despite the workbook having payroll-tax input controls.
STARTUP INVESTMENT
How Are Equipment and Opening Funds Planned?
Startup asset purchases, preopening cash items and owner funding are modeled separately from recurring operating expenses and EBITDA.
Capital Expenditure Plan
The Capital Expenditure Plan schedules startup equipment purchases and tracks depreciation for eligible assets. The selected opening equipment includes a $180,000 horizontal baler, $60,000 sorting conveyor and bins, $70,000 loader and forklift, and $15,000 certified scales.
Those four priced assets total $325,000 before electrical and fire improvements and office or weighing hardware. Other startup cash items include a refundable site deposit, permits, engineering and commissioning, promotion and preopening base pay; none is an additional annual COGS line.
The case uses 30 accounts-receivable days, zero accounts-payable days and 8 inventory days as working-capital planning inputs. These affect the cash conversion picture but should not be confused with sales or EBITDA.
Sources and Uses of Funds
The Sources and Uses of Funds report organizes cash sources and their allocation to operations, investment and financing needs. The opening plan includes estimated owner funding of $814,943 for asset and launch cash, initial working capital and a three-month recurring cash-outflow reserve.
ILLUSTRATIVE PROJECTIONS
What Does the Five-Year Forecast Show?
This selected scenario projects increasing revenue as productive throughput rises, with a first positive EBITDA year in 2027.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $954,202 | $993,437 | -$39,235 |
| 2027 | $1,166,246 | $1,153,643 | $12,603 |
| 2028 | $1,378,291 | $1,338,006 | $40,286 |
| 2029 | $1,526,723 | $1,429,634 | $97,089 |
| 2030 | $1,653,949 | $1,509,129 | $144,820 |
Illustrative projections, not historical performance. Figures are rounded to the nearest dollar; displayed subtotals may differ slightly.
With 45% utilization, 2026 has an estimated EBITDA loss of $39,235. The scenario first turns EBITDA-positive in 2027 at $12,603, reaching $144,820 in 2030 as utilization reaches 78%; its selected commodity prices remain constant.
EBITDA measures operating results before depreciation, interest and taxes. It does not establish accounting net profit or cash left after equipment purchases, collection delays, repayments and other financing movements.
Cash Flow Forecast
The Cash Flow Forecast separates operating cash receipts and payments from capital expenditure, equity contributions and any configured debt flows. It helps examine liquidity and cash balances independently from EBITDA, using receivable, payable and inventory assumptions.
BREAK-EVEN AND RETURNS
How Can You Evaluate Break-Even and Payback?
The Returns and scenario reports help test operating thresholds and investment economics without treating EBITDA as a cash return.
Break-Even, Payback and ROIC
The Returns report distinguishes sales break-even, cash break-even timing, investment payback and annual return on invested capital. It uses the model’s operating and investment schedules rather than assuming positive EBITDA automatically means recovered startup funding.
Sales break-even compares revenue with the level needed to cover modeled costs; cash break-even asks when cash generation crosses its threshold. Investment payback measures recovery of invested cash, while annual ROIC examines returns relative to invested capital.
Low, Base and High controls on the Dashboard adjust revenue and cost multipliers for comparison. The Valuation report provides DCF and sensitivity analysis, and Benchmarks compares selected margins and returns with user-entered reference levels; no payback date or valuation is asserted here.
MODEL APPLICATION
Who Is This Recycling Facility Model For?
The template fits early planning and scenario evaluation for a small, commercial, source-separated processing facility.
Use the Excel financial model to test line utilization, materials pricing, hiring plans and opening funding before committing to a site or supplier terms. The modeled case represents a privately owned US pass-through LLC in the Midwest, not a contracted operating business.
It does not include curbside collection trucks, a municipal mixed-waste line, glass, hazardous waste, e-waste or bottle-deposit redemption. Replace estimated costs and prices with your own quotes, operating plan and local requirements before relying on any projection.
FREQUENTLY ASKED QUESTIONS
Recycling Facility Financial Model FAQs
Answers about the operating scope, assumptions, financial reports and limits of this illustrative case.
Can I change the recycling throughput?
Yes. Edit short tons per hour, daily processing hours, operating days and productive utilization to recalculate the monthly volume and revenue forecast.
Does each commodity use separate capacity?
No. Cardboard, office paper, steel, PET, natural HDPE and aluminum receive portions of one net saleable-ton pool.
Are the commodity prices verified market quotes?
No. The listed selling prices are estimated planning inputs and should be replaced with relevant buyer quotes and contract terms.
Does the template cover municipal mixed waste?
No. This example covers a source-separated commercial recycling center without curbside collection, glass, hazardous waste, e-waste or deposit redemption.
Are staffing salaries included in direct costs?
No. Fixed base salaries are recorded in Payroll rather than duplicated in COGS, variable operating expenses or monthly fixed site expenses.
Does positive EBITDA mean cash is available?
No. Use Cash Flow and Balance Sheet reports to assess collections, working capital, asset purchases, debt payments and liquidity.
Can I compare alternative financial scenarios?
Yes. Dashboard controls apply Low, Base and High multipliers to revenue and expense categories, with comparative profitability reports.
Are payback and investor returns guaranteed?
No. Returns and Valuation analyze assumptions entered in the workbook; the documented case establishes no specific payback month, IRR or valuation outcome.
What Does the Recycling Center Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Formula Checks That Hold Up
I used this instead of building my own, and it kept one bad formula from throwing off the whole model. It saved me about 6 hours of cleanup and made the numbers much easier to trust.
A Solid Start Point
Starting from a blank sheet felt like a dead end, so this template gave me a clean structure to work from. I had a usable first draft in under an hour and could focus on assumptions instead of setup.
Cash Flow Was Much Clearer
The cash flow tabs made it easier to see runway and shortfalls before they became a problem. I was able to map out funding needs faster and walked into a lender call with a much clearer plan.