Financial Modeling for Debt Restructuring with Claude

Financial Modeling for Debt Restructuring with Claude adalah training publik dua hari yang mengajarkan Anda membangun model restrukturisasi utang dari diagnosis kesulitan keuangan sampai term sheet hasil negosiasi. Anda mengerjakan satu kasus maskapai fiktif, Kenari Air, bersama Claude AI, lalu menggunakan model Anda untuk bernegosiasi di sisi kreditur atau debitur. Jadwal tersedia setiap bulan sepanjang 2027.
Keputusan restrukturisasi utang bergantung pada satu pertanyaan: struktur utang seperti apa yang sanggup ditopang bisnis, dan apa yang bisa diterima kreditur? Training ini membantu Anda menjawabnya dengan angka, bukan dengan asumsi. Claude mempercepat pekerjaan membangun dan memeriksa model, sedangkan penilaian atas asumsi dan keputusan akhir tetap di tangan Anda.
Course Description
Debt restructuring decisions depend on one question: what deal can the business sustain, and what can creditors accept? This hands-on public training runs over two days and teaches you to answer it by building a restructuring model with Claude AI.
Using a fictional distressed airline, you will diagnose the causes of distress, build an integrated 3-statement model and 13-week cash flow, size sustainable debt, and model six restructuring levers.
On Day 2, you will join a creditor or debtor team, build your position, and use your model to negotiate a term sheet.
- Format: 2 days, hands-on, public class
- Case: Fictional distressed airline
- For: Bankers, corporate finance teams, advisors, and investors
- You need: Working knowledge of Excel and the three financial statements; no aviation experience
Model the Rescue, Then Negotiate It
In this course, you build the model with Claude, take a side, and use your numbers to reach a deal.
- 2 days of hands-on modeling: Day 1 builds the shared airline model. Day 2 puts that model to work in a live negotiation.
- 1 fictional airline case: About 20 aircraft, two aircraft types, rupiah revenue with USD-linked costs, and four creditor groups.
- 6 restructuring levers: Rescheduling, repricing, haircuts, debt-to-equity swaps, asset settlements, and new money, each switchable.
- 2 negotiating sides: Creditors test recovery and NPV. Debtors test viability, liquidity, covenants, and shareholder dilution.
- 1 term sheet to close: Three negotiation rounds, with each offer tested in the model, lead to an agreed term sheet and a debrief.
Built for Both Sides of the Restructuring Table
Who Should Attend
- Bankers: Credit, special assets, and workout teams
- Corporate finance teams: CFOs, treasurers, and FP&A leads
- Advisors: Restructuring, transaction, and legal advisors
- Investors: Distressed debt, private credit, and special situations
Before You Join
- Working knowledge of Excel and the three financial statements
- Laptop with Excel
- Claude Pro or higher, with Cowork set up
- No aviation experience needed; the case covers the airline basics
Course Objectives
By the end of the course, you will be able to:
- Diagnose the causes of financial distress using ratios, cash burn, and operating drivers
- Build an integrated status quo model with debt and lease schedules
- Measure liquidity and cash runway with a 13-week cash flow
- Size sustainable debt using CFADS, DSCR, and leverage
- Model rescheduling, repricing, haircuts, debt-to-equity swaps, asset settlements, and new money
- Compare proposals on recovery, NPV, liquidity, covenants, and shareholder dilution
- Explain key PSAK 109 and PSAK 116 effects, and bank collectibility and provisioning implications
- Stress-test a proposal and set a walk-away point
- Use Claude to build, check, and analyze models faster, while keeping the key judgments yours
The Case: Kenari Air, a Fictional Airline in Distress
The airline
- About 20 aircraft across two types
- Revenue mainly in rupiah; leases and many costs in or linked to USD
- Forecast driven by fleet, ASK, load factor, yield, and CASK
- Liquidity is running out and creditors are at the table
Four creditor groups, each with different leverage
- Aircraft lessors: Can take back aircraft, which can cut capacity and revenue
- Bank syndicate: Holds security and covenants, but must act together
- Bondholders: Are widely held and may rank behind secured lenders
- Trade creditors: Fuel, airport, and maintenance suppliers can disrupt operations
Two Days, One Airline, from Diagnosis to Term Sheet
- Day 1: Build the shared model. Diagnose, Status quo, Liquidity, Debt capacity, Levers. End of day: a working airline model with switchable restructuring levers.
- Day 2: Take a side and negotiate. Take sides, Build position, Negotiate, Term sheet, Debrief. End of day: a negotiated term sheet tested against your model.
Day 1: Diagnose the Distress and Build the Core Model
| Time | Session | What you produce |
|---|---|---|
| 09:00–10:30 | Why airlines fail: the causes of distress and the restructuring options | Ratio and cash burn diagnostic |
| 10:30–10:45 | Coffee break | |
| 10:45–12:15 | Status quo forecast: fleet, ASK, load factor, yield, and CASK | Integrated 3-statement model |
| 12:15–13:15 | Lunch | |
| 13:15–14:45 | Debt, leases, and liquidity, including PSAK 116 lease liabilities | Debt and lease schedules; 13-week cash flow |
| 14:45–15:00 | Coffee break | |
| 15:00–17:00 | Debt capacity and the six restructuring levers | CFADS-based debt sizing; switchable levers |
Six Levers, Each Switchable in the Model
- Rescheduling: Extend bank and bond tenors, add grace periods, and re-profile installments.
- Repricing: Lower interest and lease rates, use PIK, or switch to power-by-the-hour.
- Haircut: Write off part of the principal or arrears owed to selected creditors.
- Debt-to-equity swap: Convert debt or trade claims into equity or a convertible instrument.
- Asset settlement: Return aircraft or sell assets to settle claims and shrink the fleet.
- New money: Refinance old debt or add new facilities, often with priority over existing debt.
Day 2: Take a Side, Then Negotiate with Your Model
| Time | Session | What you produce |
|---|---|---|
| 09:00–10:30 | Team briefing and core analysis, using partly built templates | Recovery waterfall or viability plan |
| 10:30–10:45 | Coffee break | |
| 10:45–12:15 | Complete your position and stress-test it | NPV comparison or creditor proposal; walk-away point |
| 12:15–13:15 | Lunch | |
| 13:15–14:45 | Negotiation: Rounds 1 and 2 | Opening proposal and counteroffers |
| 14:45–15:00 | Coffee break | |
| 15:00–16:15 | Negotiation: final round | Agreed term sheet |
| 16:15–17:00 | Debrief: financial, accounting, and collectibility impact | Claude-drafted credit memo or proposal |
Creditors and Debtors Read the Same Model Differently
Creditor team: Is this deal better than the alternative?
- Liquidation versus going-concern value
- Recovery waterfall by creditor class
- NPV and recovery of each proposal
- Collectibility, provisions, and PSAK 109
- Stress tests and the walk-away point
Debtor team: Can the airline survive this deal?
- Turnaround plan and fleet decisions
- Sustainable debt structure
- Liquidity, covenants, and dilution by option
- Modification gains or losses under PSAK 109
- Creditor proposal and the PKPU fallback
Three Rounds Turn the Model into a Term Sheet
- Opening positions: The debtor team tables its proposal. Creditors test it against recovery and NPV.
- Counteroffers: Teams change the levers. Claude helps test each offer in the model.
- Final terms: Teams settle the open points and record the deal in a term sheet.
Then the debrief. We run the agreed deal through the model and compare each team’s result, then discuss what moved the negotiation and what would change in a real case.
Claude Speeds Up the Build; You Keep the Judgment
- Prompt: Write each prompt with the 3-Tier Prompt Framework
- Build: Build in Cowork, one prompt per module
- Check: Confirm the balance sheet, debt roll-forwards, and cash all tie
- Analyze: Use a tornado chart, one-way data table, and MIDAS
- Draft: Draft the credit memo or creditor proposal
The decisions stay with you. Which assumptions are credible, which creditor can really walk away, and what deal is worth signing all remain human calls. Claude speeds up the work around them.
Claude’s Role in Each Session
| Day | Time | Session | What Claude does |
|---|---|---|---|
| Day 1 | 09:00 | Causes of distress | Calculates ratios and cash burn, and flags trends to investigate |
| Day 1 | 10:45 | Status quo forecast | Builds the airline drivers and 3-statement model from your prompts |
| Day 1 | 13:15 | Debt, leases, and liquidity | Builds the debt and lease schedules and the 13-week cash flow |
| Day 1 | 15:00 | Debt capacity and levers | Builds the debt sizing and lever switches, then runs the model checks |
| Day 2 | 09:00 | Core analysis | Helps complete the recovery waterfall or viability plan template |
| Day 2 | 10:45 | Position and stress test | Runs the NPV comparison, sensitivities, and scenarios |
| Day 2 | 13:15 | Negotiation: Rounds 1 and 2 | Tests each offer in the model and summarizes the impact |
| Day 2 | 15:00 | Negotiation: final round | Drafts the term sheet from the terms your team agrees |
| Day 2 | 16:15 | Debrief | Runs the agreed deal through the model and drafts the memo or proposal |
Course Takeaways
- Airline restructuring model: An integrated 3-statement model with switchable levers
- 13-week cash flow: A liquidity tool you can adapt to other cases
- Creditor toolkit: A recovery waterfall and NPV comparison of proposals
- Debtor toolkit: A viability plan and creditor proposal
- Sample term sheet: The terms your class negotiated, tested in the model
- Claude-drafted memo or proposal: A credit memo or creditor proposal, depending on your team
- Reusable prompts: Module prompts you can adapt to other industries
Each team builds one side in class. Completed creditor and debtor templates are shared afterward, so you leave with both.
Jadwal Training Financial Modeling for Debt Restructuring 2027
Training berlangsung dua hari penuh setiap batch, full-day training pukul 09.00–17.00. Berikut jadwal batch sepanjang 2027:
- 28–29 Januari 2027
- 22–23 Februari 2027
- 1–2 Maret 2027
- 22–23 April 2027
- 3–4 Mei 2027
- 24–25 Juni 2027
- 22–23 Juli 2027
- 26–27 Agustus 2027
- 23–24 September 2027
- 25–26 Oktober 2027
- 22–23 November 2027
- 22–23 Desember 2027
Venue Training
Training Financial Modeling for Debt Restructuring diselenggarakan di tiga kota:
- Jakarta Selatan: Swiss-Belinn Simatupang (Jakarta Selatan), Swiss-Belhotel Pondok Indah (Jakarta Selatan), Ibis Styles Simatupang (Cilandak, Jakarta Selatan), dan Hotel TMG Tebet (Tebet, Jakarta Selatan).
- Yogyakarta
- Bandung, Jawa Barat
Investment Fee
Offline Training: Rp5.950.000 per peserta.
Biaya sudah termasuk training material, sertifikat, lunch dan coffee break, souvenir, serta door prize.
Opsi In-House Training
Program ini juga dapat diselenggarakan sebagai in-house training dengan kapasitas maksimal 20 peserta per batch. Untuk membahas kebutuhan tim Anda, hubungi kami lewat halaman kontak Seventh atau pelajari layanan in-house training Seventh Grace Consulting.
Profil Trainer: Purwadi Nitimidjojo
Purwadi Nitimidjojo adalah spesialis financial modeling dan credit analysis dengan pengalaman lebih dari 30 tahun di corporate banking, leasing, multi-finance, restrukturisasi utang, dan konsultasi. Ia memiliki lebih dari 25 tahun pengalaman membangun model keuangan di Microsoft Excel untuk corporate finance, corporate banking, debt restructuring, dan project finance.
Kariernya dimulai di perbankan, termasuk The Chase Manhattan Bank, PT Bank PDFCI, Indonesian Bank Restructuring Agency (IBRA), dan PTANJ Finance. Pada 2006–2012 ia menjadi Consultant & Trainer di Omega Performance, vendor credit analysis yang kini dimiliki Moody’s Corporation dan beroperasi di bawah Moody’s Analytics. Pada 2012–2020 ia menjabat Director, Financial Modeling di Deloitte Indonesia, lalu melanjutkan sebagai Senior Specialist hingga Mei 2022. Sejak Juni 2022 ia menjadi Senior Advisor & Trainer, Financial Modeling di BDO in Indonesia.
Ia telah melatih profesional keuangan dari lebih dari 1.000 perusahaan di Indonesia, Singapura, Malaysia, Thailand, dan Kamboja. Sejak 2026 ia mengembangkan kerangka kerja AI-assisted modeling, termasuk 3-Tier Prompt Framework, MIRROR Method, Engineering Stack, dan MIDAS (Multi-Indexed Datatable Analysis System) untuk analisis skenario. Ia lulusan Fisika Institut Teknologi Bandung (ITB), dan pelatihan dapat disampaikan dalam Bahasa Indonesia maupun Inggris.
Mengapa Mengikuti Training Ini
Restrukturisasi utang menuntut dua kemampuan sekaligus: membaca kondisi keuangan secara akurat dan menguji setiap proposal dengan angka. Dalam dua hari, Anda membangun model terintegrasi, menguji enam lever restrukturisasi, lalu memakainya langsung dalam negosiasi. Anda pulang membawa model, toolkit kreditur dan debitur, contoh term sheet, serta prompt yang dapat diadaptasi ke industri lain.
Ingin memperdalam sisi lain? Lihat juga Financial Modeling & Analysis with Claude AI, Modeling Under Uncertainty with Claude, Agentic AI for Banking with Claude Cowork, dan Public Company Financial Modeling with Claude or ChatGPT. Semua program tersedia di katalog training Seventh.
FAQ Financial Modeling for Debt Restructuring with Claude
Apa yang dipelajari dalam training Financial Modeling for Debt Restructuring with Claude?
Peserta mendiagnosis penyebab kesulitan keuangan, membangun model 3-statement dan 13-week cash flow, menghitung kapasitas utang yang berkelanjutan, memodelkan enam lever restrukturisasi, lalu menegosiasikan term sheet dengan model mereka.
Apakah saya perlu berpengalaman di industri penerbangan?
Tidak. Kasus Kenari Air, maskapai fiktif, sudah mencakup dasar-dasar bisnis penerbangan yang Anda butuhkan.
Apa yang harus saya siapkan sebelum training?
Pengetahuan dasar Excel dan tiga laporan keuangan, laptop dengan Excel, serta Claude Pro atau yang lebih tinggi dengan Cowork yang sudah disiapkan.
Siapa yang cocok mengikuti training ini?
Banker (credit, special assets, workout), tim corporate finance (CFO, treasurer, FP&A), advisor restrukturisasi dan transaksi, serta investor distressed debt, private credit, dan special situations.
Kapan jadwal training tahun 2027?
Tersedia dua belas batch, dari 28–29 Januari 2027 sampai 22–23 Desember 2027. Setiap batch berlangsung dua hari, pukul 09.00–17.00.
Di mana lokasi training?
Di Jakarta Selatan (Swiss-Belinn Simatupang, Swiss-Belhotel Pondok Indah, Ibis Styles Simatupang, atau Hotel TMG Tebet), Yogyakarta, dan Bandung, Jawa Barat.
Berapa biaya training?
Offline training Rp5.950.000 per peserta, sudah termasuk training material, sertifikat, lunch dan coffee break, souvenir, serta door prize.
Apakah tersedia in-house training?
Ya, dengan kapasitas maksimal 20 peserta per batch.
Daftar Sekarang
Amankan kursi Anda di batch 2027 dan kuasai financial modeling for debt restructuring bersama Claude. Pendaftaran dapat dilakukan lewat halaman kontak Seventh atau katalog training Seventh.id. Kenali penyelenggaranya di halaman layanan Seventh Grace Consulting.








































