Companion files · The Private Markets Career Guides

The Mortgage Loan Officer

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 workbook, the toolkit and the read-me, in one archive75 KB

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.

The files

Three numbers to reproduce first

The pay100 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 cureA 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.