Wall Street Prep

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

Debt Service Coverage Ratio (DSCR)

If the most important line item in a project finance model is the CFADS, then the most important ratio is the Debt Service Coverage Ratio (DSCR). DSCR is calculated as CFADS divided by debt ... Read More

Cash Flow Available for Debt Service (CFADS)

Cash flow available for debt service (CFADS) is arguably the most important metric in project finance. It determines how much cash is available to all debt and equity investors. Conceptually similar to unlevered free ... Read More

Project Finance vs Corporate Finance

Project finance is the financing of large, long term infrastructure projects. But theoretically, companies can still "corporate finance" an infrastructure project. So what really separates project finance from other types of finance? The answer ... Read More

Project Finance: Free Online Course

Welcome to Wall Street Prep's free online course on Project Finance!  Project finance refers to the funding of large, long term infrastructure projects such as toll roads, airports, renewable energy using a non-recourse financing ... Read More

Impact of TCJA on the Dividends Received Deduction

In addition to the headline impacts of TCJA, a lesser known change affects dividends received deductions ("DRD"). As we discuss in detail in our advanced accounting course, the dividends received deduction ("DRD") exists to ... Read More

Sales & Trading Salary Guide

A sales and trading has a similar comp structure to investment banking, comprised of a base and a bonus. For a sales & trading "Analyst 1" (an analyst's first full year after completing the ... Read More

Investment Banking Managing Director Salary

Managing Directors are at the top of the investment banking food chain.  They are responsible for relationship building with clients and revenue generation for the firm. The investment banking managing director salary (all-in comp) ... 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.