All exams are online now due to COVID related precautions read more

Financial Modelling Table of Contents


Table of Content
 

 

Financial Modelling Basics

  • What is Financial Modelling
  • Financial Models Application
  • Financial Modelling Approaches
  • Financial Modelling Guidelines
  • Income Statement (Profit and Loss Account)
  • Cash Flow Statement
  • Cash Flows from Operations
  • Cash Flows from Investments
  • Cash Flows from Financing
  • Balance Sheet

Financial Ratios

  • Liquidity ratios
  • Leverage ratios
  • Turnover Ratios
  • Profitability Ratios
  • Market Value Ratios
  • Du Point

Components of Balance Sheet

  • Shareholders' equity
  • Depreciation
  • Goodwill
  • Non-Controlling Interest
  • Deferred Tax Liability
  • Time Value of Money
  • Internal Rate of Return
  • Net Present value

Using Excel for Financial Modelling

  • Excel 2013 Basics
  • Workbook and Worksheet
  • Manipulating Data
  • Worksheet Formatting
  • Page Properties and Printing
  • Excel Formulas
  • Sort and Filter
  • Charts
  • Macros
  • Excel Shortcuts
  • Access keys for ribbon tabs
  • Work in the ribbon with the keyboard
  • Keyboard shortcuts for navigating in cells
  • Keyboard shortcuts for formatting cells
  • Keyboard shortcuts for making selections and performing actions
  • Keyboard shortcuts for working with data, functions, and the formula bar
  • Function keys
  • CTRL combination shortcut keys
  • EMI Calculation in Excel
  • Iterating Circular References
  • Macros

Valuation

  • Valuation Basics
  • Discounted Cash Flow
  • Estimating Future Cash Flow
  • Free Cash Flow to Firm (FCFF)
  • Free Cash Flow to Equity (FCFE)
  • Weighted Average Cost of Capital (WACC)
  • Cost of Debt
  • Cost of Equity
  • Capital Asset Pricing Model (CAPM)
  • Risk Free Rate
  • Beta
  • Market Risk Premium
  • Trading and Transaction Comparable
  • Football Field Analysis
  • Mergers and Acquisitions

Case Study

  • Financial Modelling Case Study - 1
  • Financial Modelling Case Study - 2



Apply of certification

https://www.vskills.in/certification/accounting-banking-and-finance/financial-modelling-certification