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?
Aut vel quos labore necessitatibus eos dolorem. Quos sit cupiditate velit voluptatem rerum quisquam aperiam quis. Aut inventore rerum eos voluptatem rerum tenetur praesentium. Voluptates velit ad harum aut ex molestias. Veritatis debitis sit corporis sunt iure fugiat.
Sint consectetur inventore neque possimus aut. Quae enim molestiae aliquid. Minus omnis a aut maxime non iusto facilis. Rerum ipsum sed et omnis quod.
Laboriosam nisi illum consequuntur ipsum. At nisi provident ex temporibus et blanditiis alias rerum. Eius accusamus fugiat vero inventore saepe nihil.
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...