IFB Equity Model Spreadsheet
Equity Accounting: Metrics and Ratios
-
What is EBITDA? (7:26)
-
EBITDA Margin (16:23)
-
Net Debt to EBITDA (9:49)
-
Interest Coverage Ratios (7:29)
-
Days Sales Outstanding (DSO) (6:47)
-
Days Sales in Inventory (DSI) (8:09)
-
Operating Cycle & Cash Conversion Cycle (5:47)
-
Cash Flow Analysis Ratios (18:47)
-
Free Cash Flow (9:44)
-
Maintenance Capital Expenditures (13:49)
-
Changes in Working Capital (12:19)
-
NOPLAT for Operating ROIC (9:03)
-
Combined Ratio (13:12)
Equity Accounting: Financial Statements
-
Operating Income & Expenses (6:43)
-
Cost of Goods Sold (COGs) (8:07)
-
Property, Plant, and Equipment (PPE) (6:14)
-
Software Depreciation (7:01)
-
Statement of Cash Flows (10:24)
-
Capital Expenditures (8:56)
-
Operating Leases (5:57)
-
Deferred Revenue (11:06)
-
Deferred Tax Liabilities (6:43)
-
Net Operating Losses (NOLs) (10:03)
-
Short term debt (14:18)
-
Contractual Obligations (6:30)
-
How to Read a 10-k (17:05)
-
MD&A (7:40)
-
Auditor's Opinion (5:48)
-
Insider Ownership (8:44)
-
Related Party Transactions (5:20)
-
Retained Earnings (16:29)
-
Other Comprehensive Income (OCI), AOCI (12:52)
Valuation
-
Investors' Adjusted Return on Equity (14:35)
-
Using ROIC to Evaluate Stocks (11:00)
-
Stages of Industry Life Cycles (13:15)
-
DCF Valuation (16:29)
-
Weighted Average Cost of Capital (17:51)
-
Calculating Terminal Value (13:25)
-
Market Value vs Book Value (6:28)
-
CAPM Assumptions (10:08)
-
The DuPont Method (10:28)
-
Relative Valuation (16:04)
-
Fair Value Measurement (10:12)
-
Reverse DCF (11:12)
-
Enterprise Multiple (13:28)
-
Sum of the Parts Valuation (15:22)
-
Normalized Earnings (17:55)
-
Price to Tangible Book (12:08)
