Knowledge Base: BIWS Financial Modeling Tutorials
Discounted Cash Flow Analysis (DCF)
Valuation
-
What Is A Valuation Multiple? (14:35)
-
Startup Valuation – How Are Startups Worth Billions? (14:10)
-
Snap Valuation: Is Snap Overvalued? (19:47)
-
Free Cash Flow vs. Unlevered Free Cash Flow vs. Levered Free Cash Flow (20:13)
-
How to Calculate EBITDA (14:11)
-
Precedent Transaction Analysis Tutorial – Microsoft / aQuantive
-
Net Operating Loss Valuation for NOLs – Sample Lesson
-
Stock Pitch Example: How to Use Valuation to Outline a Buy-Side Stock Pitch (26:05)
-
EBIT vs. EBITDA vs. Net Income: Valuation Metrics and Multiples (19:25)
-
Private Company Valuation Tutorial (23:31)
Debt & Equity
Real Estate Modeling
-
Commercial Real Estate Loan Refinancing Tutorial (16:58)
-
Real Estate Development Modeling Tutorial: Equity, Debt Draws, and Optional Repayment
-
Leasing Commissions In Real Estate: How to Project Them (37:52)
-
Real Estate Concessions, Vacancies, and Expense Reimbursements (27:48)
-
Real Estate Waterfall Model Returns and Case Study Answers (31:45)
-
Real Estate Pro-Forma: Calculations, Examples, and Scenarios (22:31)
Interviews
M&A and Merger Models
-
How Extra Cash Impacts Enterprise Value (15:14)
-
Purchase Accounting for Noncontrolling Interests AKA Minority Interests (22:59)
-
Net Operating Losses (NOLs) on the 3 Financial Statements (18:20)
-
Definitive Agreement (21:40)
-
Negative Goodwill and Bargain Purchases in Merger Models (16:09)
-
Merger Model Interview Questions: What to Expect (14:11)
-
Earnout Modeling in M&A Deals and Merger Models (21:49)
-
Expense Synergies in Merger Models (20:31)
-
Negative Goodwill and Bargain Purchases in Merger Models (16:09)
-
Earnout Modeling in M&A Deals and Merger Models (21:49)
Accounting
-
Inventory and COGS: LIFO vs FIFO (13:39)
-
Why Gains and Losses are Non-Cash Charges (11:20)
-
Depreciation on the 3 Financial Statements (7:53)
-
Equity Method Accounting (16:19)
-
IFRS vs US GAAP on the Financial Statements (21:57)
-
Accounts Receivable on the 3 Financial Statements (11:19)
-
Accrued Expenses vs Accounts Payable – Interview Question (12:43)
3-Statement Models
-
Subscription Revenue Model (Netflix) (17:37)
-
IB Case Studies: 3-Statement Modeling Test (26:05)
-
Revenue Model Example – Tops-Down Forecasting
-
Revenue Model 101
-
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)
Leveraged Buyouts and LBO Models
-
Private Equity Case Study Presentation Template (23:13)
-
LBO Valuation (19:36)
-
Quick IRR Calculation in LBO Models (20:02)
-
LBO Model: Sources & Uses (17:20)
-
IRR vs. Cash on Cash Multiples in Leveraged Buyouts and Investments (14:00)
-
LBO Model: Sources & Uses (17:20)
-
IRR vs. Cash on Cash Multiples in Leveraged Buyouts and Investments (14:00)
-
LBO Model – Debt Schedules & Interest Expense (Dell Case Study Part 3) (29:59)
-
LBO Model – Add-On Acquisitions (Dell Case Study Part 4) (35:40)
-
LBO Exit Strategies: M&A, IPOs, and Dividends / Recapitalizations (20:37)
Financial Statement Analysis
-
Leveraged Buyout – Debt Equity Ratio (19:48)
-
How to Use Cash Flows in an LBO Model: Debt, Dividends, and “Dough” (11:00)
-
Why Do You Use Net Income to Calculate Return on Assets (ROA)? (10:54)
-
Non-Recurring Charges on the Income Statement (21:15)
-
Operating Leverage: Calculation and Meaning (22:07)
-
Free Cash Flow Conversion Analysis (15:04)
-
Free Cash Flow Conversion Analysis (15:04)
-
Free Cash Flow Example (FCF) and Formulas (26:52)
-
Change in Working Capital: Calculations and Meaning (19:40)
-
What is Free Cash Flow? Full Explanation and Tutorial (21:49)
REIT Modeling
Equity Value & Enterprise Value
-
Enterprise Value: Why You Add and Subtract Items (23:39)
-
Why You Subtract Equity Investments (Associate Companies) in Enterprise Value (12:09)
-
Equity Value vs. Enterprise Value and Valuation Multiples (10:24)
-
Can Enterprise Value Be Negative? What About Equity Value? (14:49)
-
How to Calculate Enterprise Value: Enterprise Value Calculation
-
Enterprise Value vs Equity Value – Sample Technical Guide and Excel Files
Bank Modeling
-
The Allowance for Loan Losses for Banks (FIG) (22:17)
-
Price to Book Value Ratio – Interpretation and Derivation (23:02)
-
Dividends Issued & Share Issuances Excel Tutorial – Shawbrook Case Study (23:56)
-
Dividend Discount Model Example for Banks – Shawbrook Case Study (32:37)
-
Deposit Divestitures in Bank Merger Models
-
Bank Balance Sheet to its Income Statement and Cash Flow Statement (32:47)
PowerPoint
-
Building A Company Profile in PowerPoint: Alignment Tricks (12:50)
-
Investment Banking PowerPoint Shortcuts: Full Tutorial and Setup
-
PowerPoint Recommendations Slide: How to Create It (15:30)
-
PowerPoint Sections: How to Create and Order Them (23:02)
-
PowerPoint Connector Lines: How to Add Them and Create Hierarchy Charts
Oil & Gas Modeling
Excel
-
Football Field Valuation Chart with Dynamic Share Price Line [Tutorial Video] (16:54)
-
Excel Tutorial – How to Color Code Financial Models (12:20)
-
Excel Tutorial – Cleaning Up Data with TRIM, PROPER, and Text to Columns (13:49)
-
Excel Tests in Interviews: INDIRECT, MATCH, SUMIFS, and More (14:55)
-
Excel Shortcuts Investment Banking: Quick Tips (10:10)
-
Excel – Circular References (10:39)
-
How To Clean Data in Excel
-
Indirect Index Match – Advanced Formula Tutorial in Excel