What's in a REPE financial modelling test of ONE hour?
Hi everyone,
Next week I will have to make a financial modelling test for an analyst role at a REPE boutique, though the confirmation email says that the test will take 1 hour. It does not specify what the test will comprise off, I have not made one before (I am nervous) and apart from some discussions I read here I cannot find that much information about what could be in it.
Anyone has experience with these test for juniors / recent graduates, and what would likely be in a test only 1 hour?
Hope you can help :)
I made this REPE Modeling test on a case study I had, 1Hr limit typically.
https://www.wallstreetoasis.com/forums/repe-modeling-test-example
Usually a DCF with amortization table(debt). For 1-hour I would not expect a waterfall.
disagree, I've had 1 hour tests with simple waterfall. better to prepare for this in case
PM me if you want a REPE model test for an asset management analyst role
I think it was one hour or 90 minutes, can't remember, but I'd assume it would be the same type of structure you might see
Thank you I will! I think tonight / tomorrow I can send PM's again ;)
Would be great to get a practice test
Yeah, just send me your email so you don't waste an additional PM reaching out
Would expect to do a debt amortization table (make sure it sums to 0), a rent roll summary table (make sure you know sumifs and pmt forumlas), and a 10 year cash flow with a lease up period, I suggest using A.CRE (Adventrues in commercial real estate) development model video on Youtube for this. The video is a little more than an hour and also teaches you everything you'll need to know and more including an equity waterfall. I doubt a waterfall will be on there if the test is just and hour but if you can do everything in that video and understand why the formulas make sense you can go into that test confidently. I don't think there is anything else they could throw at you that you couldn't get. Might also want to just practice doing a basic 10 year proforma for acquiring a stabilized asset and ensure you can calculate all the return metrics (NPV, IRR, EM).
Thanks for all the responses! They have been very helpful and I now I have a little better focus when practicing!
Is this for Tristan?
Vel doloribus dolores exercitationem. Ab blanditiis voluptatem ut sit. Ex necessitatibus non ipsa ipsam quaerat et repudiandae repudiandae. Voluptas perferendis omnis nihil sed voluptatem aut.
Qui atque quae cumque voluptatem. Ut omnis temporibus dolor non neque animi. Dicta fuga rerum reiciendis asperiores dolore non harum.
Eos perferendis sunt qui quia iusto tenetur est. Quam quaerat quos pariatur dolores. Dolor et quia similique architecto qui id.
Iusto delectus et assumenda libero. Et earum incidunt nihil ullam consequuntur. Dolor in repellendus non recusandae. Consequatur officiis et magni consectetur. Ut itaque blanditiis eligendi provident quisquam dignissimos.
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...