FINANCIAL MODELING FUNDAMENTAL
Hotel Santika, Jakarta | 11 – 13 Desember 2013 | IDR 7.850.000,-/peserta
Tujuan :
- Memperoleh pemahaman dan keterampilan mengenai pengetahuan dasar membangun sebuah financial model.
- Pelatihan dirancang secara step by step membangun model industry manufaktur, industry sebagaimana selalu dijadikan model dasar untuk menyampaikan pengetahuan manajemen keuangan.
- Peserta akan berlatih membangun financial model sejak dari lembar kosong, agar peserta menjadi percya diri untuk membangun financial model industry apapun sesuai tempat bekerjanya. Bekerjanya.
Materi :
- Introduction to financial modeling
- Building mini financial statement
- Building mini balanced sheet
- Balancing the balance sheet
- Building mini income statement
- Introduction to Viusal Basic For Appilcation ( VBA)
- Activating and using Visual Basic editor
- Using VBA code for automation
- Using data Table
- Working with one variable data table
- Working with two-variable data table
- Building complete basic financial model
- Building historical sheet
- Building assumption sheet
- Earning & cost assumption
- Working capital assumption
- Capital expenditure assumption
- Short term loan assuemption
- Long term loan assumption
- Building complete basic financial model
- Bulidng income statement
- Bulding balance sheet
- Bulding cash flow
- Scenario simulation using VBA
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 Santika Jakarta
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