The_Mark_to_Market_Made_Usable_Blank.xlsx  (the book's own figures: chapters 10, 18 and 19, Appendix F)

Sheet 1, rows 6 to 11: tenant, area, in-place, market, years left
   Anchor law firm       25000  41.75  44  2.5
   Technology tenant     18500  36  44  6
   Insurance broker      12000  48.5  44  4
   Regional bank         9500  39  44  1
   Coworking operator    14000  34  44  8.5
   Ground-floor retail   6000  62  66  3.5

Sheet 1, rates and costs
   B14 0.0625
   B15 625000
   B16 175201
   B17 825000
   B18 1875000
   B19 292002
   B20 25000
   B21 0.6
   B24 0.95
   B25 5

Sheet 6, the other four clauses of the bridge (annual effect, value as printed)
   row 24: Gross-up absent from the base year (ch.7-8): -33125, -530000
   row 25: Expense cap, 3% cumulative on controllable costs (ch.8): -18400, -294400
   row 27: Percentage rent on the retail unit at trend sales (ch.3): 39000, 624000
   row 28: Tax reassessment protection given to a major tenant (ch.9): -42000, -672000

Result: in-place 3,510,250, market 3,872,000, time-weighted 4,783,212, net mark-to-market 807,365 at 60 per cent,
a break-even renewal probability of 43.7 per cent, and a clause bridge of -1,102,513.
