## Try Our Courses Yourself

### Sample Our Courses And View Our Learning Resources

There’s a world of difference between recorded classroom training sessions or 500-page books vs. our custom-designed interactive learning platform. BIWS allows participants to track their progress, ask questions, interact with the community, test their knowledge, progress faster, and get better results.

Our courses are based on case studies of Wal-Mart, Apple, Microsoft, JP Morgan, Exxon Mobil and more, so participants learn from real-world transactions, not just textbook theory.

There’s no travel, no waiting, and no hassle. All of our digital content is fully downloadable to almost any device, including iPads, iPhones, iPods, and all desktop, laptop, and tablet devices. Participants have complete freedom to learn whenever they want, wherever they want.

### Excellence With Excel - Sample 1 - Cleaning Up Data+

Excellence with Excel Formatting Cleaning Up Data

#### Formatting: Cleaning Up Data

You'll learn how to "clean up" data in this lesson by using the TRIM, PROPER, and CLEAN functions to remove extra spaces, non-printable characters, and fix the capitalization of words – and you'll apply it directly to the customer due diligence file we've been working with.

### Excellence With Excel - Sample 2 - INDEX, MATCH, and INDIRECT+

Excellence with Excel Formulas INDEX, MATCH, and INDIRECT

#### Formulas: INDEX, MATCH, and INDIRECT

You’ll learn how to use the INDEX, MATCH, and INDIRECT functions (as well as ADDRESS) in this lesson to enhance the normal lookup functionality in Excel, and you’ll see how those functions improve upon VLOOKUP and HLOOKUP. We’ll add additional lookup functionality to the customer due diligence file, and then you’ll get to practice on your own with a case study where you compare the financial performance of several REITs and have to work with “messy” data to do so.

### Excellence With Excel - Sample 3 - Creating the Football Field Valuation Graph+

Excellence with Excel Charts and Graphs Creating the Football Field Valuation Graph

#### Charts and Graphs: Creating the Football Field Valuation Graph

In this lesson, you’ll learn how to create the infamous “football field” valuation graph that shows a company’s implied per share value across different methodologies and assumptions, and the 25th quartile to 75th quartile for each one. To complete this graph, we’ll combine the graphing tools we just learned with the LOOKUP and TRANPOSE functions from the previous module.

### Financial Modeling Fundamentals - Sample 1 - Cash Flow Statement+

Financial Modeling Fundamentals Accounting Fundamentals Cash Flow Statement

#### Accounting Fundamentals: Cash Flow Statement

In this lesson, you’ll learn why the Cash Flow Statement is necessary and how to create one based on the company’s other financial statements; you’ll also learn which items are projected on the CFS vs. which ones flow in from elsewhere.

### Financial Modeling Fundamentals - Sample 2 - Merger Model Balance Sheet+

Financial Modeling Fundamentals Merger Model Combining & Adjusting the Balance Sheet

#### Combining & Adjusting the Balance Sheet

In this lesson, you’ll learn how to combine the balance sheets of the buyer and seller and then how to adjust them for acquisition effects to ensure that both sides balance.

### Financial Modeling Fundamentals - Sample 3 - LBO Optional Debt Repayments+

Financial Modeling Fundamentals More Advanced LBO Model Debt Schedules: Optional Repayments

#### Debt Schedules: Optional Repayments

In this video, you’ll learn how to calculate optional repayments for each tranche of debt, how to set up a cash flow sweep, and how to error-check our formulas to make sure we always repay the right amount.

### Advanced Modeling - Sample 1 - Revenue Model+

Advanced Modeling Yahoo! Operating Model Revenue Model Part 1 – Search Advertising

#### Revenue Model Part 1 – Search Advertising

You’ll learn the 3 major methodologies you can use to project revenue in this lesson, and then you’ll use a tops-down approach to estimate Yahoo’s Search Advertising revenue based on Comscore data and market size and share expectations.

### Advanced Modeling - Sample 2 - How to Value NOLs+

Advanced Modeling Yahoo! Valuation Valuing Yahoo’s Net Operating Losses (NOLs)

#### Valuing Yahoo’s Net Operating Losses (NOLs)

In this lesson, you’ll learn how to apply NOLs when modeling a real company’s estimated taxes, and you'll learn 2 different methods to determine the present value of Net Operating Losses – based on tax savings and value to the acquirer in an acquisition.

### Advanced Modeling - Sample 3 - M&A Purchase Price Allocation+

Advanced Modeling Microsoft / Yahoo Merger Model Purchase Price Allocation

#### Purchase Price Allocation, Goodwill and Other Intangibles Creation & Asset Write-Ups

In this lesson, you’ll learn how to properly "divide up" and allocate the purchase price in a merger model, how to calculate new Goodwill created, how to adjust for intangible and tangible asset write-ups, and how to create and write up / write down deferred tax assets and deferred tax liabilities, as well as how to estimate deferred revenue write-downs.

### Advanced Modeling - Sample 4 - LBO Model Mandatory Repayments+

Advanced Modeling Yahoo! LBO Model Debt Schedules – Mandatory Repayments

#### Debt Schedules – Mandatory Repayments

In this lesson, we’ll calculate the annual mandatory repayment for each tranche of debt, and show you how to draw on the revolver when Yahoo’s cash flow is not sufficient to repay its required debt obligations.

