Training Dashboard Financial Modelling With Excel

Training Dashboard Financial Modelling With Excel

Pada pelatihan 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 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

OUTLINE

• 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

• 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

• 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

• Equity and debt fund raising and repayment structure
• Debt waterfall mechanism
• Checking debt repayment ratios, leverage and covenants

• Industry practices on handling exceptions
• Integration of Cash Flows, Income Statement and Balance Sheet
• How to handle Circular References in financial modeling

• 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

• 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

• 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

• 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

INVESTASI :

Training Online, Two Days Online Training :

1. Via Aplikasi Zoom : Rp 3.500.000,- (Tiga Juta Lima Ratus Ribu Rupiah)

Training Offline, Two Days Offline Training :

1. Jakarta : Rp 5.000.000,- (Lima Juta Rupiah)
2. Bandung : Rp 6.000.000,- (Enam Juta Rupiah)

Ket : Hotel Ibis Arcadia/Hotel Dreamtel / Hotel Hi / Hotel Blue Sky / Hotel Erian Jakarta

FASILITAS :

Training Online

1. Soft Copy Materi (Dikirim By Email)
2. Seminar Kits (ATK) & Sertifikat Kehadiran (Dikirim Via JNE)

Training Offline

1. Seminar Kits ( Handcopy Materi + ATK + Souvenir)
2. Makan Siang
3. Coffee Break
4. Sertifikat

NEXT SCHEDULE:

1. Tanggal 24-25 Januari 2023
2. Tanggal 20-21 Februari 2023
3. Tanggal 20-21 Maret 2023
4. Tanggal 19-20 April 2023
5. Tanggal 22-23 Mei 2023
6. Tanggal 19-20 Juni 2023
7. Tanggal 20-21 Juli 2023
8. Tanggal 23-24 Agusutus 2023
9. Tanggal 20-21 September 2023
10. Tanggal 18-19 Oktober 2023
11. Tanggal 22-23 November 2023
12. Tanggal 20-21 Desember 2023

*Jadwal Training masih tentative running apabila telah mencapai quota