Home  »  Akuntansi • Desember 2024 • Finance, Accounting, Tax, Treasury, Audit & Risk Management • Yogyakarta   »   Certified Financial Modeler (CFM)

Certified Financial Modeler (CFM)

Pendahuluan

Pemodelan dan analisis keuangan adalah salah satu keterampilan yang paling dihormati di dunia bisnis dan pasar kerja dari bisnis Bank, Akuntansi, Investasi dan Asuransi. Pengambilan keputusan bergantung pada keputusan analitis yang kompleks setiap hari. Program Certified Financial Modeler (CFM) memberi pelajar ruang untuk mengembangkan atau maju dalam karir pemodelan dan analisis keuangan.

Manfaat

Beberapa manfaat dari sertifikasi CFM adalah:

• Memvalidasi tingkat keterampilan yang lebih tinggi dalam pemodelan keuangan
• Menjadi bagian dari komunitas modeler global yang elit dan kolaboratif
• Mempercepat atau mentransformasi karier

Suitable For:

Certified Financial Modeler (CFM) is targeted for professionals working in the following fields:

• Finance and accounting departments
• Public or private organization
• Investment banking
• Asset and portfolio management
• Commercial banking

Outline

1. Advanced excel functions
2. Business reporting andfinancial analysis
3. Fundamentals of financial modelling
4. Financial modelling best practices
5. Understanding workbook, worksheet and cell formatting for model
6. Preparation of schedules for a financial model
7. Financial statements projection model
8. Discounted cash flow model
9. Scenarios management andanalysis
10. Sensitivity analysis
11. Project appraisal calculations
12. Model auditing techniques: NPV, IRR, profitability index and payback period
13. Dashboard reporting in excel with power query and power pivot

Training Method

Pre Test

Presentation

Discussion

Case Study

Post Test

Evaluation

Facilities

Training Kit

Handout

Certificate

1x Lunch & 2x Coffee Break

Souvenir