The book's own figures

1. The_Residual_Appraisal_Blank.xlsx  (Chapter 3)

   The residual!B5                           100
   The residual!B6                           62
   The residual!B7                           8
   The residual!B8                           4
   The residual!B9                           4
   The residual!B10                          0.2
   The residual!B41                          2
   The residual!B42                          5.5
   Reverse and resilience!B5                 8
   Reverse and resilience!B21                6.4
   Cash flow and peak debt!B4                6.4
   Cash flow and peak debt!B5                0.075
   Cash flow and peak debt!B10               0
   Cash flow and peak debt!C10               0
   Cash flow and peak debt!D10               0
   Cash flow and peak debt!E10               4
   Cash flow and peak debt!F10               7
   Cash flow and peak debt!G10               8
   Cash flow and peak debt!H10               9
   Cash flow and peak debt!I10               9
   Cash flow and peak debt!J10               8
   Cash flow and peak debt!K10               7
   Cash flow and peak debt!L10               6
   Cash flow and peak debt!M10               4
   Cash flow and peak debt!N10               0
   Cash flow and peak debt!B11               1.92
   Cash flow and peak debt!C11               1.28
   Cash flow and peak debt!D11               1.28
   Cash flow and peak debt!E11               0.96
   Cash flow and peak debt!F11               0.96
   Cash flow and peak debt!G11               0.96
   Cash flow and peak debt!H11               0.8
   Cash flow and peak debt!I11               0.8
   Cash flow and peak debt!J11               0.8
   Cash flow and peak debt!K11               0.64
   Cash flow and peak debt!L11               0.64
   Cash flow and peak debt!M11               0.48
   Cash flow and peak debt!N11               0.48
   Cash flow and peak debt!B12               0
   Cash flow and peak debt!C12               0
   Cash flow and peak debt!D12               0
   Cash flow and peak debt!E12               0
   Cash flow and peak debt!F12               0
   Cash flow and peak debt!G12               0
   Cash flow and peak debt!H12               0
   Cash flow and peak debt!I12               0
   Cash flow and peak debt!J12               0
   Cash flow and peak debt!K12               0
   Cash flow and peak debt!L12               -20
   Cash flow and peak debt!M12               -40
   Cash flow and peak debt!N12               -40

   Result: residual 6.4; tests 1.4, 2.9, 1.4 and -7.1; cash flow interest 8.00, peak 74.54.

2. The_Pre_Letting_Decision_Blank.xlsx  (Chapter 14 and Appendix H)

   1. The Scheme!B5                          4
   1. The Scheme!B6                          1000
   1. The Scheme!B8                          100
   1. The Scheme!B12                         2
   1. The Scheme!B13                         0.08
   1. The Scheme!B14                         15
   1. The Scheme!B15                         120
   1. The Scheme!B20                         5000000
   1. The Scheme!B21                         0.0575
   1. The Scheme!B22                         0.06
   1. The Scheme!B24                         0.07
   1. The Scheme!B27                         0.045
   1. The Scheme!B28                         24
   1. The Scheme!B29                         0.6
   1. The Scheme!B30                         0.045
   1. The Scheme!B31                         0.72
   1. The Scheme!B32                         0.035
   1. The Scheme!B33                         0.6
   1. The Scheme!B36                         12
   1. The Scheme!B37                         18
   1. The Scheme!B38                         9
   1. The Scheme!B39                         0.1
   1. The Scheme!B40                         0
   1. The Scheme!B23                         0.065
   4. The Comparison!B17                     0.3
   4. The Comparison!C17                     6
   4. The Comparison!D17                     1
   4. The Comparison!B18                     0.35
   4. The Comparison!C18                     12
   4. The Comparison!D18                     1
   4. The Comparison!B19                     0.25
   4. The Comparison!C19                     24
   4. The Comparison!D19                     0.94
   4. The Comparison!B20                     0.1
   4. The Comparison!C20                     30
   4. The Comparison!D20                     0.85

   Result: concession 16,000 a year, 145,727 discounted, 278,261 capitalised; the pre-let wins in every
   outcome up to a 15.3 per cent discount and beats the expected case up to 21.5; the entrance is a 6.0 per cent discount.
   B23 (the empty-building yield) is not used by any formula.
