Wall Street Projections

Now that we have put together the BuyerCo’s historical income statement, let’s focus on projecting the income statement into the future. If the company we are considering is public, it is advisable to use analyst estimates for the first two or three years of the projection period, as available. You can use either Wall Street consensus (an average of analysts’ estimates), or a single analyst research report that is sufficiently detailed and does not deviate far from consensus.

 

Build Financial Models in Minutes

Enterprise-Grade Financial Modeling used by 80,000+ professionals across Investment Banking, Private Equity, and Corporate Finance. Ensure consistency, accuracy, and efficiency across your entire organization.

In the spreadsheet below, we use a single Deutsche Bank research report for BuyerCo to project the P&L for 2008 through 2010. In the absence of any equity research on BuyerCo, make our own projections that might include “flatlining” the results from the last reported year. We’ll cover flatlining in the next step.

Download Template

Download Template

Wall Street Projections

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more