Knowledge Base: BIWS Financial Modeling Tutorials

Discounted Cash Flow Analysis (DCF)

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

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

Valuation

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)

Comparable Company Analysis (CCA) Tutorial (21:36)

Debt & Equity

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

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

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

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

M&A and Merger Models

Negative Goodwill and Bargain Purchases in Merger Models (16:09)

Expense Synergies in Merger Models (20:31)

Earnout Modeling in M&A Deals and Merger Models (21:49)

Merger Model Interview Questions: What to Expect (18:38)

How to Calculate Cash Taxes in a Merger Model – Free Tutorial

Purchase Price Allocation Example – Advanced Tutorial

Merger Model Walkthrough: Combining the Income Statements (28:45)

EPS Accretion Dilution – Rules of Thumb for Merger Models (13:24)

Deferred Tax Liabilities in M&A Deals: Why They Get Created (13:23)

How to Calculate Goodwill in M&A Deals and Merger Models (17:33)

Accounting

IFRS vs US GAAP on the Financial Statements (21:57)

Equity Investments, Part 2: Net Income and Dividends (16:50)

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)

Accounts Receivable on the 3 Financial Statements (11:19)

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

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)

LBO – Returns Attribution Analysis (18:42)

LBO Debt Schedule: Mandatory Repayments (16:59)

Simple LBO Model – Case Study and Tutorial (13:24)

LBO Model Case Study – Dell Example with Excel Templates (23:11)

Financial Statement Analysis

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)

ROIC vs ROE and ROE vs ROA: Key Financial Metrics and Ratios (24:12)

REIT Modeling

REIT NAV Models 101: How to Set Them Up, and What Makes Them Tricky (21:00)

How to Calculate Discontinued Operations for a REIT: Financial Modeling Tutorial

REIT NAV Model: Market Value of Assets (24:38)

Equity Value & Enterprise Value

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

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

Investment Banking PowerPoint Shortcuts: Full Tutorial and Setup

PowerPoint Recommendations Slide: How to Create It (15:30)