Knowledge Base: BIWS Financial Modeling Tutorials

3-Statement Model Tutorials

Accounting Tutorials

Bank Modeling Tutorials

Debt & Equity Tutorials

Discounted Cash Flow Analysis (DCF) Tutorials

Equity Value & Enterprise Value Tutorials

Excel Tutorials

Financial Statement Analysis Tutorials

Insurance Modeling Tutorials

Interview Tutorials

Leveraged Buyouts and LBO Model Tutorials

M&A and Merger Models Tutorials

Oil & Gas Modeling Tutorials

PowerPoint Tutorials

REIT Modeling Tutorials

Real Estate Modeling Tutorials

Valuation Tutorials

See Premium Course

Knowledge Base: BIWS Financial Modeling Tutorials

3 Statement Model Case Study Video Tutorial (30 Minute Time Limit)

Balance Sheet Forecast: How to Project the Balance Sheet (19:03)

IB Case Studies: 3-Statement Modeling Test (26:05)

Subscription Revenue Model (Netflix) (17:37)

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)

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 vs. Equity Analysis: How to Advise Companies on Financing

IPO Valuation Model (25:44)

Original Issue Discount Debt (OID) Tutorial (12:43)

DCF – Terminal Value – Gordon Growth Method Intuition (24:35)

Unlevered Free Cash Flow Tutorial: Definition, Examples, and Formulas (20:30)

WACC, Cost of Equity, and Cost of Debt in a DCF (17:55)

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)

Insurance Model: Net Written Premiums, Unearned Premiums, and Income Statement

Engineering to Investment Banking – How to Walk Through Your Resume (19:28)

Investment Banking Behavioral Questions: Quick Prep (14:11)

Investment Banking Interviews: How to Tell Your “Story” in 5 Simple Steps (11:39)

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 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)

Leveraged Buyout – Debt Equity Ratio (19:48)

Paper LBO Example: Full Tutorial for Private Equity Interviews

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)

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 LBO Models and 3-Statement 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)