FMVA Course

A Certified Financial Modeling & Valuation Analysis

About the FMVA Certificaton The FMVA is CFI’s Financial Modeling & Valuation Analyst (FMVA)® program that is designed to teach practical applications of accounting, Excel, finance, financial modeling, valuation, presentations, and other critical skills that financial analysts need. The program consists of 12 required courses, each with a qualified assessment at the end.

Why Take the FMVA Program?

The FMVA certification was designed to fill a gap in the market for financial analysts. Traditional universities are mostly focused on theory and employers often find that new hires are not up to speed on the full skill set that’s required for doing top-notch financial analysis. Additionally, established professional designations are too focused on specific niches such as portfolio management, alternative assets, or just accounting.

This course includes:

100 Hours of Lessons

25 LECTURES

All SKILL levels

Certificate of Completion

Course Created by

Mohamed El Shazly

About

Course Created by

Mohamed El- Naggar

About

Course Curriculum

This is exactly what will be covered in this course

Accounting

Identify key items on the financial statements and describe the interrelationship between all the components.

Explain the fundamental accounting principles that underly detailed accounting standards .

Identify the key accounting standards commonly encountered by financial analysts and explain the impact on financial statements and financial models

EXCEL

Utilize the keyboard shortcuts to save time and be more efficient in Excel .

Conduct data analysis using data tables, pivot tables, and other common functions.

Use advanced formulas and functions to enhance the functionality of financial models .

Finance

Explain key concepts around capital investments, the capital-raising process, different forms of financing, and the optimal capital structure.

Assess the profitability, efficiency, returns, and value of a business using common financial ratios and analytical tools

Use key statistical measures to assess trends and relationships within sets of data.

Financial Modeling

Build a dynamic, logically designed, well structured 3-statement financial model.

Create multi-year forecasts for the income statement, cash flow, and balance sheet.

Perform scenario and sensitivity analyses to enhance the robustness of the financial model.

Valuation

Identify the different valuation methodologies and discuss the pros and cons of each.

Perform a valuation analysis using comparable company and precedent transactions analysis

Calculate the weighted-average cost of capital and construct a DCF model in Excel.

Budgeting & Forecasting

Apply various forecasting techniques to develop a robust financial forecast.

Track actual performance against budgeted amounts using variance analysis and other techniques

Analyze the impact of a variance analysis on the financial statements and use the results to improve the budgeting process.

Presentation & Visuals

Create insightful dashboards and advance data visualization techniques to communicate the results of financial analysis

Create aesthetically pleasing and insightful charts, graphs, and tables in Excel.

Design impactful presentations to communicate key messages to a wide variety of audiences

Strategy

Differentiate between the different levels of a company’s strategy

Perform an analysis of external forces and internal competencies and assess the impact on a company’s competitive advantage.

Generate, evaluate and select optimal strategic alternatives and tie these to a company’s mission, vision, and goals.

Introduction to User Experience Design