Financial Analysis & Modeling

Overview of Financial Analysis and its Importance

Types of Financial Analysis: Horizontal, Vertical, Ratio Analysis

Key Financial Metrics: Liquidity, Solvency, Profitability

Basic Accounting Concepts: Assets, Liabilities, Equity, Revenue, Expenses

Accrual vs Cash Accounting

Depreciation, Amortization, and Working Capital

Understanding Journal Entries and Ledgers

Linking Financial Statements

Ratio Analysis: Liquidity Ratios (Current Ratio, Quick Ratio) Profitability Ratios (ROE, ROA, Gross Margin) Leverage Ratios (Debt-to-Equity, Interest Coverage) Efficiency Ratios (Inventory Turnover, Receivables Turnover)

Trend Analysis & Benchmarking

Common-Size Financial Statements

What is Financial Modeling and its Applications

Types of Models: Three-Statement Model Discounted Cash Flow (DCF) Model Budgeting & Forecasting Model M&A and LBO Models

Overview of Excel Tools for Modeling

Advanced Excel Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, OFFSET

Logical Functions: IF, AND, OR, Nested IF

Date, Text, and Lookup Functions

Pivot Tables and Charts for Financial Analysis

Scenario & Sensitivity Analysis Tools

Step-by-Step Construction of a Three-Statement Model

Forecasting Revenue, Expenses, and Cash Flows

Depreciation, Interest, Taxes, and Working Capital Modeling

Integrating Balance Sheet, Income Statement, and Cash Flow

Building Assumptions, Drivers, and Inputs

Discounted Cash Flow (DCF) Analysis

Calculating Free Cash Flows

Relative Valuation: P/E, EV/EBITDA, Price-to-Book

Sensitivity and Scenario Analysis