Consumer and Retail Modelling test

Based on the most helpful WSO content, here are some insights for a consumer and retail modeling test, especially for a bulge bracket (BB) bank:

1. 3-Statement Model:

   • Income Statement: Ensure you cover all key metrics, including revenue, cost of goods sold (COGS), operating expenses, and net income.
   • Balance Sheet: Focus on assets, liabilities, and equity. Make sure it balances.
   • Cash Flow Statement: Include operating, investing, and financing activities.

2. DCF (Discounted Cash Flow):

   • Forecast Free Cash Flows: Project the company's free cash flows over a certain period.
   • Terminal Value: Calculate the terminal value using either the perpetuity growth method or the exit multiple method.
   • Discount Rate: Use the Weighted Average Cost of Capital (WACC) to discount the cash flows back to present value.

3. LBO (Leveraged Buyout):

   • Transaction Assumptions: Include purchase price, financing structure, and exit assumptions.
   • Sources and Uses of Funds: Detail how the transaction is financed and where the funds are allocated.
   • Pro Forma Financial Statements: Adjust the financial statements to reflect the new capital structure post-LBO.

Given the 2.5-hour timeframe, the test is likely to be comprehensive but not overly complex. Focus on logical assumptions and keep your models simple yet accurate.

For more detailed preparation, you might want to review the following resources from WSO: - Financial Modeling Best Practices - 3 Statement Model - DCF Modeling Training - LBO Modeling Training

Good luck with your test!

Sources: Help with 3-Statement Model Test, Preparation for 2 hour LBO modelling test, 2-hour Modeling Test for HF (Fundemental Equities) - What to expect?, Interview at CBRE and have to take test, advice?, How to account for SBC in an LBO