Tristan Capital Partners - Excel Modelling Test
2 hour interview which includes a modelling test. Has anyone got any insight into what Tristan might test? Thanks in advance!
2 hour interview which includes a modelling test. Has anyone got any insight into what Tristan might test? Thanks in advance!
+37 | Launching Own Shop | 20 | 34m | |
+34 | Tell Me About a Deal You Worked On - What Do Associates+ Want to Hear When Asked This | 5 | 21h | |
+25 | Quick mental math question | 8 | 20h | |
+23 | “Major markets” | 8 | 6d | |
+20 | Is NYU Schack (BS) worth it for Commercial RE/REPE/REIB | 12 | 1d | |
+19 | Alternative to Starting A Shop | 4 | 17h | |
+17 | Am I right to be kinda pissed about this? | 5 | 35m | |
+15 | Tightest Historical Spreads for CMBS SASB and Conduit | 1 | 2d | |
+15 | Is it easier to make $1m/yr in IB or RE | 18 | 3d | |
+15 | Graduate RE programs / Certificates / Resume Boosters | 1 | 4d |
Career Resources
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!
Hey , I have an excel test with Tristan next week . Would you mind sharing some details about your test ?
Hey, I was wondering if you could share your overview of the financial modelling test with Tristan Capital partners? Any tips/advice would be much appreciated!
Sup dude,
how was the Tristan modelling test? Was it remote or in person? How was long was it? What did it cover?
Hey LukSKYWALKER, how was the excel test? Any best tips on how to prepare?
How was the Tristan test? How long? What did it cover? was it remote or in person?
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.
Anyone heard back after excel test?
Also curious when was everyone asked to do the test?
bump
Aliquid blanditiis ea quo aut rerum dolore. Et fugiat rerum magnam corporis expedita architecto quos iste. Accusantium a numquam aut officiis. Ut sed voluptatem ratione veniam iusto corporis aut. Est autem quaerat deserunt eos adipisci ut eveniet hic. Eos qui minus perspiciatis ex sit accusantium. Cupiditate sed aut maxime consequatur doloribus.
Voluptates et soluta quo consequatur suscipit error. Dolorem neque minus sit debitis omnis. Sequi consectetur illo non officiis occaecati ea.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...