Wall Street Prep

5 Hold Shortcuts Every Investment Banker Should Know

If you are an Investment Banker or Consultant, the first type of shortcut you need to master is the Hold Shortcuts as they transcend the entire Microsoft Office Suite. But before we get ahead ... Read More

PowerPoint Shortcuts for Investment Bankers

If you are an Investment Banker or a Consultant, this mini-series is geared to speed up everything you do in Microsoft PowerPoint. That’s because shortcuts are the FASTEST way to double your productivity in ... Read More

Wall Street Prep (WSP) vs Wall Street Oasis (WSO)

Wall Street Prep pioneered the Financial Modeling Self Study Program in 2003 for students and professionals pursuing careers in finance. The program is now used widely at the world's top investment banks, private equity ... Read More

Wall Street Prep (WSP) vs Corporate Finance Institute (CFI)

Wall Street Prep pioneered the Financial Modeling Self Study Program in 2003 for students and professionals pursuing careers in finance. The program is now used widely at the world's top investment banks, private equity ... Read More

Wall Street Prep vs Corporate Finance Institute vs Wall Street Oasis

Many students and professionals considering a career in investment banking, equity research, or private equity think about enrolling in a financial and valuation modeling training program. Prior to 2003, when Wall Street Prep pioneered ... Read More

Demystifying the 13 Week Cash Flow Model in Excel

As the name suggests, a 13-week cash flow model is a weekly cash flow forecast. The 13 week cash flow uses the direct method to forecast weekly cash receipts less cash disbursements. The forecast ... Read More

Common Sections of a Project Finance Model

Below is a simplified representation of a Project finance model structure. Each of these blocks (e.g. “Cons”) represents a different calculation module. The cast of characters here is Ops = Operations, D&T = Depreciation ... Read More

Distinctive Features of a Project Finance Model

Project finance models generally share the following features: Scrutiny on construction, modeled monthly A focus on optimizing debt Long term operations, modeled quarterly or semi-annually Not a going concern, therefore cash focused Hierarchy - ... Read More

Debt sizing Excel Macro for Project Finance: Example with VBA Code

In this article, you'll learn how to build a debt sizing macro commonly used in project finance models.  The debt sizing macro is simply a copy / paste macro, which calculates debt sizing through ... Read More

Debt Sizing in Project Finance

Debt sizing refers to the project finance model mechanics for determining how much debt can be raised to support an infrastructure project. The amount of debt that can be raised is defined in the ... 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.