EY Virtual Academy | Certificate in Financial Modelling and Valuation
Learn to build robust and flexible financial models to report and analyse historical data.
Learn to build robust and flexible financial models to report and analyse historical data.
Course Snapshot
- FeeINR 12000/- + GST
- Work Experience0 - 30 Years
- Duration36+ Hours
- Delivery MethodSelf Study
Course Detail
Program Overview:
EY Virtual Academy's certification course on financial modelling is designed to cover all the major aspects of financial modelling. The course provides candidates an exposure to create efficient, robust and flexible financial models. These models enable them to report and analyze historical data, prepare future projections and present integrated financial statements, key financial ratios and outputs in a logical, summarized and effective manner. The course helps candidates to understand and apply these skills using examples specially devised to demonstrate alternate ways to compute various financial parameters. The program also introduces basics of business valuation, valuation methods and interpretation of valuation results.
The learnings from these demonstrations and examples will be further augmented by a holistic case-study, covering all the modules. On completion of the program, the candidates should be able to develop well-structured, robust and dynamic financial models to perform independent business valuations.
Program Highlights:
The programs offered in financial modelling and valuation are among the most sought after in the financial universe. This course is designed to cover all major aspects of financial modelling, such as:
- Best practices.
- Structuring and designing models.
- Sector-specific working of revenue and expense.
- Understanding various possible ways to compute different line items forming a part of financial statements.
- Tax calculation.
- Integrating financial statements to present a cohesive output.
- Building macros.
- Various approaches to valuation and how to apply them.
- Presentation of output in an appealing and meaningful manner.
Desired Candidate Profile
- Finance professionals working in investment banking and equity research.
- Finance managers.
- Corporate finance, private equity and mergers and acquisition (M&A) professionals.
- CA, FRM, MBA Finance, CFA Program candidates.
- Self-employed finance professionals.
- Graduates.
EY will award a "Certificate of Completion" to participants who achieve a minimum score of 50% in the MCQ-based assessment.
Course Modules
- Exploring excel functions.
- Exploring Excel tools.
- Overview of Financial Modelling, Best Practices & Warm Up.
- Building the Financial Statements.
- Fixed Assets and Depreciation.
- Capital Structure.
- Working capital & Tax.
- Outputs- Integrating the Financial Statements and Outputs.
- Introduction to Valuation.
- Case Study.
The course has been designed with high-quality, insights-driven, well-researched content by a team of senior professionals from members firms of EY global and the industry.