STUDENT HOUSING 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.

Student_Housing_Model_Blank.xlsx

   2. The tape!B5                          184
   2. The tape!C5                          172
   2. The tape!D5                          44
   2. The tape!E5                          14.5
   2. The tape!B6                          126
   2. The tape!C6                          163
   2. The tape!D6                          44
   2. The tape!E6                          13
   2. The tape!B7                          92
   2. The tape!C7                          196
   2. The tape!D7                          44
   2. The tape!E7                          16.5
   2. The tape!B8                          78
   2. The tape!C8                          245
   2. The tape!D8                          44
   2. The tape!E8                          22
   2. The tape!B9                          34
   2. The tape!C9                          281
   2. The tape!D9                          44
   2. The tape!E9                          27
   2. The tape!B10                         6
   2. The tape!C10                         245
   2. The tape!D10                         44
   2. The tape!E10                         30
   3. Assumptions!B4                       0.968
   3. Assumptions!B5                       0.995
   3. Assumptions!B6                       0.011
   3. Assumptions!B7                       0.04
   3. Assumptions!B8                       0.42
   3. Assumptions!B9                       0.115
   3. Assumptions!B10                      0.23
   3. Assumptions!B11                      0.055
   3. Assumptions!B12                      0.31
   3. Assumptions!B13                      1.35
   3. Assumptions!B14                      6
   3. Assumptions!B15                      2
   3. Assumptions!B16                      0.38
   3. Assumptions!B17                      0.62
   3. Assumptions!B18                      0.45
   3. Assumptions!B19                      660
   3. Assumptions!B20                      99
   3. Assumptions!B21                      618
   3. Assumptions!B22                      330
   3. Assumptions!B23                      192
   3. Assumptions!B24                      74
   3. Assumptions!B25                      196
   3. Assumptions!B26                      145
   3. Assumptions!B27                      0.035
   3. Assumptions!B28                      3300
   3. Assumptions!B29                      7
   3. Assumptions!B30                      3
   3. Assumptions!B31                      238
   3. Assumptions!B32                      0.0545
   3. Assumptions!B33                      0.0595
   3. Assumptions!B34                      0.079
   3. Assumptions!B35                      0.031
   3. Assumptions!B36                      0.028
   3. Assumptions!B37                      0.066
   3. Assumptions!B38                      0.012
   3. Assumptions!B39                      10
   3. Assumptions!B40                      46450232.6443084
   3. Assumptions!B43                      0.97
   3. Assumptions!B44                      0.88
   3. Assumptions!B45                      0.32
   3. Assumptions!B46                      130
   3. Assumptions!B47                      0.088
   3. Assumptions!B48                      38
   3. Assumptions!B49                      5
   3. Assumptions!B50                      10830
   3. Assumptions!B51                      5048
   3. Assumptions!B52                      0.028
   3. Assumptions!B53                      11
   3. Assumptions!B54                      0.62
   3. Assumptions!B55                      0.2
   3. Assumptions!B56                      0.05
   3. Assumptions!B57                      0.72
   3. Assumptions!B58                      850
   3. Assumptions!B59                      110
   3. Assumptions!B60                      0.15
   3. Assumptions!B61                      0.8
   3. Assumptions!B62                      2
   3. Assumptions!B63                      68400
   3. Assumptions!B64                      0.74
   3. Assumptions!B65                      33900
   3. Assumptions!B66                      2450
   3. Assumptions!B67                      0.55
   3. Assumptions!B68                      0.125
   3. Assumptions!B69                      400
   3. Assumptions!B70                      0.55
   3. Assumptions!B71                      1.75
   3. Assumptions!B72                      1.25
   3. Assumptions!B73                      0.0565
   3. Assumptions!B74                      1.29
   3. Assumptions!B75                      0.5
   3. Assumptions!B76                      0.025
   3. Assumptions!B77                      0.955
   3. Assumptions!B78                      0.98
   3. Assumptions!B79                      0.1
   13. What a point is worth!B81           210
   13. What a point is worth!C81           195
   13. What a point is worth!B82           0.92
   13. What a point is worth!C82           0.99
   13. What a point is worth!B83           0.62
   13. What a point is worth!C83           0.22
   13. What a point is worth!B84           0.08
   13. What a point is worth!C84           0.38

   Result: collected rate £181.35, RevPAB £173.61, net operating income £2,698,619, the price that leaves £41,728,378, exit share 58.8%.

Letting_Campaign_Tracker_Blank.xlsx

   2. Booking pace!H4                      520
   3. Achieved rate!B4                     184
   3. Achieved rate!C4                     172
   3. Achieved rate!B5                     126
   3. Achieved rate!C5                     163
   3. Achieved rate!B6                     92
   3. Achieved rate!C6                     196
   3. Achieved rate!B7                     78
   3. Achieved rate!C7                     245
   3. Achieved rate!B8                     34
   3. Achieved rate!C8                     281
   3. Achieved rate!B9                     6
   3. Achieved rate!C9                     245
   4. What the pace is worth!B4            520
   4. What the pace is worth!B5            44
   4. What the pace is worth!B8            0.011
   4. What the pace is worth!B17           0.035
   4. What the pace is worth!B19           0.968

   Result: the scheme set up; the weekly lines are yours.

Operating_Cost_Benchmark_Blank.xlsx

   3. The energy lag!B4                    660
   3. The energy lag!B5                    520
   3. The energy lag!B6                    0.4
   3. The energy lag!B7                    2
   3. The energy lag!B8                    0.079
   3. The energy lag!B9                    0.0545
   3. The energy lag!B10                   0.066
   3. The energy lag!B15                   2698619
   3. The energy lag!B18                   143695
   4. What vacancy saves!C4                0.15
   4. What vacancy saves!C5                0.8
   4. What vacancy saves!C6                0
   4. What vacancy saves!C7                0
   4. What vacancy saves!C8                0
   4. What vacancy saves!C9                0
   4. What vacancy saves!C10               0
   4. What vacancy saves!C11               0
   4. What vacancy saves!F6                520
   4. What vacancy saves!F8                181.3476
   4. What vacancy saves!F10               44
   4. What vacancy saves!F12               0.011

   Result: a 40 per cent energy move costs £245,143 over the two-year lag; the fee is erased at 41.9 per cent; five points of vacancy save £4,633. Sheet 4 now reads your cost base from sheet 2, column C: type the book's figures there (column B) to reproduce it.

Bid_Sheet_Blank.xlsx

   2. Asking price to bid!B4               46450233
   2. Asking price to bid!B5               2698619
   2. Asking price to bid!B6               378710
   2. Asking price to bid!B7               0.066
   2. Asking price to bid!B8               41728378
   2. Asking price to bid!B18              3
   2. Asking price to bid!B19              7
   2. Asking price to bid!B20              3300
   2. Asking price to bid!B21              520
   3. What would have to be true!B5        0.968
   3. What would have to be true!C5        1.0406398
   3. What would have to be true!D5        0.995
   3. What would have to be true!B6        0.031
   3. What would have to be true!C6        0.0406871
   3. What would have to be true!D6        Judgement
   3. What would have to be true!B7        0.0595
   3. What would have to be true!C7        0.0501585
   3. What would have to be true!D7        Judgement
   3. What would have to be true!B8        0.028
   3. What would have to be true!C8        -0.0052199
   3. What would have to be true!D8        Judgement

   Result: 10.2 per cent below the asking price, 8.8 per cent on the same convention; 62 basis points of extra yield.

