COMMERCIAL REAL ESTATE INVESTING - BLANK MODEL SET: THE BOOK'S OWN INPUTS

The four blank workbooks share the same two input sheets. Type these into any of them and the book's results come back.
Cell references are sheet!cell.

Inputs sheet

   Inputs!B7         Lettable area, m2                       14200
   Inputs!B8         Purchase price                          26400000
   Inputs!B9         Acquisition costs, share of price       0.068
   Inputs!B16        Rental value growth                     0.0225
   Inputs!B17        Void, months                            9
   Inputs!B18        Letting fee, share of new rent          0.15
   Inputs!B19        Non-recoverables, share of rent         0.0165
   Inputs!B20        Management, share of rent               0.0075
   Inputs!B21        Exit yield                              0.0665
   Inputs!B22        Cost of sale                            0.0125
   Inputs!B27        Loan to value, on the price             0.55
   Inputs!B29        Interest rate                           0.0435
   Inputs!B31        Arrangement fee                         0.011
   Inputs!B37        Asset management fee, on total cost     0.0075
   Inputs!B41        Preferred return                        0.08
   Inputs!B42        Promote                                 0.2
   Inputs!B44        Second gearing, convention test         0.35
   Inputs!C49        Capital programme, year 1               1850000
   Inputs!C50        Capital programme, year 2               940000
   Inputs!C51        Capital programme, year 3               610000

Rent roll sheet (columns: B area, C passing rent, D rental value, E lease expires end of year; 0 = empty at acquisition)

   row 8  Ardgour Logistics                   3150      472500      504000     7
   row 9  Kilmory Print                       1980      257400      316800     3
   row 10  Tannoch Foods                       1640      229600      262400     9
   row 11  Struan Instruments                  1310      183400      209600     5
   row 12  Balvaig Textiles                     980      117600      156800     2
   row 13  Corrour Systems                      860      129000      137600    11
   row 14  Dunardry Media                       720       93600      115200     4
   row 15  Eilanreach Labs                      640       92800      102400     8
   row 16  Unit 9 (empty at acquisition)       1420           0      227200     0
   row 17  Unit 12 (empty at acquisition)      1500           0      252000     0

Results: property return 6.8205%, equity return 8.6647%, investor return 8.0000%, promote 1,748,716;
   attribution averages: plan 2.5923, growth 1.4816, yield 0.6711, leverage 0.4535.
