THE REAL ESTATE ASSET MANAGER - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.
The monthly dashboard has no blank version: it arrives empty.

Hold_Refurbish_Sell_Blank.xlsx  (Appendix B, Chapter 6)

   1. Comparison!C5                  109.41
   1. Comparison!C6                  0.086
   1. Comparison!C7                  0
   1. Comparison!C9                  3
   1. Comparison!C10                 0.055
   1. Comparison!C11                 0.086
   1. Comparison!C12                 0.07
   1. Comparison!C13                 0.07
   1. Comparison!C14                 9
   1. Comparison!B18                 5.5
   1. Comparison!C18                 2.8
   1. Comparison!B19                 6
   1. Comparison!C19                 4
   1. Comparison!B20                 6.5
   1. Comparison!C20                 7.6
   1. Comparison!B21                 6.6
   1. Comparison!C21                 7.8
   1. Comparison!B22                 6.7
   1. Comparison!C22                 7.9
   1. Comparison!B27                 0
   1. Comparison!C27                 9
   1. Comparison!B28                 4
   1. Comparison!C28                 3
   1. Comparison!B29                 0
   1. Comparison!C29                 0
   1. Comparison!B30                 0
   1. Comparison!C30                 0
   1. Comparison!B31                 0
   1. Comparison!C31                 0
   2. Chapter 6!C9                   100
   2. Chapter 6!C10                  5.5
   2. Chapter 6!C11                  6
   2. Chapter 6!C12                  4
   2. Chapter 6!C13                  6.5
   2. Chapter 6!C14                  108
   2. Chapter 6!C18                  -100
   2. Chapter 6!C19                  5.5
   2. Chapter 6!C20                  2
   2. Chapter 6!C21                  114.5
   2. Chapter 6!C22                  122
   2. Chapter 6!B39                  0.07

   Result: forward returns 7.14 (hold), 8.49 (refurbish), 5.21 (sell); Chapter 6: 7.13 per cent, 4.33 at half a point wider.

Accept_or_Hold_Out_Blank.xlsx  (Chapter 8)

   1. Net Effective Rent!C5          0.06
   1. Net Effective Rent!B10         100
   1. Net Effective Rent!C10         90
   1. Net Effective Rent!B11         10
   1. Net Effective Rent!C11         10
   1. Net Effective Rent!B12         24
   1. Net Effective Rent!C12         6
   1. Net Effective Rent!B13         0
   1. Net Effective Rent!C13         0
   1. Net Effective Rent!B14         12
   1. Net Effective Rent!C14         10.8
   1. Net Effective Rent!B15         0
   1. Net Effective Rent!C15         0
   1. Net Effective Rent!B16         Strong
   1. Net Effective Rent!C16         Strong
   2. Accept or Wait!C5              95
   2. Accept or Wait!C6              100
   2. Accept or Wait!C7              10
   2. Accept or Wait!C8              6
   2. Accept or Wait!C9              0.6
   2. Accept or Wait!C13             6
   2. Accept or Wait!C14             9
   2. Accept or Wait!C15             2
   2. Accept or Wait!C17             0
   3. Two Offers!B11                 100
   3. Two Offers!C11                 100
   3. Two Offers!B12                 1
   3. Two Offers!C12                 0.85
   3. Two Offers!B14                 5
   3. Two Offers!C14                 10
   3. Two Offers!B15                 3
   3. Two Offers!C15                 0
   3. Two Offers!B16                 9
   3. Two Offers!C16                 6

   Result: net effective rents 78.80 and 84.42; waiting breaks even at 3.08 months and a rent of 105.18; Y secures 582.50 more than X.

