Perlu pelatihan untuk anda atau perusahaan anda?

Cari Disini. Atau hubungi kami melalui SMS/CALL/WA: 0819.9793.1188

Training Financial Modeling for Corporate Budgeting, Sensitivity & Scenario Analysis and Consolidation

Schedule

26 – 27 July 2016

15 – 16 September 2016

Venue:
Hotel Intercontinental Mid Plaza Jakarta
Jl. Jendral Sudirman Kav. 10-11, Jakarta 10220

Objective:
In this training you will be guided step by step to create a budget model as a module by module and create variance analysis, dynamic charts, sensitivity and scenario analysis tools, and also learning techniques that facilitate the financial company consolidation.

Syllabus:

  1. Introduction to Financial Modeling
    • Financial Modelling Best Practice
    • Using Mini Financial Statements for Easier Comprehension
    • Incorporating Sensitivity & Scenario Analysis Modules into the Mini Financial Statements
  2. Financial Modelling for Corporate Budgeting
    • Modelling Operating Budget – Sales & Collections – COGS, Inventory, Purchases – Operating Expenses
    • Modeling Financial Budget – Capital Budget – Borrowings and Cash Budget
    • Modeling Financial Statements and Statement of Cash Flows
    • Modeling Financial Ratios, Contribution Margin and Variance Analysis
    • Building a Dynamic Chart
    • Building a Sensitivity & Scenario Analysis Tools
  3. Financial Modelling for Consolidation
    • Modeling Techniques for Consolidation
    • Modeling Cost Method, Equity Method and Consolidation in a mini financial model
    • Modeling Cost Method, Equity Method and Consolidation using fully developed financial models

Who should attend?
Finance & Accounting Staff and Manager, Strategic & Corporate Planner, Financial Controller, Financial & Business Analysts, Risk Manager, Credit Analyst & Reviewer, Investment Analysis, Equity Analyst, Investment Banker, Corporate Finance Officer, Corporate Planner, Project Analyst, Treasury Manager, General Manager, Corporate & Government Officer, Business Owner, Business Advisor or anyone who has strong passion for Financial Modeling.

Trainer:
Mariawati Lim

Maria has over 16 year’s experiences in the field of financial advisory services in one of the big four. As a financial model trainer, Maria has been providing training, both public and in- house to more than 1,500 professionals from various companies.

Noted:

  • Please bring your own laptop with Microsoft Excel 2007 or 2010 installed
  • This training is paperless so you will receive full course notes in a USB full of practical templates, exercises & solutions, reference guides, add-ins and other useful tools.
  • Training will be delivered in Bahasa Indonesia
  • You will receive a Certificate of Completion, a recognition of your accomplishment, skills & knowledge learned after completion of this course
  • It is assumed that participants know how to navigate confidently in Excel, create and use simple formulas

Registration Fee:
Regular IDR 6,500,000
Get discount 10% for register 2 person