Financial Modeling From zero to a Master
FOUR SEASONS HOTEL | 14 – 15 April 2011 | Rp 4.950.000,-
Take your analytical skill to the next level….and design world class models…in just 2 days
Financial Modeling techniques allow business users to improve the reliability, quality and timeliness of their decision making. Modeling techniques are now used in many different areas, such as capital budgeting, investment appraisal, business valuation, financial analysis and forecasting. With a model-by-model approach, this course will guide you through the various techniques, providing you with a comprehensive understanding of Modeling, covering such issues as scenario analysis, forecasting and Solver
analysis, as well as how each technique can practically be applied through the use of Excel, VBA and other tools.
Who should attend:
- Finance Managers & Supervisors
- Business & Finance Analysts
- Strategic Planners
- Project Financiers & Lenders
- Budget Analysts and Financial Planners
- Corporate Finance Managers
- Management Accountant
- Etc…
Benefits from attending this course:
- Learn new ways to improve efficiencies in your financial modeling processes by gaining valuable skills
- Discover a range of sophisticated techniques that will improve the usability and reliability of your financial models
- Learn how to integrate & align your financial models with business strategy
- Learn how to properly incorporate imprecise data and allow for uncertainties in model assumptions and variables
- See how to properly utilize spreadsheet modeling best practices into action to create better financial models
- Learn to optimize scenarios, sensitivity and risk analysis into financial modeling in the effective way
Day 1:
Principles of Financial Modeling
- Basic Design
- Objective of Financial Modeling
- User Interface
- Key Variables and Rules
- Layout of good financial modeling
- Management Reporting
- Testing
- Protection and Documentation
Excel Fundamental
- Learn how to use function If
- offset, match and index
- Linking data
- Formatting
- Data Validation Built simple macro using recording
- Using range names
Capital Budgeting
- The NPV rule for judging investments and projects
- The IRR rule for judging investments
- NPV or IRR, which to use
Performance Management
- Financial Ratio understanding
- Profitability Ratio
- Liquidity Ratio
- Operating Ratio
- Modeling
Advanced Financial Modeling-Workshop
- Formatting and Layout
- Build intuitive model: Font Formatting, Color and Input
- Advanced Menu: Combo Box, Scroll Bar, List Box and other Menu
- Building summary and documentation in your model
- Using Comment and Data Validation
- Build Graph, creating interactive graph
Day 2
Advanced Financial Modeling Workshop…continue Build Dynamic Chart using advanced menu, and use menu as inputs
- Put Sensitivity on your financial modeling
- Build Sensitivity Chart
- Build Scenario using Advanced Menu and VBA to automatically query
- Build Goalseek using Advanced Menu and VBA to automatically target
- Build Interactive Chart
- Using Solver and build VBA for Scenario
- Create dynamic range using Names
Group Discussion, Building Financial Modeling
- You will learn how to add combo box, list box and other menu
- You will build a simple menu
- You will add input/ output to your model by using menu, validation and comment
- You will learn how to use macro and vba to automatically input or result
- You will learn how to create, manage, and present multiple scenarios and perform sensitivity analysis
Tips and Tricks in building a good and interactive financial modeling
- Using Pivot Table
- Advanced Data Validation
- Using YTD function
- Building Advanced Interactive Chart
- Using sumproduct, sumif and building mega formula into your financial modelingUse advanced features to link into your
- model to a database (local or web database)
- Xcelsius Dashboard Model automation using controls to enhance usability
- Build Waterfall Chart
- Forecasting
- Linear regression, Moving Average and seasonality
- Building Function using Visual Basic Application for Excel
- Monte Carlo analysis
- Create Add-in
- Reporting and Dashboard
Your Presenter
Tri Gunawan Bayu Aji SE Ak, MM, CMA
Bayu is a practitioner in Corporate Finance, Management Accounting, Business Planning and Budgeting with years of solid experience in various industries such as manufacturing, distribution, Financial Institution, Shipping Line and Port Operator. He graduated from Accounting Department of UNPAD and obtain MM Degree from LPPM Jakarta. He has extensive experiences in giving public workshop; in-house training and lectures specialized in Financial Analysis and Financial Modeling. His team members are also practitioners from the biggest Beverages Company and Telecommunication Company, and having many experience in giving Financial Modeling Workshop. He and his team have already trained more than 200 professionals from many organization, with positive feedback and result.
Registration Fee:
- Regular :Rp 4.950.000,-
- Before March 31, 2011 :Rp. 4.500.000,-
Date and Venue:
- 14 – 15 April 2011
- FOUR SEASONS HOTEL Jalan H.R. Rasuna Said, Jakarta 12920
Course materials
- You receive full course notes,
- plus a CD full of practical templates,
- exercises & solutions, reference guides,
- addins and other useful tools that can be used to efficiently build effective and robust financial models.