TRAINING FINANCIAL MODELLING WITH EXCEL

TRAINING PENGENALAN FINANCIAL MODELLING WITH EXCEL

TRAINING MODEL KEUANGAN

OVERVIEW TRAINING FINANCIAL MODELLING WITH EXCEL

Pada  pelatihan financial  modelling with excel ini Para peserta akan
mendapatkan   wawasan   tentang   proses  atau  langkah-langkah  dalam
menciptakan  model   keuangan  dengan  menggunakan  Microsoft  Excel,
melakukan  pemeriksaan  dan  audit  dan akhirnya menganalisis hal yang
sama.

Pelatihan  financial  modelling  with  excel  ini akan membekali semua
peserta   dengan   berbagai  alat  untuk  membantu  dalam  pengambilan
keputusan  bisnis yang kompleks dengan memasukkan beberapa faktor  di
lingkungan  bisnis  yang dinamis. Pada akhir pelatihan, setiap peserta
akan  dapat  membuat  model  keuangan  secara  mandiri  dan  melakukan
analisis untuk mengambil keputusan terbaik untuk perusahaan mereka.

WHO SHOULD ATTEND

Semua individu yang ingin meningkatkan keterampilan pemodelan keuangan
yaitu
* Analis/ profesional keuangan
* Manajer menengah ke atas dari berbagai industri
* Semua  profesional  yang  ingin  berurusan atau saat ini berurusan
dengan pemodelan keuangan di perusahaan mereka
* Konsultan, penasihat, dan profesional lain yang ingin meningkatkan
keterampilan modeling mereka

MATERI TRAINING FINANCIAL MODELLING WITH EXCEL

1. Setting up a financial model  and building project
+ Overview of best industry practices for financial modeling
+ Importance of historic information
+ Analysis of company and industry information
+ Steps for creating financial models
+ Proper  presentation  of  various  sheets  and setting up the
model input dashboard
2. Preparation  of  Income statement, cash flow statement and balance
sheet
+ Analysis  of  industry  assumptions  and  their rationale for
revenues  &  costs, assets and liabilities’ assumptions –
operating  cost,  capex,  leverage,  modeling  of  historical
ratios and trends
+ Short listing assumptions and applying adjustments
+ Applying various forecasting tools, etc
3. Importance of key schedules and their application
+ Working capital schedule
+ Fixed assets and depreciation
+ Schedule of amortization of intangible assets
+ Preparation of debt and interest
+ Taxation
+ Equity fund raising
+ Equity gap and funding
+ Components of cash and non-cash working capital
+ Working capital ratios and their interpretation
+ Forecasting working capital requirements
4. How to create capex and funding schedules includng multiple debts
+ Equity and debt fund raising and repayment structure
+ Debt waterfall mechanism
+ Checking debt repayment ratios, leverage and covenants
5. Integeration  of income statement , balanced and cash flow
+ Industry practices on handling exceptions
+ Integration of Cash Flows, Income Statement and Balance Sheet
+ How to handle Circular References in financial modeling
6. Establish scenarios and sensivity Analysis
+ Use of data for sensitivity analysis
+ Importance of scenario manager
+ Identifying  suitable  scenarios  and sensitivities and their
impact on financial analysis
+ Managing key pitfalls in the analysis
7. How to analyse the  data
+ Data sorting and Data filtering
+ Creating,  customizing  Pivots  Tables, advanced pivot tables
and analysis
+ V-LOOK UP and H-LOOK UP, Macros, Goal Seek and other analysis
+ Solver function and its uses
8. How to apply different Financial Analysis techniques model
+ Importance  of  PV,  NPV  and IRR and their link with company
valuation
+ How to analysis various capital budgeting decisions
+ Calculation of various ratios
+ Calculate  the weighted average cost of capital using capital
asset pricing model (CAPM)
+ Calculation of WACC
+ Investment and exit analysis – equity IRR, project IRR etc
9. Approaches to apply different valuation tecniques  in the model
+ Different   methods   of   valuation   –   DCF,  Multiples,
comparables etc
+ Discounted  Cash Flow valuation and different multiples based
methodologies
+ Importance of terminal valuation
+ 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  adjustments  to  the publicly available
versions of company valuation

Â

PROFIL PEMBICARAÂ TRAINING FINANCIAL MODELLING WITH EXCEL

TEAM TRAINER

JADWAL TRAINING TAHUN 2026

03 – 04 Januari 2026 | 16 – 17 Januari 2026

06 – 07 Februari 2026 | 20 – 21 Februari 2026

05 – 06 Maret 2026 | 19 – 20 Maret 2026

03 – 04 April 2026 | 23 – 24 April 2026

07 – 08 Mei 2026 | 21 – 22 Mei 2026

05 – 06 Juni 2026 | 25 – 26 Juni 2026

09 – 10 Juli 2026 | 23 – 24 Juli 2026

06 – 07 Agustus 2026 | 20 – 21 Agustus 2026

04 – 05 September 2026 | 18 – 19 September 2026

08 – 09 Oktober 2026 | 22 – 23 Oktober 2026

06 – 07 November 2026 | 26 – 27 November 2026

04 – 05 Desember 2026 | 18 – 19 Desember 2026

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