Financial Modeling

Financial Modeling

★★★★★

Instruktur Pelatihan

Kelas ini hanya dijalankan bila minimal
ada 2 peserta yang mendaftar.
9-10 Oktober 2024 2 Hari
09.00-16.00 WIB
Tempat Pelatihan
Hotel Aryaduta Semanggi*
Hotel Best Western Premier*
Hotel Cosmo Amaroossa*
Jakarta

*Tempat masih tentative

Rp 5.650.000

Harga belum termasuk pajak

B O O K I N G*

*Untuk mendapatkan form pendaftaran & brosur.

Financial modeling telah digunakan secara luas di kalangan profesi keuangan. Ada banyak jenis financial model, namun yang paling umum digunakan adalah financial statements for project model. 

Pelatihan ini akan berfokus pada financial statements for project model. Cocok diikuti oleh mereka yang bergerak dalam bidang bisnis development. Selain itu, bisa juga diikuti oleh para manajer profesional dan pemimpin perusahaan yang ingin memahami financial modeling.

Apa yang akan Anda dapatkan dalam pelatihan ini?

  • Memahami berbagai financial modeling yang banyak digunakan.
  • Mengaplikasikan dalam beberapa kasus financial modeling.

Outline Materi

  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
    • 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
  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
    • Different method valuation – DCF, Multiple, comparable
    • 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 adjustment to the publicly available versions of company valuation

Metode Penyampaian

  • Program pelatihan berlangsung selama 2 hari, total 12 jam.
  • Waktu pembelajaran pukul 09.00-16.00 WIB, setiap harinya.
  • Materi disampaikan dengan pemaparan, latihan dan diskusi.
  • Diperkaya dengan studi kasus, simulasi, dll.

Fasilitas & Kelengkapan Pelatihan

  • Modul pelatihan dan seminar kit.
  • Sertifikat pelatihan.
  • Lunch & coffee break.
  • Tidak termasuk penginapan dan transportasi.

Membutuhkan in house training?
Pelatihan untuk lebih dari 10 peserta, silakan isi permintaan proposal in house.

Financial Modeling

Kelas disampaikan melalui platform video conference seperti Zoom, Microsoft Teams, Google Meet, dll.

Financial Modeling

★★★★★

Instruktur Pelatihan

Kelas ini akan dijalankan meskipun hanya
ada 1 peserta yang mendaftar.
2-3 Oktober 2024 2 Hari
09.00-15.00 WIB
Tempat Pelatihan

Online by Zoom

Rp 3.950.000

*Harga belum termasuk pajak

B O O K I N G*

*Untuk mendapatkan form pendaftaran & brosur.

Financial modeling telah digunakan secara luas di kalangan profesi keuangan. Ada banyak jenis financial model, namun yang paling umum digunakan adalah financial statements for project model. 

Pelatihan ini akan berfokus pada financial statements for project model. Cocok diikuti oleh mereka yang bergerak dalam bidang bisnis development. Selain itu, bisa juga diikuti oleh para manajer profesional dan pemimpin perusahaan yang ingin memahami financial modeling.

Apa yang akan Anda dapatkan dalam pelatihan ini?

  • Memahami berbagai financial modeling yang banyak digunakan.
  • Mengaplikasikan dalam beberapa kasus financial modeling.

Outline Materi

  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
    • 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
  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
    • Different method valuation – DCF, Multiple, comparable
    • 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 adjustment to the publicly available versions of company valuation

Metode Penyampaian

  • Pembelajaran dengan metode video conference by Zoom.
  • Program berlangsung selama 2 hari, total durasi 10 jam.
  • Waktu pembelajaran pukul 09.00-15.00 WIB.
  • Materi disampaikan dengan pemaparan, tanya jawab, dan latihan.

Fasilitas Training

  • Modul pelatihan dalam bentuk softcopy.
  • Sertifikat pelatihan diberikan dalam bentuk e-certificate.
  • Bila membutuhkan sertifikat cetak, akan dikirimkan lewat jasa kurir.
  • Souvenir, selama persediaan masih ada.

Ketentuan Kelas Online

Apa yang harus dilakukan peserta?

  • Menyiapkan komputer yang mendukung kamera dan mikrofon.
  • Menyiapkan koneksi internet yang stabil.
  • Menyiapkan alat tulis untuk mencatat.
  • Tidak mematikan kamera selama pembelajaran berlangsung, kecuali atas arahan fasilitator.

Bagaimana cara mengikutinya?

  • Proses pembelajaran menggunakan aplikasi video konferensi seperti Zoom, Google Meet, Microsoft Team, dll.
  • Penyelenggara akan memberikan tautan undangan kepada peserta terdaftar.
  • Lihat cara menggunakan aplikasi video konferensi di sini.

Membutuhkan in house training?
Pelatihan untuk lebih dari 10 peserta, silakan isi permintaan proposal in house.