Knowledge Base: BIWS Financial Modeling Tutorials
-
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)
-
IFRS vs US GAAP on the Financial Statements (21:57)
-
Inventory and COGS: LIFO vs FIFO (13:39)
-
Video Tutorial: Net Operating Losses and Deferred Tax Assets
-
Why Gains and Losses are Non-Cash Charges (11:20)
-
Bank Balance Sheet to its Income Statement and Cash Flow Statement (32:47)
-
Bank Regulatory Capital and the Tragic Tale of Silicon Valley Bank and Credit Suisse
-
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)
-
Can Enterprise Value Be Negative? What About Equity Value? (14:49)
-
Enterprise Value vs Equity Value – Sample Technical Guide and Excel Files
-
Equity Value and Enterprise Value in Leveraged Buyouts (13:30)
-
Equity Value and Enterprise Value Interview Questions: What to Expect (17:10)
-
Equity Value vs. Enterprise Value and Valuation Multiples (10:24)
-
How to Calculate Enterprise Value: Examples for Target, Vivendi, and Zendesk (24:00)
-
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)
-
XLOOKUP in Excel: How to Use It, and Whether Or Not It’s a Game-Changer (14:38)
-
Free Cash Flow Conversion Analysis (15:04)
-
How to Calculate Free Cash Flow and What It Means (16:37)
-
Non-Recurring Charges on the Income Statement (21:15)
-
Operating Leverage Formula: 4 Methods For Calculation
-
ROIC vs ROE and ROE vs ROA: Key Financial Metrics and Ratios (24:12)
-
The Change in Working Capital in Valuation and Financial Modeling (29:15)
-
Why Do You Use Net Income to Calculate Return on Assets (ROA)? (10:54)
-
Existing Debt in Leveraged Buyouts: Why It Doesn’t Matter (14:02)
-
How to Use Cash Flows in an LBO Model: Debt, Dividends, and “Dough” (11:00)
-
IRR vs. Cash on Cash Multiples in Leveraged Buyouts and Investments (14:00)
-
LBO – Returns Attribution Analysis (18:42)
-
LBO Exit Strategies: M&A, IPOs, and Dividends / Recapitalizations
-
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)
-
Leveraged Buyout – Debt Equity Ratio (19:48)
-
Paper LBO Example: Full Tutorial for Private Equity Interviews
-
Quick IRR Calculation in LBO Models (20:02)
-
Simple LBO Model – Case Study and Tutorial (13:24)
-
The Cash-Free Debt-Free Basis in M&A Deals and Leveraged Buyouts: What It Means and How to Model It
-
The Dividend Recap in an LBO Model: Full Tutorial
-
Video Tutorial: Bolt-On Acquisitions
-
Video Tutorial: The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models
-
Waterfall Returns Distribution in an LBO Model (19:18)
-
Cost Synergies in M&A Deals and Merger Models: Full Tutorial and Sample Excel Model
-
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)
-
Exchange Ratios in M&A Deals: Fixed, Floating, and Collars (20:05)
-
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 (19:25)
-
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)
-
Purchase Price in M&A Deals: Equity Value or Enterprise Value? (15:28)
-
Section 382 Limitations and Net Operating Losses (NOLs) in the U.S. Tax Code
-
Video Tutorial: Purchase Price Allocation Example and Walkthrough
-
Building A Company Profile in PowerPoint: Alignment Tricks (12:50)
-
How to Duplicate a Shape in PowerPoint: Full Video Tutorial with Written Guide
-
Investment Banking PowerPoint Shortcuts: Full Tutorial and Setup
-
Macros in PowerPoint: Full Tutorial and How to Write VBA Code for a “Swap Multiple Shapes” Macro
-
PowerPoint Maps: How to Create Slides for Global Operations, Teams, and More
-
PowerPoint Quick Access Toolbar: Full Download, Setup, and Guide
-
PowerPoint Sections: How to Create Sections in PowerPoint to Reorganize Presentations Quickly
-
PowerPoint Shortcuts Investment Banking: Quick Tips (13:10)
-
PowerPoint Slide Master: Full Tutorial, Video, and Sample Files
-
Tables in PowerPoint: Full Video Tutorial, Samples, and Practice Exercise
-
The PowerPoint Connector: How to Connect Lines in PowerPoint to Create Diagrams
-
The PowerPoint Recommendations Slide: Full Tutorial, Templates, and Examples from Real Banks
-
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)
-
Comparable Company Analysis (CCA) Tutorial (21:36)
-
EBIT vs. EBITDA vs. Net Income: Valuation Metrics and Multiples Video Tutorial
-
How to Calculate EBITDA (14:11)
-
Levered Free Cash Flow and the Levered DCF: The Most Useless Concepts in Valuation? [PLEASE SEE THE IMPORTANT NOTE BELOW THE VIDEO]
-
Precedent Transaction Analysis: Video Tutorial With Excel Examples
-
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)
-
US GAAP vs. IFRS in Valuation and Financial Modeling (25:50)
-
Video Tutorial: Sum of the Parts (SOTP) Valuation, With Excel Example
-
What Is A Valuation Multiple? (14:35)