Reading_a_Funds_Numbers_Blank.xlsx  (the book's own figures, Appendix J)

Sheet 1, the terms:
   C5  Fund name                              Meridian Growth Partners III
   C6  Commitment                             300
   C7  First year of calls                    2018
   C8  Valuation year                         2025
   C9  Net asset value at that date           145
   C10 Window opening year                    2022
   C11 Net asset value at that date           210
   C12 Public index, a year                   9%
   C13 Line cost, a year                      4%
   C14 Call deferral, months                  6
   C15 Years of calls deferred                2

Sheet 1, year by year (columns D and E, from row 20):
   Year   Called   Distributed
   2018       45             0
   2019       60             0
   2020       50             8
   2021       40            35
   2022       30            62
   2023       20            90
   2024       10            75
   2025        0            40

Result: DPI 1.216, TVPI 1.784, net IRR 18.04% (7.12% on realised cash), window 20.14%, PME 1.323,
19.20% with the line on actual days (19.23% on whole years), 2.1 million of interest, TVPI 1.770.
