Financial Modelling and Valuation Analyst FMVA Certification (Batch-05)

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Financial Modeling & Valuation Analyst (FMVA)® Certification Program will teach you the essential skills required to perform practical financial analysis.

 

Financial models are a critical part of the decision-making process in the finance industry today. By following our recommended financial modeling courses, students learn the best way to structure their models to instill confidence in the stakeholders involved in the decision-making process.

 

The Financial Modeling & Valuation Analyst FMVA® certification can help you learn financial modeling skills, streamline a budgeting and forecasting process, or improve competency levels across the entire accounting and finance spectrum. The FMVA® certification provides all the skills, tools, and techniques required to become a world-class financial professional.

 

Financial Modeling & Valuation Analyst (FMVA)® Certification Program covers the most important skills required to become a world-class financial analyst including finance, accounting, Excel, financial modeling, valuation, budgeting, forecasting, presentations, dashboards, and strategy.

 

This program is designed to equip anyone who desires to begin a career or advance their financial modeling and valuation knowledge. Our courses cover Basic, Intermediate, and Advanced Levels so students can choose their learning path based on their skill level and interest.

Show More

What Will You Learn?

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

Course Content

Financial Accounting: Introduction

  • Why Study Accounting
    04:19
  • Meet Your Instructor and Introduction to Course
    05:12

Financial Accounting: Lesson Financial Practice Set

Financial Accounting: Sales Revenues

Financial Accounting: Inventory

Financial Accounting: Operating Expenses

Financial Accounting: Long Term Operating Assets

Financial Accounting: Debt and Equity Financing

Financial Accounting: Financial Statement Analysis

Financial Accounting: General Financial Statement

Financial Accounting: Accounting Cycle (01)

Financial Accounting: Accounting Cycle (02)

Financial Accounting: Financial Accounts – Intro

Introductory Class

Class 01 –

Class 02 –

Class 03 –

Class 04 –

Class 05 –

Clas 06 –

Class 07 –

Class 08 –

Class 09 –

Class 10 –

Class 11 – Financial Model Template | Excel Shortcuts | Market Conventions

Class 12 – Financial Model Assumptions | Forecasting Approaches | Income Statement Forecast (Revenue to EBITDA)

Class 13 – Working Capital Forecasting | Capital Assets & Depreciation | Completing Income Statement

Class 14 – Capital Assets & Financing Forecast | Completing Financial Statements | Cash Flow Forecasting | Model Accuracy Checks

Class 15 – Startup E-Commerce Model: Key Assumptions (IAV, GOV, NOV, Churn, Orders, Conversions) | IS Forecast (Revenue to EBITDA)

Class 16 – E-Commerce Model: IS, BS, CFS Forecast | Amortization Table | Straight-Line Depreciation | Working Capital Projection

Class 17 – Financial Planning and Analysis (FP&A) Model:

Class 18 – Financial Planning and Analysis (FP&A) Model:

Conceptual (Lecture 01) – Valuation: Time Value of Money | Valuation Approaches (Income, Asset, Market) | Techniques (DCF, DDM, Relative, Precedent, Asset-Based)

Conceptual (Lecture 02) – Enterprise vs Equity Value | DCF Roadmap | Risk Types & Calculation via WACC | Capital Asset Pricing Model (CAPM) & Cost of Equity (Ke)

Conceptual (Lecture 03) – Risk-Free Rate Concepts | Reinvestment & Default Risk | CDS Spread | Moody’s Ratings | Pay Wall Management | Calculating Risk-Free Rate

Conceptual (Lecture 04) – Corporate Project: Forecasting Working Capital | Peer & Equity Market Analysis | Financial Statement Reading | Market Research | Story Development

Conceptual (Lecture 05) – Conceptual Topics: Risk-Free Rate (Re-Investment, Default Risk, CDS, Moody’s, Pay Wall) | Calculating Risk-Free Rate | Equity Risk Premium (ERP & Country Risk) | ERP Methods & Limitations

Conceptual (Lecture 06) – Conceptual Topics: Beta (Market, Leveraged, Unleveraged) | Factors Affecting Beta (Size, Debt, Mix, Leverage) | Cost of Debt (Kd), YTM, Default Risk | Market Value of Debt | WACC Calculation

Class 19 – Relative Valuation

Class 20 – Relative Valuation

Class 21 – Valuation: Introduction of Equity Research Report | One Page Company Profile

Class 22 – Valuation: Common Size Statement | Ratio Analysis | Value at Risk (VaR) Analysis – Monte Carlo Simulation

Class 23 – Industrial Project: Fauji Cement (FCCL) – Working Capital Forecasting (Trade Debt, Stock in Trade) | Peer Analysis Market Research, Historical Analysis, Sector Analysis

Class 24 – Industrial Project: Fauji Cement (FCCL): Current Liabilities Forecasting (Trade and Other Payables) | Current Assets Forecasting (Stores, Spares and Tools)

Class 25 – Industrial Project: Fauji Cement (FCCL): Current Liabilities Forecasting | Non-Current Liabilities Forecasting (Property, Plant and Equipment PP&E | Capital Work in Progress | Depreciable Assets | Capital Asset Turnover Ratio)

Class 26 –

Class 27 –

Class 28 –

Class 29 – Industrial Project: Fauji Cement (FCCL): Forecasting (Short Term Financing, Accrued Liabilities, Depreciation) | Completing Income Statement, Balance Sheet and Cash Flow Statement | Balancing Balance Sheet with Cash Balance from Cash Flow Statement

Merger & Acquisition (M&A) Modelling

Leveraged Buyout Model (LBO) Modelling

Class 30 – WACC (Weighted Average Cost of Capital) | CAPM (Capital Asset Pricing Model) – Risk Free Rate Calculation, Risk Premium Calculation, Beta Calculation

Class 31 – Corporate Project: Free Cash Flow to the Firm (FCFF) | Terminal Value | Perpetual Growth | Present Value of the Cash Flows | Enterprise Value and Equity Value of Firm | Upside/ Downside of the Market Price

Class 32 –

Class 33 – Aisha Steel Mills: Free Cash Flow to the Firm (FCFF) | Terminal Value | EV/ EBITDA Ratio | Perpetual Growth | Present Value of the Cash Flows | Enterprise Value and Equity Value | Upside/ Downside of the Market Price | Football Field Analysis | Sensitivity Analysis | Finalizing Corporate Project

Class 34 – Business Valuation Report: PowerPoint Template Designing | Connecting Excel Tables with PowerPoint | Adjusting Table Layout | Inputs Commentary | Report Writing