### Advanced Modeling - Sample 5 - Book vs. Cash Taxes and NOLs in an LBO+

Advanced Modeling Yahoo! LBO Model Book vs. Cash Tax and NOL Schedule & Deferred Tax Liabilities

#### Book vs. Cash Tax and NOL Schedule & Deferred Tax Liabilities

You’ll learn how to modify our book vs. cash tax, NOL and deferred tax liability schedule from the advanced merger model to handle negative pre-tax income as well as the creation of new NOLs in this lesson.

### Bank Modeling - Sample 1 - BS to IS & Tier 1 Capital+

Bank & Financial Institution Modeling Overview, Bank Accounting & Regulatory Capital Balance Sheet to Income Statement & Tier 1 Capital

#### Balance Sheet to Income Statement & Tier 1 Capital

This video will teach you how to move from a bank’s balance sheet to its income statement, and how the interest-earning assets and interest-bearing liabilities drive many of the income statement line items such as net interest income.

You’ll also get an introduction to different types of capital, including Tier 1 Capital.

### Bank Modeling - Sample 2 - Interest-Earning Assets & Interest-Bearing Liab.+

Bank & Financial Institution Modeling Bank Operating Model Interest-Earning Assets & Interest-Bearing Liabilities

#### Interest-Earning Assets & Interest-Bearing Liabilities

We’ll begin moving from the balance sheet to the income statement in this lesson by projecting JP Morgan’s interest-earning assets and interest-bearing liabilities – and you’ll learn how to project the interest rate spread and the net interest income based on these items.

### Bank Modeling - Sample 3 - Dividend Discount Model+

Bank & Financial Institution Modeling Bank Valuation Dividend Discount Model – Calculating Dividends Issued and Present Value

#### Dividend Discount Model – Calculating Dividends Issued and Present Value

In this lesson, we’ll go through the most important part of a dividend discount model – the circular calculation required to estimate dividends issued based on a minimum Tier 1 Common ratio.

You’ll also learn several methods you can use to calculate the terminal value and how to tie everything together to calculate the present value of equity for JP Morgan.

### Oil & Gas Modeling - Sample 1 - Successful Efforts vs. Full Cost Accounting+

Oil & Gas Modeling Overview, Accounting & Key Metrics Successful Efforts vs. Full Cost Accounting

#### Successful Efforts vs. Full Cost Accounting

In this video, you’ll learn how the income statement and PP&E of an oil & gas company would differ under successful efforts vs. full cost accounting, and you’ll get practice converting between these two accounting standards.

### Oil & Gas Modeling - Sample 2 - Price Hedging and Revenue by Segment+

Oil & Gas Modeling Oil & Gas Operating Model Price Hedging and Revenue by Segment

#### Price Hedging and Revenue by Segment

This lesson will teach you how to take into account the impact of hedging on realized sale prices, and how to set up base, downside, and upside cases. Then we’ll tie together all the revenue assumptions to calculate the total revenue by segment for XTO.

### Oil & Gas Modeling - Sample 3 - NAV – Revenue Projections+

Oil & Gas Modeling Oil & Gas Valuation NAV – Revenue Projections

#### NAV – Revenue Projections

In this video, you’ll learn to project revenue in a NAV model out beyond the traditional 5-year period used in operating models using assumptions for long-term production decline rates and average realized prices.

### Real Estate Modeling - Sample 1 - Apartment Complex Construction+

Real Estate & REIT Modeling Accounting, Overview & Key Metrics Apartment Complex Construction

#### Apartment Complex Construction

In this video, you’ll learn how to estimate the size and cost of constructing an apartment complex and what its stabilized net operating income might be; you will also create a monthly income statement for the complex and estimate monthly construction costs.

### Real Estate Modeling - Sample 2 - Equity and Debt Draws+

Real Estate & REIT Modeling Office Development & Sale Part 3 – Equity and Debt Draws and Optional Repayment

#### Part 3 – Equity and Debt Draws and Optional Repayment

In this lesson, you’ll learn how to allocate the funds required between equity and debt tranches, and how you can ensure that the proper amounts are drawn each month. You will also learn how to project optional debt repayments.

### Real Estate Modeling - Sample 3 - REIT Dispositions and Discontinued Ops.+

Real Estate & REIT Modeling REIT Operating Model REIT Dispositions and Discontinued Operations

#### REIT Dispositions and Discontinued Operations

In this video, you will learn how to project income from discontinued operations for Avalon Bay, including the gain or loss on the sale of real estate assets and net income from those assets. You will also learn how these assumptions affect the rest of the model, including the impact of dispositions on Avalon Bay’s real estate assets in other segments.

### PowerPoint Pro - Sample 1 - Grouping and Aligning Objects+

PowerPoint Pro Grouping, Aligning & Formatting Grouping & Aligning Objects

#### Grouping & Aligning Objects

In this lesson, you’ll get practice fixing a company profile in our pitch book by properly grouping and aligning objects to make sure that all the text and images line up correctly.

### PowerPoint Pro - Sample 2 - Sending Objects Forward and Backward+

PowerPoint Pro Grouping, Aligning & Formatting Sending Objects Forward & Backward

#### Sending Objects Forward & Backward

This video will teach how to properly format the process recommendations slide by ensuring that text and objects appear in the correct positions – and you’ll learn to use the bring forward and send backward commands to do this.