LOGISTICS AND INDUSTRIAL REAL ESTATE - 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.
Specification_and_Sixty_Questions.xlsx has no blank version: it arrives empty.

Rent_and_Net_Effective_Blank.xlsx  (Appendix D, Cases 1 and 2)

   Rent and cube!B6                          15000
   Rent and cube!C6                          15000
   Rent and cube!B7                          8
   Rent and cube!C7                          12.5
   Rent and cube!B8                          1.5
   Rent and cube!C8                          1.5
   Rent and cube!B9                          1170000
   Rent and cube!C23                         1300000
   Rent and cube!C24                         10
   Rent and cube!C25                         0.08
   Rent and cube!C39                         94.5
   Rent and cube!C48                         2250
   Rent and cube!C49                         90
   Rent and cube!C50                         300000
   Rent and cube!C51                         120000
   Rent and cube!C52                         400000
   Rent and cube!C56                         0.0575
   Net effective rent!B5                     12000
   Net effective rent!B6                     96
   Net effective rent!B7                     10
   Net effective rent!B8                     10
   Net effective rent!B9                     0.06
   Net effective rent!B10                    0
   Net effective rent!B17                    620000
   Net effective rent!B18                    430000
   Net effective rent!B19                    520000
   Net effective rent!B20                    280000
   Net effective rent!C17                    yes
   Net effective rent!C18                    yes
   Net effective rent!C19                    no
   Net effective rent!C20                    no
   Uplifts!B5                                1000000
   Uplifts!B6                                0.025
   Uplifts!B15                               1000000
   Uplifts!B16                               0.04
   Uplifts!B17                               0
   Uplifts!B20                               0.062
   Uplifts!C20                               0.055
   Uplifts!D20                               0.031
   Uplifts!E20                               0.018
   Uplifts!F20                               0.045

   Result: cube-parity rent 132.00; the band 88.27 to 102.65; net effective rents 80.58, 75.05 and 86.94.

Valuation_and_the_Ageing_Asset_Blank.xlsx  (Appendix D, Cases 4 and 5)

   Net to gross!B6                           20000
   Net to gross!C6                           17500
   Net to gross!B7                           70
   Net to gross!C7                           80
   Net to gross!B9                           1
   Net to gross!C9                           14
   Net to gross!B10                          12
   Net to gross!C10                          3.4
   Net to gross!B13                          0
   Net to gross!C13                          0.06
   Net to gross!B16                          0
   Net to gross!C16                          32000
   Net to gross!B17                          0
   Net to gross!C17                          38000
   Net to gross!B18                          0.005
   Net to gross!C18                          0.025
   Net to gross!B21                          0
   Net to gross!C21                          12000
   Net to gross!B23                          0
   Net to gross!C23                          0.01
   Net to gross!B25                          0
   Net to gross!C25                          22000
   Net to gross!B32                          0.055
   Net to gross!B39                          0.006
   Term and reversion!B5                     26000
   Term and reversion!B6                     22
   Term and reversion!B7                     62
   Term and reversion!B8                     6
   Term and reversion!B9                     0.0625
   Term and reversion!B10                    0.065
   Term and reversion!B24                    26000
   Term and reversion!B25                    12000
   Term and reversion!B26                    4
   Term and reversion!B27                    26000
   Term and reversion!D24                    78
   Term and reversion!D25                    55
   Term and reversion!D26                    62000
   Term and reversion!D27                    11
   Term and reversion!E28                    340000
   Term and reversion!B32                    64
   Term and reversion!B33                    9
   Term and reversion!B34                    12
   Term and reversion!B35                    0.1
   Term and reversion!B36                    26
   Term and reversion!B37                    0.07
   Term and reversion!B62                    850000
   Term and reversion!B63                    6.5
   Term and reversion!B64                    45
   Yield sensitivity!B17                     23771429

   Result: 25,327,273 and 20,544,364; headline yields 5.53 and 6.81 per cent; the honest figure 18,508,808 against 24,217,840.

