TRAINING ONLINE FINANCIAL MODELING FOR COMPANY VALUATION WITH SENSITIVITY & SCENARIO ANALYSIS AND XCELSIUS
DESKRISPSI TRAINING WEBINAR PEMODELAN KEUANGAN UNTUK PENILAIAN PERUSAHAAN DENGAN ANALISIS SENSITIVITAS & SKENARIO DAN XCELSIUS
Secara umum, suatu financial model adalah suatu spreadsheet yang dibuat untuk tujuan melakukan analisa keuangan bagi suatu perusahaan, proyek, portfolio keuangan dan lain-lain.
Berbagai jenis financial model antara lain Risk analysis models, Trading models dan lain lain. Namun jenis financial model yang umum digunakan adalah financial statements projection model, sehingga dalam berbagai pelatihan, para pelatih memfokuskan khusus pada membangun financial model jenis tersebut.
Menimbang cukup kompleknya materi pelatihan Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius ini bagi peserta, dibutuhkan training provider yang berpengalaman di bidangnya agar tidak membuat peserta tidak menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini.
TUJUAN TRAINING FINANCIAL MODELING FOR COMPANY VALUATION UNTUK PRAKERJA
Dengan mengikuti pelatihan Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius Peserta dapat berbagi pengetahuan / sharing knowledge mengenai Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius dengan peserta dari perusahaan lain yang bergerak di bidang Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius
MATERI pelatihan Pemodelan Keuangan Untuk Penilaian Perusahaan Dengan Analisis Sensitivitas & Skenario dan Xcelsius online Zoom
Day 1
Day 1a – Financial Modeling Fundamental
08:30 – 09:00 Registration
09:00 – 09:30 Session 1 :
Introduction and Overview
* Overview of the Course
* Definition of Financial Model
* Scope of financial model
* Objectives of financial model
Financial Modeling Design Principles
* Financial Statement Interrelationship
* Financial Modeling Design Principles
* Design Flow & Model Layout : Input, Working & Output
* Financial Model Flow Chart
09:30 – 10:15 Session 2 :
Developing Excel Skills : Powerful Functions Used in Financial Models
* Statistical Functions: MAX, MIN
* Lookup and Reference Functions: OFFSET, INDEX, MATCH
* Date and Time Functions: DATE, DATEDIF
* Information Functions: IFERROR, ISNUMBER, ISTEXT
10:15 – 10:30 Coffee Break
10:30 – 12:00 Session 2 (Continued) :
Developing Excel Skills : Powerful Functions Used in Financial
Models (Continued)
* Math Functions : ROUND, ROUNDUP, ROUNDDOWN, MOD
* Range Names : Naming one cell, Naming Row, Naming relative
reference
* Conditional Formatting
* Data Validation
* Using Form Control : Combo Box, List Box, Spinner, Button
What-if Analysis Techniques
* Using scenario manager & scenario buttons
12:00 – 13:00 Lunch Break
Day 1b – Modeling Mini Financial Model
13:00 – 15:15 Session 3 :
Modeling Mini Financial Model
* Pre-Development – Defining a financial model plan
+ Knowing financial model objective
+ Specification and planning, flowchart and information flow
+ Design and structure – key steps
Development process
* Modeling mini balance sheet
* Balancing the balance sheet
* Modeling mini income statement
* Testing and debug
15:15 – 15:30 Coffee Break
What-if Analysis Techniques
* Using scenario manager & scenario buttons
Using Datatable
* Working with one-variable datatable
* Working with two-variable datatable
Introduction to VBA (Visual Basic for Application)
* Recording Macro for Button
* Activating and using Visual Basic Editor
* Using VBA codes for automation What-if analysis techniques
* Number Fomating Using VBA codes
Day 2
Day 2a – Modeling Financial Model and Using Sensitivity & Scenario
Analysis Tool
08:30 – 09:00 Registration
09:00 – 09:30 Session 4:
Modeling Powerful and Easy to Use Financial Model
* Understanding and creating a financial model template
* Modeling historical sheet
* Modeling assumption sheet – identifying key growth drivers
* Modeling income statement
* Modeling balance sheet statement
* Modeling accounting relationships between the income statement and
the balance sheet.
* Modeling cash flow statement
* Modeling ratios for analysis
10:15 – 10:30 Coffee Break
10:30 – 12:00 Session 5:
Modeling Sensitivity & Scenario Analysis Tool
* Scenarios simulation using VBA
* Using Data Table & Scenarios for Sensitivity & Scenario Analysis
* Modeling Dynamic Data Table for versatile Sensitivity & Scenario
Analysis
* Modeling Dynamic Chart to visualize the result of Sensitivity &
Scenario Analysis
12:00 – 13:00 Lunch Break
Day 2b – Valuation Modeling
13:00 – 15:15 Session 6:
Valuation Modeling
* Introduction to Company Valuation
*
+ Comparable Company Analysis
+ Discounted Cash Flow Analysis Model
* Modeling diluted shares outstanding using the treasury stock
method
+ Comparable Company Analysis data input
+ Modeling net debt
+ Modeling EBITDA multiple
+ Modeling P/E Multiple
* Modeling the weighted average cost of capital (WACC)
+ Projecting long term forward & terminal year
+ Modeling unlevered free cash flows
+ Modeling present value of free cash flow
+ Modeling terminal value using growth in perpetuity approach
+ Modeling terminal value using exit multiple approach
+ Modeling intrinsic (“fair”) value
* Sensitivity analysis using data tables
15:15 – 15:30 Coffee Break
15:30 – 17:00 Session 7:
Introduction to Dynamic Business Dashboards
* Relationship between Excel & SAP Dashboard Design (Xcelsius)
* Crystal Xcelsius elements
*
+ The canvas
+ The component list & categories
+ The component properties (General, Behavior, Appearance)
* Importing Excel file into Xcelsius
Modeling Dynamic Business Dashboard
* Creating multi pages valuation dashboard using ‘Label-based Menu’
* Creating dynamic what-if analysis dashboard using:
*
+ Horizontal slider and progress bars
+ Dials
* Setting Scenarios using ‘Local Scenario button’
Testing and Publishing Finished Dashboard to :
* Pdf File
* Powerpoint file
Studi Kasus / Praktek pemecahan masalah Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius
METODE pelatihan Financial Modeling For Company Valuation online Zoom
Metode Training Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius dapat menggunakan fasilitas training zoom atau training online, dan bisa juga training offline atau training tatap muka.
INSTRUKTUR pelatihan Financial Modeling Fundamental using Excel, VBA & Xcelcius online Zoom
Instruktur yang mengajar pelatihan Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius ini adalah instruktur yang berkompeten di bidang Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius baik dari kalangan akademisi maupun praktisi.
PESERTA
Peserta yang dapat mengikuti training Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius ini adalah staff sdm atau karyawan yang ingin mendalami bidang Financial Modeling For Company Valuation With Sensitivity & Scenario Analysis and Xcelsius.
Karena kompleksnya pelatihan ini, maka dibutuhkan pendalaman yang lebih komprehensif melalui sebuah training. Dan menjadi sebuah kebutuhan akan training provider yang berpengalaman di bidangnya agar tidak membuat peserta menjadi cepat bosan dan jenuh dalam mendalami bidang teknik ini.
Jadwal pelatihan trainingmekatronika.com tahun 2024 :
- Batch 1 : 03 – 04 Januari 2024 | 16 – 17 Januari 2024
- Batch 2 : 07 – 08 Februari 2024 | 20 – 21 Februari 2024
- Batch 3 : 05 – 06 Maret 2024 | 19 – 20 Maret 2024
- Batch 4 : 09 – 10 April 2024 | 13 – 24 April 2024
- Batch 5 : 07 – 08 Mei 2024 | 22 – 23 Mei 2024
- Batch 6 : 05 – 06 Juni 2024 | 25 – 29 Juni 2024
- Batch 7 : 09 – 10 Juli 2024 | 23 – 24 Juli 2024
- Batch 8 : 06 – 07 Agustus 2024 | 20 – 21 Agustus 2024
- Batch 9 : 04 – 05 September 2024 | 18 – 19 September 2024
- Batch 10 : 18 – 19 Oktober 2024 | 15 – 16 Oktober 2024
- Batch 11 :06 – 07 November 2024 | 26 – 27 November 2024
- Batch 12 : 04 – 05 Desember 2024 | 18 – 19 Desember 2024
Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta training Fundamentals of Mechanics pasti jalan
Invetasi dan Lokasi :
· Yogyakarta,
· Jakarta,
· Bandung,
· Bali,
· Surabaya,
· Lombok,
Catatan : Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas :
- FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)
- FREE Akomodasi ke tempat pelatihan bagi peserta training mechanical engineering bali pasti running
- Module / Handout training Understand common engineering material bali fixed running
- FREE Flashdisk
- Sertifikat training TRANSMISI DAYA MEKANIK (MECHANICAL POWER TRANSMISSION) di bali murah
- FREE Bag or bagpackers (Tas Training)
- Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
- 2xCoffe Break & 1 Lunch, Dinner
- FREE Souvenir Exclusive
- Training room full AC and Multimedia