OFFICE 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.
The eighty-question checklist has no blank version: it arrives empty.

The_Yield_You_Are_Actually_Buying_Blank.xlsx  (Chapters 1, 5 and 6)

   1. Inputs!B3                            12000
   1. Inputs!B4                            3048940
   1. Inputs!B5                            2160
   1. Inputs!B6                            300
   1. Inputs!B7                            0.06
   1. Inputs!B8                            55
   1. Inputs!B9                            43000000
   1. Inputs!B10                           0.065
   1. Inputs!B11                           420
   1. Inputs!B12                           9
   1. Inputs!B13                           9
   1. Inputs!B14                           0.12
   1. Inputs!B15                           5

   Result: net initial yield 6.00%, reversionary 7.39%, capital-adjusted 3.20%, income cliff 1,121.25 per m2.

Headline_to_Net_Effective_Rent_Blank.xlsx  (Chapters 3, 4 and 8)

   2. Headline to net effective!B3         300
   2. Headline to net effective!B4         9
   2. Headline to net effective!B5         420
   2. Headline to net effective!B6         0.12
   2. Headline to net effective!B7         0
   2. Headline to net effective!B8         5
   3. Net effective to headline!B3         220
   3. Net effective to headline!B4         9
   3. Net effective to headline!B5         420
   3. Net effective to headline!B6         0.12
   3. Net effective to headline!B7         5
   5. Break, occupancy, index!B7           12000
   5. Break, occupancy, index!B15          65
   5. Break, occupancy, index!B16          95
   5. Break, occupancy, index!B20          0.0675
   5. Break, occupancy, index!B21          0.06
   5. Break, occupancy, index!B25          300
   5. Break, occupancy, index!B26          0.03
   5. Break, occupancy, index!B27          0.0775

   Result: net effective rent 163.80 (231.90 over ten years), headline 368 for 220 net, 2,506,667 lost to a 15 service charge gap, cap worth 431,544.

The_Ten_Year_Cash_Flow_Blank.xlsx  (Chapters 7 to 21)

   2. Inputs!B3                            300
   2. Inputs!B4                            0.015
   2. Inputs!B5                            420
   2. Inputs!B6                            0.025
   2. Inputs!B7                            3
   2. Inputs!B8                            3
   2. Inputs!B9                            20
   2. Inputs!B10                           0.12
   2. Inputs!B11                           0.06
   2. Inputs!B12                           55
   2. Inputs!B13                           1900000
   2. Inputs!B14                           12
   2. Inputs!B15                           0.0775
   2. Inputs!B16                           0.0675
   2. Inputs!B17                           0.065
   2. Inputs!B18                           0.015
   2. Inputs!B19                           43000000
   3. Leases!B3                            4200
   3. Leases!C3                            318
   3. Leases!D3                            10
   3. Leases!B4                            3100
   3. Leases!C4                            305
   3. Leases!D4                            16
   3. Leases!B5                            1540
   3. Leases!C5                            296
   3. Leases!D5                            26
   3. Leases!B6                            1000
   3. Leases!C6                            312
   3. Leases!D6                            6
   3. Leases!B7                            2160
   3. Leases!C7                            0
   3. Leases!D7                            0
   9. Exit, energy, cliffs!C33             4945816.072908035
   10. Layer and bridge!B4                 300
   10. Layer and bridge!B5                 0.0725
   10. Layer and bridge!B6                 0.095
   11. Debt!B5                             0.0285
   11. Debt!B6                             0.025
   11. Debt!B7                             0.55
   11. Debt!B8                             2
   11. Debt!B9                             0.09

   Result: value 32,551,200, IRR at the asking price 4.32%, layer value 42,772,436, equity IRR 3.27% at the asking price.

Refurbish_Reposition_Convert_or_Sell_Blank.xlsx  (Chapters 14, 17 and 18)

   2. Conversion!B3                        12000
   2. Conversion!B4                        1.176470588235294
   2. Conversion!B5                        0.75
   2. Conversion!B6                        4800
   2. Conversion!B7                        2150
   2. Conversion!B8                        0.1
   2. Conversion!B9                        0.175
   2. Conversion!B10                       2.5
   2. Conversion!B11                       0.08
   2. Conversion!B12                       0.6
   2. Conversion!B13                       0.025
   2. Conversion!B14                       0.065
   6. Office inputs!B3                     300
   6. Office inputs!B4                     0.015
   6. Office inputs!B5                     420
   6. Office inputs!B6                     0.025
   6. Office inputs!B7                     3
   6. Office inputs!B8                     3
   6. Office inputs!B9                     20
   6. Office inputs!B10                    0.12
   6. Office inputs!B11                    0.06
   6. Office inputs!B12                    55
   6. Office inputs!B13                    1900000
   6. Office inputs!B14                    12
   6. Office inputs!B15                    0.0775
   6. Office inputs!B16                    0.0675
   6. Office inputs!B17                    0.065
   6. Office inputs!B18                    0.015
   6. Office inputs!B19                    43000000
   7. Office leases!B3                     4200
   7. Office leases!C3                     318
   7. Office leases!D3                     10
   7. Office leases!B4                     3100
   7. Office leases!C4                     305
   7. Office leases!D4                     16
   7. Office leases!B5                     1540
   7. Office leases!C5                     296
   7. Office leases!D5                     26
   7. Office leases!B6                     1000
   7. Office leases!C6                     312
   7. Office leases!D6                     6
   7. Office leases!B7                     2160
   7. Office leases!C7                     0
   7. Office leases!D7                     0
   E2 As it stands!B4                      248
   E2 As it stands!B6                      90
   E2 As it stands!B8                      5
   E2 As it stands!B9                      5
   E2 As it stands!B10                     12
   E2 As it stands!B17                     0.0775
   E3 Repositioning!B4                     345
   E3 Repositioning!B8                     1
   E3 Repositioning!B9                     2
   E3 Repositioning!B10                    40
   E3 Repositioning!B17                    0.06
   E3 Repositioning!B22                    1250
   E3 Repositioning!B23                    6
   E3 Repositioning!B24                    0.25
   E3 Repositioning!B25                    1.5
   4. Repositioning thresholds!C4          400.9
   4. Repositioning thresholds!C5          524.9

   Result: hold 32,551,200, as it stands 25,403,185, repositioning 24,893,689, conversion 4,945,816; thresholds 400.90 and 524.90.

