5.0 Million Barrel Refinery Storage Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Provides a model to test any deal term and see the full result at once: flexible switches on one control tab cover tariff, tax, debt, dividends and buy-back, and every valuation and balance sheet updates together
2. Provides a lenders-focused financial model: Addressing senior & shareholder debt with a reserve account, the Tax Act computed line by line, three financial statements, a contractual waterfall and five valuation methods.
3. Provides every result to its source: each number links to a named sheet and row, and five integrity checks

OIL & GAS EXCEL DESCRIPTION

5.0 Million Barrel Refinery Storage Financial Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This is a 5.0 million barrel crude and refined products storage terminal model. Its engine comprises of well linked worksheets arranged in seven dependent layers, driven by eleven switches on a single control tab. Nothing downstream is hardcoded: change the tariff and revenue, capital allowances, the Development Levy, debt service cover, the distribution lock-up, dividends, withholding tax, or the equity buy-back, and every valuation output re-solves together, with the balance sheets. The more useful measure of a model is not its complexity but the accuracy of what it produces. This engine is unusually broad for a single workbook.

It computes:
● A bottom-up capital cost mapped to eight asset classes. ● A senior facility with capitalised interest during construction and a six-month debt service reserve.
● A subordinated shareholder loan tested against the connected-party interest limitation.
● Three depreciation methods run in parallel.
● Units-of-production decommissioning with a funded escrow.
● Tax Act computation built line by line.
● Three full financial statements – income statement, balance sheet and cash flow – to audited standard. ● A contractual waterfall.
● Four dividend policies.
● Five valuation methods.
● A complete all-equity engine run alongside, for a like-for-like financing comparison. Traceability The benefit is traceability.

Every number resolves to a named sheet and row, every switch re-solves the whole workbook, and five integrity checks must read nil before any result is quoted. For further enquiries, reach out to

Source: Best Practices in Oil & Gas, Integrated Financial Model Excel: 5.0 Million Barrel Refinery Storage Financial Model Excel (XLSX) Spreadsheet, Desyton Energy Advisors