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: Definition, Examples, and Formulas (20:30)

Valuation

Precedent Transaction Analysis – 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 (23:31)

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

Debt & Equity

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

Real Estate Modeling

Commercial Real Estate Loan Refinancing: What It Means and Why Investors Do It (16:58)

Real Estate Development Modeling: Equity, Debt Draws, and Optional Repayment

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

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

M&A and Merger Models

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

Accrued Expenses vs Accounts Payable – Interview Question (12:43)

3-Statement Models

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

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

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

How to Calculate Enterprise Value: Enterprise Value Calculation

Enterprise Value vs Equity Value – Sample Technical Guide and Excel Files

Bank Modeling

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)

PowerPoint Sections: How to Create and Order Them (23:02)

PowerPoint Connector Lines: How to Add Them and Create Hierarchy Charts

Oil & Gas Modeling

Oil and Gas Merger Model: Synergy Calculations

NAV Model for Oil & Gas: Revenue Projections

Oil and Gas Revenue Projections: Financial Modeling Tutorial

Type Curves Oil and Gas: Projecting the Production Decline Rate

Net Asset Value Oil and Gas: How to Calculate NAV per Share

Excel

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

Football Field Valuation Chart: How to Create It in Excel

Indirect Index Match – Advanced Formula Tutorial in Excel

Insurance Modeling

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