Excel Modeling Test for CRE firm

Hi! For an asset management internship this summer (with Brookfield Properties), I have to do an excel modeling test for 1 hour. What should I prepare? They said it would be simpler than property valuation, more like cash-flow modeling....

108 WSO Academy Real Estate Session Reviews: 4.91/5

Class of '29 Sep 2026 Cohort

5.00/5

Real Estate Career Roadmap (optional)

“Nick was extremely informative and gave me a lot of solid and practical advice. He answered all of my questions clearly and thoughtfully. I really appreciated that he gave me an actionable plan for how to approach recruiting and developing my career in general. He was very open about sharing his own experiences. He also gave me helpful perspective on how to differentiate myself during the recruiting process and make my conversations with professionals more meaningful. I feel like I have a clearer understanding of what I should focus on and concrete next steps. This was overall a helpful and valuable conversation. ”

Class of '28 Aug 2026 Cohort

5.00/5

Real Estate Mock Interview

“Nick was fantastic. He didn’t just glance at my resume and give me generic advice—he explained exactly why it wasn’t telling the story I wanted it to tell, then helped me figure out how to fix it. He pushed me to be more intentional about how I talk about my experience and gave me concrete steps to prepare for interviews, from tailoring my resume to practicing financial modeling. I also appreciated how candid he was. When I asked about real estate capital markets versus sales and trading, he gave me his honest opinion while being clear about his own perspective. He shared interview guides, answered all my questions, and offered to do a more detailed mock interview if I move forward with JLL. I left with a lot of work to do, but also a much clearer idea of how to do it. I’d absolutely recommend talking with Nick.”

See All 11,600 WSO Academy Reviews

2 Comments

WSO Monkey Bot

O

1y

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

Basic Excel Skills:
- Ensure you are comfortable with basic Excel functions and shortcuts to improve efficiency.
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.
Financial Formulas:
- Practice using financial formulas such as NPV (Net Present Value), IRR (Internal Rate of Return), and other relevant metrics.
Excel Functions:
- Master essential Excel functions like SUM, AVERAGE, IF, VLOOKUP, HLOOKUP, INDEX, MATCH, and conditional formatting.
Scenario Analysis:
- Be prepared to perform scenario analysis and sensitivity analysis to show how changes in assumptions impact cash flows.
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

Reply

Quote

Report

Other

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

IB

Analyst 1 in IB-M&A

1y

Autem accusamus quisquam tempore error. Quod nulla odit distinctio sit placeat dolore. Est qui quos quos doloribus repellendus eveniet. Maxime assumenda tempora molestiae minus quos ratione et. Quo fugiat qui deserunt dolores et voluptate.

Officia ducimus delectus ea incidunt soluta et tempore soluta. Sint quos ab modi corrupti accusantium. Sint deserunt beatae vero non architecto neque vero. Omnis et maiores veniam. Ut eius quia labore et et qui sint. Cum numquam neque asperiores molestiae voluptas.

Deserunt dolores est quia et perspiciatis eum. Est et distinctio quaerat magnam cumque consequuntur. Quidem beatae dolores sint cupiditate excepturi. Non quam cum repudiandae eius. Consequuntur aut assumenda fugiat qui blanditiis perspiciatis. Eligendi illum autem voluptate et harum eos est ut. Id dignissimos ipsum quidem temporibus voluptatum a possimus.

Fuga perspiciatis sequi est veritatis fuga sapiente id. Praesentium quia temporibus consectetur sint consequuntur iure maxime.

Reply

Quote

Report

Other

+98	Is RE cooked for the medium term? Feels like it	33	8h
+26	The Capital Bifurcation: Private GPs are handing the keys back to Public REITs	11	2d
+18	How to move from Real Estate to Infrastructure?	11	11h
+15	Capital Formation/Capital Raising Roles Q	1	2d
+14	Are Co-GP development structures successful?	4	21m
+13	Multifamily Job Search Advice	3	14h
+9	Insurance company RE investments internship, how is it viewed?	2	5h
+3	What Are the Biggest Financial Challenges in Custom Home Construction?	1	3d
+3	UK Capital Raising Environment	1	1d
+3	TA Realty	2	12h

1	redever	99.2
2	BankonBanking	99.0
3	kanon	99.0
4	Secyh62	99.0
5	GameTheory	98.9
6	CompBanker	98.9
7	DrApeman	98.9
8	dosk17	98.9
9	Betsy Massar	98.9
10	Linda Abraham	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Modeling Test for CRE firm

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Excel Modeling Test for CRE firm

See All Comments - 100% Free

Trending Content - Real Estate Forum