Urea Plant Financial Model | Natural Gas to Urea Excel

Business Valuation, Dashboard, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial modelling, Financial Projections, Financial Ratios, Financial Statements, Income Statement, Investing Cash Flows, Investor Cash Flows, IRR (Internal Rate of Return), LLCR (Loan Life Coverage Ratio), PLCR (Project Life Coverage Ratio), Project Finance, Scenario Analysis, Three Statement Model | Three Financial Statements, Uses and Sources of Funds

A detailed, institutional-grade urea plant financial model for a natural gas-to-urea project, covering construction, operations, and financing — with three integrated statements, a full cash waterfall, and complete lender metrics, built in Excel.

A urea plant lives or dies on the spread between two volatile commodities — natural gas going in as feedstock and fuel, and urea coming out as the product sold into a global fertilizer market. Add a capital-intensive EPC build spanning reforming, air separation, and ammonia synthesis before urea synthesis even begins, and you have an asset whose viability turns on getting that spread, and the debt structure layered on top of it, right. That is why this urea plant financial model is built to project-finance discipline, not stretched from a generic industrials template.

Because it follows the discipline of project finance, the model resolves every assumption into the complete suite of bankability outputs a developer, sponsor or lender needs — Project and Equity IRR and NPV, minimum and average DSCR, LLCR, PLCR, gearing ratio, a Levelized Cost of Urea (LCOU), and a full cash waterfall.

Two Commodities, Modelled Properly

The economics of a urea plant are a spread, not a single price. Natural gas cost going in and urea price coming out each sit on their own scenario curve with independent indexation — natural gas carries a dedicated price curve separate from general inflation, since it rarely moves in line with CPI. That lets you stress the spread that actually drives the project, rather than just one side of it.

Between the two sits the natural gas efficiency factor — the gas consumed per tonne of urea produced — which converts the feedstock assumption into a cost per tonne of output. It is the single technical parameter that most directly determines whether the plant is competitive, and it is an explicit, editable input.

Two Phases, a Flexible Timeline and Three Scenarios

The model separates the construction and operations phases cleanly on a quarterly timeline, with an automated flag engine tracking construction progress, commercial operations date and an optional decommissioning period.

Every revenue and cost assumption can be entered across three scenarios — low, base case and upside — and switched instantly from a dropdown on the Dashboard, each carrying its own indexation curve. Debt drawdown carries its own phasing scenarios, and repayment can be profiled as annuity, sculpted to a target DSCR, or even-principal, each flowing through to IRR and coverage ratios instantly.

What’s Inside the Urea Plant Financial Model

Every driver of viability is an explicit, editable input, organized into eight categories:

Development & Construction
Development costs (FEED, EIA, surveys), PMC, spare parts, pre-operating expenses, EPC cost across reforming, ASU, ammonia synthesis and carbon capture, civil works, contingency, license fee and developer’s fee

Plant & Feedstock
Annual production capacity, plant utilisation (3 cases) and the natural gas efficiency factor per tonne of urea produced

Revenue Streams
Urea offtake price (3 scenarios with indexation) and revenue from other sources

Variable O&M
Natural gas cost, power consumption and cost, and other variable costs across salary, boiler feed water, cooling water, chemicals & catalyst, and overheads — each on its own scenario and indexation

Fixed Costs
SPV costs, insurance, land lease, security, community payment and management fee

Funding Profile
Cash equity, Equity Bridge Loan, senior construction debt, DSRA, refinancing of balloon repayment, and overdraft facilities

Debt Repayment
Annuity, debt sculpting to a target DSCR, and even-principal options

Adjustments
CPI and gas-price indexation curves, VAT during construction and operations, depreciation options, working capital (receivable/payable days) and income tax with tax holiday

Lender & Investor Outputs

Project IRR & NPV — returns to the project as a whole
Equity IRR & NPV — returns to shareholders after debt service
Minimum & Average DSCR — the coverage lenders scrutinise first
LLCR & PLCR — loan life and project life coverage ratios
Gearing Ratio — the debt-to-equity structure of the project
Levelized Cost of Urea (LCOU) — the all-in cost per tonne that sets your competitive floor
Cash Waterfall & Debt Service Profile — the full cascade of cash through the structure
Integrated Financial Statements & Dashboard — income statement, balance sheet, cash flow and a fully linked dashboard

Who This Urea Plant Financial Model Is For

Urea and nitrogen fertilizer developers building the case for a build-and-operate project
Gas-to-chemicals and industrial investors assessing returns and structuring equity
Lenders and debt advisors testing coverage ratios and debt sizing
Project finance advisors preparing bankable models for financial close
Fertilizer and energy finance teams running feasibility and scenario analysis

Why This Model

Built to project-finance discipline – Two-phase structure, cash waterfall and full coverage ratios — the standard lenders expect, not a corporate template stretched to fit.
Two commodities modelled properly – Gas cost in and urea price out each sit on their own scenario curve with independent indexation, so you can stress the spread that drives the economics.Fully transparent – Clearly defined input, calculation and output cells, with dozens of automated checks rolling up into a single Master Check, so you can trust the numbers.

You must log in to submit a review.