TRAINING FINANCIAL MODELING AND EVALUATION


INFO JADWAL PELATIHAN FINANCIAL MODELING AND EVALUATION

INTRODUCTION

The course extends the core theory introduced in the Principles of Finance by emphasizing its practical application to strategic financial decisions and potential problems.

COURSE OBJECTIVES

  • Understanding and analyzing income statements
  • Understanding and analyzing balance sheets
  • Understanding and analyzing cash flow
  • Understanding financial modeling usage in financial reporting
  • Use of Discounted Cash Flow (DCF) and Weighted Average Cost of Capital
  • Use of Excel in financial modeling

WHO SHOULD ATTEND

The course targets financial analysts, Business entrepreneurs, accountants, bookkeepers, business managers, investment officers, and managing directors.

COURSE OUTLINE

Introduction to evaluation

  • Importance of evaluation
  • Enterprise value and equity value

Comparable Company Analysis

  • Selection of companies that are comparable
  • Spreading of comparable companies
  • Analyzing the valuation multiples
  • Understanding value and making conclusions

Precedent Transaction Analysis

  • selection of transactions that are comparable
  • Spreading comparable transactions

  Analysis of Discounted Cash Flows (DCF)

  • Unlevered free cash flow
  • Free cash flow forecasting
  • Terminal value forecasting
  • Presentation of value and discounting
  • Stub periods
  • Sensitivity analysis

Weighted Average Cost of Capital (WACC)

  • Estimating equity cost using CAPM
  • Estimating debt cost
  • Analysis of WACC

Building and Integrated Cash Flow Model

  • Introduction to financial modeling
  • Financial statement links
  • Understanding circularity
  • Set up and formation of the model
  • Selection of model drivers and assumptions

Modeling and Projecting the Financial Statements

  • Income statement projection
  • Balance sheet projection
  • Cash flow statement projection
  • Debt and interest schedule creation
  • Revolver modeling

Utilizing and Concluding the Model

  • Output analysis
  • Stress testing of the model
  • Fixing of modeling errors
  • Techniques of advanced modeling
  • Creating a Discounted Cash Flow (DCF) Analysis using the model

============================================================

FACILITIES

  • Certificate, Quality Training Kit (Pencil case: Erase, Bolpoint, Pencil, Tipe X, Stabillo, Flash Disk 8
  • Bag (Public Training)
  • Training Material (Hand Out & Soft Copy)
  • Convenient training facilities in stars hotel (Public Training)
  • Lunch 1 and Coffee Break 2 / Day (Public Training)
  • Souvenir
  • Gratis antar Jemput dari Bandara/Stasiun ( Khusus Yogyakarta )

 

VENUE 

Yogyakarta, Jakarta, Bandung, Bogor, Cirebon, Solo, Semarang, Surabaya, Malang, Bali, Lombok, Samarinda, Balikpapan, Banjarmasin, Pontianak, Makassar, Medan, Palembang, Lampung, Timor Leste, Thailand, Singapore , Kuala Lumpur.  (dengan harga dan minimal kuota yang berbeda)

TRAINING METHOD

  • Group Discussions
  • Group & Individ_pelatihanual Exercises
  • Presentations
  • Games
  • Case Studies
  • Role Plays
  • Self-Assessment
  • Action Plan

INSTRUCTOR TRAINING

 Tim Konsultan BMG Training & Development

Course Timings:

Daily Course Timings:

  •     08:00 - 08:20       Registerasi dan Pembukaan
  •     08:30 - 10:00       Sesi Pertama
  •     10:00 - 10:20       Coffee / Tea / Snacks
  •     10:20 - 12:00       Sesi Kedua
  •     12:00 - 13:00       Lunch Break & Prayer Break
  •     13:00 - 15:00       Sesi ketiga
  •     15:00 - 15:20       Coffee / Tea / Snacks & Prayer Break
  •     15:00 - 16:30       Sesi Terakhir

Permintaan Brosur penawaran Training ( Harga, Waktu dan Tempat) silahkan Menghubungi kami.

======================================================

Catatan :

Pelatihan ini dapat di-customized sesuai kebutuhan perusahaan Anda bila diselenggarakan dalam bentuk In-House Training. Untuk permintaan In-House Training dengan jenis topik lainya, silahkan mengirimkan ke alamat email yang tercantum di web kami.

—————————————————————————————-

Request Training. Jika anda membutuhkan informasi pelatihan yang belum tercantum pada website ini, atau anda ingin memberikan usulan materi yang sesuai dengan tingkat kebutuhan perusahaan anda, silahkan mengirimkan ke alamat emailyang tercantum.

—————————————————————————————-

Bila tid_pelatihanak ada tanggal dan waktu atau yang tercantum sudah kadaluarsa did_pelatihanalam artikel mohon tanyakan kepada kami untuk jadwal terbarunya.

—————————————————————————————-

Peserta bisa mengajukan Tanggal Pelatihan / Training selain yang tertera pada silabus penawaran.

—————————————————————————————-

Venue : di Yogyakarta, Jakarta, Bandung, Bogor, Cirebon, Solo, Semarang, Surabaya, Malang, Bali, Lombok, Samarinda, Balikpapan, Banjarmasin, Pontianak, Makassar, Medan, Palembang, Lampung, Timor Leste, Thailand, Singapore , Kuala Lumpur.  (dengan harga dan minimal kuota yang berbeda)

—————————————————————————————-

Info Jadwal training 2019 , Jadwal training 2019 , Informasi Jadwal training 2019 , Jadwal training 2020 , Jadwal training 2021 , Jadwal training 2022