Development_and_the_Letting_Decision_Blank.xlsx  (Appendix D, Case 3)

   The carry!B5                              18000
   The carry!B6                              4700000
   The carry!B7                              12300000
   The carry!B8                              2800000
   The carry!B13                             21
   The carry!B14                             8
   The carry!B15                             0.06
   The letting decision!B4                   0.0575
   The letting decision!B5                   0.065
   The letting decision!B6                   0.1
   The letting decision!B13                  6
   The letting decision!C13                  12
   The letting decision!D13                  21
   The letting decision!E13                  30
   The letting decision!B14                  84
   The letting decision!C14                  82
   The letting decision!D14                  76
   The letting decision!E14                  0
   The letting decision!B15                  0
   The letting decision!C15                  0
   The letting decision!D15                  12
   The letting decision!E15                  0
   The letting decision!E16                  17500000
   The letting decision!B17                  0.3
   The letting decision!C17                  0.4
   The letting decision!D17                  0.22
   The letting decision!E17                  0.08
   The letting decision!B34                  0.175
   The letting decision!B45                  0.15
   Land residual!B5                          1476000
   Land residual!B6                          0.0575
   Land residual!B7                          0.065
   Land residual!B8                          12300000
   Land residual!B9                          2800000
   Land residual!B10                         0.175
   Land residual!B18                         4700000

   Result: carry 142,500 a month; expected profit 1,186,707 (6.0 per cent); land supported 2,761,027; 29.2 and 8.3 months.

