5-year Financial Projections, Business Valuation, Cash Flow Projections, DCF Model, Debt Amortization, Debt Schedule, Debt Service Coverage, Excel, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Project Finance, Sensitivity Analysis, Three Statement Model | Three Financial Statements, Valuation, WACC (Weighted Average Cost of Capital)

This model assesses the economic feasibility of a 3-5 MTPA Ammonia Project, comprising 17 highly detailed tabs:

DASHBOARD: Presents modelled results with economic outcomes
CONTROL: Includes key sections depending on the model versions( shown below)
– Asset Scenario: model sensitivity to cost and delay schedules
– Profit Share Model: addresses R-factor and DROP model
– Ammonia Plant Capacity profile: scenarios for incremental capacity expansion
– Production Bonus option schedule: payable to the government
MAINT.CAPEX: Ammonia project development cost assumptions (3 model cases)
FLAGS: Working model scenario of project schedules (Pre-Construction, Construction, Operation, Financing)
INPUTS: Model inputs (yellow background, blue text)
DRIVER: Model cases based on INPUT tabs, schedule shifts, and delays
MACRO: Time-sensitive indices (capital expenditure escalations, fixed/variable costs, discount factor)
OPERATING MODEL: Gross Operating Cash Flow (GOCF) model
DEPRECIATION: 2 depreciation models (straight-line, bespoke)
DECOM: Decommissioning & Abandonment model (Unit of Production Approach)
FISCALS: Fiscal analysis with tax calculations and provisional tax holidays
PSC MODEL: Contractor cost recovery, petrochemical costs, and tax
PSC ANALYSIS: Profit share model (R-factor, DROP model)
FINANCING MODEL: Detailed financing inputs, equity injection, and lender considerations with flexible tenor and coupon rates
METR: Marginal Effective Tax Rate calculation
Sensitivity: The model features a comprehensive sensitivity analysis of 19 key variables, enabling users to instantly run up to 5 high-priority scenarios with a single click.
CHARTS: Validation checks for model integrity.

Our model comes in different versions, and we’ve outlined the variations in our model versions matrix below. If you need a bespoke version or customizations, we’re happy to help with expert support that may be required – just let us know!.

You must log in to submit a review.