Training Financial Modeling For Company Debt Re-Structuring Using Multiple Cashflow Calculation Method With Excel, Vba & Xcelcius

Training Pemodelan Finansial

Training Konsep Financial Modeling

Latar Belakang
1. Kreditur sering melakukan analisa terhadap berbagai cara debitur untuk melakukan pembayaran kembali pinjaman yang diberikan (debt repayment methods) dalam kegiatan pembiayaan proyek (project finance transaction). Proses ini sangat penting dalam menentukan struktur kredit yang akan diberikan.
2. Kreditur ingin agar dapat melakukan simulasi atas berbagai cara pembayaran kembali seperti :
+ Annuity (Equal Principal Repayment+Interest)
+ Equal Principal (Straight line equal Principal repayments)
+ % Profile (User to enter % repayment profile)
3. Dengan memiliki financial model dengan kedua fitur ini, maka para pengambil keputusan akan dapat mengambil keputusan dengan cepat.
4. Mengetahui cara menggunakan SAP Dashboard Design (Xcelsius), menentukan komponen mana yang paling sesuai untuk me-representasikan bermacam-macam informasi yang berbeda, mem-finalisasi dashboard dan mengekspor menjadi file format yang berbeda.

Manfaat pelatihan
1. Pelatihan ini sangat berguna untuk membekali peserta agar dapat membangun financial model yang dapat menggunakan berbagai cara pembayaran pinjaman (multiple debt repayment methods), dengan cara yang jelas (in a transparent way) dan sekaligus juga bersifat dinamis dengan hanya mengaktifkan satu tombol saja
2. Pelatihan ini akan membimbing peserta secara step-by-step untuk membangun berbagai cara pembayaran pinjaman baik membangun model dari awal, maupun menambahkan pada financial model yang sudah ada.
3. Peserta akan dapat membuat model yang dapat dimengerti dengan mudah oleh orang lain yang berasal dari berbagai tingkat keahlian,
4. Menampilkan analisa “what-if” dengan cara yang mudah untuk memperjelas permasalahan dan menyelesaikan masalah, dan
5. Membuat presentasi dan laporan yang menarik.

Syllabus
Day 1 :
Day 1a – Financial Modeling Fundamental

08:30 – 09:00
Registration

09:00 – 09:30
Session 1 :
o.Introduction and Overview
Overview of the Course
Definition of Financial Model
Scope of financial model
Objectives of financial model

o.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 :
o.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) :
o.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

o.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 :
o.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

15:30 – 17:00
Session 4 :
o.Using Datatable
+ Working with one-variable datatable
+ Working with two-variable datatable

o.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 Powerful and Easy to Use Financial Model

08:30 – 09:00
Registration

09:00 – 09:30
Session 5 :
o.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 6 :
o.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 7 :
o.Modeling Cash Sweep
o.Modeling Cashflow Waterfall
o.Modeling Average DSCR (Debt Service Coverage Ratio)
o.Modeling CFADS (Cashflow Available for Debt Service)
o.Modeling Dynamic Graph CFADS (Cashflow Available for Debt Service)
o.Modeling DSRA (Debt Service Reserve Account)

15:15 – 15:30
Coffee Break

15:30 – 17:00
Session 8 :
o.Introduction to Dynamic Business Dashboards
What is a SAP Dashboard Design (Xcelsius)? How does it work?
Sample Crystal Xcelsius – Different by application
Relationship between Excel & Xcelsius
Supported Excel Functions
Principles of a good design – best practice
Crystal Xcelsius elements
•       The canvas
•       The component list & categories
•       The component properties (General, Behavior, Appearance)

o.Modeling Dynamic Business Dashboard
Importing underlying spreadsheet
Working with canvas, components and properties
Creating dynamic what-if analysis dashboard (Creating dynamic dashboard for profitability analysis)
Assessing the company profitability
Setting Scenarios
Export interactive business dashboard to Powerpoint, Word dan PDF, for easy distribution to other people

Siapakah yang harus hadir
·         CFOs
·         Directors / Managers of Corporate Finance
·         Directors / Managers of Finance & Accounting
·         Credit analysts
·         Financial Analysts
·         Treasury Personnel
·         Any other financial practitioners

Jadwal Pelatihan Trainingakuntansi 2023:

Batch 1 : 14 – 16 Februari 2023

Batch 2 : 15 – 17 Mei 2023

Batch 3 : 14 – 16 Agustus 2023

Batch 4 : 7 – 9 November 2023

Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta Training Pengenalan Financial Modeling Pasti Jalan

Invetasi dan Lokasi Pelatihan Konsep Financial Modeling Di Jogja :

· Yogyakarta, Hotel 101 (6.500.000 IDR / participant)

· Jakarta, Hotel Amaris Kemang (6.500.000 IDR / participant)

· Bandung, Hotel Neo Dipatiukur (6.500.000 IDR / participant)

· Bali, Hotel Ibis Kuta(7.500.000 IDR / participant)

· Surabaya, Hotel Amaris, Ibis Style (6.000.000 IDR / participant)

· Lombok, Sentosa Resort (7.500.000 IDR / participant)

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

Fasilitas  pelatihan Pengenalan Financial Modeling di jogja :

• FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara/Stasiun/Terminal)
• FREE Akomodasi ke tempat pelatihan bagi peserta training Konsep financial Modeling jogja pasti running
• Module / Handout Training Pemodelan Finansial Jogja Fixed Running
• FREE Flashdisk
• Sertifikat Training Financial Modeling For Company Debt Re-Structuring Using Multiple Cashflow Calculation Method With Excel, Vba & Xcelcius Di Jogja 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

.