Training Financial Modeling for Corporate Budgeting, Sensitivity & Scenario Analysis and Consolidation
Hotel Intercontinental Mid Plaza Jakarta
Jl. Jendral Sudirman Kav. 10-11, Jakarta 10220
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.
- 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
- 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
- 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.
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.
- 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.