BofA modeling Test

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