FINANCIAL MODELING FOR FINANCIAL & CREDIT ANALYSIS

FINANCIAL MODELING FOR FINANCIAL & CREDIT ANALYSIS

Hotel Aston, Bandung | 11 – 13 Desember 2013 | IDR 7.8500.000,-/peserta

Tujuan :

Pelatihan ini sangat sesuai bagi bankers/kreditur, professional dari perusahaan sekuritas, investor dan siapapun yang ingin menigkatkan kemampuan utnuk dapat :

1. Membangun financial model untuk melakukan analisa keuangan dna kredit
2. Membangun modul untuk menemukan batas-batas covenant sebagai persyaratan kredit/obligasi/MTN
3. Melakukan stress test dengan menggunakan sensitivity & Scenario analysis tool
4. Melakukan analisa menggunakan dana dengan dynamic charts of sources & User of cash analysis tool.
5. Melakukan simulasi pinjaman/obligasi/MTN

Materi :

Materi :

• Building financial model  for analysis :

•  Identifying key drivers in the financial model
•   Modeling accounting relationships between the income statement and balanced sheet
• Modeling multi currency short term and long term borrowing & estimating forex loss/gain
•  Modeling income statement , balance sheet & cash flow statement
• Balancing the balance sheet-incorporating short term debt plug on balance sheet

•  Modeling financial covenant
•  Understanding of risk and multiple outcomers:

• Sensitivity & stress test analysis
• Scenario analysis

• Using dynamic charts of sources & use of cash analysis
•   Modeling scenario using button & macro recording
• Financial simulation

•  The impact on forecast financial statement
•  Modeling covenant compliance, forecasting credit ratios
•  Testing covenant sensitivity, developing the base for credit analysis
•  Using dynamic data tables for sensitivity & Scenario analysis to test company’s creditworthiness
• Using dynamic chart to visualize the result of sensitivity and scenario analysis

Peserta :

CFOs, Managers of Startegic Planner, Financial Controller, Financial Analysis, Financial Officer, Financial / Accounting staff, Corporate Finance Personnel, Treasury Personnel, Risk Manager, General manager.

Instruktur :

Edwar Peterson.   Adalah konsulatan dalam bidang Financial Modeling.

Waktu

• 11 – 13 Desember 2013

Tempat
Hotel  Aston, Bandung

Metode

• Pre-test and post- test
•   Role play
•   Group case discussion
• Game

Investasi
IDR 7.8500.000,-/peserta non residensial. Pendaftaran 3 peserta dari perusahaan yang sama discount 10 %.

Fasilitas

•   Training KIT
• Sertifikat
•   Souvenir
• 2 X Coffe Break +lunch
• Soft copy materi
•   Additional programm

cforms contact form by delicious:days