- October 4, 2017 at 12:47 pm #391
We are exploring the route of acquiring a value add office building. We will likely not take on any debt to start. I have a few questions as it relates to the model. I’m struggling to figure out how to enter an acquisition price of x dollars but also have some sort of development piece layered in. My goal is to acquire the property for x dollars, put x dollars into cap ex per year while leasing the building up and exiting the property in year x. Could you please walk me through how this could be achieved.
- October 4, 2017 at 7:01 pm #392
This is a great question; one that requires more than a simple response on this thread. So, I’m working on a written and video tutorial showing you how I would model the scenario you describe, together with a few other things to keep in mind when using the Ai1 to model value-add opportunities. I hope to have the walkthrough completed by the end of the week, if not sooner. Standby!
- October 4, 2017 at 9:28 pm #395
Here you go:
Let me know if you have other questions.
- October 11, 2017 at 2:31 pm #401
Thank you Spencer, very helpful.
Another question – how do you change the funding method for the construction loan from Loan 1st, Equity 2nd. I see it on the Dev-Data tab but know how to change it.
Thanks in advance – model is one of a kind!
- October 14, 2017 at 2:08 pm #406
The model does not currently support any other sequence but Equity 1st, Debt 2nd. I’ve included an input to change that assumption down the road, but currently no other sequence is available.
- October 11, 2017 at 4:51 pm #402
Also – we are going to have a quick close and wont be able to close with debt. Is there a way to model where you bring in construction debt month 3 and close with all cash. And still take out the construction debt in 36 months with perm debt.
- October 14, 2017 at 2:10 pm #407
There isn’t currently a way to change the funding method for construction debt. It funds once all required equity dollars have been invested, and is paid off at stabilization via the permanent debt.
- October 12, 2017 at 9:35 am #404
One more question – sorry to be a pain but this model is amazing and digging in and learning the functions more and more every day are bringing up more questions. How is the renewal probability calculated on the back end. Like if I have a 50% renewal probability how does that equate on the back end?
- October 14, 2017 at 2:14 pm #408
Sorry for the delayed response – it’s been a very busy week for me!
The renewal probability determines how much in tenant improvements, leasing commissions, free rent, and downtime is charged to the deal. TIs, leasing commission, and free rent are paid at new lease start date based on the ratio of new/renew at the renewal probability percentage. Downtime is charged based on the probability the tenant vacates over the entire downtime period.
You can dig into the renewal probability calcs, and all other backend calcs by showing the Calc tabs. This can been down on the Summary tab.
You must be logged in to reply to this topic.