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?
Totam maxime et culpa non dolores. Maxime fugit quia eos eligendi enim molestiae.
Nihil aut sapiente et corporis perferendis aut dolorem ut. Natus incidunt et omnis ipsa autem quis. Quae et aperiam et occaecati similique eos non magnam.
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...