6_Plastic_Pyrolysis_featured_722x361 | eFinancialModels

Construction, EPC, Financial Model, Infrastructure, Manufacturing, Recycling, Renewable Energy

10-year Financial Projections, 5-year Financial Projections, Amortization, Break-Even, Business Valuation, Cash Flow Analysis, Cash Flow Projections, Cash on Cash Yield, Cash-on-Cash Multiple, Cost Calculation, Cost per Ton Analysis, Cost Projections, Dashboard, DCF Model, Debt Amortization, Debt Schedule, Debt Security, Debt Service Coverage, Discount Rate, EPC, Excel, Financial Analysis, Financial Debt, Financial Due Diligence, Financial Feasibility, Financial Model, Financial Modeling, Financial modelling, Financial Planning, Financial Projections, Financial Ratios, Financial Reporting, Financial Statements, Financing, Forecast, Forecasting, Free Cash Flows, Fundraising, Income Statement, Interest Accrual, Investing Cash Flows, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), LLCR (Loan Life Coverage Ratio), Loans, NPV (Net Present Value), Payback Period, PLCR (Project Life Coverage Ratio), Pro-Forma, Profitability Analysis, Project Finance, Return on Investment (ROI), Revenue Projections, Scenario Analysis, Sensitivity Analysis, Startup Financial Models, Three Statement Model | Three Financial Statements, Uses and Sources of Funds, Valuation

Planning a plastic pyrolysis plant, or assessing one for investors or lenders? This Excel model turns your plant assumptions into a full financial case. It follows mixed plastic bales through pre-treatment and the reactor into oil, wax, gas and char, then on to revenue, operating costs, debt service, tax, the three financial statements and project and equity returns. It is built for developers, investors, lenders, consultants and analysts working on chemical recycling and plastic-to-oil projects.

Why this model

Generic recycling templates treat plastic as one material at one price. Pyrolysis economics turn on things they leave out: how much PET, PVC and contamination is in the bales, how much of each polymer becomes oil, whether the oil is sold crude or distilled, whether it earns a certified circular premium, what the plant is paid (or pays) for its feedstock, and above all what the plant costs per tonne of capacity. This model handles each of them. Every default is referenced on a Sources tab, and the capital cost can be switched between an itemized modular build and a published large-plant benchmark, so you can see how much the result depends on that one number.

Two editions

Feasibility Edition: a fast annual model for early screening. Three-case scenario switch, modular trains and capacity, rejects and blended yields, oil, wax, gate-fee and premium revenue, a staffing and cost build, itemized capital cost by area with capital grants, level-annuity senior debt with an interest-only period, tax with loss carry-forward, income statement, cash flow and balance sheet, project and equity IRR, NPV, payback, DSCR, a dashboard and integrity checks.
Due Diligence Edition: everything in the Feasibility Edition, plus:
a bale composition and pre-treatment table (PE, PP, PS, PET, PVC, other polymers, contaminants, moisture) with PET and PVC warning limits
a polymer-by-polymer yield calculator for liquid, gas, char and water/HCl, with a closing mass balance every year
crude oil or on-site distillation into diesel and naphtha cuts, with product densities and per-barrel pricing
optional ISCC PLUS certification with a circular premium and certification cost
an offtake contract with a price floor, plus spot sales
capital cost by plant area as a site amount plus a per-train amount, with a switch to an all-in benchmark per tonne
1 to 3 development years with spend by permitting milestone and probability of success
debt sized and sculpted to a target DSCR with no circular references, a debt service reserve account and a distribution lock-up
four editable scenarios, 12 live sensitivity cases and a tornado chart
a path-to-hurdle panel showing the product price, gate fee and capital cost per tonne that deliver your target project IRR
a developer comparison of selling the project at notice to proceed against building and operating it

Key outputs

Project IRR (unlevered, after tax), equity IRR, NPV, equity multiple and payback
Senior debt amount, binding sizing constraint, minimum and average DSCR, LLCR and PLCR (Due Diligence Edition)
Sources and uses to completion, including grants, interest during construction, financing fees and the DSRA
Income statement, cash flow statement and balance sheet for every year, with a balance check
Dashboard with revenue by product, EBITDA and net income, CFADS against debt service, debt balance, equity cash flow and the sensitivity tornado

Built to modeling best practice

Inputs, calculations and outputs on separate sheets; color-coded inputs (blue on yellow), formulas (black) and cross-sheet links (green)
Consistent formulas across every year; start year, currency code and mass unit (tonne or short ton) are inputs
No macros, no circular references, no hidden or protected sheets, no external links
Checks sheet confirms the balance sheet balances, cash never goes negative, debt is repaid, sources equal uses, composition totals 100% and the mass balance closes
Contents sheet with links, step-by-step instructions, a glossary of terms and a full source list

Timeline

Annual periods. Up to 3 development years (Due Diligence Edition), 1 to 3 construction years and up to 25 operating years. Prices and costs escalate with separate inflation and indexation inputs.

Default assumptions

Defaults describe three modular 2 tonne-per-hour trains (48,000 tonnes a year of mixed plastic, about 48 tonnes a day per train, the scale of operating modular plants), crude pyrolysis oil at $75 per barrel, plastic delivered free at the gate, and an itemized plant cost of about $39.3 million before owner’s costs, contingency and land, or about $1,040 per tonne of annual capacity all-in. Yields, prices, landfill fees, wages, tax and the capital cost range come from published research, government data and public project announcements, each cited on the Sources tab. Published all-in costs run from about EUR 500 per tonne in a design study to about $2,870 per tonne for a large US plant; the default sits inside that range, and each plant area is a line for you to replace with supplier and EPC quotes. At the defaults the base case returns about 12.5% unlevered and 14% to equity in the Due Diligence Edition, just above the 12% hurdle. Switch the capital cost to the $2,870 per tonne benchmark and the project return falls below zero: capital cost is the item to diligence first, and the model shows it.

Compare the editions

The free PDF demo, the Feasibility Edition ($99) and the Due Diligence Edition ($199) side by side:

Plastic Pyrolysis Plant Financial Model: comparison of the Free PDF Demo, Feasibility Edition and Due Diligence Edition

What you get

One Excel workbook (.xlsx) for the edition purchased, built only with functions available since Excel 2010 (no dynamic arrays, no macros)
A free PDF demo showing the main sheets of the Due Diligence Edition

Support and customization

Questions about how the template works are answered by email. Launchwright can also adapt the model to your project, lender or investor requirements, quoted at a fixed price in writing before work begins. Contact details are inside the model.

You must log in to submit a review.