Financial Modeling Fundamentals with Sensitivity and Scenario Analysis and Xcelsius

DESKRIPSI

Tujuan :

1. Memperoleh pemahaman dan ketrampilan mengenai pengetahuan dasar membangun sebuah financial model.
2. Pelatihan dirancang secara step-by-step membangun model industri manufaktur yang selalu dijadikan model dasar untuk menyampaikan pengetahuan manajemen keuangan.
3. Peserta akan berlatih membangun financial model sejak dari lembar kosong, agar peserta menjadi percaya diri untuk membangun financial model dari industri apapun sesuai tempatnya bekerja.

Syllabus :

• Introduction to financial modeling
• Building mini financial statement:
  • Building mini balance sheet
  • Balancing the balance sheet
  • Building mini income statement
  • Introduction to Visual Basic for Application (VBA)
    • Activating and using Visual Basic Editor
    • Using VBA codes for automation
    • What-if analysis techniques
      • Using scenario manager & scenario buttons
      • Using data table
        • Working with one-variable data table
        • Working with two-variable data table
        • Building complete basic financial model
          • Building historical sheet
          • Building assumption sheet
          • Earning & cost assumptions
          • Working capital assumptions
          • Capital expenditure assumptions
          • Short term loan assumptions
          • Long term loan assumptions
          • Building complete basic financial model
            • Building Income Statement
            • Building balance sheet
            • Building cash flow
            • Scenario simulations using VBA
              

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...