Project Finance Modeling with Claude AI

Credit: Unsplash.com

Rate this post

Course Description

Project Finance Modeling is one of the most technically demanding disciplines in Corporate Finance —combining long-term cash flow projections, complex debt structuring, traffic or production assumptions, and multi-party equity waterfalls into a single integrated model. This two-day program equips finance professionals to build, review, and audit these models with significantly greater speed and precision by leveraging Claude AI as a structured modeling partner.

What is Claude?

Claude is a next-generation AI assistant and family of large language models (LLMs) developed by Anthropic, designed to be safe, accurate, and highly performant in reasoning, coding, and analysis. Known for its “helpful, honest, and harmless” approach, Claude is a popular alternative to ChatGPT, often used for complex tasks, creative writing, and processing long documents.

AI-Augmented Workflow

Learn the architect-and-engineer model: Claude reasons and designs; you validate and refine. Build faster without sacrificing rigor.

Real Project Contexts

Work through a complete toll road concession model and a sector variant (power or port), using Indonesian and regional case studies.

Immediately Applicable

Every prompt template, Excel structure, and ratio formula is yours to take and deploy in your next real engagement —the day after training.

Trainer Profile

Purwadi Nitimidjojo

the trainer, started his financial modelling career in early 2005 after working for Indonesian Bank Restructuring Agency (IBRA / BPPN) during the monetary crisis from 1998 through 2004. At IBRA’s Credit Risk Management Division he developed various financial models for debt restructuring and corporate restructuring and learned that most of IBRA’s large debtors hired foreign financial consultants to develop financial models as they didn’t have any resources who could develop proper financial models, and financial modelling training courses were not available back then. This is when he saw an opportunity to deliver financial modelling training courses and develop best-practice financial models for clients in various industries in Jakarta.

In early 2005 Purwadi teamed up with two of his friends and used “Edward, Farral & Peterson” and “Edward & Peterson” as their brands to provide monthly public training courses and financial modelling services until early 2012 before he was hired by Deloitte Financial Advisory as a Financial Modelling Director to do the same. At Deloitte he and his financial modelling team developed best-practice financial models for his clients in various industries for various purposes and delivered monthly financial modelling and Power BI training courses for the public, clients, and Deloitte’s internal staff in Indonesia, Singapore, Malaysia, Thailand, and Cambodia.

After spending 10 years working for Deloitte, he returned to his own financial modelling business and is now working as a financial modelling subcontractor for BDO and Deloitte as well as an independent private financial modelling consultant and trainer.

Schedule 2026

22-23 January 2026
12-13 February 2026
12-13 March 2026
14-15 April 2026
11-12 May 2026
11-12 June 2026
13-14 July 2026
10-11 August 2026
10-11 September 2026
12-13 October 2026
19-20 November 2026
17-18 December 2026

Full Day Training: 09.00 – 17.00 wib

Venue Training

Yogyakarta:

NEO Hotel Malioboro Yogyakarta
Royal Malioboro by ASTON Yogyakarta
Novotel Suites Yogyakarta Malioboro

Jakarta:

Swiss-Belinn Simatupang, Jakarta Selatan
Swiss-Belhotel Pondok Indah, Jakarta Selatan
Ibis Styles Simatupang, Cilandak, Jakarta Selatan

(Kepastian venue akan dikonfirmasikan H-4 sebelum event)

Investment Fee

Yogyakarta: IDR 6,950,000/ Peserta

Jakarta: IDR 5,950,000/ Peserta

Harga sudah termasuk Training Material, Sertifikat, Lunch & Coffee Break, Souvenir, Door Prize.
Discount 10% bagi peserta yang mendaftar lebih dari 1 participants dan pembayaran dilakukan sebelum event berlangsung.
In-House Training: maksimal 20 Peserta.

Course Objective

Structure a full project finance model architecture using Claude as a reasoning partner —covering construction, revenue, debt, and equity in a modular 11-sheet workbook
Build sector-specific revenue models for toll roads including tariff escalation, multi-class traffic ramp-up curves, and minimum traffic guarantee provisions
Design and apply the CFADS waterfall —from EBITDA through DSRA, debt service, and reserve top-ups to distributable cash
Calculate and interpret DSCR, LLCR, and PLCR covenant ratios and link them to distribution lock-up triggers
Craft reusable prompt templates for project finance model builds, audits, and training exercises —portable across Claude, Shortcut, Tracelight, and Copilot
Run structured sensitivity and scenario analysis (Base / Upside / Downside / Stress) and present results in a one-page dashboard

Course Pre-Requisites

Required

Excel Proficiency
Comfortable building multi-sheet financial models; familiar with IF, OFFSET, INDIRECT, and array formulas
3-Statement Modeling
Can build an integrated P&L → Balance Sheet → Cash Flow model from scratch
Corporate Finance Fundamentals
Understands NPV, IRR, WACC, debt service, and basic valuation concepts
Project Finance Awareness
Has read or worked with a project finance model before (does not need to be an expert)

