TRAINING FINANCIAL MODELING FUNDAMENTALS

Table of Contents Toggle TRAINING ANALISIS KEUANGAN

TRAINING TEKNIK OPTIMALISASI KEUANGAN training Building a Core Financial di jakarta

Objective:
In this training you will be guided step by step to create a financial
model  as a module by module and to create dynamic charts, sensitivity
and  scenario  analysis tools, and also learn techniques in optimizing
corporate finance.

Syllabus:
1. Introduction to Financial Modelling
+ Mini Financial Statements for easier comprehension
+ Incorporating  Sensitivity  &  Scenario Analysis Modules into
the Mini Financial Statements
2. Building a Core Financial Model
+ Building   Input   Sheets:   Historical   Data  &  Projection
Assumptions
+ Building  Working  Sheets:  Sales,  COGS, Operating Expenses,
Capital Expenditure, Borrowings, Deferred Tax, Equity
+ Building Output Sheets: Balance Sheet, Income Statement, Cash
Flows, Financial Ratios
3. Building a Dynamic Chart
+ Developing a VBA-driven Dashboard for Dynamic Chart
4. Building a Sensitivity & Scenario Analysis Tools
+ Developing  a VBA-driven Dashboard for Sensitivity & Scenario
analysis
5. Optimization

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.