Can anyone review my modeling test answers? - Super Modelers Wanted
I am currently in a buyside sales role, wanting to break into acquisitions at REPE. Having a modeling test next week. Can somebody review my answer for this modeling test I found in the forum? (Or even better, show me your own?)
I'm already in REPE but I'm basically a sales guy (RFP for funds) and I'm not sure if I'm in the right direction. Any pointers and suggestions would be appreciated.
I know my work is pretty amateur and there's got to be mistakes - the goal here is to finalize a mental template beforehand so my mind doesn't break down in my two-hour test. I'm also interested in what would be an "acceptable range" solution in this kind of two-hour test.
Hi SalesMonkey2448, any of these topics helpful:
If those topics were completely useless, don't blame me, blame my programmers...
Are you paying?
The firm changed their interview policy and mentioned they'll do a take-home (few days) modelling assignment instead of an on-the spot 2 hour one. Thanks for the offer and I just might PM you...
OK, I would be able to check anything you are given. Would do it for a reasonable price.
Thanks for the free Related case study
$125 / hr and I'm all yours.
deleted
NOI / Total debt must 6%
NOI/6% similar to a DSCR metric for non I/O loans
Can I have some input on why this is a "Maximum" debt yield instead of Minimum? I'm assuming this is a metric for the lender's point of view to assess risk of lending like LTV and DSCR.
It would make sense for me if the 6% hurdle was a minimum, but can you share your insights?
Assumed this topic was dead so I had turned off the link - I opened it again now. Looks like I had more people looking at this than I thought.
Thought the topic was dead too so I removed my answer yesterday.
My model should be correct. https://we.tl/t-eyk2qgsZLM
If anyone could teach me how to model a catch up (I understand the concept but not the formula and how it should be tied to the other formulas in the waterfall) it would be really nice.
Thanks for the answer about the debt yield we don't have this in Europe.
I'll PM you a waterfall with catch-up
Hi all, seems like I had a modeling test after all. After the test and subsequent steps I have managed to get the offer! Thanks everyone for the tips and offers.
I’d like to give my thanks and thumbs up to EuReChimp as I tried to replicate his format during the test. This helped me a lot, and saved tons of time.
In comparison to the case study here, it was very similar except the below were some key differences. - Not development, but an existing office. - 5+ tenants with different expiration dates, must model downtime and free rent for new tenants. - New tenants will come in at market rent, where you will have to come up with the right figure based on the location and comps that were given. - 1 page IC memo/investment rationale on Word >> I bought a $200 REFM case study that had this and mimicked this - I added some sensitivities, especially as the market rent was open to different opinions. I laid out some upside and downside case and mentioned this in the IC memo, and got good feedback.
Thanks guys!
Congrats dude, Great firm to land at!
Hell yeah! Love seeing this forum help people.
Hi! Would you mind sharing your complete model? I think the model EuREchimp shared is expired. I'm also preparing for my REPE modeling test and think this would be super helpful!
Thank you!
Might be a dumb question, but when you're calculating your general vacancy, why do you use min(1-general occupancy,0) when your if statement comes out to become false as opposed to just 0? When will this false statement ever trigger the 1-gen occupancy to ever be smaller than 0?
I'm relatively new to this modeling thing.
Does anyone have a completed version of this they could PM me? Would like to see how mine is stacking up.
Bump
Voluptatum maxime veritatis illo animi corrupti placeat assumenda. Sunt et sapiente doloremque modi vel incidunt ut. Ex earum dolor qui eum voluptatem voluptatibus quae. Vero accusamus aut et. Quia tenetur molestiae quidem fuga.
Consequatur doloremque quia aperiam ut delectus. Eum et sapiente voluptates soluta iusto cumque. Praesentium voluptatibus sit reiciendis sed incidunt aut est. Nemo eius qui qui explicabo vero sint. Quaerat aut nulla perspiciatis ex aspernatur at. Perspiciatis vero ipsum aut.
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...
Sunt consequuntur maiores rem nobis voluptatem. Tempora rerum nemo amet porro. Repellendus perferendis velit molestiae assumenda rem. Culpa ipsa rerum cupiditate odio quis consequatur. Est accusantium voluptatem voluptatum vel quo autem consequatur explicabo. Dicta sit dolorum officia odit. Reiciendis fugit maiores quibusdam esse iste quibusdam.