RETAIL 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.
Eighty_Questions.xlsx has no blank version: it arrives empty.

Occupancy_Cost_and_Rent_at_Risk_Blank.xlsx  (Chapters 3, 4, 7, 8, 16)

   1. Costs!B3                       72
   1. Costs!B4                       48
   2. The tape!C4                    7200
   2. The tape!D4                    78
   2. The tape!E4                    5850
   2. The tape!C5                    1850
   2. The tape!D5                    340
   2. The tape!E5                    2950
   2. The tape!C6                    1420
   2. The tape!D6                    355
   2. The tape!E6                    2380
   2. The tape!C7                    640
   2. The tape!D7                    300
   2. The tape!E7                    3100
   2. The tape!C8                    1600
   2. The tape!D8                    265
   2. The tape!E8                    2700
   2. The tape!C9                    880
   2. The tape!D9                    250
   2. The tape!E9                    3050
   2. The tape!C10                   460
   2. The tape!D10                   520
   2. The tape!E10                   5400
   2. The tape!C11                   320
   2. The tape!D11                   300
   2. The tape!E11                   7600
   2. The tape!C12                   2400
   2. The tape!D12                   245
   2. The tape!E12                   6100
   2. The tape!C13                   120
   2. The tape!D13                   700
   2. The tape!E13                   9800
   2. The tape!C14                   380
   2. The tape!D14                   560
   2. The tape!E14                   4900
   2. The tape!C15                   1450
   2. The tape!D15                   330
   2. The tape!E15                   3650
   2. The tape!C16                   3900
   2. The tape!D16                   145
   2. The tape!E16                   2450
   2. The tape!C17                   1250
   2. The tape!D17                   175
   2. The tape!E17                   2900
   2. The tape!C18                   900
   2. The tape!D18                   130
   2. The tape!E18                   2550
   2. The tape!C19                   1180
   2. The tape!D19                   400
   2. The tape!E19                   4300
   2. The tape!H4                    0.035
   2. The tape!H5                    0.14
   2. The tape!H6                    0.14
   2. The tape!H7                    0.14
   2. The tape!H8                    0.14
   2. The tape!H9                    0.13
   2. The tape!H10                   0.11
   2. The tape!H11                   0.06
   2. The tape!H12                   0.06
   2. The tape!H13                   0.09
   2. The tape!H14                   0.12
   2. The tape!H15                   0.12
   2. The tape!H16                   0.07
   2. The tape!H17                   0.09
   2. The tape!H18                   0.09
   2. The tape!H19                   0.1
   4. Around the tape!B7             0.35
   4. Around the tape!B8             0.4
   4. Around the tape!B9             0.18
   4. Around the tape!B10            0.0725
   4. Around the tape!B11            0.0825
   4. Around the tape!B12            0.05
   4. Around the tape!G4             0
   4. Around the tape!G5             0.25
   4. Around the tape!G6             0.6
   4. Around the tape!G7             0.9
   4. Around the tape!B15            44
   4. Around the tape!B16            14
   4. Around the tape!B17            6
   4. Around the tape!B18            10
   4. Around the tape!B19            24
   4. Around the tape!B20            18
   4. Around the tape!B21            22
   4. Around the tape!B22            30
   4. Around the tape!B23            12
   4. Around the tape!B24            26
   4. Around the tape!B25            8
   4. Around the tape!B26            34
   4. Around the tape!B27            16
   4. Around the tape!B28            28
   4. Around the tape!B29            4
   4. Around the tape!B30            20

   Result: rent at risk 904,826 (16.2% of the rent roll), reversion 102,240; anchor departure 1,985,894; restructuring 570,874.

Capacity_and_the_Service_Charge_Blank.xlsx  (Chapters 5 and 15)

   1. Inputs!B3                      72
   1. Inputs!B4                      48
   1. Inputs!B5                      0.015
   1. Inputs!B6                      0.025
   2. Capacity by trade!B4           5850
   2. Capacity by trade!C4           0.035
   2. Capacity by trade!B5           2950
   2. Capacity by trade!C5           0.14
   2. Capacity by trade!B6           3050
   2. Capacity by trade!C6           0.13
   2. Capacity by trade!B7           5400
   2. Capacity by trade!C7           0.11
   2. Capacity by trade!B8           7600
   2. Capacity by trade!C8           0.06
   2. Capacity by trade!B9           6100
   2. Capacity by trade!C9           0.06
   2. Capacity by trade!B10          9800
   2. Capacity by trade!C10          0.09
   2. Capacity by trade!B11          4900
   2. Capacity by trade!C11          0.12
   2. Capacity by trade!B12          2450
   2. Capacity by trade!C12          0.07
   2. Capacity by trade!B13          2900
   2. Capacity by trade!C13          0.09
   2. Capacity by trade!B14          4300
   2. Capacity by trade!C14          0.1

   Result: value operator capacity 51.50 now, 45.42 in ten years; sales growth to stand still 1.81%; leverage 3.33.

