Financial Modeling for Corporate Budgeting with Sensitivity and Scenario Analysis Using Excel, VBA and Xcelcius

DESKRIPSI

Tujuan :

Memperoleh pemahaman dan ketrampilan:

1. Dasar-dasar corporate budgeting
2. Pengetahuan prinsip dasar financial modeling yang diterapkan pada budget model
3. Membangun budget model secara bulanan

Syllabus :

• Model Layout, Design Principles & Overview of Corporate Budget Model
• Modeling Assumption module
• Modeling Operating Budget ? Sales & Collections module
• Modeling Operating Budget ? Cost of Goods Sold, Inventory & Purchase module
• Modeling Operating Budget ? Operating Expenses module
• Modeling Operating Budget ? Income Statement module
• Modeling Financial Budget ? Capital Budget & Cash Budget module
• Modeling Financial Budget ? Balance Sheet module
• Modeling Cash Flow Statement module
• Modeling Free Cash Flow module
• Modeling Contribution Margin module
• Modeling Variance Analysis Chart
• Modeling Dynamic Chart

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

Course Leader :

Irwin Ibrahim

More...