Financial Modeling for Debt Restructuring with Claude

Analis keuangan mengetik di keyboard sambil memeriksa laporan dengan grafik, ilustrasi training financial modeling for debt restructuring
Training 2 hari Financial Modeling for Debt Restructuring with Claude, dari diagnosis kesulitan keuangan sampai term sheet.
Bagikan
Rate this post

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:

  1. Diagnose the causes of financial distress using ratios, cash burn, and operating drivers
  2. Build an integrated status quo model with debt and lease schedules
  3. Measure liquidity and cash runway with a 13-week cash flow
  4. Size sustainable debt using CFADS, DSCR, and leverage
  5. Model rescheduling, repricing, haircuts, debt-to-equity swaps, asset settlements, and new money
  6. Compare proposals on recovery, NPV, liquidity, covenants, and shareholder dilution
  7. Explain key PSAK 109 and PSAK 116 effects, and bank collectibility and provisioning implications
  8. Stress-test a proposal and set a walk-away point
  9. 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

  1. Opening positions: The debtor team tables its proposal. Creditors test it against recovery and NPV.
  2. Counteroffers: Teams change the levers. Claude helps test each offer in the model.
  3. 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:

  1. 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).
  2. Yogyakarta
  3. 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.

You may also like...