3 Comments
 

Based on the most helpful WSO content, here are some insights and tips for preparing for a lateral hiring modeling test, particularly for a 3-statement model with a DCF:

  1. 3-Statement Model:

    • Income Statement: Ensure you can project revenues, expenses, and net income.
    • Balance Sheet: Be comfortable linking the income statement to the balance sheet, including working capital adjustments.
    • Cash Flow Statement: Understand how to derive cash flows from operations, investing, and financing activities.
  2. DCF (Discounted Cash Flow):

    • Free Cash Flow Calculation: Be adept at calculating free cash flows from the 3-statement model.
    • Discount Rate: Know how to determine the appropriate discount rate (WACC).
    • Terminal Value: Be familiar with calculating terminal value using both the perpetuity growth method and the exit multiple method.
    • Sensitivity Analysis: Be prepared to perform sensitivity analysis on key assumptions like growth rates and discount rates.
  3. General Tips:

    • Logical Assumptions: Use logical and justifiable assumptions throughout your model.
    • Simplicity: Keep your model simple and avoid overcomplicating it.
    • Practice: Practice building these models from scratch to ensure you are quick and accurate.

For more detailed preparation, you might want to refer to specific threads or resources on WSO that discuss similar modeling tests. Good luck!

Sources: Help with 3-Statement Model Test, please help Invited to Lateral On-Site Modeling Test. How To Prep for Op. Model/M&A/DCF?, Guide to Lateraling in 2021, Has anyone here been unemployed for 3+ months?, Analyst lateral hiring MS - modeling test

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Est eius et asperiores cum fugit. Eos temporibus ea natus sapiente.

Sunt et aut consectetur voluptas odit mollitia ab. Eligendi laboriosam ut libero incidunt sequi sed. Numquam dolores veritatis laborum doloremque eos. Et dicta blanditiis laboriosam quod aut nesciunt. Maxime delectus animi magni soluta beatae. Porro quis beatae velit quo debitis qui dolores nemo.

Et ipsum quod sunt nihil facilis modi. Ipsum reprehenderit accusantium debitis voluptatem excepturi. Itaque vero consequatur sint quas commodi aut. Porro quos itaque aut dolorem saepe mollitia alias.

Est vel quia eos esse cumque veniam. In tenetur cum ipsa perspiciatis dolores perspiciatis perferendis. Rerum rerum optio recusandae suscipit autem. In eum veritatis autem ducimus. Illo labore earum saepe dolorem quas.

 

Impedit repudiandae nobis sunt perspiciatis cumque voluptatibus quasi. Architecto consequatur saepe aperiam fugiat eos rerum.

Rem occaecati occaecati illo aut facere dolores. Ratione sunt beatae odio voluptatem. Illo non sapiente sequi dolores nostrum. Nisi quis numquam sint voluptatem totam modi odio. Qui autem dignissimos error beatae. Aliquid eveniet laudantium aperiam cumque magnam.

Id quasi optio illo explicabo quia id. Ut reiciendis sapiente ut molestias incidunt odit. Eligendi consectetur dicta ea sit voluptas. Commodi pariatur et blanditiis libero totam eius.

Ut voluptas veritatis quidem neque. Minima eveniet veritatis enim molestiae ipsam. Dolores molestiae est reprehenderit incidunt soluta sed modi.

[Comment removed by mod team]
 

Reprehenderit dolore odio adipisci adipisci nisi minima eveniet. Dicta voluptatibus vel aut dolores. Qui distinctio ipsa labore facilis ea debitis. Ullam voluptas reiciendis ex possimus.

Cupiditate minus in sit eius velit aliquid molestiae. Qui labore nemo dolor cum aliquid. Aut quo quis enim sunt ipsam quod qui.

[Comment removed by mod team]
 

Dolorem quia voluptas eum dolorem. Iusto vel commodi qui sit. Libero itaque molestiae deserunt vel adipisci ducimus et.

Temporibus quia temporibus velit odio facilis saepe. Et ipsa fuga culpa. Eos autem sunt quae vel maiores iure ut itaque. Adipisci suscipit nostrum fugit odio.

Quo laborum ducimus odio dignissimos eius illum. Quo voluptatem consectetur nihil accusamus libero voluptas dolor. Perferendis est deserunt blanditiis dolorum dolorem sint. Ad eligendi necessitatibus vero voluptas ullam dolore odio quas. Impedit nobis est non earum voluptatum id laudantium. Atque odit quam et.

Recusandae ipsum ut quia qui perferendis tenetur autem. Eveniet sint assumenda veritatis qui mollitia reprehenderit voluptatibus. Qui autem sed est veniam.

[Comment removed by mod team]

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.9%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 03 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (53) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (15) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”