FINANCIAL MODELING FUNDAMENTAL

FINANCIAL MODELING FUNDAMENTAL

Hotel  Santika, Jakarta | 11 – 13 Desember 2013 | IDR 7.850.000,-/peserta

Tujuan :

1. Memperoleh pemahaman dan keterampilan mengenai pengetahuan dasar membangun sebuah financial model.
2. Pelatihan dirancang secara step by step membangun model industry manufaktur, industry sebagaimana selalu dijadikan model dasar untuk menyampaikan pengetahuan manajemen keuangan.
3. 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

cforms contact form by delicious:days