Financial Model, Infrastructure, Mining Industry, Oil & Gas

Amortization, Break-Even, Cash Flow Projections, Excel, Financial Feasibility, Financial Model, Financial Modeling, Financial Planning, Financial Projections, Profitability Analysis, VC Valuation, Venture Capital

Here is a comprehensive model for evaluating project viability for a capacity up to 20 MTPA(scalable to user preferences). This project model consists of 6 distinct sections with 20 tabs, covering various aspects of the project’s economics.

Here’s a breakdown of the tabs:

Project Overview and Inputs

FISCAL DASHBOARD: Economic results and key performance indicators (KPIs)
PROJECT SUMMARY: Summary of key model results and assumptions
SCENARIO_INPUTS: Model inputs with yellow background and blue text
MODEL DRIVER: Model case development scenario based on “LNG terminal” tab
CONTROL: Asset scenario, profit share model, LNG plant capacity profile, production bonus option, and model sensitivity analysis

Project Economics and Operations

FLAGS: Working model scenario of project schedules (pre-construction, construction, operation, and financing flags)
MACRO: Time-series macroeconomic indicators (capital expenditure escalations, OPEX expenditure escalations, and terminal revenue driver indices)
MAINT. CAPEX: Phased-based maintenance capital expenditure for the gas flare infrastructure project
REVENUE: Bottom up model structure considering energy content, capacity utilization and gas prices
CAPEX: Detailed breakdown of capital expenditure model drivers
OPERATING MODEL: Gross operating cash flow (GOCF) model based on the model case scenario

Fiscal and Financing Analysis

ASSET DEPRECIATION: Two depreciation models (straight-line and bespoke CF based methodology)
D&A: Decommissioning and abandonment model using the unit of production approach (UOP)

Fiscal Analysis

FISCALS: Fiscal analysis with assessable taxes and provisional tax holiday models
PSC MODEL: Contractor cost recovery, profit split, and entitlement analysis
PSC ANALYSIS: Profit share model (R-factor and DROP model)

FCFF PREFINANCING: Pre-financing analysis

FINANCING: Financing model inputs (annuity approaches, debt modeling with Cash flows with high level charts.

Valuation Analysis

Financing appraisal techniques using NPV, IRR, payback, unit costs, Capital efficiency metrics and much more.

Sensitivity Analysis

Flexible tornado for sensitivity analysis on project variables