Home  »  Bandung   »   Financial Modelling

Bandung Finance, Accounting, Tax, Treasury, Audit & Risk Management

Financial Modelling

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

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

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Financial Modelling
Link
*Jumlah Peserta	Estimasi Jumlah Peserta yang di ajukan
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan	Jabatan/Divisi/Departement
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif	eg: gmail, yahoo, hotmail
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi