TRAINING FINANCIAL MODELING FOR PROJECT

TRAINING KONSEP MODEL KEUANGAN

TRAINING PENERAPAN MODEL KEUANGAN

DESKRIPSI TRAINING FINANCIAL MODELING FOR PROJECT

Financial  model  telah  digunakan secara luas dalam berbagai kegiatan
bisnis perusahaan 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.
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 FOR PROJECT

Setelah mengikuti pelatihan ini, diharapkan peserta dapat:
* Memahami  berbagai  financial  modeling  for  Project terkini yang
banyak digunakan oleh perusahaan
* Mengaplikasikan dalam beberapa kasus financial modeling

PESERTAÂ TRAINING FINANCIAL MODELING FOR PROJECT

Pemahaman  yang  memadai  pada  Financial  Model  sangat penting untuk
ditekankan  dan  diikuti  oleh  para  staff  professional, manager dan
leader di perusahaan.

MATERI TRAINING FINANCIAL MODELING FOR PROJECT

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
5. 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
6. Establish scenario and sensitivity analysis
1. uses of data for sensitivity analysis
2. Importance of scenario manager
3. Identifying  suitable  scenarios  and  sensitivity  and their
impact on financial analysis
4. Managing key pitfalls in the analysis
7. 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
8. 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
9. Approaches to apply different valuation techniques in the model
10. Different method valuation – DCF, Multiple, comparable
11. Discounted  Cash  flow  valuation  and  different  multiples based
methodologies
12. Importance of terminal valuation
13. Current  industry  practices  followed  in company valuation using
single or multiple methodologies
14. How to factor size and illiquidity discount in the final valuation
15. Incorporate  various adjustment to the publicly available versions
of company valuation

METODE TRAINING FINANCIAL MODELING FOR PROJECT
* Presentasi
* Diskusi Interaktif
* Studi Kasus
* Simulasi
* Evaluasi

INSTRUKTURÂ TRAINING FINANCIAL MODELING FOR PROJECT
* Yunita Anggarini, SE., M.Si., Dr (cand)
* Achmad Tjahjono, MM, Ak.

Trainer  dan  Pakar  di  bidang  analisis  kelayakan  usaha  dan studi
kelayakan  investasi.  Pengajar  dan  konsultan  manajemen keuangan di
berbagai perusahaan.

JADWAL TRAINING TAHUN 2023

17 – 18 Januari 2023

14 – 15 Februari 2023

20 – 21 Maret 2023

4 – 5 April 2023

16 – 17 Mei 2023

20 – 21 Juni 2023

17 – 18 Juli 2023

15 – 16 Agustus 2023

25 – 26 September 2023

17 – 18 Oktober 2023

21 – 22 November 2023

27 – 28 Desember 2023

Metode Training

1. Tatap Muka/offline
2. Online via zoom

Kota Penyelenggaraan jika offline :

1. Bandung
2. Jogjakarta
3. Surabaya
4. Jakarta

fasilitas yang didapatkan

1. Training Kit Eksklusif
   • Tas
   • Name Tag
   • Modul
   • Flash disk
   • Ballpoint
   • Block Note
   • Souvenir
2. Harga yang Reliable
3. Trainer Kompeten di bidangnya
4. Pelayanan Maksimal untuk peserta
5. Penjemputan dari dan ke bandara

Investasi :

Public training : Rp. 4.500.000 (minimum 3 pax)

In House Training : on Call