• Model to buy “Property A” for a bid price of say £10m (this would then be varied to ascertain best price to bid at)
• It should also take into account acquisition costs such as agent fees, legal fees, SDLT as % of the above that can be overwritten with a hard figure without compromising model.
• Property A has two different rental tenants at different rents and expiry dates who will be acquired in TOGC purchase of property. It also has 5 residential tenants, different rents and expiry terms
o Tenancy schedule containing pertinent information should be included such as lease start/expiry dates/break clauses/nsa/rent pa/erv/exit yield etc.
o Cashflow function for each tenant with the ability to introduce lease breaks/rent free periods/voids without compromising model.
• Banking for acquisition needs to include input of LTV (say 60%), loan period and arrangement fees/legal fees other costs (as above percentage that can be overwritten is fine)
o Ability to turn amortisation of loan “on and off” would be appreciated, please default to off
o Ability to refinance at interval periods (3 and 5 year) would be appreciated
• Model should be able to ascertain capital required to acquire the property based on inputs above
o It should also be able to suggest where further capital may be required in scenarios where expenditure exceeds income of course
• Project cashflow showing rental income, loan interest etc. on a quarterly basis required.
o Ability to dispose of parts of the property (say all resi after year 1) and 1 retail unit in year 3 as example, with ability to change these assumptions in straightforward manner
o Disposal costs (whether when partial or at exit) need to be included; agent & legal fees
• It should include assumptions and inputs for asset management costs and service charge costs/management
• It should include cashflow waterfalls for PPR and separately investors putting up capital at acquisition (% of quarterly profit that can be overwritten with a hard figure)
• Model should be able to illustrate full exit at different points, say 5, 7 and 10 years
• Exit price should be linked to dynamic exit income and exit yield
o Exit yield needs to be a composite of rent, quality of tenant, wault, cost of bank loan.
• It should track IRR and absolute return at any exit point
• Exec summary tab with headline information would be appreciated.