Notice to Have

Prior DCF / LBO Experience
Familiarity with discounted cash flow or leveraged buyout modeling gives a head start on ratio calculations
Exposure to AI Tools
Has used ChatGPT, Copilot, or Claude before —even casually. No prompt engineering experience needed.
Sector Background
Worked in banking, infrastructure, project advisory, or government —helpful for understanding concession logic

Course Outline

Day-1: AI-Powered Model Architecture, Construction, Revenue & Operating Costs

1. Foundations —AI as Your Modeling Partner

The architect-and-engineer framework: how Claude reasons vs. how you validate
Project finance model anatomy: 11-sheet modular structure overview
Prompt engineering for financial modeling: the 11-block master template
Live demo: sending Block 1 + Block 2 (toll road) and reviewing Claude’s output

2. Construction Phase & Capital Structure

Uses of funds: EPC, land acquisition (ROW), IDC, contingency —sizing each line
Debt vs. equity injection schedules —drawdown linked to milestones
IDC calculation: capitalized into TPC vs. expensed —impact on debt sizing
Reserve accounts: DSRA, MMRA, Handback Reserve —funding mechanics
Hands-on: Prompting Claude to build the Construction and Timeline sheets

3. Revenue Modeling —Toll Road Traffic & Tariff

Tariff structure: vehicle class breakdown, escalation mechanism, regulatory reset risk
Traffic model: ramp-up curve, growth phases, seasonal factors, minimum guarantee
Revenue calculation logic: tariff ×volume ×mix —formula architecture in Excel
Non-toll revenue: rest areas, VGF government subsidies, shadow toll structures
Hands-on: Prompting Claude for the Revenue sheet; reviewing and correcting output

4. Operating Costs & EBITDA

Routine O&M: pavement, structural, drainage —escalation index selection
Toll operations: ETC fees, ITS O&M, toll staff costs
Periodic major maintenance: asphalt overlay, bridge inspection —model by year
Concession fee and insurance: fixed vs. revenue-linked structures
Building the EBITDA bridge: Revenue → EBITDA in one waterfall row

Day-2: Debt Structuring, Returns, Ratios, Sensitivity& Dashboard

5. Debt Structuring & the CFADS Waterfall

Senior debt sizing: DSCR-sculpted vs. annuity vs. equal installments —choosing the right profile
IDC capitalization and drawdown schedule —linking to the construction phase
The CFADS waterfall: OpEx → Tax → DSRA → Debt Service → MMRA → Distributions
DSRA mechanics: minimum balance covenant, top-up funding, and release conditions
Hands-on: Prompting Claude for the Debt sheet; validating the waterfall logic

6. Ratio Analysis, Covenants & Equity Returns

DSCR, LLCR, PLCR: formulas, interpretation, and covenant triggers
Distribution lock-up: DSCR threshold mechanics —when equity gets paid
Equity IRR, Project IRR, NPV, and payback —building the returns sheet
Equity waterfall: return of capital → preferred return → pro-rata distribution
Hands-on: Prompting Claude for Ratios and Equity Returns sheets

7. Sensitivity, Scenarios & Stress Testing

Identifying the top 5 value drivers: traffic volume, tariff, land cost, rate, OpEx
Building a sensitivity table: one-variable and two-variable analysis
Four scenarios: Base / Upside / Downside / Stress —full model run for each
Minimum Traffic Guarantee (MTG) scenario: modeling the government floor
Presenting results: tornado chart, scenario comparison table, executive summary

8. Dashboard, Prompt Library & Next Steps

Building the one-page dashboard: DSCR bar chart, equity cashflow, traffic vs. base
Formatting conventions: input cells, formula cells, error checks
Your reusable prompt library: 11-block master template + toll road variant
Adapting the template for solar IPP, port, and water sector models
Action planning: deploying AI-assisted modeling in your next engagement

Key Takeaways

What you leave with —immediately deployable

Master Prompt Template: The full 11-block project finance prompt template, tested and refined. Reusable across toll road, power, port, and water sector projects.
Live Excel Model: A working toll road project finance model built during the training —complete with CFADS waterfall, DSCR ratios, and a one-page dashboard.
Ratio Toolkit: DSCR / LLCR / PLCR formula set, covenant trigger logic, and sensitivity table structure —ready to drop into any new model.
Sector Variant Library: Toll road Block 4 (traffic & tariff) plus starter templates for solar IPP and port sectors —your growing prompt library.
Prompt Engineering Skills: Ability to craft precise, structured prompts that produce high-quality model output from Claude —and to spot and correct errors fast.
Methodology You Can Teach: The architect-and-engineer framework and 11-block structure are training-ready —apply them in your own in-house or public programs.