THE PRIVATE EQUITY SECONDARIES INVESTOR - COMPANION FILES
julianrsterling.com/secondaries

Free. No sign-up, no email address. Nothing is locked, protected or watermarked.
Revised 22 September 2026.

WHAT IS IN THE ARCHIVE

1. The book's workbooks
   Secondary_Deal_Model.xlsx          Chapters 8 and 9: all sixteen figures reproduced
   NAV_Bottom_Up.xlsx                 Chapter 7
   Underwriting_Checklist.xlsx        Appendix B
   Interview_and_Case_Prep.xlsx       Appendix C and Chapter 13
   Secondaries_Bid_and_Floor.xlsx     Appendix E
   00_START_HERE.md

2. Blank_Model_Set/  (new)
   Secondary_Deal_Model_Blank.xlsx, NAV_Bottom_Up_Blank.xlsx
   The same formulas with every input emptied. The checks sheet counts the inputs
   still empty and runs the tests that hold on any deal. The book's inputs are in
   book_inputs.txt inside this folder.

3. Working_Documents.pdf  (new)
   Four working documents on five printable pages: the Appendix B underwriting
   checklist, a bid one-pager, the company-by-company NAV rebuild, and a GP-led
   transaction review. A4, fits Letter.

4. Forty_Questions.xlsx  (new)
   Forty questions across the book, marked by the file as you type.

5. Cases/  (new)
   Case_1_The_Commitment_That_Comes_With_It.xlsx   the unfunded commitment, priced
   Case_2_Paying_Later_Or_Borrowing.xlsx           deferral and leverage, base and stress
   Case_3_Sell_Or_Roll.xlsx                        a continuation vehicle, from the LP side
   Each case: the note on the first sheet, the model after it, checks at the end.

The files open in Excel, LibreOffice Calc, Google Sheets and Numbers. No macros.
