Comments ( 6 )

Most Helpful
2y
IWasREPED , what's your opinion? Comment below:

It's kind of difficult give you the specific answer your are looking for. However, as a more general note, what they undoubtedly are trying to gauge is your understanding of real estate finance and to see that you are not complete novice in excel. That being said, in the past what I've seen is generally a simple value-add acquisition of a office/residential building where you have a simple rent roll and some key assumptions relating to expenses, financing, leases, return requirement etc. From there, you generally are expected to model out these cash flows and generate some key metrics such as IRR /EMx/CoC and various sensitivity analyses .

If this is a more senior analyst/associate role, I think the test generally are more complex, perhaps with multiple layers of debt, specific return requirements, draw schedules etc. From what I know about Tristan, the technical test is not their most important step and functions more like a check-the-box. I would focus more on the firm itself and making sure it is a personality fit.

Good luck!

1y
LukSKYWALKER , what's your opinion? Comment below:

Hey , I have an excel test with Tristan next week . Would you mind sharing some details about your test ?

2mo
unnamedchimp , what's your opinion? Comment below:
LukSKYWALKER

Hey , I have an excel test with Tristan next week . Would you mind sharing some details about your test ?

Hey LukSKYWALKER, how was the excel test? Any best tips on how to prepare?

  • VP in RE - Other
1y

The guy above is correct, it is known more for being a lifestyle and culture shop rather than a technical shop doing complex deals. You are best off doing research on the company itself, its founders and story (ex AEW). The model test is likely not a deciding factor, we have interviewed candidates from there over the years. Pretty mixed bag, some were very awful and some were fantastically smart.

  • 1
1d
IIIchmothn , what's your opinion? Comment below:

Nam ab aperiam mollitia est. Voluptatibus unde nostrum est molestiae non. Ducimus repellendus enim vel fugit quia enim.

Reprehenderit impedit omnis nulla ducimus veritatis voluptatem suscipit. Molestiae incidunt magnam modi. Quam illo dolorum mollitia debitis. Et voluptas fugiat repellendus voluptates quod.

Start Discussion

Career Advancement Opportunities

March 2023 Investment Banking

  • Lazard Freres ( + + ) 99.5%
  • Jefferies & Company ( ▽01 ) 99.1%
  • Financial Technology Partners ( = = ) 98.6%
  • Lincoln International ( ▽02 ) 98.2%
  • William Blair ( ▲10 ) 97.7%

Overall Employee Satisfaction

March 2023 Investment Banking

  • William Blair ( ▲04 ) 99.5%
  • Canaccord Genuity ( ▲18 ) 99.1%
  • Lincoln International ( ▲09 ) 98.6%
  • Stephens Inc ( ▲10 ) 98.1%
  • Jefferies & Company ( ▲05 ) 97.7%

Professional Growth Opportunities

March 2023 Investment Banking

  • Financial Technology Partners ( ▲11 ) 99.5%
  • Lazard Freres ( ▲14 ) 99.1%
  • Lincoln International ( = = ) 98.6%
  • Jefferies & Company ( ▽03 ) 98.1%
  • William Blair ( ▲01 ) 97.7%

Total Avg Compensation

March 2023 Investment Banking

  • Director/MD (6) $592
  • Vice President (26) $422
  • Associates (140) $260
  • 3rd+ Year Analyst (9) $194
  • 1st Year Analyst (260) $171
  • 2nd Year Analyst (84) $170
  • Intern/Summer Associate (43) $164
  • Intern/Summer Analyst (192) $92