Companion files · The Private Markets Career Guides
Pipeline, Pricing, Rate Locks, Loan Estimates and Compensation Rules for Mortgage Originators.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. One workbook rebuilds Quillfield Home Loans, the fictional nonbank lender of the case, and one retail loan officer: a 2027 plan of 328 leads, 96 applications and 60 funded loans, a pay plan at 100 basis points with a minimum and a maximum, one buyer and three loans on a $450,000 home, a rate sheet and a lock, a Loan Estimate and its tolerances, the file calendar from application to closing, a pipeline snapshot and a refinance. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3, 5 and 8 to 16, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Pipeline, Compensation, Products, Pricing, Loan Estimate, Calendar, Refinance. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 8 exercises of Appendix A run on it.
Download the workbook38 KBAppendix B
First call intake; Preapproval letter; Product comparison for a buyer; Rate lock and extension; Loan Estimate delivery and walkthrough; Tolerance and cure review before the Closing Disclosure; RESPA section 8 test for any marketing arrangement; Compensation plan review.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The pay | 100 basis points of the amount of credit, with a $1,000 minimum and a $7,500 maximum: $210,600 on $21.64 million, an average of 97.32 basis points |
| The payment | $427,500 at 7.000 percent over 360 months: $2,844.17 of principal and interest, a housing payment of $3,679.48 and a debt-to-income ratio of 45.57 percent |
| The cure | A 10 percent bucket disclosed at $2,400 that closes at $2,760, and an appraisal fee up $75: a total cure of $195 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Quillfield Home Loans, its loan officer, its borrowers and its partners are fictional, and rates, points, fees, premiums, pay plans and dates are the book’s assumptions, not market rates, market fees or market pay. Rule texts change. Nothing here is legal, compliance, tax or investment advice.