Training Online Financial Modeling
JADWAL PELATIHAN FINANCIAL MODELING TAHUN 2023
- Model pengelolaan keuangan
- Manajemen keuangna
- Financial management
DESKRIPSI
Financial model telah digunakan secara luas oleh kalangan perbankan
maupun profesi keuangan lainnya dan telah digunakan untuk berbagai
keperluan analisa keuangan. Berbagai jenis financial model antara
lain, Risk analysis models, Trading models dan lain-lain. Namun jenis
financial model yang umum digunakan adalah financial statements for
project model, sehingga dalam berbagai pelatihan, para pelatih
memfokuskan khusus pada membangun financial model jenis tersebut.
Proses pembuatan financial model menyangkut juga unsur ilmu
pengetahuan dan seni. Dengan demikian, mengikuti suatu pelatihan
financial modeling yang baik adalah suatu keharusan bagi mereka di
bidang bisnis development dan yang berkaitan dengan keputusan
keuangan.
Bagi para staff professional, manager dan leader di perusahaan,
pemahaman yang memadai pada Financial Model menjadi sangat penting
untuk ditekankan.
Tujuan Training Financial Modeling
Melalui kegiatan pelatihan, para peserta akan diperkenalkan konsep dan
aplikasinya :
• Memahami berbagai financial modeling for Project terkini yang banyak
digunakan oleh lembaga keuangan dan non lembaga keuangan
• Mengaplikasikan dalam beberapa kasus financial modeling
Outline Training Financial Modeling
Materi Training Financial Modeling yang akan dibahas ini adalah :
Hari Pertama :
1. Setting up a Financial Model and Building Projections
+ Overview of the best industry practice for financial modeling
+ Important of historic information
+ Step for creating financial model
+ Analysis of company and industry information
+ Proper presentation of various sheet and setting up the model
input dashboard
2. Preparation of Income statement, cash flow and balance sheet
+ Analysis of industry assumptions and their rationale for
revenue and cost, asset and liabilities’ assumptions
operating cost, capex, leverage, modeling of historical
ratios and trends
+ Short listing assumption applying adjustment
+ Applying various forecasting tool and etc
3. Importance of key schedule and their application
+ Working capital schedule (component cash and non cash)
+ Working capital ratio and their interpretation
+ Forecasting working capital requirement
+ Fixed asset and depreciation
+ Schedule of amortization of intangible asset
+ Preparation of debt and interest
+ Taxation
+ Equity fund raising
+ Equity Gap and funding
4. How to Create Capex and Funding schedule including multiple
multiple debts
+ Equity and debt fund raising and repayment structure
+ Debt waterfall mechanism
+ Checking debt repayment ratio. Leverage and covenant
Hari Kedua :
1. Integration of income statement, balance sheet and cash flow
statement
+ Industry practices on handling exceptions
+ Integration of cash flow, income statement and balance sheet
+ How to handle circular reference in financial model
2. Establish scenario and sensitivity analysis
+ uses of data for sensitivity analysis
+ Importance of scenario manager
+ Identifying suitable scenarios and sensitivity and their
impact on financial analysis
+ Managing key pitfalls in the analysis
3. How to analysis the data
+ Data sort and filtering
+ Creating customizing pivot table, advanced pivot tables and
analysis
+ V-lookup and H-lookup, Macros, Goal seek and other analysis
+ Solver function and it use
4. How to apply different financial analysis technique on the model
+ Important of PV, NPV and IRR and their link with company
valuation
+ How to analysis various capital budget decisions
+ Calculation of various ratios
+ Calculation the Weighted average cost of capital using CAPM
+ Calculation of WACC
+ Investment and exit analysis – equity IRR, Project IRR
5. Approaches to apply different valuation techniques in the model
6. Different method valuation – DCF, Multiple, comparable
7. Discounted Cash flow valuation and different multiples based
methodologies
8. Importance of terminal valuation
9. Current industry practices followed in company valuation using
single or multiple methodologies
- How to factor size and illiquidity discount in the final valuation
- Incorporate various adjustment to the publicly available versions
of company valuation
JADWAL TRAINING TERBARU 2025 :
Batch 1 : 15 – 16 Januari 2025
Batch 2 : 12 – 13 Februari 2025
Batch 3 : 19 – 20 Maret 2025
Batch 4 : 16 – 17 April 2025
Batch 5 : 14 – 15 Mei 2025
Batch 6 : 11 – 12 Juni 2025
Batch 7 : 9 – 10 Juli 2025
Batch 8 : 13 – 14 Agustus 2025
Batch 9 : 17 – 18 September 2025
Batch 10 : 15 – 16 Oktober 2025
Batch 11 : 12 – 13 November 2025
Batch 12 : 10 – 11 Desember 2025
Catatan : Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta pelatihan.
LOKASI
Jakarta : Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget.
Bandung : Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel .
Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel .
Surabaya : Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel .
Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel .
Bali : Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions .
Lombok : Favehotel, Novotel Lombok, D Praya Hotel .
Investasi training murah :
Offline Training 6.000.000
Online Training 3.000.000
Syarat dan Ketentuan Berlaku
Investasi pelatihan tersebut menyesuaikan dengan jumlah peserta (on call).
*Please feel free to contact us.
FASILITAS
-FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara)
-FREE Akomodasi Peserta ke tempat pelatihan
-Module / Handout training
-FREE Flashdisk
-Sertifikat training
-FREE Bag or bagpackers (Tas Training)
-Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
