FINANCIAL MODELING FOR PROJECT – Available Online

Financial Modelling perlu diikuti bagi para staf profesional, manager dan leader di perusahaan 

JADWAL TRAINING ONLINE

Online Training | 26 – 27 Oktober 2020 | Rp 2.000.000,- 
Online Training | 11 – 12 November 2020 | Rp 2.000.000,-

Jadwal Training Online Selanjutnya …

JADWAL TRAINING KELAS

Yogyakarta | 03 – 05 November 2020 | Rp 6.000.000 per peserta
Yogyakarta | 01 – 02 Desember 2020 | Rp 6.000.000 per peserta

 

DESKRIPSI TRAINING FINANCIAL MODELING FOR PROJECT

Financial model telah digunakan secara luas dalam berbagai kegiatan bisnis perusahaan dan telah digunakan untuk berbagai keperluan analisa keuangan. Berbagai jenis financial model antara lain, Risk analysis models, Trading models dan lain-lain. Namun jenis financial model yang umum digunakan adalah financial statements for project model. Pelatihan financial modeling yang baik adalah suatu keharusan bagi mereka di bidang bisnis development dan yang berkaitan dengan keputusan keuangan. Bagi para staff professional, manager dan leader di perusahaan, pemahaman yang memadai pada  Financial Model menjadi sangat penting untuk ditekankan.

 

TUJUAN TRAINING FINANCIAL MODELING FOR PROJECT

Setelah mengikuti pelatihan ini, diharapkan peserta dapat:

• Memahami berbagai financial modeling for Project terkini yang banyak digunakan oleh perusahaan
• Mengaplikasikan dalam beberapa kasus financial modeling

 

PESERTA TRAINING FINANCIAL MODELING FOR PROJECT

Pemahaman yang memadai pada Financial Model sangat penting untuk ditekankan dan diikuti oleh para staff professional, manager dan leader di perusahaan.

 

MATERI TRAINING FINANCIAL MODELING FOR PROJECT

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
   1. uses of data for sensitivity analysis
   2. Importance of scenario manager
   3. Identifying suitable scenarios and sensitivity and their impact on financial analysis
   4. 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
10. Different method valuation – DCF, Multiple, comparable
11. Discounted Cash flow valuation and different multiples based methodologies
12. Importance of terminal valuation
13. Current industry practices followed in company valuation using single or multiple methodologies
14. How to factor size and illiquidity discount in the final valuation
15. Incorporate various adjustment to the publicly available versions of company valuation

 

METODE TRAINING

• Presentasi
• Diskusi Interaktif
• Studi Kasus
• Simulasi
• Evaluasi

 

INSTRUKTUR TRAINING

• Yunita Anggarini, SE., M.Si., Dr (cand)
• Achmad Tjahjono, MM, Ak.

Trainer dan Pakar di bidang analisis kelayakan usaha dan studi kelayakan investasi. Pengajar dan konsultan manajemen keuangan di berbagai perusahaan.

 

JADWAL TRAINING ONLINE 2020

JADWAL TRAINING ONLINE

• Batch 4 : 26 – 27 Oktober 2020
• Batch 5 : 11 – 12 November 2020
• Batch 6 : 25 – 26 November 2020
• Batch 7 : 09 – 10 Desember 2020
• Batch 8 : 28 – 29 Desember 2020

PENYELENGGARAAN DIBAGI 2 SESI PER HARI

• SESI 1: Pukul 09.00 – 11.30 WIB
• SESI 2: Pukul 13.00 – 15.30 WIB

VIA APLIKASI ZOOM

* Peserta diwajibkan menginstall aplikasi zoom di laptop
* Peserta akan mendapatkan softfile modul format pdf

 

BIAYA DAN FASILITAS TRAINING ONLINE

* Publish Rate    : Rp 2.000.000,- / participant
* Special Rate    : Rp 1.850.000,- / participant (untuk registrasi minimal 5 peserta dari 1 perusahaan)

INCLUDE:

• Qualified Instructor
• Softfile modul/materi format pdf
• Sertifikat (dikirimkan via jasa pengiriman)

EXCLUDE:

• Pajak (VAT/PPN)

 

JADWAL TRAINING KELAS 2020

JADWAL TRAINING 2020

Yogyakarta: Cavinton Hotel Yogyakarta; Neo + Awana Hotel Yogyakarta; Pesonna Malioboro Hotel Yogyakarta
Surabaya: Hotel Neo Gubeng Surabaya; Hotel Santika Pandegiling Surabaya
Malang: Ibis Styles Malang Hotel
Jakarta: Yello Hotel Manggarai Jakarta; Dreamtel Jakarta Hotel
Bandung: Serela Cihampelas Hotel Bandung; Grand Setiabudi Hotel Bandung; Grand Tebu Hotel Bandung
Bali: Ibis Bali Kuta Hotel; Hotel Neo + Kuta Legian Bali

In House Training : Depend on request

 

TUITION FEE TRAINING

Yogyakarta:

• Publish Rate       : Rp 6.000.000,- / participant
• Special Rate        : Rp 5.600.000,- / participant (min 4 participants from the same company)

Bandung / Jakarta / Surabaya / Malang:

• Publish Rate       : Rp 7.000.000,- / participant

Bali:

• Publish Rate       : Rp 8.000.000,- / participant

 

FASILITAS TRAINING

INCLUDE:

• Meeting Room at hotel, Coffe Break, Lunch
• Module (hard & soft copy/flashdish)
• Training Kit, Souvenir, Sertifikat
• Airport pick up services
• Transportation during training

EXCLUDE:

• Penginapan peserta training
• Pajak (Ppn 10 %)

 

FINANCIAL MODELING FOR PROJECT

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training

1. INFORMATION OPTIONS
2. Judul Training(required)
3. Tanggal Training
4. Select a message type Registration Offering Letter (Permintaan Proposal Penawaran) Next Schedule Information (Jadwal selanjutnya) More Information (Informasi tambahan) Others (lain-lain) (required)
5. PERSONAL DATA
6. Your Name(required)
7. Job Title(required)
8. Company(required)
9. Company Address
10. Email(valid email required)
11. Mobile Phone(required)
12. Office Phone(required)
13. Extention No.
14. Facsimile (Fax)
15. Website
16. PRE REGISTRATION DATA (Tidak Mengikat)
17. Penanggung Jawab Training di Perusahaan
18. Email
19. Office Phone+Ext atau No. Handphone
20. Jumlah Peserta(required)
21. Nama-nama peserta
22. Payment Method Bank Transfers Submitting an Invoice Cheque or Cash on arrival ( If Possible)
23. MESSAGE FOR TRAINING PROVIDER
24. Pesan untuk penyelenggara Training
25. CC this registration / message to me
26. Isikan angka/huruf pada gambar

 

cforms contact form by delicious:days