PRIVATE MARKETS PERFORMANCE - 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 measurement checklist has no blank version: it arrives empty. The practice cases are exercises, not models.

Complete_Measurement_Blank.xlsx  (Chapter 19: Meridian Capital Partners IV)

   1. Cash Flows!B7                  60
   1. Cash Flows!C7                  0
   1. Cash Flows!B8                  75
   1. Cash Flows!C8                  0
   1. Cash Flows!B9                  60
   1. Cash Flows!C9                  0
   1. Cash Flows!B10                 45
   1. Cash Flows!C10                 0
   1. Cash Flows!B11                 30
   1. Cash Flows!C11                 0
   1. Cash Flows!B12                 0
   1. Cash Flows!C12                 40
   1. Cash Flows!B13                 0
   1. Cash Flows!C13                 90
   1. Cash Flows!B14                 0
   1. Cash Flows!C14                 120
   1. Cash Flows!B15                 0
   1. Cash Flows!C15                 100
   1. Cash Flows!B16                 0
   1. Cash Flows!C16                 60
   1. Cash Flows!D20                 85
   4. Facility Test!B5               1
   4. Facility Test!B6               0.045
   5. PME!B9                         0.09
   5. PME!B10                        0.12
   5. PME!B11                        -0.05
   5. PME!B12                        0.18
   5. PME!B13                        0.14
   5. PME!B14                        -0.14
   5. PME!B15                        0.22
   5. PME!B16                        0.11
   5. PME!B17                        0.07
   5. PME!D80                        0.03
   6. Gross to Net!B5                300
   6. Gross to Net!B6                0.02
   6. Gross to Net!B7                0.0175
   6. Gross to Net!B9                9.9
   6. Gross to Net!B10               0.0045
   6. Gross to Net!C19               180
   6. Gross to Net!C20               140
   6. Gross to Net!C21               95
   6. Gross to Net!C22               50
   6. Gross to Net!C23               20

   Result: IRR 11.07%, TVPI 1.833x, Kaplan-Schoar 1.239, lambda 0.7739, PME+ 7.05%, Direct Alpha 3.80%, facility 12.76% and 1.788x, gross 14.25%.
   The printed figures that sheets 2 to 6 compare against: the first edition's values, in the companion workbook itself.

PME_Calculator_Blank.xlsx  (Chapters 3, 5 and 9: the same fund)

   1. Inputs!D6                      2018
   1. Inputs!D7                      9
   1. Inputs!D8                      1
   1. Inputs!D9                      85
   1. Inputs!D10                     0.03
   1. Inputs!B14                     60
   1. Inputs!C14                     0
   1. Inputs!D14                     100
   1. Inputs!B15                     75
   1. Inputs!C15                     0
   1. Inputs!D15                     109
   1. Inputs!B16                     60
   1. Inputs!C16                     0
   1. Inputs!D16                     122.08
   1. Inputs!B17                     45
   1. Inputs!C17                     0
   1. Inputs!D17                     115.976
   1. Inputs!B18                     30
   1. Inputs!C18                     0
   1. Inputs!D18                     136.85168
   1. Inputs!B19                     0
   1. Inputs!C19                     40
   1. Inputs!D19                     156.010915
   1. Inputs!B20                     0
   1. Inputs!C20                     90
   1. Inputs!D20                     134.169387
   1. Inputs!B21                     0
   1. Inputs!C21                     120
   1. Inputs!D21                     163.686652
   1. Inputs!B22                     0
   1. Inputs!C22                     100
   1. Inputs!D22                     181.692184
   1. Inputs!B23                     0
   1. Inputs!C23                     60
   1. Inputs!D23                     194.410637

   Result: as above; index annualized 7.67%.

Cohort_Blank.xlsx  (Appendix F: the cohort of 24, and Meridian IV at 11.07)

   1 Cohort!B6                       24.31
   1 Cohort!B7                       21.06
   1 Cohort!B8                       18.42
   1 Cohort!B9                       16.55
   1 Cohort!B10                      15.28
   1 Cohort!B11                      14.02
   1 Cohort!B12                      13.11
   1 Cohort!B13                      12.44
   1 Cohort!B14                      11.86
   1 Cohort!B15                      11.41
   1 Cohort!B16                      11.07
   1 Cohort!B17                      10.62
   1 Cohort!B18                      10.18
   1 Cohort!B19                      9.73
   1 Cohort!B20                      9.05
   1 Cohort!B21                      8.41
   1 Cohort!B22                      7.66
   1 Cohort!B23                      6.92
   1 Cohort!B24                      5.88
   1 Cohort!B25                      4.71
   1 Cohort!B26                      3.24
   1 Cohort!B27                      1.05
   1 Cohort!B28                      -2.48
   1 Cohort!B29                      -7.3
   1 Cohort!B43                      11.07

   Result: N 24, median 10.40, top-quartile boundary 14.02, rank 11, second quartile; true median about 6.60.

