FINANCIAL MODELLING WITH EXCEL – Pasti Jalan

admin4

5 years ago

Financial Modelling

FINANCIAL MODELLING WITH EXCEL

Jadwal Training 2019 Selanjutnya …

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

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
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
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
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
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
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
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
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
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 & Tempat Pelaksanaan

Tanggal 25-27April 2019
Tanggal 6-7 Mei 2019
Tanggal 17-18 Juni 2019
Tanggal 8-9 Juli 2019
Tanggal 5-6 Agustus 2019
Tanggal 5-6 September 2019
Tanggal 3-4 Oktober 2019
Tanggal 11-12 November 2019
Tanggal 5-6 Desember 2019

INVESTASI TRAINING FINANCIAL MODELLING WITH EXCEL

Hotel Ibis / Dreamtel Jakarta Rp 4.500.000,-
Bandung Rp 5.000.000,-
Yogyakarta / Surabaya / Semarang Rp 6.000.000,-
Malang Rp 6.500.000,-
Bali Rp 7.000.000,-

Investasi sudah termasuk :

Sertifikat keikutsertaan.
Coffe Break 2X dan Lunch.
Souvenirs dan Seminar Kits.
Seminar Bag.
Modul
- Discount 10% apabila pendaftaran group minimal 5 orang dari perusahaan yang sama (untuk satu pelatihan dan waktu yang sama).
- Pelaksanaan training akan diselenggarakan apabila telah mencapai quota peserta 4-5 orang.
- Konfirmasi pelaksanaan training akan dilakukan 3 (tiga hari sebelum tanggal pelaksanaan).

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training

INFORMATION OPTIONS
Judul Training(required)
Tanggal Training
Select a message type (required)
PERSONAL DATA
Your Name(required)
Job Title(required)
Company(required)
Company Address
Email(valid email required)
Mobile Phone(required)
Office Phone(required)
Extention No.
Facsimile (Fax)
Website
PRE REGISTRATION DATA (Tidak Mengikat)
Penanggung Jawab Training di Perusahaan
Email
Office Phone+Ext atau No. Handphone
Jumlah Peserta(required)
Nama-nama peserta
Payment Method
MESSAGE FOR TRAINING PROVIDER
Pesan untuk penyelenggara Training
CC this registration / message to me

cforms contact form by delicious:days