The_Eighteen_Chapters_Blank.xlsx  (Chapters 1 to 18)

   1. Capital intensity!B6                   1000000
   1. Capital intensity!B7                   10
   1. Capital intensity!B8                   0.06
   1. Capital intensity!B9                   1400000
   1. Capital intensity!B10                  900000
   1. Capital intensity!B11                  600000
   1. Capital intensity!B12                  600000
   1. Capital intensity!B13                  300000
   1. Capital intensity!B14                  100000
   2. Height!B6                              20000
   2. Height!B7                              10
   2. Height!B8                              15
   2. Height!B9                              1.5
   2. Height!B10                             1.65
   2. Height!B11                             0.7
   2. Height!B12                             0.42
   2. Height!B13                             5800
   2. Height!B14                             90
   2. Height!B15                             105
   3. Site coverage!B6                       16000
   3. Site coverage!B7                       160
   3. Site coverage!B8                       520
   3. Site coverage!B9                       40000
   3. Site coverage!B10                      29000
   3. Site coverage!B13                      35
   3. Site coverage!B14                      40
   3. Site coverage!B15                      55
   3. Site coverage!B16                      250
   3. Site coverage!B17                      25
   3. Site coverage!B18                      7
   3. Site coverage!B19                      3000
   3. Site coverage!B30                      28
   3. Site coverage!B31                      120
   4. Two sites!B6                           25
   4. Two sites!C6                           5
   4. Two sites!D6                           3
   4. Two sites!E6                           20
   4. Two sites!F6                           5
   4. Two sites!G6                           3
   4. Two sites!B7                           20
   4. Two sites!C7                           2
   4. Two sites!D7                           5
   4. Two sites!E7                           15
   4. Two sites!F7                           2
   4. Two sites!G7                           5
   4. Two sites!B8                           15
   4. Two sites!C8                           4
   4. Two sites!D8                           4
   4. Two sites!E8                           10
   4. Two sites!F8                           4
   4. Two sites!G8                           4
   4. Two sites!B9                           10
   4. Two sites!C9                           3
   4. Two sites!D9                           5
   4. Two sites!E9                           5
   4. Two sites!F9                           3
   4. Two sites!G9                           5
   4. Two sites!B10                          15
   4. Two sites!C10                          2
   4. Two sites!D10                          5
   4. Two sites!E10                          15
   4. Two sites!F10                          5
   4. Two sites!G10                          2
   4. Two sites!B11                          5
   4. Two sites!C11                          1
   4. Two sites!D11                          4
   4. Two sites!E11                          5
   4. Two sites!F11                          5
   4. Two sites!G11                          2
   4. Two sites!B12                          10
   4. Two sites!C12                          5
   4. Two sites!D12                          1
   4. Two sites!E12                          30
   4. Two sites!F12                          5
   4. Two sites!G12                          1
   4. Two sites!B22                          15
   5. Occupier cost!B6                       20000
   5. Occupier cost!B7                       90
   5. Occupier cost!B8                       500000
   5. Occupier cost!B9                       300000
   5. Occupier cost!B10                      400
   5. Occupier cost!B11                      32000
   5. Occupier cost!B12                      9000000
   5. Occupier cost!B13                      1200000
   5. Occupier cost!B21                      0.1
   5. Occupier cost!B22                      0.04
   5. Occupier cost!B23                      0.05
   5. Occupier cost!B24                      0.2
   5. Occupier cost!B44                      10
   5. Occupier cost!B45                      3
   6. Renewal!B4                             30000
   6. Renewal!B5                             55
   6. Renewal!B6                             60
   6. Renewal!B7                             1400000
   6. Renewal!B8                             18000000
   6. Renewal!B9                             10
   6. Renewal!B10                            0.08
   6. Renewal!B18                            66
   6. Renewal!B19                            0.055
   6. Renewal!B20                            0.07
   6. Renewal!B21                            10
   6. Renewal!B22                            2000000
   7. Urban!B6                               2400
   7. Urban!B7                               6
   7. Urban!B8                               170
   7. Urban!B9                               3
   7. Urban!B10                              40000
   7. Urban!B11                              15
   7. Urban!B12                              62
   7. Urban!B13                              8
   7. Urban!B14                              0.65
   7. Urban!B15                              1.4
   7. Urban!B35                              1.5
   7. Urban!B36                              1.65
   7. Urban!B43                              60
   7. Urban!B44                              305
   7. Urban!B45                              25
   7. Urban!B46                              14
   7. Urban!B47                              34
   7. Urban!B48                              0.42
   7. Urban!B59                              1320000
   7. Urban!B60                              12000
   7. Urban!B61                              0.07
   7. Urban!B62                              40000
   7. Urban!B63                              0.04
   7. Urban!B64                              0.01
   7. Urban!B65                              55000
   7. Urban!B66                              0.0575
   7. Urban!B79                              25000
   7. Urban!B80                              18
   7. Urban!B81                              3
   8. Cold storage!B4                        20000
   8. Cold storage!B5                        6000000
   8. Cold storage!B6                        750
   8. Cold storage!B7                        2000000
   8. Cold storage!B8                        68
   8. Cold storage!B9                        0.0525
   8. Cold storage!B10                       2100
   8. Cold storage!B11                       5000000
   8. Cold storage!B12                       145
   8. Cold storage!B13                       0.07
   8. Cold storage!B32                       180
   8. Cold storage!B33                       60
   8. Cold storage!B34                       0.055
   8. Cold storage!B35                       40000
   8. Cold storage!B36                       900
   9. Rent review!B4                         1000000
   9. Rent review!B5                         0.025
   9. Rent review!B6                         0.01
   9. Rent review!B7                         0.04
   9. Rent review!B8                         0.005
   9. Rent review!B9                         0.025
   9. Rent review!B10                        0.06
   9. Rent review!B11                        0.045
   9. Rent review!B12                        0.055
   10. Income!B4                             25000
   10. Income!B5                             72
   10. Income!B6                             9
   10. Income!B7                             750000
   10. Income!B8                             500000
   10. Income!B9                             5
   10. Income!B10                            10
   10. Income!B11                            0.06
   10. Income!B39                            45
   10. Income!B40                            60
   10. Income!B46                            4200000
   10. Income!B47                            19000000
   10. Income!B52                            300000
   10. Income!B53                            1850000
   10. Income!B54                            9
   10. Income!B55                            185000
   10. Income!B56                            900000
   10. Income!B63                            62
   10. Income!B64                            0.055
   10. Income!B65                            0.07
   11. Land residual!B4                      120000
   11. Land residual!B5                      0.45
   11. Land residual!B6                      66
   11. Land residual!B7                      0.055
   11. Land residual!B8                      0.065
   11. Land residual!B9                      610
   11. Land residual!B10                     4500000
   11. Land residual!B11                     0.08
   11. Land residual!B12                     0.05
   11. Land residual!B13                     0.1
   11. Land residual!B14                     0.01
   11. Land residual!B15                     250000
   11. Land residual!B16                     0.07
   11. Land residual!B17                     12
   11. Land residual!B18                     0.15
   11. Land residual!B19                     24
   11. Land residual!B20                     0.06
   12. Cost and delay!B4                     40000
   12. Cost and delay!B5                     3600000
   12. Cost and delay!B6                     8000000
   12. Cost and delay!B7                     2400000
   12. Cost and delay!B8                     2000000
   12. Cost and delay!B9                     900000
   12. Cost and delay!B10                    2800000
   12. Cost and delay!B11                    1600000
   12. Cost and delay!B12                    1800000
   12. Cost and delay!B13                    7200000
   12. Cost and delay!B14                    1500000
   12. Cost and delay!B19                    0.07
   12. Cost and delay!B20                    0.05
   12. Cost and delay!B28                    4800000
   12. Cost and delay!B29                    0.07
   12. Cost and delay!B30                    24
   12. Cost and delay!B31                    14
   12. Cost and delay!B32                    72
   12. Cost and delay!B33                    0.055
   12. Cost and delay!B34                    0.065
   12. Cost and delay!B35                    0.1
   12. Cost and delay!B36                    0.01
   12. Cost and delay!B37                    150000
   12. Cost and delay!B51                    1200000
   12. Cost and delay!B52                    1100000
   12. Cost and delay!B53                    1500000
   12. Cost and delay!B54                    180000
   12. Cost and delay!B55                    4
   13. Spec or pre-let!B4                    31000000
   13. Spec or pre-let!B5                    0.07
   13. Spec or pre-let!B6                    450000
   13. Spec or pre-let!B7                    30000
   13. Spec or pre-let!B12                   0.065
   13. Spec or pre-let!B13                   0.1
   13. Spec or pre-let!B14                   0.01
   13. Spec or pre-let!B17                   69
   13. Spec or pre-let!B18                   0.0525
   13. Spec or pre-let!B19                   9
   13. Spec or pre-let!B31                   78
   13. Spec or pre-let!B32                   0.055
   13. Spec or pre-let!B33                   15
   13. Spec or pre-let!E49                   0.3
   13. Spec or pre-let!F49                   0.5
   13. Spec or pre-let!E50                   0.3
   13. Spec or pre-let!F50                   0.3
   13. Spec or pre-let!E51                   0.2
   13. Spec or pre-let!F51                   0.15
   13. Spec or pre-let!E52                   0.12
   13. Spec or pre-let!F52                   0.05
   13. Spec or pre-let!E53                   0.08
   13. Spec or pre-let!F53                   0
   14. Yields!B6                             1400000
   14. Yields!B7                             1750000
   14. Yields!B8                             3
   14. Yields!B9                             0.05
   14. Yields!B10                            0.0525
   14. Yields!B22                            24000000
   14. Yields!B23                            13000000
   14. Yields!B24                            5250000
   14. Yields!B25                            0.04
   14. Yields!B26                            0.02
   14. Yields!B27                            0.3
   14. Yields!B28                            0.03
   14. Yields!B29                            25000
   14. Yields!B44                            2200000
   14. Yields!B45                            2600000
   14. Yields!B46                            1400000
   14. Yields!B47                            0.4
   14. Yields!B54                            1900000
   14. Yields!B55                            1600000
   14. Yields!B56                            6
   14. Yields!B57                            0.06
   14. Yields!B58                            0.065
   15. Ageing asset!B4                       22000
   15. Ageing asset!B5                       55
   15. Ageing asset!B6                       0.06
   15. Ageing asset!B7                       0.065
   15. Ageing asset!B12                      240000
   15. Ageing asset!B13                      220000
   15. Ageing asset!B14                      1870000
   15. Ageing asset!B15                      675000
   15. Ageing asset!B16                      400000
   15. Ageing asset!B17                      350000
   15. Ageing asset!B18                      250000
   15. Ageing asset!B19                      58
   15. Ageing asset!B20                      0.1
   15. Ageing asset!B21                      0.0675
   15. Ageing asset!B22                      0.01
   15. Ageing asset!B23                      0.08
   15. Ageing asset!B41                      900000
   15. Ageing asset!B42                      5.5
   15. Ageing asset!B43                      45
   15. Ageing asset!B44                      15
   16. Roof!B4                               20000
   16. Roof!B5                               8
   16. Roof!B6                               25
   16. Roof!B7                               12
   16. Roof!B8                               25
   16. Roof!B9                               85
   16. Roof!B10                              0.07
   16. Roof!B11                              8
   16. Roof!B12                              0.055
   16. Roof!B13                              0.08
   17. Net income!B4                         1800000
   17. Net income!B5                         0.005
   17. Net income!B6                         9
   17. Net income!B7                         12
   17. Net income!B8                         1200000
   17. Net income!B9                         180000
   17. Net income!B10                        12
   17. Net income!B20                        25000
   17. Net income!B21                        18
   17. Net income!B22                        0.08
   17. Net income!B23                        300000
   17. Net income!B24                        0.05
   17. Net income!B25                        20000
   17. Net income!B26                        0.03
   17. Net income!B27                        0.015
   17. Net income!B28                        5
   17. Net income!B29                        100000
   17. Net income!B30                        0.0525
   17. Net income!B47                        1000000000
   17. Net income!B48                        0.25
   18. Exit timing!B4                        2100000
   18. Exit timing!B5                        2220000
   18. Exit timing!B6                        0.07
   18. Exit timing!B7                        0.065
   18. Exit timing!B8                        180000
   18. Exit timing!B9                        750000
   18. Exit timing!B10                       222000
   18. Exit timing!B11                       3
   18. Exit timing!B12                       0.055
   18. Exit timing!B25                       6
   18. Exit timing!B26                       111000
   18. Exit timing!B27                       400000
   18. Exit timing!B28                       0.05
   18. Exit timing!B40                       0.075
   18. Exit timing!B41                       2600000
   18. Exit timing!B46                       0.65

   Result: every chapter's printed figures, e.g. land residual 4,181,332 (Chapter 11), parity 6.9 months (Chapter 13), roof contract 1,642,567 (Chapter 16), expected gain from waiting 1,586,047 (Chapter 18).

