TRAINING DASHBOARD FINANCIAL MODELLING WITH EXCEL

Tempat dan Biaya

Online Training (Reguler)
Rp 3.500.000
Jakarta
Rp 5.200.000,-
Bandung
Rp 5.750.000,-
Yogyakarta
Rp 6.000.000
Kota lain
Rp 7.000.000

Jadwal

18
- 19 Apr 2024

Akan Datang

13
- 14 May 2024

Akan Datang

10
- 11 Jun 2024

Akan Datang

22
- 23 Jul 2024

Akan Datang

12
- 13 Aug 2024

Akan Datang

09
- 10 Sep 2024

Akan Datang

10
- 11 Oct 2024

Akan Datang

11
- 12 Nov 2024

Akan Datang

09
- 10 Dec 2024

Akan Datang

INVESTASI ONLINE TRAINING (2 Days)

Online Training (Reguler)

Rp 3.500.000,-/ orang

Online Training (Private)

Dapatkan harga khusus hubungi kami

 

PELAKSANAAN ONLINE TRAINING :

09.00-15.00 WIB

 

INVESTASI TERMASUK  : 

  1. Soft Copy Modul Training (Email)
  2. Modul Training (Ekspedisi)
  3. Sertifikat Kehadiran (Ekspedisi)
  4. Qualified Instructor

 

TANGGAL PELAKSANAAN :

11-12 Januari 2024

12-13 Februari 2024

14-15 Maret 2024

18-19 April 2024

13-14 Mei 2024

10-11 Juni 2024

22-23 Juli 2024

12-13 Agustus 2024

9-10 September 2024

10-11 Oktober 2024

11-12 November 2024

9-10 Desember 2024

*Mohon memastikan kembali kepada kami untuk tanggal yang dipilih

 

OVERVIEW

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

  1. Analis / profesional keuangan
  2. Manajer menengah ke atas dari berbagai industri
  3. Semua profesional yang ingin berurusan atau saat ini berurusan dengan pemodelan keuangan di perusahaan mereka
  4. Konsultan, penasihat, dan profesional lain yang ingin meningkatkan keterampilan modeling mereka

 

OUTLINE

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

 

TRAINER & FACILITATOR :

Tim Trainer Arcarta Consultant

 

INVESTASI TRAINING  

(Jakarta ):

Rp 5.200.000,-/ orang

(Bandung):

Rp. 5.750.000,-/ orang

(Yogyakarta):

Rp. 6.000.000,-/ orang

 

INVESTASI TRAINING (LUAR KOTA):

Rp. 7.000.000,-/ orang (Pengiriman 1-5 peserta)

 

INVESTASI TERMASUK  : 

  1. Modul Training
  2. Sertifikat Kehadiran
  3. Seminar Bag
  4. Seminar Kits
  5. Training room with full AC facilities and multimedia
  6. 2X Cofee Break dan Lunch
  7. Qualified Instructor

PELAKSANAAN TRAINING :

09.00 – 16.00 WIB

 

TEMPAT : 

Hotel Ibis Group, hotel lainnya yang akan di konfirmasi kemudian

 

REQUEST FOR TRAINING VENUE: 

Jakarta, Bandung, Yogyakarta, Bali, Semarang, Surabaya 

 

In House Training Depend on request

 

INFORMASI

Registrasi, hubungi :

Arcarta Consultant 

TELEPON : +6221-889-68569 

HP/ WA : 

+62-812-2483-2565 (Citra)

Email: 

[email protected]

[email protected]

Galleries Training

No results found.

error: Content is protected !!