Aqusitions Excel Test ( Analyst Position)

Hello, Everyone I have an excel test with a REIT acquisitions company coming up and I wanted to know what should I focus on? I am given 30 mins to complete a live exam via zoom. I just need to know what do I focus on?

Thanks

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,667 WSO Academy Reviews

3 Comments

Alpha.Omega

RE

4y

I'd say all your basic functions. Build a model from scratch. Watch videos on YouTube.Btw what is a live exam? Do you have to share screen the whole time? Sounds unbearably unnecessary.

Reply

Quote

Report

Other

Authored by: Certified Real Estate Professional - 1st Year AssociateCertified Real Estate Pro

RE

Analyst 1 in RE - Comm

4y

Most Helpful

I am not familiar with Crown Castle at all, but if it is 30 minutes over zoom, I assume it will be an extremely high-level model. It would be best to focus on unlevered and levered outputs, such as IRR, Emx, distributions, contributions, net profit. Also, they will probably ask you to create an amortization table for the debt. You probably do not need to know how to model out a waterfall, but that would be nice to know. Lastly, it would be good to learn how to use the goal seek function across the board. For instance, let's say you model it out and have an IRR they wish to achieve. You can use that function to determine the purchase price to accomplish that return. Other than that, it will probably consist of basic functions.

Reply

Quote

Report

Other

Real Estate

IB

Analyst 2 in IB - DCM

4y

Qui quod consequuntur provident voluptatum. Incidunt aut voluptates sed impedit. Fugiat recusandae aut recusandae similique ut.

Dolorem ut cupiditate illum eveniet. Provident libero delectus vel quia praesentium iste. Esse excepturi et harum eos illum ut nisi. Excepturi vitae nobis occaecati. Dolorem ipsa eum quibusdam amet eum sint.

Mollitia sequi rerum sit quam nulla. Quod ipsum placeat praesentium earum repellat est. Labore iste qui dolor magni aliquid.

Molestiae aliquam perspiciatis possimus blanditiis et. Ad ea sunt officia atque similique consequuntur incidunt. Blanditiis molestias eum quibusdam. Sed ratione adipisci porro amet.

Reply

Quote

Report

Other

Authored by: Certified Corporate Finance Professional - 2nd Year AnalystCertified Corporate Finance Pro

+32	Are Co-GP development structures successful?	12	1d
+19	Capital Formation/Capital Raising Roles Q	2	2d
+19	How to move from Real Estate to Infrastructure?	15	21h
+13	Multifamily Job Search Advice	3	3d
+9	Insurance company RE investments internship, how is it viewed?	3	1d
+9	How do sponsors structure comp for an acquisitions/development lead? Salary vs. promote vs. dev fee	2	3h
+5	What Are the Biggest Financial Challenges in Custom Home Construction?	2	16h
+5	TA Realty	2	3d
+3	UK Capital Raising Environment	1	4d
+3	Wells Fargo RESF	1	1d

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

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Aqusitions Excel Test ( Analyst Position)

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Aqusitions Excel Test ( Analyst Position)

See All Comments - 100% Free

Trending Content - Real Estate Forum