Modeling test Wording
Training to transfer. Here a couple of questions that are going to sound dumb but literally stuck atm:
3-hour modeling test for Industrial REPE with a tenancy schedule of 3 units (some vacant, some need capex, different lease price...) freehold + but got a global asking price for all.
Should I run cashflows 1 tab / 1 unit and have 1 tab gathering the 3? (They face the same line item in terms of OPEX and lease type & growth assumptions)
Being Asked to build a tenancy schedule incl. WALE, Rent... Should I just build a simple table resuming all the asked metrics?
Debt assumptions driving me crazy: 50% LTV Fixed 4.5% margin/year, 1% amo, 75bps exit fee.
Does that mean 50% of the asking price (125m) with a blended rate of 5.5% (4.5+1) and 75bps of the loan value in terms of exit fee (when repaid)?
I really don't get the margin / amo should I just add them and work on 5.5% interests/y?
Thank you very much in advance guys!