FINANCIAL MODELING FOR FINANCIAL & CREDIT ANALYSIS

FINANCIAL MODELING FOR FINANCIAL & CREDIT ANALYSIS

Hotel Aston, Bandung | 26 – 28 Maret 2013 | IDR 7.8500.000,-/peserta
Hotel Aston, Bandung | 12 – 14  Juli 2013 | IDR 7.8500.000,-/peserta
Hotel Aston, Bandung | 10 – 12 September 2013 | IDR 7.8500.000,-/peserta
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

• 26 – 28 Maret 2013 Bacth I
• 12 – 14  Juli 2013 Batch  II
• 10 – 12 September 2013 Batch III
• 11 – 13 Desember 2013 Batch IV

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

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training

1. INFORMATION OPTIONS
2. Judul Training(required)
3. Tanggal Training
4. Select a message type Registration Offering Letter (Permintaan Proposal Penawaran) Next Schedule Information (Jadwal selanjutnya) More Information (Informasi tambahan) Others (lain-lain) (required)
5. PERSONAL DATA
6. Your Name(required)
7. Job Title(required)
8. Company(required)
9. Company Address
10. Email(valid email required)
11. Mobile Phone(required)
12. Office Phone(required)
13. Extention No.
14. Facsimile (Fax)
15. Website
16. PRE REGISTRATION DATA (Tidak Mengikat)
17. Penanggung Jawab Training di Perusahaan
18. Email
19. Office Phone+Ext atau No. Handphone
20. Jumlah Peserta(required)
21. Nama-nama peserta
22. Payment Method Bank Transfers Submitting an Invoice Cheque or Cash on arrival ( If Possible)
23. MESSAGE FOR TRAINING PROVIDER
24. Pesan untuk penyelenggara Training
25. CC this registration / message to me
26. Isikan angka/huruf pada gambar

 

cforms contact form by delicious:days