Wall Street Prep

Financial Modeling Techniques: Sensitivity Analysis ("What if" Analysis)

A financial model is a great way to assess the performance of a business on both a historical and projected basis. It provides a way for the analyst to organize a business’s operations and analyze the results in both a ... Read More

Financial Modeling Techniques: Index & Match

In a prior post, I discussed scenario analysis using the OFFSET function. Today I would like to introduce you to two useful formulas, the “Index” and “Match” functions, which can actually be combined to create an even more useful “super” ... Read More

Financial Concepts: Deferred Taxes

I want to briefly focus on deferred taxes because it's a topic that pops up quite frequently in our public modeling and valuation seminars, as well as our corporate training. It turns out this is a topic that many analysts and associates are not very comfortable ... Read More

Fundamentals and Finance Career Opportunities in the Fog of Recession

Over the past few months, by far the most common questions we have received have to do with the economy as a whole, and more specifically, how it will impact the market for jobs in corporate finance. We are not ... Read More

Top 10 Investment Banking Interview Questions

With the start of a new academic year, we know that finance interviews are again at the forefront of many of your minds. This article is part of a series on the most frequently asked technical finance interview questions and answers across a ... Read More

LBO Analysis on a Cocktail Napkin

As many of you know, we conduct LBO Modeling boot camps across the globe. We get into relatively sophisticated modeling techniques and teach practitioners how to model out various scenarios. But as former analysts and associates ourselves, we still remember ... Read More

Financial Modeling Techniques: Selecting Operating and Financing Scenarios

We would like to introduce you to an important concept in financial modeling: Scenario analysis. This key concept takes your financial model to the next level by allowing you the flexibility to quickly change the assumptions of the model and ... Read More

Balance Sheet Projection Best Practices

In a finance and investment banking interview, candidates will almost certainly be asked questions that test their understanding of the relationship between the balance sheet income statement, and cash flow statement. The reason is that on-the-job modeling is heavily predicated ... Read More

Financial Modeling Techniques

2017 Update: Click here for the new Ultimate Guide to Financial Modeling Conventions and Best Practices.   Because financial modeling requires a great deal of spreadsheet work, most often in Microsoft Excel, I wanted to take the time to highlight some important features ... Read More


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.