A complete, working project finance model packaged as a reference
template. Not an exercise, not a stripped-out shell - this is a
fully populated, fully linked institutional-grade PF model that you
can open, read, follow, and learn from.
The model is built around a generic operating wind farm in Australia
but the architecture is what you are buying. Construction phase,
operations phase, debt sizing solved against minimum DSCR covenants,
debt sculpting, integrated 3-statement output, valuation block,
scenario manager, integrity checks. The same skeleton used by Big 4
advisory teams, sponsor-side developers, and project finance bankers
across renewables, digital infrastructure, transport, and social
Excel workbook (.xlsx) - 16 fully linked tabs:
- Cover Model identity, version, status
- L (Legend) Cell styles, named ranges, conventions
- Inputs Timing, capex, operating, debt, tax, indexation
- Scenarios Working scenario manager with overrides
- Checks Live model integrity, macro and significance checks
- Cons Construction phase capex and funding
- Ops Operations - production, revenue, costs, working capital
- Equity Equity contributions, distributions, returns
- Debt Debt sizing, sculpting, schedule, hedging, DSCR
- Dep Accounting and tax depreciation
- Tax Geared and ungeared tax workings
- Val Project IRR, Equity IRR, NPV, payback
- AFS Annual integrated financial statements
- IFS Periodic (quarterly) integrated financial statements
- ID Indicators block (cash waterfall, ratios)
- Copy Working / scratch tab
- How a real PF model is laid out, tab by tab.
- Named-range discipline (Name_Project, Name_Scenario, Days_yr,
Months_yr, M, k, etc.) and why it matters.
- Construction-phase modelling: drawdowns, IDC, funding mix.
- Operations: production, MLF, degradation, OPEX indexation.
- Debt sizing solved against minimum DSCR covenant binding rules.
- DSCR sculpting and circular reference handling.
- Integrated 3-statement output (P&L, Balance Sheet, Cash Flow).
- Cell-style conventions: hardcodes vs links vs assumptions vs
off-sheet vs in-sheet vs check cells.
- Graduates and laterals moving into project finance / infrastructure
/ energy teams who want to see how a senior model is structured
before they have to build one themselves.
- Big 4 Transaction Services / Deal Advisory analysts who want a
reference of what "modelling integrity standards" actually look like
- Sponsor-side developers and infra PE analysts modelling renewables,
energy storage, transmission, or any DSCR-sized asset.
- Anyone reverse-engineering institutional-grade PF model architecture
before building their own from scratch.
- This is a reference template, not a structured course or tutorial.
No walkthrough video, no commentary doc, no exam-style questions.
- No live trainer support. Open the file, follow the links, learn
.xlsx file. Opens in Excel (Microsoft 365, 2019, 2021) or LibreOffice
Calc. Fully editable - all named ranges, formulas and styles intact.
