Subject Area Weighting
Financial modeling is the key FP&A tool that is needed for business valuations, M&A or any other complex planning & forecasting scenario.
The importance of business valuation as a specialized skill is growing rapidly. More and more accountants and finance professionals are expected to hold expert knowledge in business valuations to support increased mergers and acquisitions activity.
This high-powered training program has been designed and developed for modern day accountants and finance professionals for qualitatively upgrading their financial modeling skills and ability to apply those skills to business valuation scenarios.
The programs comprises of Eight workshops, each running from 10:00 am to 5:00 pm. The workshops are usually scheduled on eight consecutive Saturdays or Sundays.
The program delivers the most comprehensive and complete foundational training on how to build and use financial models to value private business enterprises. The attendees will take a deep dive into financial modeling techniques and best practices and will gain an advanced skill level whilst working on several valuation and M&A case studies.
What You Will Cover
Learning excel as a financial analyst
Power Excel crash course. Learn advanced Excel formulas, setup and functions for complex financial analysis, as well as financial modeling best practices.
Fundamentals of financial modeling
Building a 3-Statement Financial Model. Step-by-step course to learn to build a 3-statement financial model from scratch.
Financial modeling for business valuation
Performing Business Valuation Modeling. Learn to create a financial model to value a business based on Comps, Precedents, and a DCF analysis.
Financial modeling under uncertainty
Scenario & Sensitivity Analysis Modeling. Learn how to build advanced scenario & sensitivity analysis for FP&A, investment banking and equity research in financial models.
Financial modeling for M&A valuations
Advanced financial modeling for mergers and acquisitions (M&A) transactions.
Leveraged buyout LBO modeling
Learn to build a Leveraged Buyout (LBO) financial model from scratch.
Presentation & visual elements of financial models
Dashboards & Data Visualization. Learn how to build custom dashboards and great presentations with data visualization techniques.
Financial modeling case study
Advanced Financial Modeling for Valuation Case Study.
Who Should Attend
Professional accountants and financial consultants who wish to specialize in a non-seasonal consulting niche; employees of companies whose business plan includes growth/change via acquisitions and/ or divestitures; and anyone else who deals with business value in the course of his or her work.
The program is also suitable for:
Anyone working in mid-level FP&A and Corporate Finance type roles
Mid-level banking executives
ACCA, CIMA, ACMA, ICAP students & members
MBA/MCOM students & graduates
How You Will Benefit
After completing this course, attendees will be able to:
Take their excel expertise to the next level. They will learn how excel is used by world-class financial analysts
Build a three statement financial model forecast in the most effective and efficient way for any complexity of scenarios
Identify the fundamental steps to valuing a business, from beginning to end
Create a financial model to value a business based on Comps, Precedents, and a DCF analysis
Build custom dashboards and great presentations with data visualization techniques
Fee & Schedule
Next Session Begins:
08 consecutive Saturdays
Three ( 08 Workshops )
10:00 am To 5:00 pm
Fee: Mandatory Modules:
Fee: Optional Modules:
Course material + ACS Certificate
Lunch + Tea + Coffee + Water
Learn, Grow & Succeed
For free consultation about your professional training needs, contact ACS today!