Project Finance Modeling with Claude AI

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. Baca Juga: Financial Statement Spreading and Analysis with Claude AI

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 Baca Juga: Prompt Engineering Best Practices for Financial Modeling using AI

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

1. 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
2. Build sector-specific revenue models for toll roads including tariff escalation, multi-class traffic ramp-up curves, and minimum traffic guarantee provisions
3. 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
4. Craft reusable prompt templates for project finance model builds, audits, and training exercises —portable across Claude, Shortcut, Tracelight, and Copilot
5. Run structured sensitivity and scenario analysis (Base / Upside / Downside / Stress) and present results in a one-page dashboard

Baca Juga: Prompt Engineering for Financial Modeling using Claude AI

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

Baca Juga: Building Financial Models with Claude AI

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

Baca Juga: Data Analysis & Visualization with Power BI

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

1. Master Prompt Template: The full 11-block project finance prompt template, tested and refined. Reusable across toll road, power, port, and water sector projects.
2. 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.
3. Ratio Toolkit: DSCR / LLCR / PLCR formula set, covenant trigger logic, and sensitivity table structure —ready to drop into any new model.
4. Sector Variant Library: Toll road Block 4 (traffic & tariff) plus starter templates for solar IPP and port sectors —your growing prompt library.
5. Prompt Engineering Skills: Ability to craft precise, structured prompts that produce high-quality model output from Claude —and to spot and correct errors fast.
6. 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.