Excel Modeling Test for CRE firm

For an Excel modeling test focused on cash-flow modeling for an asset management internship, here are some key areas to prepare:

1. Basic Excel Skills:

   • Ensure you are comfortable with basic Excel functions and shortcuts to improve efficiency.

2. Cash Flow Modeling:

   • Understand the fundamentals of cash flow modeling, including how to project revenues, expenses, and net cash flows.
   • Be familiar with creating and interpreting cash flow statements.

3. Financial Formulas:

   • Practice using financial formulas such as NPV (Net Present Value), IRR (Internal Rate of Return), and other relevant metrics.

4. Excel Functions:

   • Master essential Excel functions like SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, and conditional formatting.

5. Scenario Analysis:

   • Be prepared to perform scenario analysis and sensitivity analysis to show how changes in assumptions impact cash flows.

6. Formatting and Presentation:

   • Ensure your model is well-organized, clearly labeled, and easy to follow. Good formatting can make a significant difference.

For more detailed preparation, you can refer to resources available on Wall Street Oasis, such as: - Financial Modeling Resources - Excel Modeling Training - Financial Modeling Templates

These resources can provide you with templates and best practices to refine your skills. Good luck with your test!

Sources: Best ways to prep Excel & PowerPoint for internship?, How should I prepare to be a good intern?, Advice for summer Asset Management interns, Real Estate Modelling Test Practice, Asset Management Academic Primer for Internships/Grad Programs