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.

Only BIWS Trains Your People and Tracks Progress,
Without The Need For Extensive Management Oversight

Managers have told us they want three things from their training partner:

  1. It must be effective at building high-level skills.
  2. It must be accountable, so you know at a glance who has successfully acquired the skills.
  3. It must be easy to administer and manage.

BIWS Delivers these three benefits much better than traditional classroom training alternatives. Here’s how:

  1. Our training portal allows each trainee to thoroughly master content at their own individual pace, mark their progress and take notes along the way. Staff can’t just "sit through a few days of training". They actually have to acquire the skills that will add value to your firm.
  2. Managers can tell at a glance which staff members have completed the training by simply checking who has been awarded certifications from our rigorous online testing.
  3. All support and Q&A is handled by our expert team on an individualized basis. As a manager, all you really have to do is sign up, point your team members to our portal and wait for each staff member to pass our testing.

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.