Financial Modeling for Company Valuation Using Excel and Xcelsius with Sensitivity and Scenario Analysis

DESKRIPSI

Valuation model dibangun dengan melanjutkan financial & credit analysis model, kemudian dilanjutkan dengan membangun valuation model, sehingga peserta memiliki pemahaman dan kemampuan untuk:

1. Membangun discounted cash flow analysis model,
2. Comparable company analysis model,
3. Membuat rangkuman atas nilai perusahaan yang dihasilkan.

Syllabus :

• Introduction to Company Valuation
• Comparable Company Analysis
• Discounted Cash Flow Analysis
• Building Comparable Company Analysis Model
• Comparable Company Analysis data input
• Modeling diluted shares outstanding
• Modeling EBITDA multiple
• Modeling P/E Multiple
• Building Discounted Cash Flow Analysis Model
• Projecting long term forward & terminal year
• Modeling diluted shares outstanding
• Modeling weighted average cost of capital
• Modeling present value of free cash flow
• Modeling terminal value
• Modeling intrinsic (?fair?) value

Siapakah yang harus hadir :

• CFOs
• Directors / Managers of Corporate Finance
• Directors / Managers of Finance & Accounting
• Credit analysts
• Financial Analysts
• Treasury Personnel
• Any other financial practitioners

Waktu :

• 2 hari kerja, 09.00 am ? 05.00 pm, diselingi 2 kali coffee break dan 1 kali istirahat makan siang

Course Leader :

Irwin Ibrahim

More...