# The Mortgage Loan Officer: companion files

Julian R. Sterling

## What is here

- **Mortgage_Loan_Officer_Model.xlsx**: the workbook that rebuilds the Quillfield case and reproduces the figures of the book with live formulas. Sheets: Inputs, Pipeline, Compensation, Products, Pricing, Loan Estimate, Calendar, Refinance, Checks.
- **Mortgage_Loan_Officer_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapter 5 and Chapter 14: Pipeline (the 2027 plan, 96 applications and 60 funded loans for $21.64 million; the pipeline snapshot, 37 files and 21.59 expected fundings)
- Chapters 3, 15 and 16: Compensation (commission $210,600, total $225,600 with the bonus; the broker example; three seats compared; the first-year ramp and the draw)
- Chapters 8 and 9: Products (conventional, FHA and VA for one buyer, housing payments $3,679.48, $3,739.86 and $3,618.35; the jumbo and non-QM files)
- Chapter 11: Pricing (the rate sheet, a buy-down that pays back in 74.8 months, a 6-day extension at $513.00)
- Chapters 12 and 13: Loan Estimate (closing costs $9,985.68, cash to close $27,485.68, cures $195)
- Chapters 12 and 13: Calendar (application Tuesday 2 March 2027, closing Thursday 8 April 2027, and the disclosure and lock dates between)
- Chapter 10: Refinance (break-even 22.4 months; a cash-out of $92,500)
- Appendix A: 8 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, move the conventional note rate from 7.000 percent to 7.250 percent: watch the payment and the debt-to-income ratio on Products.
2. On Loan Estimate, set the final recording fees from $390 to $250: the 10 percent bucket falls under its limit and the cure on it disappears. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Most inputs are on the Inputs sheet; the ones an exercise names sit on that exercise's sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Quillfield Home Loans, its loan officer, its borrowers and its partners are fictional; rates, points, fees, premiums, conversion rates, pay plans and dates are teaching assumptions, not market rates, market fees or market pay. Rule texts change: check the current text. Provided as is, without warranty. Not legal, compliance, tax or investment advice.
