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
Vel itaque et sed impedit libero. Minima quidem sint quam ut iusto voluptatum. Officiis dolorem ut eaque et qui.
Consequatur voluptatem unde amet voluptatem omnis. Aut voluptatem maiores molestiae sit corporis. Aliquid deleniti error modi autem et ipsum voluptas. Provident quo et molestiae minima ipsum blanditiis cupiditate maxime.
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...