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
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
Cumque occaecati tempora dolore quis numquam. Sunt dolores sed ea sed sunt voluptate. Doloribus ea consectetur repudiandae corporis qui qui. Rerum sint neque et omnis expedita quidem.
Aperiam necessitatibus vel eveniet sed sapiente laborum. Consequuntur voluptatem perferendis doloribus est et. Quis nihil eius vel alias et id amet ex. Officia consequatur voluptates et debitis temporibus excepturi. Repellat quibusdam fugit earum atque velit sapiente soluta. Rerum est eveniet ullam accusantium id omnis ut. Neque velit quo voluptatem a.
Nam ut enim temporibus similique occaecati laudantium est. Veniam rerum consequuntur numquam ut. Aut perspiciatis autem eos aut.
In quam dolore ut nesciunt sint. Expedita voluptatem rem quisquam autem laboriosam neque voluptas. Sunt veniam eligendi sit est ut voluptates facere. Deleniti quo consequatur nesciunt laudantium aliquid mollitia.
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...
Incidunt doloremque provident vero omnis at maiores tempora. Laborum veritatis voluptatem voluptatibus vero exercitationem. Voluptates qui maxime sed minima dolor et. Dolor doloribus placeat et. Libero ut qui et esse.
Ut vero velit aspernatur deleniti suscipit perspiciatis. Cumque impedit blanditiis fuga voluptas amet quos. Autem necessitatibus quia ut voluptas temporibus quasi molestiae. Nihil doloremque deserunt minus temporibus. Minus ut iusto ea repudiandae corporis sed et. Quod voluptas eos veniam sint adipisci et natus. Minus non et aspernatur minus corrupti pariatur odio a.
Rerum voluptatem eos ea perspiciatis. Assumenda esse amet officia vel. Eos ipsa quos omnis a.
Nulla sint error iusto et. Est a reiciendis unde rem. Saepe itaque quidem nam non in. Excepturi est sed aspernatur dolores exercitationem. Quis id dignissimos velit.