Wall Street Prep

Best Real Estate Books for Breaking into Real Estate Investing

As a real estate private equity professional, I have certain "must-read" books on my bookshelf.  Below is a list of those books, broken down by book types. Please note that we do not get ... Read More

Advanced LBO Modeling Test: 4 Hour Example (Step-By-Step Tutorial)

Taking a step back, this is the final post in our five-part series on private equity interviews and LBO modeling tests: Top 25 Private Equity Interview Questions – Confirms that you have the baseline ... Read More

Real Estate Financial Modeling Tutorial

BoE multifamily acquisition models are a common method for REPE professionals to quickly model a potential real estate investment without all the dynamic bells and whistles of a full blown model. A BoE model ... Read More

RIP INDEX MATCH? Here’s an example where XLOOKUP Loses [VIDEO]

XLOOKUP has been crowned the new king of Excel reference functions, even defeating the mighty index match. But it's not a complete victory. Here is an example of Index Match (more accurately - INDEX ... Read More

XLOOKUP is Magic: Using XLOOKUP to Generate Multiple Values [VIDEO]

Below is a short tutorial on using XLOOKUP to instantly generate multiple values with just 1 formula. Download the Excel file that goes with this lesson below.

Scenario Analysis Using XLOOKUP [VIDEO]

XLOOKUP simplifies building a scenario analysis significantly.  Why does this matter? In corporate finance, one of the most common use cases for index match was building scenarios. If this video goes a bit too ... Read More

Nested (Two-Way) XLOOKUP vs Index Match Match [VIDEO and Excel File]

As we've discussed in a prior lesson, XLOOKUP is a game changer - replacing VLOOKUP and HLOOKUP and eliminating many use cases where more complicated INDEX MATCH functions needed to be used. In this ... Read More

XLOOKUP in Excel: Why it Rocks and Comparison to VLOOKUP and Index Match [VIDEO]

XLOOKUP is a new Excel function announced in 2019 and broadly released in 2020 that significantly improves some of the most common lookup and reference tasks Excel users encounter on the job. If you're ... Read More

Leveraged Buyout (LBO) Modeling: Standard 1 Hour Practice Test

This LBO Modeling Test usually comes after the more basic "Paper LBO" or Technical Interview Questions you might encounter in earlier rounds.  If you're completely new to this, you should start by reviewing those ... Read More

Cash-Free Debt-Free: Why It’s Used and Impact on Enterprise Valuation

Cash-free debt-free simply means that when an acquirer buys another company, the transaction will be structured such that the buyer will not assume any of the debt on the seller's balance sheet, nor will ... Read More

X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.