Financial modelling is a technique used by companies for financial analysis in which the income statement, balance sheet, and cash flow statement of a company are forecasted for the next five to ten years. It includes preparing detailed company-specific excel models which are then used for the purpose of decision-making and performing financial analysis. It is nothing but constructing a financial representation of some, or all, aspects of the firm or given security. In other words, It is preparing the expected financial statements predicting the company’s financial performance in a future period using the assumptions and historical performance information. One may use such financial models in DCF valuations, mergers and acquisitions, private equity, project finance, etc.
This course is a comprehensive bundle of MS Excel, Valuation, Accounting, Financial Analysis and Financial Modeling. Anyone interested in a career in Finance and Financial Analyst Industry. This course is a must.
Course Features
- Lectures 254
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
Curriculum
- 8 Sections
- 254 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- BASIC EXCEL TRAINING FOR FINANCIAL MODELING41
- 1.1Accessing MS Excel
- 1.2MS Excel Startup Screen
- 1.3Understanding the Ribbon
- 1.4Cells in Excel
- 1.5Worksheet Essentials
- 1.6Formatting Cells
- 1.7Custom Cell Styles
- 1.8Custom Number Formatting in Excel
- 1.9More on Custom Number Formatting
- 1.10Custom Formats of Data
- 1.11The BEDMAS Order of Mathematical Operations
- 1.12Mathematical Operations without Functions
- 1.13Mathematical Operations without Functions Continued
- 1.14IF Function
- 1.15More on IF Function
- 1.16Importing Data and Calculations
- 1.17Working with the Count Function
- 1.18Conditional Counts – Count IF Function
- 1.19Working with the Sum Function
- 1.20Finding the Average
- 1.21Conditional Average – Average IFS Function
- 1.22Finding the Maximum Value Using the MAX Function
- 1.23Finding the Minimum Value Using the MINFS Function
- 1.24Determining Proportions and Updating a Calculation
- 1.25Conditional Formatting
- 1.26More on Conditional Formatting
- 1.27Working with Tables
- 1.28Formatting Table
- 1.29Filtering and Sorting of Data
- 1.30Freeze and Split
- 1.31Printing and Layouts in Excel
- 1.32Pivot Tables
- 1.33Creating Custom Tables
- 1.34Organizing Pivot Tables
- 1.35Column Chart
- 1.36Bar Chart
- 1.37Line Chart
- 1.38Pie Chart
- 1.39Common Errors in Excel
- 1.40Map Chart
- 1.41More on Common Errors
- Advanced excel features & Functions for financial modeling57
- 2.1Logical Function – IF
- 2.2AND OR and XOR Functions
- 2.3IFS Function – Example 1
- 2.4IFS Function – Example 2
- 2.5SWITCH Function
- 2.6Other Logical Functions
- 2.7Information Functions – ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT
- 2.8Date Functions – TODAY DAY
- 2.9MONTH YEAR WEEKDAY WEEKNUM Functions
- 2.10EDATE and EOMONTH Functions
- 2.11YEARFRAC Function
- 2.12Joining Data using CONCAT and TEXTJOIN
- 2.13LEN FIND LEFT RIGHT TRIM
- 2.14Using UNIQUE and TRANSPOSE
- 2.15TEXT Function
- 2.16CHOOSE Function
- 2.17More on CHOOSE Function
- 2.18VLOOKUP Function
- 2.19HLOOKUP Function
- 2.20Index Function
- 2.21Match Function
- 2.22XLOOKUP and XMATCH Functions
- 2.23Using the OFFSET Function
- 2.24OFFSET Function – Total and Average Score
- 2.25OFFSET Function – Highest and Lowest Score
- 2.26OFFSET Function – Year to Month Sales
- 2.27OFFSET Function – Quarterly and Half-Month Sales
- 2.28Naming of Cell
- 2.29Naming a Range
- 2.30Text to Columns
- 2.31Grouping Tabs and Subtotal Function
- 2.32Working with Hyperlinks
- 2.33Data Validation
- 2.34Data Validation Continued
- 2.35Custom Data Validation
- 2.36Generating Random Numbers
- 2.37Protecting Worksheet and Workbook
- 2.38PivotTable – Advanced Features
- 2.39More on Advanced Features
- 2.40Slicers and Timelines
- 2.41Solver
- 2.42Data Tables
- 2.43More on Data Tables
- 2.44Goal Seek
- 2.45Combo Charts
- 2.46More on Combo Charts
- 2.47Sparklines
- 2.48Waterfall Chart
- 2.49Box Chart
- 2.50Whisker Chart
- 2.51TreeMap and Sun Burst Charts
- 2.52Radar Chart
- 2.53Scroll Bar
- 2.54Spin Button and Radio Button
- 2.55Form Control Application
- 2.56Form Control Application Continued
- 2.57Data Entry Form
- Accounting foundation9
- Understanding Income Statement for financial Modelling15
- 4.1Financial Statements – Fiscal Year Vs Calendar Year
- 4.2Income Statement Format
- 4.3Calculating Profit Margins
- 4.4Non Recurring Items
- 4.5Changes In Accounting Estimates
- 4.6Final Remarks
- 4.7Revenue Recognition – Percentage Completion & Completed Contract
- 4.8Revenue Recognition – Installment Method & Cost Recovery
- 4.9Depreciation Expense
- 4.10Downloading Colgates Income Statement
- 4.11Analyst Format Of Colgate’S Income Statement
- 4.12Formatting The Income Statement
- 4.13Investigating The Non-Recurring Charges
- 4.14Seperating Non-Recurring Items
- 4.15Comparision Of Margins – Before And After Adjustments
- Understanding balance sheet39
- 5.1Introduction To Balance Sheet
- 5.2Introduction To Current Assets
- 5.3Cash And Cash Equivalents
- 5.4Cash And Cash Equivalents – Colgate’ and Microsoft
- 5.5Accounts Receivables
- 5.6Accounts Receivables Case Study
- 5.7Inventory
- 5.8Inventory – Case Study
- 5.9Inventory – Lcm
- 5.10Inventory – Colgate
- 5.11Inventory Valuations
- 5.12Inventory Valuation – Recap
- 5.13Prepaid Expenses
- 5.14Other Current Assets – Colgate
- 5.15Financial Reporting Standards
- 5.16Current Liabilities
- 5.17Current Liabilities – Colgate
- 5.18Long Term Assets
- 5.19Introduction To Goodwill
- 5.20Pooling Method Of Accounting
- 5.21Purchase Method Of Accounting
- 5.22Goodwill Impairment
- 5.23Long Term Investments Part 1
- 5.24Long Term Investments Continued
- 5.25Long Term Investments – Example
- 5.26Long Term Liabilities
- 5.27Long Term Liabilities – Risk Profile
- 5.28Introduction To Shareholder’S Equity
- 5.29Common Stock – Par Value And Apic
- 5.30Treasury Stock Or Shares
- 5.31Retained Earnings and Dividends
- 5.32Additional Other Comprehensive Income
- 5.33Introduction To Preference Shares
- 5.34Macdonald’S Shareholder’S Equity
- 5.35Dividends – Types
- 5.36Cash And Property Dividend – Example
- 5.37Stock Dividends
- 5.38Small & Large Stock Dividends – Example
- 5.39Stock Split
- Cash flows analysis14
- 6.1Introduction To Cash Flows
- 6.2Cfo – Direct Method
- 6.3Cfo – Direct Method – Continued
- 6.4Cfo – Direct Method – Example
- 6.5Cfo – Indirect Method
- 6.6Cfo – Indirect Method – Example
- 6.7Cfi
- 6.8Cff
- 6.9Comprehensive Example – Cfo – Direct Method – 1
- 6.10Comprehensive Example – Cfo – Direct Method – 2
- 6.11Comprehensive Example – Cfo – Indirect Method
- 6.12Comprehensive Example – Cfi
- 6.13Comprehensive Example – Cff
- 6.14Comprehensive Example – Ending Cash Balance
- Valuation, dcf & Relative Valuation35
- 7.1Corporate Valuations – Overview
- 7.2Ddm – Dividend Discount Model- Intrinsic Value
- 7.3Ddm – Dividend Discount Model- Required Rate Of Return
- 7.4Ddm – Dividend Discount Model- Compare Intrinsic And Market Price
- 7.5Ddm – Intrinsic Value Of Growth Companies
- 7.6Ddm – Dividend Discount Model- Present Value
- 7.7Introduction To Dcf
- 7.8Forecasting Income Statement Ebitda
- 7.9Understanding The Working Capital
- 7.10Completing The Working Capital Calculations
- 7.11Linking The Free Cash Flow To Firm Fcff
- 7.12Discounting The Explicit Period Cash Flows
- 7.13Calculation Of Terminal Values
- 7.14Dcf Valuation Summary
- 7.15Dcf Sensitivity Analysis
- 7.16Understanding The Capital Structure
- 7.17Options Treasury Stock Method
- 7.18Options Explained
- 7.19Calculation Of In The Money Convertibles
- 7.20Calculation Of In The Money Stock Options
- 7.21Calculation Of Debt Equity Ratio
- 7.22Cost Of Debt Calculations
- 7.23Cost Of Equity Calculation
- 7.24Enterprise Value Calculation Completing The Missing Links
- 7.25Introduction To Relative Valuation
- 7.26Relative Valuations Enterprise Value And Equity Value
- 7.27Relative Valuations Comparable Comp Sheet
- 7.28Understanding Pe Ratio
- 7.29Forward And Trailing Pe
- 7.30Advantages And Limitations Of Pe
- 7.31Understanding Pbv Ratio
- 7.32Why Pbv Is Used In Banks
- 7.33Pbv And Roe Used For Energy Sector
- 7.34Understanding Pcf Ratio
- 7.35Why Pcf Used In Oil Gas Gold Real Estate
- Financial Modeling of apple inc44
- 8.1Financial Modeling Overview
- 8.2Reading the Annual Report
- 8.3Revenue Forecasting
- 8.4Cost Sheet Calculations
- 8.5Linking Cost Sheet Data to Income Statement
- 8.6Earning Per Share Calculations
- 8.7Computing Weighted Average Shares
- 8.8Introduction to Balance Sheet and its Components
- 8.9Calculating Net Working Capital
- 8.10Cash Conversion Cycle
- 8.11Calculating Account Receivable
- 8.12Building Assumptions
- 8.13Linking Working Capital Values to Balance Sheet
- 8.14Forecasting Capital Expenditures
- 8.15Forecasting Depreciation Using a Waterfall
- 8.16Calculating Ending Net PP and E
- 8.17Common Stock and Retained Earnings
- 8.18Forecasting Dividend
- 8.19Other Current and Non Current Liabilities
- 8.20Forecasting Long Term Debt
- 8.21Interest Expense Calculation
- 8.22Linking Debt
- 8.23Circular Reference in Financial Models
- 8.24DCF Mechanics
- 8.25Modeling Cost of Debt
- 8.26Modeling WACC
- 8.27Understanding Weighted Average Interest Rates
- 8.28WACC Concept
- 8.29Time Value of Money
- 8.30Opportunity Cost
- 8.31Calculating Risk Free Rate
- 8.32Calculating Beta and Equity Risk Premium
- 8.33Market Value of Equity and Book Value of Debt
- 8.34WACC Calculations
- 8.35FCFF Concept
- 8.36FCFE Concept
- 8.37FCFF of Apple Inc
- 8.38FCFF Growth Rate Considerations
- 8.39NPV of Explicit Period
- 8.40Target Share Price Calculations
- 8.41Sensitivity Analysis
- 8.42Growth Rate and Valuation Relation
- 8.43Exit Option
- 8.44More on Valuation
