MF Cash Flow Modeling Interview PREP

Based on the most helpful WSO content, here are some targeted recommendations to prepare for your cash flow modeling test for an Asset Management (AM) role at a developer:

1. Master Key Excel Skills:

   • Focus on dynamic formulas like INDEX-MATCH, OFFSET, and IFERROR to make your models flexible and error-proof.
   • Practice creating dynamic cash flow statements, debt amortization schedules, and equity waterfalls. These are often tested in modeling exams.

2. Understand Core Metrics:

   • Be comfortable calculating and interpreting IRR (Internal Rate of Return), cash-on-cash return, and equity multiple. These are essential for evaluating cash flow performance.
   • Know how to calculate levered vs. unlevered cash flows and how debt impacts returns.

3. Practice Realistic Scenarios:

   • Many tests are based on value-add multi-family or hotel assets. You might be given assumptions like current occupancy, rents, and stabilization timelines. Practice building models from scratch with these inputs.
   • Be prepared to solve for specific targets, such as determining the purchase price that achieves a levered IRR of 18%.

4. Dynamic Modeling:

   • Ensure your model is dynamic and can handle changes in assumptions. For example, if rents or debt terms change, your outputs should update automatically.

5. Prepare for Equity Waterfalls:

   • Familiarize yourself with a basic 2-tier equity waterfall. Understand how to allocate cash flows between investors and sponsors based on preferred returns and promote structures.

6. Scenario Analysis:

   • Practice running different scenarios, such as refinancing, supplemental loans, or sales. This is often part of disposition models and helps assess the impact of capital events on cash flow.

7. Leverage Resources:

   • If you have access to example models, use them to reverse-engineer and understand the logic behind the formulas.
   • Consider reaching out to peers or mentors for feedback on your practice models.

8. Time Management:

   • During the test, focus on building a clean, functional model first. Avoid overcomplicating it. Once the basics are solid, you can add more advanced features if time permits.

9. Written Analysis:

   • Some tests may include a written portion asking whether you would invest in the project you modeled. Be ready to discuss key drivers like rent growth, expense control, and market conditions.

10. Practice Resources:

    • Check out WSO’s financial modeling templates and lessons, which include examples of cash flow modeling, debt schedules, and equity waterfalls. These can be invaluable for honing your skills.

By focusing on these areas, you’ll be well-prepared to tackle the test and demonstrate your ability to build and analyze cash flow models effectively. Good luck!

Sources: Real Estate Modelling Test Practice, Real Estate Modelling Test Practice, Multi-Family Acquisitions Excel Test, https://www.wallstreetoasis.com/forum/real-estate/megafund-repe-modeling-test?customgpt=1, How to break into Real Estate Private Equity (w/ 0 RE Knowledge)