6-hour Modeling test !?
Hi guys,
First interview done, Great Industrial REPE Fund, received an email for a 6-hour "modelling exam".
Job Title "REPE Debt Analyst", finance team, working on acquisitions but not only (relations with lenders, debt modeling, debt origination...) Not too many employees so varied role.
What can I expect from a 6-hour test!? I'm not from RE neither PE maybe it's their regular 3-hour one but doubled time regarding my profile? Can I ask him for some guidance regarding the exam?
I have a model from their fund that a previous analyst sent me (3-hour), I made it in 25 minutes without the sensitivity analysis and another analyst told me that he's been hired fu***** up his modeling test... I'd be glad to send the "old" test in private message to anyone that can help ahah!
Thanks for your return guys!
PM me
Is it solely 6 hours of modelling, or is it modelling / presentation / discuss output with interviewers?
I can’t see what they would expect if it’s solely modelling, complete overkill. Rather than asking here where we’ll all just speculate I’d email them to confirm what it involves.
Thanks! I emailed them, due to the lockdown (French in London) it’s going to be from home without any presentation I think.
Pm from a previous analyst of the fund: « Sounds like a take home - should take 2hrs. He’s probably giving you flex »
I can remember him saying during the interview « if you go to the next step you’ll receive an excel exam 6-7 hours. Of course you’re not obliged to use the 6 hours »
I’ve worked a lot on acquisition modeling, as the role is based in the debt / finance team I hope it’s going to be an acquisition test still but maybe with the building of an amortization table and let’s say assumptions regarding a development loan first and then another loan?
Agree with above. Maybe 2 hour test, presentation, questions, and then feedback.
Answer from the Principal: "6/7 hours for the test as it involves a case study with an excel modelling exam and preparing a presentation but it is up to you how quickly you submit."
I guess the case study will be "classic" but regarding the presentation I'm trained for DCM... Any materials I can find for this? Thanks a lot guys
Keep it simple, summarise the transaction, outputs showing key figures / credit metrics etc, sensitivity analysis showing at what point they’d breach hypothetical covenants etc. If you are given a location for the transaction include some market info and context as to whether the value sounds reasonable vs. high level market info.
.
Thanks vm guys!
Quick question: Should I use "named cells" or it's worthless for such an excel exam?
3 hours test sent by a previous Analyst at the fund:
" XXX will be assessing the potential acquisition of a 260,000 square foot logistics facility in Rugby, UK on a leveraged basis. Please use the information below to construct a 10 YR cash flow model and the following outputs:
IRR – based on 5 YR hold
Equity multiple – based on 5 YR hold
Stabilized Cash on Cash return
Debt Amortization Schedule – Make reasonable assumptions for the debt
terms
Sensitivity tables (time permitting)"
If anyone has a few minutes I would love to send the pdf of this case, I just have 2-3 questions regarding the expectations!
Cheers
Don't don't don't overcomplicate the model. If using names is your usual style then fine, go for it, but you aren't going to impress anyone or get extra points for knowing how to alt-m-n.
Please for the love of god NEVER used named cells it’s a horrible practice
Why's that?
I don't have any usual style (junior from DCM trying to transfer) I just want to secure a role, not impress anyone. But thanks!
Great, then attempt it yourself.
Don't you think it's unfair on the next person that you're sending the Case Study to someone to provide "guidance" (I.e. hand-hold you)?
Try to get this job on your own merits. Asking questions is fine, so long as general guidance ... but not asking to send them the case and tell you what to do. Not cool, bhruv.
Atque voluptatem voluptate aut ut ea non dignissimos. Et quasi adipisci autem dolor consequatur quis repellendus. Neque omnis sit iusto. Tempora et delectus aut velit. Et ab doloremque enim sunt quidem ducimus suscipit. Illo nihil nihil non non dignissimos consectetur. Ut animi non earum veniam quo excepturi.
Non dolorem ratione a laboriosam quis quis. Et repellat nisi perferendis in. Aspernatur numquam debitis eaque sapiente. Delectus nisi minus eos sint accusamus quisquam et neque.
Quos repellendus cupiditate occaecati et laudantium. Ut ad quibusdam voluptatibus molestiae et consequatur. Voluptatem nesciunt maxime doloremque ratione et blanditiis. Ratione et voluptatum nihil ut voluptatem. Exercitationem adipisci aut aliquam possimus officia sint. Et sit quo non amet.
Ab repellendus sunt voluptates. Odio officia aliquam omnis fugiat esse quibusdam. Iusto itaque eius quia et et est ipsa. Porro non rerum harum eum est eum.
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...