The_Ten_Year_Cash_Flow_Blank.xlsx  (Chapters 12 to 14)

   2. Inputs!B3                      72
   2. Inputs!B4                      48
   2. Inputs!B5                      118
   2. Inputs!B6                      0.015
   2. Inputs!B7                      0.025
   2. Inputs!B8                      180
   2. Inputs!B9                      4
   2. Inputs!B10                     2
   2. Inputs!B11                     20
   2. Inputs!B12                     0.15
   2. Inputs!B13                     0.05
   2. Inputs!B14                     0
   2. Inputs!B15                     0
   2. Inputs!B16                     0.085
   2. Inputs!B17                     0.0825
   2. Inputs!B18                     0.065
   2. Inputs!B19                     0.015
   2. Inputs!B20                     66000000
   3. Leases!C3                      7200
   3. Leases!D3                      78
   3. Leases!E3                      5850
   3. Leases!F3                      0.035
   3. Leases!G3                      44
   3. Leases!C4                      1850
   3. Leases!D4                      340
   3. Leases!E4                      2950
   3. Leases!F4                      0.14
   3. Leases!G4                      14
   3. Leases!C5                      1420
   3. Leases!D5                      355
   3. Leases!E5                      2380
   3. Leases!F5                      0.14
   3. Leases!G5                      6
   3. Leases!C6                      640
   3. Leases!D6                      300
   3. Leases!E6                      3100
   3. Leases!F6                      0.14
   3. Leases!G6                      10
   3. Leases!C7                      1600
   3. Leases!D7                      265
   3. Leases!E7                      2700
   3. Leases!F7                      0.14
   3. Leases!G7                      24
   3. Leases!C8                      880
   3. Leases!D8                      250
   3. Leases!E8                      3050
   3. Leases!F8                      0.13
   3. Leases!G8                      18
   3. Leases!C9                      460
   3. Leases!D9                      520
   3. Leases!E9                      5400
   3. Leases!F9                      0.11
   3. Leases!G9                      22
   3. Leases!C10                     320
   3. Leases!D10                     300
   3. Leases!E10                     7600
   3. Leases!F10                     0.06
   3. Leases!G10                     30
   3. Leases!C11                     2400
   3. Leases!D11                     245
   3. Leases!E11                     6100
   3. Leases!F11                     0.06
   3. Leases!G11                     12
   3. Leases!C12                     120
   3. Leases!D12                     700
   3. Leases!E12                     9800
   3. Leases!F12                     0.09
   3. Leases!G12                     26
   3. Leases!C13                     380
   3. Leases!D13                     560
   3. Leases!E13                     4900
   3. Leases!F13                     0.12
   3. Leases!G13                     8
   3. Leases!C14                     1450
   3. Leases!D14                     330
   3. Leases!E14                     3650
   3. Leases!F14                     0.12
   3. Leases!G14                     34
   3. Leases!C15                     3900
   3. Leases!D15                     145
   3. Leases!E15                     2450
   3. Leases!F15                     0.07
   3. Leases!G15                     16
   3. Leases!C16                     1250
   3. Leases!D16                     175
   3. Leases!E16                     2900
   3. Leases!F16                     0.09
   3. Leases!G16                     28
   3. Leases!C17                     900
   3. Leases!D17                     130
   3. Leases!E17                     2550
   3. Leases!F17                     0.09
   3. Leases!G17                     4
   3. Leases!C18                     1180
   3. Leases!D18                     400
   3. Leases!E18                     4300
   3. Leases!F18                     0.1
   3. Leases!G18                     20
   3. Leases!C19                     2050
   3. Leases!D19                     0
   3. Leases!E19                     2450
   3. Leases!F19                     0.07
   3. Leases!G19                     0

   Result: value 44,583,441 net of acquisition costs; exit 57,995,182; IRR at the asking price 2.93%.

Right_Size_Convert_or_Hold_Blank.xlsx  (Chapters 17 and 18)

   2. The test!B3                    5950
   2. The test!B4                    0.07
   2. The test!B5                    2450
   2. The test!B6                    120
   2. The test!B7                    180
   2. The test!B8                    4
   2. The test!B9                    2
   2. The test!B10                   20
   2. The test!B11                   0.15
   2. The test!B12                   0.05
   2. The test!B13                   118
   2. The test!B14                   0.0825
   3. The alternative!B3             85
   3. The alternative!B4             430
   3. The alternative!B5             6
   3. The alternative!B6             60
   3. The alternative!B7             80
   3. The alternative!B8             2
   3. The alternative!B9             2
   3. The alternative!B10            0.1
   3. The alternative!B11            45
   3. The alternative!B12            0.0725
   3. The alternative!B13            0.085
   3. The alternative!B14            118
   4. The decision!B4                44583440.64681441
   4. The decision!B5                42535852.51619194
   4. The decision!B8                466430.1293947804
   4. The decision!B9                1814870.675218223
   4. The decision!B10               640292.4626528225
   4. The decision!B18               0.065

   Result: -1,028,479 as retail; tie rent 47.82; gain from right-sizing 695,692.

