TRAINING ONLINE FINANCIAL MODELING FOR COMPANY VALUATION WITH SENSITIVITY & SCENARIO ANALYSIS AND XCELSIUS

TRAINING ONLINE FINANCIAL MODELING FOR COMPANY VALUATION WITH SENSITIVITY & SCENARIO ANALYSIS AND XCELSIUS

training

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

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

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

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

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 Training Akuntansi Manajemen Untuk Oil And Gas Company Jogja Media Training 2023 :

Batch 1 : 24 – 26 Januari 2023

Batch 2 : 20 – 23 Maret 2023

Batch 3 : 15 – 17 Mei 2023

Batch 4 : 17 – 19 Juli 2023

Batch 5 : 25 – 27 September 2023

Batch 6 : 7 – 9 November 2023

Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta

Lokasi Pelatihan :

· Yogyakarta, Hotel Dafam Malioboro

· Jakarta, Hotel Amaris Tendean

· Bandung, Hotel Golden Flower

· Bali, Hotel Ibis Kuta

· Online dan Daring, Zoom, Google Meets, Teamlink

Investasi Pelatihan Akuntansi Manajemen Untuk Oil And Gas Company Tahun 2021 ini :

· Investasi pelatihan selama tiga hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.

· Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.

Fasilitas Training :

1. FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)

2. Module / Handout

3. FREE Flashdisk

4. Sertifikat

5. FREE Bag or bagpackers (Tas Training)

6. Training Kit (Dokumentasi photo, Blocknote, ATK, etc)

7. 2xCoffe Break & 1 Lunch, Dinner

8. FREE Souvenir Exclusive

9. Training room full AC and Multimedia

Tanyakan pada kami ?

Kami di sini untuk membantu Anda! Jangan ragu untuk menanyakan apapun kepada kami. Klik di bawah untuk memulai obrolan.

Marketing

IQBAL

Online

IQBAL

Hai, tanyakan pada kami ? 00.00