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

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
• Understand Transaction Comparative

Breakeven Analysis

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

• 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

For Support