Asset_Business_Plan_Blank.xlsx  (Appendix A; the example is invented, not the book's)

   2. Rent Roll!A22                  Ground — Halvers Ltd
   2. Rent Roll!B22                  450
   2. Rent Roll!C22                  Let
   2. Rent Roll!D22                  1.3
   2. Rent Roll!E22                  1.38
   2. Rent Roll!F22                  6.5
   2. Rent Roll!G22                  3.5
   2. Rent Roll!H22                  Strong
   2. Rent Roll!A23                  First — Nyland Group
   2. Rent Roll!B23                  450
   2. Rent Roll!C23                  Let
   2. Rent Roll!D23                  1.2
   2. Rent Roll!E23                  1.38
   2. Rent Roll!F23                  4
   2. Rent Roll!G23                  4
   2. Rent Roll!H23                  Adequate
   2. Rent Roll!A24                  Second
   2. Rent Roll!B24                  450
   2. Rent Roll!C24                  Vacant
   2. Rent Roll!D24                  0
   2. Rent Roll!E24                  1.38
   2. Rent Roll!F24                  0
   2. Rent Roll!G24                  0
   2. Rent Roll!A25                  Third — Camber & Co
   2. Rent Roll!B25                  450
   2. Rent Roll!C25                  Let
   2. Rent Roll!D25                  1.35
   2. Rent Roll!E25                  1.38
   2. Rent Roll!F25                  8
   2. Rent Roll!G25                  8
   2. Rent Roll!H25                  Strong
   2. Rent Roll!A26                  Unit A — Sedge
   2. Rent Roll!B26                  300
   2. Rent Roll!C26                  Let
   2. Rent Roll!D26                  0.75
   2. Rent Roll!E26                  0.8
   2. Rent Roll!F26                  2
   2. Rent Roll!G26                  2
   2. Rent Roll!H26                  Adequate
   2. Rent Roll!A27                  Unit B — Sedge
   2. Rent Roll!B27                  300
   2. Rent Roll!C27                  Let
   2. Rent Roll!D27                  0.78
   2. Rent Roll!E27                  0.8
   2. Rent Roll!F27                  7
   2. Rent Roll!G27                  5
   2. Rent Roll!H27                  Weak
   2. Rent Roll!C59                  0.2
   2. Rent Roll!C60                  0.5
   2. Rent Roll!C61                  0.7
   3. Projection!C5                  100
   3. Projection!C6                  5
   3. Projection!C7                  0.015
   3. Projection!C8                  9
   3. Projection!C9                  9
   3. Projection!C10                 0.12
   3. Projection!C11                 0.6
   3. Projection!C12                 9
   3. Projection!C13                 9
   3. Projection!C14                 0.51
   3. Projection!C15                 0.88
   3. Projection!C16                 0.1
   3. Projection!C17                 0.055
   3. Projection!C18                 0.086
   3. Projection!C19                 0
   3. Projection!C20                 0.05
   3. Projection!C21                 0.07
   3. Projection!A25                 Plant replacement
   3. Projection!B25                 Maintenance
   3. Projection!C25                 3
   3. Projection!D25                 0.4
   3. Projection!E25                 No
   3. Projection!A26                 Reception refurbishment
   3. Projection!B26                 Improvement
   3. Projection!C26                 2
   3. Projection!D26                 0.25
   3. Projection!E26                 No
   3. Projection!A27                 Common-part finishes
   3. Projection!B27                 Maintenance
   3. Projection!E27                 No

   Result: WAULT 5.76, WAULB 4.75, occupancy by rent 80.6%, forward return 8.67%, break-even exit yield 6.02%.

Cost_of_Doing_Nothing_Blank.xlsx  (Appendix F)

   1. The Building!B5                5000
   1. The Building!B6                250
   1. The Building!B8                0.08
   1. The Building!B12               0.6
   1. The Building!B13               3
   1. The Building!B14               8
   1. The Building!B15               1
   1. The Building!B18               4
   1. The Building!B19               0.35
   1. The Building!B20               0.5
   1. The Building!B21               0.1
   1. The Building!B25               0.075
   1. The Building!B26               0.0625
   1. The Building!B27               0.0775
   1. The Building!B28               0.05
   1. The Building!B29               10
   1. The Building!B30               0.02
   2. The Three Routes!B5            1800000
   2. The Three Routes!C5            3200000
   2. The Three Routes!D5            4400000
   2. The Three Routes!B6            12
   2. The Three Routes!C6            30
   2. The Three Routes!D6            30
   2. The Three Routes!B7            0
   2. The Three Routes!B8            yes
   2. The Three Routes!C8            yes
   2. The Three Routes!D8            yes

   Result: cost of doing nothing 4,770,279; value of the void 1,301,868; fabric beats plant by 447,545; buyer's discount 8,317,548.

