24h - Modeling Test - Analyst Level
Hi guys,
Kind of stuck on a modeling test, would appreciate any help!
1° "You can assume the property will lease up in even tranches over 5 months"
- Does that mean that after the development part (12-Mths) the property is going from 0% to 100% occupancy in 5 months, proportionally?
- Is, 5 month post development, my stabilisation date (Month 17)?
2° "All leases are 12-Mths - 1 month free for new leases but not for renewals"
Do you have any idea on how to model this? I was thinking of starting with a weighed-average of the different unit rent (not taking SF into account but a monthly rent by unit type) and then calculate a percentage of it representing 1 month on the "Rent Free" line. But how can I keep it dynamic and avoid reaching more than 1 month rent free for all units (60 approx.) Using a MIN function on a total Rent free amount maybe?
3° "Purchase price is $X, project will be financed by a loan..., balance of the loan amount to be used to fund development costs and capitalised interest "
Do I assume that the purchase price + purchase costs go with Equity in my source and uses line-item?
May have some other questions but thanks a lot in advance for that!
1. Yes, once the project starts lease up straight line the 60 units over 5 months (i.e., 12 units/month)
2. Have a unit tracker for new leases and renewals (during lease up all units will be new leases, afterward you'll need to make some assumptions about renewal rates) and have a concession line item equal to the market rate rent during that month times the number of new leases in that month (negative obviously.
3. Not totally sure what you're asking here, in a sources and uses the sources will just be equity and debt (or if you have some sort of mezz structure you'd show that too) and uses will be purchase price, closing costs (probably wouldn't get too detailed here for a test), financing costs, etc. You shouldn't be allocating the sources to anything in the uses here, just outlining where you're getting the money from and what you're spending it on in.
Hope this helps
Thanks a lot, that's definitely helpful!
Good luck Baboon.
Quick question:
"The project will be financed with a senior loan, with max loan amount of 70% LTC and subject to max. 50% of the purchase price. The balance of the loan amount to be used to fund development costs and capitalized interest.
The senior loan will have no amortization and a PIK (pay in kind) interest of 5.5%."
Am I right: During the whole life of the senior loan (before refi) I'm not paying amort nor interests but once I am refinancing this loan I'm adding X months of capitalized interests to the balance I have to pay?
Thanks!
The short answer to your question is yes, you'll accrue interest that adds to the balance of the loan. One thing to be careful about here is that as you add interest you have to make sure you don't go over the 70% LTC inclusive of the accrued interest. This ends up being a circular reference in excel (interest costs = higher total costs = higher loan = Higher interest costs = higher total costs, etc.) so you'll need to watch that or use a work around to avoid it.
Thanks again! Just shot the model, we'll see ahah! I think it went well, not perfect but I've shown that I knew how to model on excel and my returns looked ok! I'm supposed to have a call to comment my model.
Thanks a lot for your replies guys!
Qui pariatur quia qui iusto cum. Est dolore neque veniam alias sed.
Ex corporis dolore sint numquam quia qui qui aut. Enim dolores incidunt molestiae modi. Qui dolorem nisi unde provident eum. Cumque dolorem cumque debitis aut pariatur ad facere ut.
Magnam amet aut et similique accusamus possimus. Suscipit fuga impedit minus perferendis. Iste iusto ducimus accusantium omnis velit quia odit.
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...