



Financial Statement Analysis
This course introduces participants to the three common financial statements and ratio analysis. Participants will learn Excel and use Excel to create statements and perform numeric analysis.

Module 1: Fundamental Concepts
-
Generally accepted accounting principles
-
Matching principle
-
Historical cost vs. fair value
-
A = L+ E
-
Three-statement relationships
-
Footnotes

Module 2: Balance Sheet
-
Assets and liabilities (detailed discussion of flow and terms)
-
Debt features and terms
-
Introduction of related period expenses (depreciation, amortization, interest expense, etc.)
-
Equity (detailed discussion of flow and terms)

Module 3: Income Statement
-
Income statement (detailed discussion of flow and terms)
-
EBIT
-
Relationships with the balance sheet

Module 4: Cash Flow Statement and Other Topics
-
Mechanics and flow of cash flow statement
-
Detailed construction
-
EBITDA
-
Ratio analysis and case study

Module 5: Using Excel to Create Financial Statements
-
Building basic tables in Excel
-
Using pivot tables to organize data
-
Building financial statements
-
Highlight, format, and create borders/tables for best presentation of data