FINANCIAL MODELING USING EXCEL & VBA – FROM ZERO TO MASTER
Tanggal
14-15 April 2011
Jam Pelaksanaan
09.00 – 17.00 WIB
Tempat
Four Seasons Hotel
Jl. H.R. Rasuna Said,
Jakarta Selatan 12920
Pembicara / Fasilitator
Tri Gunawan Bayu Aji SE, Ak MM
is a practitioner in Management Accounting, Business Planning and Budgeting with 10 years 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.
Harga
Rp.4,950,000,.
termasuk materi hand-out, 2 x coffee break, makan siang dan sertifikat
Potongan 10% untuk peserta lebih dari 1 orang
Materi
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, and 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.
Attend this two days intensive training course and enhance your modeling skills by learning:
- How to design a model to suit your purpose valuation modeling using conventional and new approaches.
- How to identify and control key sensitivity through advanced spreadsheet simulation.
- How to design a model to maximize flexibility of key variables.
- Easy review other people models.
You will need to put financial modeling into practice. This will be achieved by hands-on training and guidance from your training leader who will combine both real life and simulated exercise, using excel as a base for your spreadsheet. The course starts by focusing on the advance use of excel in Modeling. These newly gained skills will be applied in the construction of basic company valuation models, before the incorporation of risk assessment, scenarios, optimization and forecasting into the models. With the help of the course director and a proven step-by-step approach, delegates will then construct models of different types, delegates will then construct models of different types. Delegate will leave this intensive two-days course the ability to effectively apply modeling techniques in Excel in a wide range of practical techniques in Excel in a wide range of practical scenarios.
Workshop outline:
Day One
Principle 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
- Basic Understanding
- Tools ( ROI, Payback period, Net Present Value and IRR)
Performance Management
- Financial Ratio understanding
- Profitability Ratio
- Liquidity Ratio
- Operating Ratio
- Modeling
Advance Financial Modeling
- 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 two
Advanced Financial Modeling…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
Workshop Simulation and Group Discussion, Building inancial 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 build sensitivity, scenario and Simulation into your model
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 modeling
- Use advanced features to link into your model to a database (local or web database)
- Build Waterfall Chart
- Forecasting
- Linear regression, Moving Average and seasonality
- Building Function using Visual Basic Application for Excel
- Monte Carlo analysis
- Reporting and Dashboard
- And other advanced tip and trick
Financial Modeling Sample:
- Budgeting
- Financial Analysis & Dashboard
- Investment Analysis
- Business Valuation
Wajib diikuti oleh
- Analyst and Finance Manager
- Strategic Planner and General Managers
- Project Financiers and Lenders
- Budget Analyst and Financial Planners
- Engineer and System Managers
- Risk Manager
- Corporate Finance and M&A Professionals
