FINANCIAL MODELING

Acara

20 – 21 Maret 2019 | Rp 4.500.000/ peserta di Jakarta
15 – 16 April 2019 | Rp 4.500.000/ peserta di Jakarta
23 – 24 Mei 2019 | Rp 4.500.000/ peserta di Jakarta
17 – 18 Juni 2019 | Rp 4.500.000/ peserta di Jakarta

Jadwal Training 2019 Selanjutnya …

 

 

TUJUAN PELATIHAN FINANCIAL MODELING

Setelah mengikut pelatihan ini diharapkan peserta mampu untuk melakukan hal-hal sebagai berikut:

  1. Mendesain dan membangun aplikasi financial modeling yang sangat membantu mempercepat proses pengambilan keputusan.
  2. Mampu melakukan forecasting keuangan
  3. Mampu menggunakan beberapa teknik dan support tools dalam program spreadsheet excel
  4. Mampu menggunakan analisa skenario dan sensitivitas.

 

TARGET AUDIENCE

  1. Professional institusi keuangan yang membutuhkan model keuangan yang siap pakai dalam menunjang aktivitasnya sehari-hari.
  2. Investor yang akan melakukan studi kelayakan bisnis.
  3. Professional jasa penilai (appraiser professional)
  4. Mahasiswa dan khalayak umum yang punya minat dalam bidang keuangan dan investasi.

 

MATERI PELATIHAN FINANCIAL MODELING

  1. Pengantar Modeling
  • Menggunakan Excel sebagai kertas kerja (worksheet)
  • Konstruksi efektif terhadap sebuah model
  • Struktur dan tujuan
  • Persiapan awal
  1. Dasar-dasar Financial Modeling
  • Menggunakan shortcuts
  • Menyusun workbook
  • Memformat data secara professional
  • Inputting base data
  • Setting up date flexibility throughout the model using EDATE, EOMONTH and other date functions
  • Breakdown and grouping of accounting elements
  • Determine drivers of the model
  • Assumptions for projections
  • Effective use of short keys and functions
  • Applicable financial and logical functions
  • Data transfer and links
  • Professional use of Excel –protection, range names, data validation
  • Maximum use of Excel applications
  • Flexible and user-friendly models
  • Sensitivities
  • Model diagnostics
  1. Auditing
  • Using existing models
  • How to become comfortable with ‘new’ models
  • Auditing models
  1. Formatting and Showcasing
  • Formatting
  • Professional showcase
  • Use of graphs
  • Using switches

 

INSTRUCTOR :   Subur Harahap, SE, Ak, Dipl.FP, MM, CFP®, CA, CMA(Aust)

 

VENUE :  Jakarta (Maxone Hotel Menteng, Balairung Hotel Matraman, Sentral Hotel, Haris Tebet, Gd Muamalat Institute, Ibis Manggadua, Little Amaroossa Residence, Cosmo Amaroossa, Zodiak MT. Haryono, Grand Tjokro)

 

DURATION :   2 days

 

JADWAL TRAINING 2019

  1. 20 Mar 2019-21 Mar 2019
  2. 15 Apr 2019-16 Apr 2019
  3. 29 Apr 2019-30 Apr 2019
  4. 20 Jun 2019-21 Jun 2019
  5. 03 Jul 2019-04 Jul 2019
  6. 21 Agust 2019-22 Agust 2019
  7. 18 Sep 2019-19 Sep 2019
  8. 02 Okt 2019-03 Okt 2019
  9. 20 Nop 2019-21 Nop 2019
  10. 26 Des 2019-27 Des 2019

 

INVESTMENT/PERSON :

  1. 4.500.000/person (full fare) or
  2. 4.250.000/person (early bird, payment 1 week before training) or
  3. 3.950.000/person (if there are 3 persons or more from the same company)

 

FACILITIES FOR PARTICIPANTS :

  1. Training Module
  2. Flash Disk contains training material
  3. Certificate
  4. Stationeries: NoteBook and Ballpoint
  5. T-Shirt
  6. Backpack
  7. Training Photo
  8. Training room with full AC facilities and multimedia
  9. Lunch and twice coffeebreak everyday of training
  10. Qualified instructor

 

INTRODUCTION TO FINANCIAL MODELING

 

Formulir Pra-Pendaftaran Public Training / Permintaan Informasi Lebih Lanjut
  1. JENIS INFORMASI/TRAINING
  2. (required)
  3. (required)
  4. DATA PRIBADI
  5. (required)
  6. (required)
  7. (required)
  8. (valid email required)
  9. (required)
  10. (required)
  11. DATA PRE REGISTRATION (Tidak Mengikat)
  12. (required)
  13. PESAN UNTUK PENYELENGGARA TRAINING
  14. Captcha
 

cforms contact form by delicious:days

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.