- November 15, 2018 at 9:24 am #722
There may be an error when a tenant / renewal changes its OpEx recovery percentage.
I’m modeling a tenant being on a gross lease with 0% recovery of OpEx in cell AI13 on the ORI-RR tab that then renews / is replaced by a NNN tenant with 100% recovery (BI13 on the ORI-RR tab). However, if I follow this to the ORI-Calc tab and look at BDP13:BFX13, that change never gets picked up. The error seems to stem from AG13:AQ13 on the OIR-Calc tab. These reference AK13:AU13 on the ORI-RR tab (tenant recovery % detail). The formula on the ORI-Calc tab works if you have the same tenant that change their reimbursements over time, but doesn’t work if you bring in a new tenant that is switching leases.
That leaves me wondering if I’m modeling something wrong because I misunderstand how the model is supposed to work or if there is an error with BI13 on the ORI-RR tab not solving its intent.
- This topic was modified 10 months ago by OzMutz.
- November 16, 2018 at 8:36 am #725
Thanks for pointing this out. It sounds like you’re modeling it correctly, so let me take a look at what’s going on and include a fix in the next update.
- December 12, 2018 at 11:10 am #737This reply has been marked as private.
- December 13, 2018 at 10:56 am #738
Thanks for all of the good work that you do. I just updated my model with the newer version, but it looks like the same error is happening. I see that some of the formulas have been cleaned up, but unless I manually override the formulas in ORI-Calc, it doesn’t work. Is this update coming in the future?
- December 30, 2018 at 11:55 pm #739
I apologize but I had added this to my list of fixes last month but missed it with my early December update. As it turned out, when I changed the ORI rent growth calculation methodology a few updates ago, the expense reimbursement calculation for future generation leases in the ORI module stopped working properly. I’ve made the fix in beta version 0.7 and will push the new version out tomorrow (12/31/2018).
Note that beta version 0.7 also includes the option to refinance the initial senior debt mid-hold.
Thanks for your contribution here!
You must be logged in to reply to this topic.