Building Financial Models with Claude for Banks

Building Financial Models with Claude adalah training dua hari yang melatih tim perbankan membangun, men-stress-test, dan mereview model keuangan kelas bank dengan Claude AI sebagai co-pilot. Hasilnya lebih cepat, namun tetap disertai judgment dan kontrol yang dibutuhkan keputusan kredit.
Peserta bekerja dengan satu kasus debitur fiktif dari awal sampai akhir, lalu menyusun rekomendasi kredit. Program ini dibawakan oleh Purwadi Nitimidjojo, trainer dengan pengalaman lebih dari 30 tahun di perbankan dan financial modeling.
Ringkasan Training Building Financial Models with Claude for Banks
Banyak bank sudah mencoba AI, tetapi belum tahu cara memakainya untuk pekerjaan inti seperti spreading laporan keuangan, proyeksi, dan analisis kemampuan bayar. Training ini menjawab kebutuhan tersebut secara praktis. Setiap sesi berisi praktik langsung dengan Claude dan Excel.
Program ini cocok untuk credit analyst korporasi, komersial, dan UKM, relationship manager, tim credit risk dan portfolio review, serta tim financial analytics. Anda dapat memilih training publik offline sesuai jadwal 2027, atau in-house training untuk satu bank. Pelajari juga program training lain dari Seventh Grace Consulting.
2 hari penuh, 09.00-17.00, dengan 8 sesi hands-on.
Bahasa Indonesia atau English, sesuai kebutuhan peserta.
Offline di hotel meeting room, atau in-house di lokasi bank Anda.
Training Syllabus: Building Financial Models with Claude, Your AI Co-Pilot
Berikut silabus resmi program dalam bahasa aslinya (English).
Training Syllabus • Build, Stress-Test and Review Bank-Grade Models with Claude AI
Purwadi Nitimidjojo, AI-Assisted Financial Modeling Consultant & Trainer
Training at a Glance
Full Days
Hands-On Sessions
Integrated Borrower Case
Maximum Participants per Class
Equip bankers to build, stress-test and review bank-grade financial models with Claude as a co-pilot — faster, and with the judgment and controls that credit decisions require.
Corporate, commercial and SME credit analysts, relationship managers, credit risk and portfolio reviewers, and financial analytics teams.
In-house, 09:00–17:00 each day. Hands-on with Claude (Cowork) and Excel, one fictional borrower case from start to finish. Bahasa Indonesia or English, as the bank prefers.
What Participants Will Be Able to Do
Spread & Analyze
Turn a borrower’s financial statements into a standard spread, ratios and red flags with Claude.
Build the Model
Prompt Claude to build an integrated 3-statement model, one prompt per sheet, that balances.
Size the Debt
Assess repayment ability with CFADS, DSCR, ICR, leverage and covenant tests.
Stress-Test
Run sensitivity (tornado + data table) and base, downside and stress scenarios with MIDAS.
Review AI Output
Audit an AI-built model against a review checklist before it informs a credit decision.
Recommend
Turn the model into a credit memo draft and committee-ready slides with Claude.
The Learning Path: From Chat to Agent
Chat
Ask, explain, draft formulas and check logic in conversation.
Day 1
Structured Prompts
One prompt per sheet or module, built with the 3-Tier Prompt Framework.
Day 1–2 • Core
Agent
Claude in Cowork runs multi-step tasks: build, check, fix, report.
Day 2
Multi-Agent
Several agents build and review models in parallel, orchestrated.
Preview • Optional
The core of the program is L2 — the level where bank-grade models are built reliably. L3 shows how Claude takes over the repetitive build-and-check loop.
Two Days at a Glance
Session 1: Claude as Your Co-Pilot
Capabilities, limits, Cowork setup, data governance
Session 2: Prompting for Financial Models
3-Tier Prompt Framework and the MIRROR Method
Session 3: Financial Statement Spreading
Spread, ratios, common-size, trends, red flags
Session 4: Integrated 3-Statement Model
Drivers, capex, working capital, debt, checks
Session 5: Debt Capacity & Repayment
CFADS, DSCR, ICR, leverage, covenants, sizing
Session 6: Sensitivity & Scenarios
Tornado + data table, MIDAS scenarios, headroom
Session 7: Reviewing AI-Built Models
AI-Built Model Review Standard, governance
Session 8: From Model to Credit Decision
Credit memo, committee slides, agentic workflow
Day 1 Agenda — Build the Model
| Time | Session | Key Content |
|---|---|---|
| 09:00–09:30 | Opening & Pre-Assessment | Objectives, case introduction, baseline skills check |
| 09:30–10:45 | Session 1: Claude as Your Co-Pilot | What Claude can and cannot do in modeling • L1–L4 ladder • Cowork setup • Data security and governance in banking |
| 10:45–11:00 | Break | |
| 11:00–12:30 | Session 2: Prompting for Financial Models | 3-Tier Prompt Framework (P1–P5) • Prompt anatomy • MIRROR Method: dissecting an expert prompt • One prompt per sheet |
| 12:30–13:30 | Lunch | |
| 13:30–15:00 | Session 3: Financial Statement Spreading & Analysis | Spread borrower statements into a standard template • Ratio, common-size and trend analysis • Red-flag detection |
| 15:00–15:15 | Break | |
| 15:15–16:45 | Session 4: Integrated 3-Statement Model | Assumptions, revenue and cost drivers, capex, working capital, debt schedule • Balance sheet and cash checks |
| 16:45–17:00 | Day 1 Wrap-Up & Q&A | Key takeaways and preparation for Day 2 |
Day 2 Agenda — Analyze, Stress & Decide
| Time | Session | Key Content |
|---|---|---|
| 09:00–09:15 | Day 1 Recap | Model status check and open questions |
| 09:15–10:45 | Session 5: Debt Capacity & Repayment Ability | CFADS, DSCR, ICR and leverage • Covenant tests and headroom • Cash-flow-based facility sizing |
| 10:45–11:00 | Break | |
| 11:00–12:30 | Session 6: Sensitivity & Scenario Analysis | Tornado chart + one-way data table • MIDAS scenarios: base, downside, stress • Break-even analysis |
| 12:30–13:30 | Lunch | |
| 13:30–14:45 | Session 7: Reviewing AI-Built Models | AI-Built Model Review Standard • Common AI errors and traps • Audit trail and model governance |
| 14:45–15:00 | Break | |
| 15:00–16:15 | Session 8: From Model to Credit Decision | Credit memo draft with Claude • Committee-ready slides • Introduction to agentic workflow (L3) in Cowork |
| 16:15–17:00 | Capstone & Closing | Team credit recommendation • Post-assessment • Certificates |
One Borrower Case, End to End
PT Nusantara Pangan (fictional)
- A mid-sized Indonesian food & beverage manufacturer.
- Requests an investment loan for a new production line, plus a working capital facility.
- Three years of historical statements; seven-year projection.
- Participants act as the bank’s credit team: analyze, model, stress-test and recommend.
- Financial statement spread and ratio analysis
- Integrated 3-statement model, built with Claude
- Debt capacity and covenant dashboard
- Sensitivity and scenario analysis outputs
- AI-Built Model Review checklist
- Credit memo draft and committee slides
- Reusable prompt library for the bank’s own cases
Proven Frameworks Behind the Program
3-Tier Prompt Framework
Structured prompts (P1–P5) that make Claude build models consistently — used in real client builds.
MIRROR Method
Learn prompting by dissecting an expert prompt reverse-engineered from a finished model.
Modano Formatting Standard
Bank-grade layout, color semantics, sign conventions and integrity checks.
MIDAS
Multi-Indexed DataTable Analysis System: switch and compare scenarios with one data table.
AI-Built Model Review Standard
A checklist to audit what Claude builds before it informs a credit decision.
The Engineering Stack
Prompt → Context → Harness → Loop: good AI output is engineered, not hoped for.
More Programs for Other Divisions
The same hands-on approach is available for other divisions: 1–2 days in-house, tailored after a short needs analysis.
Project Finance Modeling with Claude AI
CFADS, DSCR sculpting, LLCR, reserve accounts, cash sweep and circularity, on a toll road case.
Corporate Valuation (DCF) with Claude AI
WACC, terminal value and equity bridge for M&A and acquisition financing.
Financial Modeling for Debt Restructuring with Claude AI
Restructuring options from the creditor or debtor side: new terms, repayment capacity and recovery.
Sensitivity, Scenario & Monte Carlo Analysis with Claude AI
Tornado charts, MIDAS scenarios and Monte Carlo simulation to size downside risk.
AI-Built Model Review & Governance
A review checklist, common AI errors and an audit trail for models built with AI.
Financial Modeling for Corporate Budgeting with Claude AI
Driver-based budgets and forecasts across business units, with variance analysis.
From Data to Decisions: Power BI, Excel & Claude AI
Analyze and visualize data in Power BI, model it in Excel, explain it with Claude.
From Chat to Agent: Agentic AI with Claude
The L1–L4 ladder: from chat to agents and multi-agent workflows in Cowork.
Prerequisites & Logistics
Participants Need
- Laptop with Microsoft Excel 365 (desktop app)
- Individual Claude Pro account (minimum), with Cowork available
- Working knowledge of financial statements and Excel
The Bank Provides
- Training room, projector and stable internet
- IT clearance for Claude access on the training network
- Maximum 25 participants per class
Data & Governance
- Fictional case data only — no customer data is uploaded
- Aligned with the bank’s IT security policy and OJK guidance
- Prompt library handed over for the bank’s internal use
Jadwal Training Building Financial Models with Claude 2027
Training berlangsung full-day pukul 09.00-17.00 WIB selama dua hari berturut-turut. Berikut 12 batch sepanjang tahun 2027.
| Batch | Tanggal | Hari |
|---|---|---|
| Januari | 25-26 Januari 2027 | Senin-Selasa |
| Februari | 18-19 Februari 2027 | Kamis-Jumat |
| Maret | 29-30 Maret 2027 | Senin-Selasa |
| April | 19-20 April 2027 | Senin-Selasa |
| Mei | 27-28 Mei 2027 | Kamis-Jumat |
| Juni | 21-22 Juni 2027 | Senin-Selasa |
| Juli | 19-20 Juli 2027 | Senin-Selasa |
| Agustus | 23-24 Agustus 2027 | Senin-Selasa |
| September | 20-21 September 2027 | Senin-Selasa |
| Oktober | 21-22 Oktober 2027 | Kamis-Jumat |
| November | 18-19 November 2027 | Kamis-Jumat |
| Desember | 20-21 Desember 2027 | Senin-Selasa |
Venue Training: Jakarta Selatan, Yogyakarta, dan Bandung
- Swiss-Belinn Simatupang, Jakarta Selatan
- Swiss-Belhotel Pondok Indah, Jakarta Selatan
- Ibis Styles Simatupang, Cilandak, Jakarta Selatan
- Hotel TMG Tebet, Tebet, Jakarta Selatan
Hotel dan meeting room di Yogyakarta, diinformasikan saat konfirmasi batch.
Hotel dan meeting room di Bandung, diinformasikan saat konfirmasi batch.
Investment Fee Training Building Financial Models with Claude
Rp5.950.000 / Peserta
Termasuk:
- Training Material
- Sertifikat
- Lunch & Coffee Break
- Souvenir
- Door Prize
Profil Trainer: Purwadi Nitimidjojo
Purwadi Nitimidjojo adalah konsultan dan trainer financial modeling serta analisis kredit dengan pengalaman lebih dari 30 tahun di corporate banking, leasing, multi-finance, debt restructuring, dan konsultansi. Kini beliau melatih tim bank untuk membangun, menguji, dan mempertanggungjawabkan keputusan kredit dengan Claude AI.
- Lebih dari 25 tahun membangun financial model di Microsoft Excel untuk corporate finance, corporate banking, debt restructuring, dan project finance.
- Membangun model keuangan untuk analisis kredit di berbagai industri bagi Bank Mandiri dan Mandiri Tunas Finance.
- Melatih analis kredit di bank-bank besar Jakarta sebagai Consultant & Trainer di Omega Performance (2006-2012), vendor analisis kredit yang kini dimiliki Moody’s Corporation dan beroperasi di bawah Moody’s Analytics.
- Melatih profesional keuangan dari lebih dari 1.000 perusahaan di Indonesia, Singapura, Malaysia, Thailand, dan Kamboja.
- Mantan banker di bidang credit risk dan corporate finance di The Chase Manhattan Bank, PT Bank PDFCI, Badan Penyehatan Perbankan Nasional (IBRA), dan PT ANJ Finance.
- Senior Advisor & Trainer, Financial Modeling di BDO in Indonesia (sejak 2022); sebelumnya Director, Financial Modeling di PT Deloitte Konsultan Indonesia (2012-2020) dan Senior Specialist di Deloitte (2021-2022).
- Menyelenggarakan Business Valuation Seminar tahunan di Jakarta bersama Profesor Aswath Damodaran (Stern School of Business, New York University).
- Pendidikan: S1 Fisika, Institut Teknologi Bandung (ITB), 1984. Mengajar dalam Bahasa Indonesia maupun English.
Keahlian Utama
Credit analysis, integrated 3-statement model, forecasting, budgeting, DCF valuation, M&A, LBO, project finance, debt restructuring, dan model review.
Scenario & Sensitivity
MIDAS scenario tables, tornado chart, break-even dan reverse stress test, serta Monte Carlo simulation.
AI-Assisted Modeling
Prompt engineering untuk financial modeling, Claude Cowork, Claude Code, dan verifikasi output AI terhadap data sumber.
Klien Perbankan & Keuangan
PT Bank Mandiri, PT Mandiri Tunas Finance, PT Indonesia Eximbank (LPEI), PT Sarana Multi Infrastruktur, dan PT Penjaminan Infrastruktur Indonesia (IIGF).
Cara Mendaftar Training Building Financial Models with Claude
Amankan Kursi Anda
Hubungi tim Seventh Grace Consulting untuk memilih batch, kota, atau mendiskusikan in-house training bagi bank Anda.
FAQ: Training Building Financial Models with Claude for Banks
Apa itu training Building Financial Models with Claude for Banks?
Training dua hari yang melatih tim perbankan membangun, men-stress-test, dan mereview model keuangan kelas bank dengan Claude AI sebagai co-pilot, menggunakan satu kasus debitur fiktif dari awal sampai rekomendasi kredit.
Siapa yang cocok mengikuti training ini?
Credit analyst korporasi, komersial, dan UKM, relationship manager, tim credit risk dan portfolio review, serta tim financial analytics di bank dan lembaga keuangan.
Kapan jadwal training tahun 2027?
Ada 12 batch: 25-26 Januari, 18-19 Februari, 29-30 Maret, 19-20 April, 27-28 Mei, 21-22 Juni, 19-20 Juli, 23-24 Agustus, 20-21 September, 21-22 Oktober, 18-19 November, dan 20-21 Desember 2027. Waktu pelaksanaan full-day pukul 09.00-17.00.
Di mana lokasi training diselenggarakan?
Di Jakarta Selatan (Swiss-Belinn Simatupang, Swiss-Belhotel Pondok Indah, Ibis Styles Simatupang, dan Hotel TMG Tebet), Yogyakarta, dan Bandung.
Berapa biaya training dan apa saja yang termasuk?
Biaya training offline adalah Rp5.950.000 per peserta, sudah termasuk training material, sertifikat, lunch dan coffee break, souvenir, serta door prize.
Apakah tersedia in-house training untuk bank kami?
Ya. Program ini dapat diselenggarakan sebagai in-house training dengan kapasitas maksimal 20 peserta per batch, dalam Bahasa Indonesia atau English.
Apa yang perlu disiapkan peserta?
Laptop dengan Microsoft Excel 365 (desktop app), akun Claude Pro individual (minimum) dengan Cowork tersedia, serta pengetahuan dasar laporan keuangan dan Excel.
Apakah data nasabah digunakan dalam training?
Tidak. Training memakai data kasus fiktif saja, tidak ada data nasabah yang diunggah, dan selaras dengan kebijakan keamanan IT bank serta panduan OJK.








































