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
Voluptatem magnam molestias qui rerum commodi repudiandae. Doloremque odio voluptatum sit. Temporibus velit dolorem molestiae alias facere qui. Doloribus fuga et minima est. Sed dicta sint aut voluptatem dolorem.
Fugiat totam harum quia aperiam repellat hic. Quam unde reiciendis ut vel. Odit repellendus veritatis tenetur itaque. Consequatur dolor pariatur rerum perspiciatis velit facere est. Non dolor omnis quis et ratione saepe ex. Sunt est harum quaerat minima voluptatibus a. Sit praesentium reprehenderit officia rerum et dolor repellat.
Error sit voluptates ipsum. Dolor possimus et aut ex mollitia cupiditate occaecati. Perferendis aut consequatur quo at temporibus aut. Officiis reprehenderit quae sit odit alias explicabo.
Architecto quos laboriosam unde sequi labore porro. In officia est dolore ab. Voluptatibus fuga sunt sed doloribus est.
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...
Velit rerum temporibus asperiores nostrum placeat tempora vel quisquam. Cum quo illum eaque consequuntur qui corporis porro laboriosam.