Knowledge Base: BIWS Financial Modeling Tutorials

Knowledge Base: BIWS Financial Modeling Tutorials

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)

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

Enterprise Value: Why You Add and Subtract Items (23:39)

Equity Value vs. Enterprise Value and Valuation Multiples (10:24)

From Equity Value to Enterprise Value: “The Bridge” for Target, Vivendi, and Zendesk (24:00)

How to Calculate Enterprise Value: Enterprise Value Calculation

Why You Subtract Equity Investments (Associate Companies) in Enterprise Value (12:09)

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)

Change in Working Capital: Calculations and Meaning (19:40)

Free Cash Flow Conversion Analysis (15:04)

How to Calculate Free Cash Flow and What It Means (16:37)

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 Formula: 4 Methods For Calculation

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)

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

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

Investment Banking “Fit” Questions: Quick Prep (14:11)

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

Investment Banking “Fit” Questions: Quick Prep (14:58)

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

LBO Model – Add-On Acquisitions (Dell Case Study Part 4) (35:40)

LBO Model – Debt Schedules & Interest Expense Tutorial

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)

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)