Financial Modeling
Master the art of building robust, accurate financial models for business valuation, forecasting, and decision-making.
Articles
6
Typical Undertakings in a Project Finance Agreement
A practical guide to project finance undertakings, including SPV controls, permits, construction, reporting, ratios, cash controls, security and lender protections.
Inflation & Escalation in Financial Modelling
A complete practitioner's guide to modelling price adjustments over time — from foundational concepts to advanced implementation techniques in project finance spreadsheets.
Project Finance Modelling in Excel: How to Build Models That Win Negotiations
Learn how to build negotiation-ready project finance models in Excel. Practical guidance on output-led design, cash flow logic, risk allocation, debt sculpting, auditability, and decision-focused outputs.
Financial Modeling - Build or Adapt
A SWOT analysis exploring when to build custom financial models from scratch versus adapting existing templates, examining strengths, weaknesses, opportunities, and threats of each approach.
Best Practices for Financial Modeling
Essential guidelines and methodologies for creating well-designed, well-documented, maintainable, and verifiable financial models.
Project Finance: Funding Massive Undertakings
Understanding the structures, stakeholders, and strategies behind large-scale project financing for infrastructure and energy projects.
Tutorials
3
Working Capital Calculation Methods in Project Finance Models
A practical comparison of the End Balance Approach and Movement Approach for modeling working capital in project finance, with formulas and best practices.
Comprehensive Guide to Advanced NPV Calculations in Project Finance
Master three NPV calculation methods — Discount Factor, XNPV, and NPV — for project finance models, with Excel formulas and implementation guidance.
Fixed Asset vs. IFRIC 12 – A Practical Accounting Comparison
Compare the accounting treatment of service concession arrangements under IFRIC 12 (intangible and financial asset models) versus traditional IAS 16 fixed assets.