Table of Content
 

Basics of Excel

  • Custom Formatting In Excel
  • Creating A Layout For Integrated Model
  • EMI Basic Case
  • Excel Shortcuts I
  • Excel Shortcuts II
  • Referencing Framework In Excel

Income Statement

  • Introduction Financial Statement Analysis
  • Introduction Income Statement 1
  • Introduction Income Statement 2
  • Introduction Income Statement 3
  • Income Statement of Accenture
  • Revenue Recognition 1
  • Revenue Recognition 2
  • Concept Checker and Exercise
  • EPS for Apple

Balance Sheet Cash Flow and Complete Business Perspective

  • Understanding Balance Sheet
  • Balance Sheet of Accenture
  • Balance Sheet Exercise 1
  • Balance Sheet Exercise 2
  • Understanding Cash Flow
  • Cash Flow Statement of Accenture
  • Cash Flow Exercise
  • Complete Business Perspective

Ratio Analysis

  • Basics of Ratio
  • Classification of ratios
  • Activity Ratios
  • DuPont
  • Liquidity Ratios
  • Market ratios
  • Profitability Ratios
  • Solvency ratios

Corporate Finance

  • Time Value of Money
  • NPV and IRR
  • NPV Vs. IRR
  • NPV Profile and Crossover Rate
  • Free Cash Flow to Firm and Equity I
  • Free Cash Flow to Firm and Equity II
  • Free Cash Flow to Firm and Equity III
  • Free Cash Flow to Firm and Equity IV
  • Free Cash Flow to Firm and Equity V
  • Theory Relative Valuation
  • Trading Multiples
  • Understand Transaction Comparative

Breakeven Analysis

  • Understanding Breakeven Analysis
  • Case Breakeven
  • Breakeven Excel Based
  • Breakeven Taxes
  • Breakeven Dashboard
  • Breakeven Synergy

Advanced Accounting Concepts

  • Long Lived Assets and Depreciation
  • Straight Line Depreciation
  • Double Declining Depreciation Method
  • Deferred Taxes Liabilities and Assets 1
  • Deferred Taxes Liabilities and Assets 2
  • Amortization and Goodwill
  • Provisions
  • Working Capital Management
  • Inventory Accounting

Stocks Comparison tools and Concept of Unit Economics

  • Mean, Median, Mode and SD 1
  • Mean, Median, Mode and SD 2
  • Coefficient of Variation 1
  • Coefficient of Variation 2
  • Case 1: Identifying Relevant Costs
  • Case 2: Old Vs. New Machine
  • Case 3: Adding or Dropping Segments
  • Case 4: Make or Buy Decision

Accounting Abuses

  • Case 1: Xerox Corporation
  • Case 2: WorldCom
  • Case 3: Enron Corporation
  • Theory

Budgeting

  • Budgeting_0
  • Budgeting_01
  • Budgeting_02
  • Budgeting_03
  • Budgeting_04
  • Budgeting_05
  • Budgeting_06
  • Budgeting_07
  • Budgeting_08

 

Apply for certification

https://www.vskills.in/certification/Management/Finance-for-Non-Finance-Professionals