FMVA (Financial Modeling & Valuation Analyst)

Accounting

 ▪ Balance sheet, income statement, cash flow statement

 ▪ Assets, liabilities, shareholders’ Equity

 ▪ Financial transactions

 ▪ Prepayments, accrued expenses, unearned revenue

 ▪ Operating cash flow, investing cash flow, financial cash flow

 ▪ Depreciation methods

 ▪ Working capital

 ▪ Property, Plant and Equipment (PP&E) and Capital Expenditures (CapEx)

 Excel

 ▪ Functions and formulas (XNPV, XIRR, PMT, IPMT, VLOOKUP,

 ▪ CHOOSE, INDEX MATCH MATCH, OFFSET)

 ▪ Auditing tools (tracing precedents/dependents, go to special,

 ▪ conditional formatting)

 ▪ Data validation, data table, goal seek

 ▪ Solver and Macros

Finance

 ▪ Present value, future value, net present value, terminal value

 ▪ Annuities and perpetuities

 ▪ Capital markets

 ▪ Capital raising process (IPO)

 ▪ Bond pricing, par value, coupon rate, yield to maturity

 Financial Modeling

 ▪ Statement financial modeling

 ▪ Discounted Cash Flow (DCF)

 ▪ Scenario and sensitivity analysis

 ▪ Monthly cash flow forecasting

 ▪ Accretion/dilution analysis

 ▪ Leveraged Buyout (LBO)

 ▪ Mergers & Acquisitions (M&A)

 ▪ Industry-specific financial modeling

 Valuation

 ▪ Comparable company analysis

 ▪ Precedent transactions analysis

 ▪ Discounted Cash Flow (DCF) analysis

 ▪ Weighted Average Cost of Capital (WACC)

 ▪ Net Present Value (NPV) and Internal Rate of Return (IRR)

 ▪ Sum-of-the-Parts (SOTP)

 Budgeting & Forecasting

 ▪ Break-even analysis, margin of safety

 ▪ Quantitative forecasting

 ▪ Variance analysis

 ▪ Budgeting tools

 Presentation & Visuals

 ▪ Dynamic charts and graphs

 ▪ Professional pitch deck

 ▪ Financial dashboards

After FMVA Course Certificate completion, participants will be able to :

▪ Gain a solid understanding of fundamental accounting principles and their impact on financial modeling.
▪ Craft financial models independently.
▪ Utilize valuation methodologies to determine a company’s worth.
▪ Understand and apply different valuation methodologies.
▪ Create multi-year forecasts for the income statement, cash flow, and balance sheet.