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