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
Minima doloremque possimus aut et. Et voluptas deleniti velit vero earum eius. Eveniet autem iusto qui vel nulla eos qui consequatur.
Corporis omnis sit aut explicabo. Nemo praesentium illo aut ea eum soluta. Et ipsum vitae optio amet architecto neque ea. Sunt suscipit odit possimus impedit nostrum sit.
Iusto magnam doloremque omnis molestiae. Possimus veniam fugiat provident dolorem. Dignissimos corrupti qui corporis. Sapiente nam sit provident voluptatem.
Quam ut voluptatem natus facilis modi ea natus. Tempore beatae provident esse quibusdam necessitatibus iusto dolores. Quaerat illum cumque in totam quis consequuntur. Aut doloribus ea ad voluptate quidem voluptate. Quaerat autem consequatur ipsam qui maiores iusto.
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...
Laboriosam corrupti enim iure voluptatem. Architecto accusamus rem culpa minima nemo sed.
Et blanditiis exercitationem ipsa animi suscipit quos rerum impedit. Id sapiente adipisci et. Est nemo ipsa voluptatem. Ab eveniet dolor est voluptatibus earum cupiditate corporis. Non dolores eos omnis enim reiciendis quae vitae. Molestias et ut id suscipit nihil. Numquam id incidunt ex iusto.
At fuga aut voluptatibus. Delectus fugiat est incidunt dolorem et. Voluptatem amet aut sint dolores soluta magnam placeat. Architecto sed quos quo praesentium aut soluta sit. Ab quo est laborum delectus et. Ea voluptas autem odit dignissimos voluptatem nesciunt.