Hello fellow monkeys,
I am in the interview process for an experienced analyst role at Tishman Speyer and the next phase of the process is the modeling test.
Has anyone taken a modeling test for Tishman Speyer that can provide me with any information? Such as: asset class, development or acquisition, waterfall, and etc?
I have searched online and have found nothing.
I am very thankful for anything you guys can share.
| +74 | Rise48 - Posts Being Removed, Speaking Only Truths | 46 | 1d | |
| +61 | Help Me Understand Office Rationale Today… | 28 | 17h | |
| +60 | Multifamily Outlook | 26 | 22h | |
| +42 | Lender Funded Interest Reserve - Trying to Make Sense | 18 | 1d | |
| +40 | Real Estate DCM or Credit Family Office | 5 | 2d | |
| +31 | Seeking advice - Raising capital for the first time on a solo deal | 5 | 22h | |
| +22 | Long Term Comp Prospect of CRE | 7 | 4d | |
| +21 | Standing out as a new grad applying for analyst roles | 8 | 4d | |
| +20 | PERE 100 / 200 2024 | 16 | 23h | |
| +19 | Agency MF Underwriting Parameters Re: CNA | 1 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Following
I have a copy of the test from last spring. Let me see I I can figure out how to post and will share a link
Please share
Interested, can I pm u?
https://www.dropbox.com/scl/fi/osg7gvzd3h2c4v0ms8hgw/TS-Modeling-Exerci…
Do you have the solution for this model?
Working on this now, for fun. Do we know if the lease rate is FS or NNN? Just trying to figure out if OpEx is reimbursed by the tenant. If so, would free rent be fully abated or just on the base rent?
Thanks so much for sharing!
For fun....
.... On a Friday.....
.... Dear God......
I'd assume FS, since the lease and market rate seem kind of high to be NNN.
Have you solved it?
do you have the completed version?
do you have the completed version?
How was your modeling test?
What kind of questions did you get asked in the model walk-through?
Hey all - just completed the latest version from TS for their "Experienced Analyst" role in SF. Exactly the same test as the linked excel file above. The only difference is the requirement to run a single tiered waterfall structure and create a 1-pager that summarizes all findings.
Thank you this is super helpful, I have an interview coming up now for the same program. Btw, is it just me or is the model template shared above messed up with the dates being weird (some start of month others month end?)
Thank you for the heads up, would it be possible for you to share solved test? I'm trying to check if I've got the same values in my waterfall.
Do you have a copy of the completed test?
Have you interviewed?
How much time was given to complete this?
2 hours
Having trouble figuring out the case study that someone commented before. I already built out my cash flows but I’m lost on how to back into a purchase price and subsequent loan amount at 65% that produces a 15% levered IRR. Can anyone help here?
Can you use goal seek?
Tried that. Doesn’t work.
take year 1 noi and divide by a cap rate to get hypothetical PP. build cashflows and loan amount based off hypothetical PP. then set Lev IRR to .15 by changing cell Purchase price. have loan amount directly tie to that same purchase price cell. hope that helps
Thanks. It works. I thought there woulda been another way but I was just overthinking
Consequatur laborum quia ut id eius. Et voluptatem ratione est alias omnis. Sint aut et exercitationem praesentium animi quia ut. Dolorem ex voluptates ipsam maxime. Cumque cupiditate dolorem fugiat provident.
Nemo est sed asperiores aut ducimus. Minus laborum nobis doloribus et. Dolorum voluptas aut aspernatur laborum repudiandae cumque impedit.
Alias rerum iusto eveniet qui quod. Veniam fugiat quam et laborum. Recusandae est reprehenderit temporibus a in ut quasi. Quisquam sapiente dolor id sed sequi. Temporibus vero voluptatem labore porro et. Et aut fugit nostrum architecto quibusdam repudiandae. Dolorum est suscipit quam suscipit voluptatem sequi quibusdam delectus.
Provident esse odio incidunt in vitae. Qui aliquam voluptatem sunt. Voluptas sit quasi voluptatibus occaecati ipsam quia.
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...
Reprehenderit repellat delectus aut quasi. Velit id est doloremque quia distinctio quidem. Quo aut voluptatem dolorem error. Exercitationem soluta nulla sint eligendi. Rerum accusantium totam aut.
Delectus illum qui magnam inventore. Sapiente sit unde voluptas consequatur. Modi doloribus voluptatem sint sed et. Id eos dolor blanditiis non voluptatem laborum cupiditate repellat.
Tempore ut reprehenderit velit. Tempora magnam corrupti eos aspernatur iste id autem. Vero laborum qui reprehenderit pariatur nobis quod. Debitis corporis ipsum quod maxime perferendis rerum consequatur. Eum nisi illo sed cumque.