Knowledge Base: BIWS Financial Modeling Tutorials
3-Statement Models
-
3-Statement Model Case Study (30 Minutes) (Illinois Tool Works, Industrials, Manufacturing) (34:34)
-
Balance Sheet Forecast: How to Project the Balance Sheet (19:03)
-
IB Case Studies: 3-Statement Modeling Test (26:05)
-
Revenue Model 101
-
Revenue Model Example – Tops-Down Forecasting
-
Subscription Revenue Model (Netflix) (17:37)
Accounting
-
Accounts Receivable on the 3 Financial Statements (11:19)
-
Accrued Expenses vs Accounts Payable – Interview Question (12:43)
-
Depreciation on the 3 Financial Statements (7:53)
-
Equity Method Accounting (16:19)
-
IFRS vs US GAAP on the Financial Statements (21:57)
-
Inventory and COGS: LIFO vs FIFO (13:39)
-
Why Gains and Losses are Non-Cash Charges (11:20)
Bank Modeling
-
Bank Balance Sheet to its Income Statement and Cash Flow Statement (32:47)
-
Deposit Divestitures in Bank Merger Models
-
Dividend Discount Model Example for Banks – Shawbrook Case Study (32:37)
-
Dividends Issued & Share Issuances Excel Tutorial – Shawbrook Case Study (23:56)
-
Price to Book Value Ratio – Interpretation and Derivation (23:02)
-
The Allowance for Loan Losses for Banks (FIG) (22:17)
Debt & Equity
Discounted Cash Flow Analysis (DCF)
Equity Value & Enterprise Value
-
Can Enterprise Value Be Negative? What About Equity Value? (14:49)
-
Enterprise Value vs Equity Value – Sample Technical Guide and Excel Files
-
Enterprise Value: Why You Add and Subtract Items (23:39)
-
Equity Value vs. Enterprise Value and Valuation Multiples (10:24)
-
How to Calculate Enterprise Value: Enterprise Value Calculation
-
Why You Subtract Equity Investments (Associate Companies) in Enterprise Value (12:09)
Excel
-
Circular Reference Excel – How to Find and Fix Them [Tutorial Video] (10:47)
-
Excel Database Functions: How to Use Them [Tutorial Video] (21:22)
-
Excel Power Query: Full Explanation and Examples [Tutorial Video] (11:03)
-
Excel Practice Test for Interviews: Full Tutorial Using INDIRECT, MATCH, and SUMIFS [Tutorial Video] (14:55)
-
Excel Shortcuts Investment Banking: Quick Tips (10:10)
-
Excel VBA Programming: How to Record a Macro in Excel [Tutorial Video] (19:16)
-
Football Field Valuation Chart with Dynamic Share Price Line [Tutorial Video] (16:54)
-
How to Clean Data in Excel (PC/Windows Version) [Tutorial Video] (10:20)
-
How to Color Code in Excel for Financial Models (PC/Windows Version) [Tutorial Video] (32:42)
-
Index Match Function Excel [Tutorial Video] (16:32)
-
Sensitivity Analysis Excel: How to Set It Up [Tutorial Video] (17:58)
Financial Statement Analysis
-
Change in Working Capital: Calculations and Meaning (19:40)
-
Free Cash Flow Conversion Analysis (15:04)
-
Free Cash Flow Example (FCF) and Formulas (26:52)
-
How to Use Cash Flows in an LBO Model: Debt, Dividends, and “Dough” (11:00)
-
Leveraged Buyout – Debt Equity Ratio (19:48)
-
Non-Recurring Charges on the Income Statement (21:15)
-
Operating Leverage: Calculation and Meaning (22:07)
-
ROIC vs ROE and ROE vs ROA: Key Financial Metrics and Ratios (24:12)
-
What is Free Cash Flow? Full Explanation and Tutorial (21:49)
-
Why Do You Use Net Income to Calculate Return on Assets (ROA)? (10:54)
Interviews
Leveraged Buyouts and LBO Models
-
Existing Debt in Leveraged Buyouts: Why It Doesn’t Matter (14:02)
-
IRR vs. Cash on Cash Multiples in Leveraged Buyouts and Investments (14:00)
-
LBO – Returns Attribution Analysis (18:42)
-
LBO Debt Schedule: Mandatory Repayments (16:59)
-
LBO Exit Strategies: M&A, IPOs, and Dividends / Recapitalizations (20:37)
-
LBO Model – Add-On Acquisitions (Dell Case Study Part 4) (35:40)
-
LBO Model – Debt Schedules & Interest Expense (Dell Case Study Part 3) (29:59)
-
LBO Model Case Study – Dell Example with Excel Templates (23:11)
-
LBO Model Concept: Leveraged Buyout and Buying a House (13:16)
-
LBO Model Interview Questions: What to Expect (18:48)
-
LBO Model: Sources & Uses (17:20)
-
LBO Valuation (19:36)
-
Private Equity Case Study Presentation Template (23:13)
-
Quick IRR Calculation in LBO Models (20:02)
-
Simple LBO Model – Case Study and Tutorial (13:24)
-
Waterfall Returns Distribution in an LBO Model (19:18)
M&A and Merger Models
-
Deferred Tax Liabilities in M&A Deals: Why They Get Created (13:23)
-
Definitive Agreement (21:40)
-
Earnout Modeling in M&A Deals and Merger Models (21:49)
-
EPS Accretion Dilution – Rules of Thumb for Merger Models (13:24)
-
Expense Synergies in Merger Models (20:31)
-
How Extra Cash Impacts Enterprise Value (15:14)
-
How to Calculate Cash Taxes in a Merger Model – Free Tutorial
-
How to Calculate Goodwill in M&A Deals and Merger Models (17:33)
-
Merger Model Interview Questions: What to Expect (18:38)
-
Merger Model Walkthrough: Combining the Income Statements (28:45)
-
Merger Model: Assessment Centre Case Study (24:14)
-
Merger Model: Cash, Debt, and Stock Mix (19:58)
-
Negative Goodwill and Bargain Purchases in Merger Models (16:09)
-
Net Operating Losses (NOLs) on the 3 Financial Statements (18:20)
-
Purchase Accounting for Noncontrolling Interests AKA Minority Interests (22:59)
-
Purchase Price Allocation Example – Advanced Tutorial
-
Purchase Price in M&A Deals: Equity Value or Enterprise Value? (15:28)
Networking
Oil & Gas Modeling
-
NAV Model (Oil & Gas): Production Decline Curve (24:27)
-
NAV Model for Oil & Gas: Revenue Projections
-
Net Asset Value Oil and Gas: How to Calculate NAV per Share
-
Oil & Gas Stock Pitch: How to Research and Present It (22:10)
-
Oil and Gas Merger Model: Synergy Calculations
-
Oil and Gas Revenue Projections: Financial Modeling Tutorial
-
Type Curves Oil and Gas: Projecting the Production Decline Rate
PowerPoint
-
Building A Company Profile in PowerPoint: Alignment Tricks (12:50)
-
Investment Banking PowerPoint Shortcuts: Full Tutorial and Setup
-
PowerPoint Connector Lines: How to Add Them and Create Hierarchy Charts
-
PowerPoint Recommendations Slide: How to Create It (15:30)
-
PowerPoint Sections: How to Create and Order Them (23:02)
-
PowerPoint Shortcuts Investment Banking: Quick Tips (13:10)
REIT Modeling
Real Estate Modeling
-
Commercial Real Estate Loan Refinancing Tutorial (16:58)
-
Leasing Commissions In Real Estate: How to Project Them (37:52)
-
Real Estate Concessions, Vacancies, and Expense Reimbursements (27:48)
-
Real Estate Development Modeling Tutorial: Equity, Debt Draws, and Optional Repayment
-
Real Estate Pro-Forma: Calculations, Examples, and Scenarios (22:31)
-
Real Estate Waterfall Model Returns and Case Study Answers (31:45)
Valuation
-
Comparable Company Analysis (CCA) Tutorial (21:36)
-
EBIT vs. EBITDA vs. Net Income: Valuation Metrics and Multiples (19:25)
-
Free Cash Flow vs. Unlevered Free Cash Flow vs. Levered Free Cash Flow (20:13)
-
How to Calculate EBITDA (14:11)
-
Net Operating Loss Valuation for NOLs – Sample Lesson
-
Precedent Transaction Analysis Tutorial – Microsoft / aQuantive
-
Private Company Valuation Tutorial (23:31)
-
Snap Valuation: Is Snap Overvalued? (19:47)
-
Startup Valuation – How Are Startups Worth Billions? (14:10)
-
Stock Pitch Example: How to Use Valuation to Outline a Buy-Side Stock Pitch (26:05)
-
What Is A Valuation Multiple? (14:35)