Home » Financial Modeling
Financial Modeling
July 29, 2013
Jadwal Pelatihan Financial Modeling
| Tanggal | Tempat | Kota | | Belum ada jadwal terbaru |
TUJUAN
Pelatihan ini sangat sesuai bagi bankers/kreditur, professional dari perusahaan sekuritas, investor dan siapapun yang ingin menigkatkan kemampuan utnuk dapat :
- Membangun financial model untuk melakukan analisa keuangan dna kredit
- Membangun modul untuk menemukan batas-batas covenant sebagai persyaratan kredit/obligasi/MTN
- Melakukan stress test dengan menggunakan sensitivity & Scenario analysis tool
- Melakukan analisa menggunakan dana dengan dynamic charts of sources & User of cash analysis tool.
- Melakukan simulasi pinjaman/obligasi/MTN
MATERI Training Financial Modeling
1. 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
2. Modeling financial covenant
3. Understanding of risk and multiple outcomers:
- Sensitivity & stress test analysis
- Scenario analysis
4. Using dynamic charts of sources & use of cash analysis
5. Modeling scenario using button & macro recording
6. 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
METODE PELATIHAN
Presentation
Discussion
Case Study
Evaluation
FASILITAS
Training Kit
Flash disc
Handout
Certificate
Lunch + 2 X Coffee Break
Souvenir
BIAYA PELATIHAN
Rp. 8.000.000,- /Peserta /Non Recidential
