Modeling Test Solution is driving my crazy
Hi guys,
I received feedbacks for a modeling test I took for an Analyst Position and I'm currently stuck.
It was a 7-hour modeling test from home (yup weird... A previous analyst from the fund sent me his exam from 2018: an extremely easy 3-hour acquisition model that you can do in 25minutes...)
1st question:
"Combine the London1 asset and London 2 asset cashflows on a calendar quarter basis. The residual values can be totalled to the nearest calendar quarter, i.e. an April residual value can be treated as a March value."
(I'm going to try to be clear as possible)
In the solution if we take the sheet where he grouped the 2 assets, for the Potential Base rent we have a result that is equal to London 1 Potential Base Rent Q1 + London 2 Potential Base Rent Q1 but the formula is really different...
(In some blank cell he wrote "2/3")
Formula wrote to find the combined Potential Base Rent:
London2 Potential Base Rent Q1+(London1 Potentiel Base Rent Q2(2/3))+(London1 Potential Base Rent Q1(1-(2/3))
Just why ? Must be something obvious but I'm really stuck to work on the solution and learn from my mistakes... He said that they will contact me for follow-up calls but I'm still waiting...
2nd question:
Basically the test was grouping the 2 assets, model debt assumptions (2 scenarii), then find IRR, Waterfall, Refinancing loan...
"a) You have received terms from a lender who is willing to provide total debt that would result in a 2.5x annual NOI ICR once stabilised (NOI for the next 12 months over interest cost for the next 12 months). The interest rate on the debt will be 4% pa, comprised of a 0.5% base rate + 3.5% margin, and the total cost of financing fees are estimated to be 2.25% (including the arrangement fee / legals etc.).
The debt will be issued Day 1 at acquisition in December 2018. On the same tab as the combined cashflows, model the financing fees, as well as the total debt and interest cost each quarter.
b) The lender has also requested that 12 months post stabilisation of the portfolio, there is amortisation of the debt for a period of 1 year at a rate of 1% pa."
I would be curious to know what you would have done to model Debt Assumptions from "2.5x annual NOI ICR" and for the "b)"...
Is it me or it was a really difficult modeling test?
Thanks a lot in advance for your returns!
Come on fellow monkeys
.
I asked some friends (Investment Analyst and Fund Manager in RE AM companies and they were not able to answer)... I've followed several RE modeling courses online and regarding your answer it must be something extremely obvious, I would be glad to get your explanation!
Only thing I can think of is that they're (lazily) assuming some vacancy/bad debt.
Otherwise dumb LMAO
It sounds wrong
Maiores aliquid omnis ut. Magni eum similique ut expedita est. Molestiae officiis officia qui nihil magni aut vitae. Excepturi est et sit sapiente. Ipsam iste voluptatem dolores ullam.
Libero similique corporis est voluptates. Non nisi et corrupti reiciendis consectetur quibusdam cumque recusandae. Tempora illum ratione consequatur at nostrum. Repudiandae nam nulla molestiae esse autem. Voluptates facere sed optio adipisci. Nobis ex magni maxime est odio sunt.
Amet deserunt aut nulla sit. Est itaque illum assumenda adipisci voluptas ducimus. Sapiente id autem sunt numquam rerum repellendus et. Provident nam expedita voluptates nemo culpa sint.
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...