The book's own figures

1. The_Diligence_Priced_Blank.xlsx  (Chapters 2 and 19, Appendix F; sheet 1)

   B5    Purchase price                                    24000000
   B6    Net operating income                              1440000
   B7    Equity discount rate                              0.07
   B8    Capitalisation rate for the rent review           0.06
   B11   Roof, quoted cost                                 640000
   B12   Roof, years until incurred                        3
   B13   Lifts, quoted cost                                180000
   B14   Lifts, years until incurred                       1
   B15   Compartmentation, bottom of range                 90000
   B16   Compartmentation, top of range                    260000
   B17   Rent review, rent at risk per year                42000
   B18   Rent review, occupier's prospects                 0.4
   B19   Mezzanine, policy premium                         38000
   B22   Reporting materiality threshold                   50000
   B23   Warranty basket, per cent of price                0.01
   B24   Pre-exclusivity physical investigation            80000
   B25   Bidders in the process                            4
   B28   Building and services survey                      0.004
   B29   Legal title and leases                            0.0035
   B30   Environmental desk study                          0.0004
   B31   Intrusive ground investigation                    0.001
   B32   Measured survey                                   0.0008
   B33   Financial and tax structuring                     0.0025
   B34   Insurance review and placement                    0.0006
   B35   Counterparty and source of funds                  0.0008
   B36   Valuation for lender                              0.001
   B37   Contract and disclosure                           0.003

   The ten fee lines (B28 to B37) are the ones the book's workbook ADDED, anchored on the 80,000 of Chapter 2.
   Result: deduction 690,000, 17.8 bp; full recovery 1,183,000, 31.1 bp; fees 422,400; break-even 2.4% at a million.

2. From_Findings_To_Price_Blank.xlsx, two sets

   Set A, the chapters

   Sheet 1 (Chapter 9): yield 7.00%, no purchaser's costs, quoted income 860,000, arrears over 90 days 41,000
     Permanent:  turnover top-up not supported 14,000; service charge shortfall 38,000
     Temporary:  Tenant 3 step, 24,000 a year for 22 months
     One-off:    rent free 112,000; contribution 85,000; shopfront works 130,000
     Result: verified value 11,171,857, a correction of 1,113,857 (9.1%). Rows 50 to 52 give
     the chapter's reading, the step capitalised in perpetuity: 1,412,714 (11.5%), as printed.
   Sheet 2 (Chapter 10): fees 12%, contingency 10%, discount 7%, no inflation, hold 10 years, no exit test
     Bands: 340,000 in year 0; 610,000 over years 2 to 5; 1,450,000 in year 12
     Result: present value 1,806,819 (printed 1,807,007: the short-term band is 594,756, not 594,944);
     the ask 1,013,636 ("approximately 1,010,000"); against a loaded nominal of 2,956,800, not 2,400,000.
   Sheet 3 (Chapter 19): price 24,000,000, income 1,440,000, discount 7%, capitalisation 6.00%
     Roof D 640,000 year 3, agreed 522,000; lifts D 180,000 year 1, agreed 168,000; compartmentation R 90,000-260,000;
     rent review I 42,000 a year at 40%; mezzanine P 38,000; ground A.
     Result: 690,000 deduction, 260,000 retention, 700,000 cap, 38,000 premium; 17.8 bp; 1,183,000 carried, 31.1 bp.

   Set B, Appendix C

   Sheet 1 (Case 1): yield 6.25%, purchaser's costs 6.00%, quoted income 1,284,000
     Permanent: Unit 2 cap 4,860. Temporary: Unit 3 step 24,000 x 14 months; Unit 4 rent 96,000 x 15 months;
     Unit 4 void costs 21,000 x 9 months. One-off: letting fees 11,520.
     Result: correction 248,628; the naive reduction 2,201,660 (row 49); ratio 11.3%.
   Sheet 2 (Case 2): no fees or contingency, discount 8%, inflation 3%, hold 5, exit income 1,300,000 at 6.50%,
     comparable liability 250,000. Bands: 410,000 year 1; 690,000 year 3; 1,240,000 year 10.
     Result: 1,761,445; ask 989,553; exit deduction 1,134,162, 39 bp; honest ask 739,553.
   Sheet 3 (Case 5): price 32,000,000, income 2,120,000, discount 8%, inflation 3%, capitalisation 6.25% with
     6.00% costs, exit income 2,240,000 at 6.25% in 5 years. Roof D 620,000 year 2 agreed 564,000; fire doors D
     90,000-260,000; right of way PD 34,000; review R 34,000 a year agreed 520,000; tank I 700,000 at 20% cap
     900,000; energy X 15 bp.
     Result: 858,000 deduction, 520,000 retention, 900,000 cap, energy accepted at 571,690. Value carried
     1,511,208: the case prints "roughly 2,142,000", which none of its figures reproduces.

3. Completion_Statement_Blank.xlsx (Chapters 20 and 16; the year is not stated: 2027, not a leap year)

   Sheet 1: price 24,000,000; buyer's first day 16 Mar 2027; rent 360,000 1 Jan-31 Mar RA; service charge 90,000
     1 Jan-31 Mar RA; insurance 48,000 1 Jul 2026-30 Jun 2027 PA; ground rent 24,000 1 Apr 2026-31 Mar 2027 PR;
     deposits 150,000 to the buyer.
     Result: ground rent credit 22,948 (349 days; the chapter uses 74 and prints 4,866); completion
     payment 23,761,123 (printed 23,779,205).
   Sheet 2: value 62,000,000; cash 1,450,000; liabilities 2,100,000; debt 24,000,000; 31 Dec 2026 to 31 Mar 2027;
     4.00% on 365 days; management fee 45,000 of which 22,500 permitted; distribution 250,000, none permitted.
     Result: 37,445,883.56, as printed (37,445,884).
