Revenue & Calc
Processing capacity, utilization, intake fees, output yields and product prices feed monthly revenue calculations by stream.
This Excel tire recycling financial model plans one-shift ambient mechanical processing of customer-delivered scrap tires near Cleveland, Ohio. It forecasts 2026–2030 throughput, acceptance fees, recovered-material sales, operating costs, staffing and EBITDA in nominal U.S. dollars.
Passenger and truck tire intake feeds one shared processing pool; granulate, powder and steel are sold B2B. Change utilization, recovery yields, fee rates, product prices and costs to test a different case rather than treating these estimates as observed results.
The workbook links tire-processing inputs to monthly calculations, financial statements and investment reports.
Processing capacity, utilization, intake fees, output yields and product prices feed monthly revenue calculations by stream.
COGS & OPEX separates revenue-linked expenses and fixed coverage; Payroll budgets employee roles without duplicating salaries.
CAPEX tracks purchases and depreciation; CapTable, Dashboard debt controls and Sources & Uses plan funding and cash allocation.
Income Statement, Cash Flow, Balance Sheet, Scenarios, Returns, Valuation and Checks support review using the entered assumptions.
A single incoming-ton pool drives two tire acceptance fees plus sales of granulate, powder and steel.
Scheduled capacity is 3 short tons/hour × 8 hours/day × 22 days/month × 12 months, or 6,336 short tons yearly. At 55% utilization, 2026 intake is 3,484.8 tons; at 80% utilization, 2030 intake reaches 5,068.8 tons.
Passenger tires are 90% of incoming mass at $100 per ton and truck tires are 10% at $120. Both acceptance fees apply to incoming, not recovered, mass.
The Revenue Forecast connects hourly throughput, scheduled processing, utilization and tire-class mix to acceptance fees and recovered-material sales. The monthly calculation starts with the selected January 2026 launch and applies each year’s utilization.
Each incoming ton yields 45% granulate at $300 per ton, 20% powder at $450, 15% steel at $120, and 20% residue for disposal. These exclusive allocations sum to 100% of intake.
Blended acceptance fees equal $102 per incoming ton and material sales equal $243. The case assumes no feedstock purchase expense for customer-delivered tires; residue disposal is a cost.
3,484.8 incoming short tons × ($102 acceptance fees + $243 recovered materials) = $1,202,256 annual revenue.
Revenue-linked processing costs, site expenses and separate payroll determine operating EBITDA.
COGS totals 29% of revenue: electricity 9%, knives and maintenance parts 7%, disposal 5%, packaging 3% and freight/loading 5%. Variable credit losses, banking charges, samples and commissions total another 1.5%. In 2026, these categories equal $348,654 and $18,034, respectively.
The COGS and Operating Expenses report separates direct, variable and fixed charges. Use it to adjust expenses for disposal, energy, parts, freight or monthly plant overhead without combining those categories with salaries.
Fixed expenses total $185,400 yearly, including $9,000 monthly occupancy for 12 months. The balance covers insurance, closure bond premiums, compliance, security, software, water demand charges and professional services.
Payroll adds $366,000 annually, outside COGS, variable and fixed categories. Employer payroll taxes, benefits and personal taxes are excluded from the illustrated salaries.
The Payroll Forecast budgets 6.5 annual-average FTE: three processing operators, one forklift operator, a half-time mechanic, a plant manager and one sales-administration employee. Base salaries feed personnel expense separately from other plant costs.
Equipment, preopening payments, working capital and equity contributions are separate from EBITDA.
Startup assets include a $1,350,000 shredding/granulation line, $450,000 fine-grinding unit, $180,000 dust/fire system and $110,000 weighbridge/handling assets. Forklift, electrical and site improvements are additional investments.
The January 31, 2026 launch activates the full selected month. Equipment purchases are capital spending, not direct annual EBITDA expenses.
The Capital Expenditure Plan schedules equipment purchases by date and distinguishes depreciable from non-depreciable items. It tracks depreciation and asset values separately from direct processing costs.
Preopening cash includes an occupancy deposit, permits, training, commissioning, launch outreach and restricted closure collateral. Opening working capital uses 30 receivable days, 10 payable days and 10 inventory days, plus a three-month operating-outflow reserve.
Estimated owner funding is $2,856,338, with no committed external debt. Dashboard debt controls can model alternative borrowing without implying loan approval.
The Sources and Uses of Funds report reconciles equity and any modeled borrowing with planned equipment, operating payments and retained cash. It distinguishes funding activity from operating earnings.
Revenue rises with utilization in the 2026–2030 example, while fixed payroll and occupancy remain unchanged.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $1,202,256 | $918,088 | $284,168 |
| 2027 | $1,420,848 | $984,759 | $436,089 |
| 2028 | $1,573,862 | $1,031,428 | $542,434 |
| 2029 | $1,683,158 | $1,064,763 | $618,395 |
| 2030 | $1,748,736 | $1,084,764 | $663,972 |
Illustrative model outputs, not actual facility results. Whole-dollar rounding can create small differences in displayed sums.
Revenue increases from $1,202,256 in 2026 to $1,748,736 in 2030 as utilization rises from 55% to 80% at flat prices. Expenses combine 29% COGS, 1.5% variable costs, fixed coverage and base payroll.
EBITDA grows from $284,168 to $663,972, before depreciation, interest, tax and equipment spending. The linked Income Statement can report accounting earnings, but the supplied illustration provides no net-profit result.
The Cash Flow Forecast follows monthly operating receipts and payments, investing expenditures and financing flows. Review it with the Balance Sheet for collection timing, equipment spending and possible liquidity shortages rather than equating EBITDA with cash.
Returns and scenarios test operating coverage, project cash recovery and changed assumptions.
Sales break-even compares revenue with costs; cash break-even accounts for payment timing. Investment payback tracks cumulative project cash flow, while annual ROIC relates returns to invested capital. None is the same as EBITDA.
Dashboard Low, Base and High controls vary revenue and cost multipliers. Scenarios then compares revenue, margins and EBITDA without assuming a specific outcome for any case.
The Returns report examines sales break-even, cash break-even, investment payback and annual ROIC using linked schedules. Changes in tire throughput, product prices and equipment spending affect these measures differently.
Valuation provides discounted cash flow and terminal-value sensitivity; Checks flags reconciliation issues. No validated payback date, ROIC figure, borrowing capacity or enterprise value is provided in the example.
These answers explain the model’s inputs, analysis and illustrative assumptions.
Yes. Edit hourly throughput, processing hours, scheduled days and annual utilization to recalculate incoming short tons and related revenue.
Yes. Passenger and truck fees apply to one shared intake pool, while exclusive yields allocate those same incoming tons to granulate, powder, steel and residue.
Payroll models 6.5 annual-average FTE and their fixed base pay separately from direct and fixed operating costs; employer taxes and benefits are excluded in this case.
Yes. CAPEX, CapTable, Sources & Uses and Dashboard debt controls support funding analysis, but the illustrative case has owner funding and no committed external debt.
No. EBITDA excludes depreciation, interest, taxes and investing cash flows; use the Income Statement and Cash Flow reports for those different measures.
Yes. Returns covers sales break-even, cash break-even, investment payback and annual ROIC, but the source case does not report a confirmed timing or return figure.
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.
I stopped chasing statements and charts across different files, and the model kept everything in one place. It saved me about 6 hours on month-end updates and made the deck much easier to review.
Starting from scratch always slows me down, but this template gave me a clear place to begin. I had a working first draft in one afternoon instead of spending days setting up the model.
I wasn’t sure what investors would expect, and this template made the structure obvious. It helped me prepare cleaner outputs for a meeting and book a follow-up call the same week.