# The Home Builder Business Owner: companion files

Julian R. Sterling

## What is here

- **Home_Builder_1_House_Budget_and_Margin.xlsx** (Chapters 2, 3, 4 and 9; Workbook 1 of Appendix A): sheets House budget, Case inputs, Month by month, Houses, Loan balances, Results, then Checks. The three house budgets before options, and house No. 44 from list price to a contribution of $66,858 after interest and selling costs.
- **Home_Builder_2_Pace_and_Spec_Inventory.xlsx** (Chapters 7 and 8; Workbook 2): same sheets after Pace, then Checks. Demand, the start policy, crew capacity and build time: starts, spec sales, closings and unsold specs month by month, and the lowest month-end cash of $1,340,651.
- **Home_Builder_3_Loans_and_Interest.xlsx** (Chapters 6, 11 and 13; Workbook 3): same sheets after Loan terms, then Checks. Advance rates, the house loan rate, the spec cap, curtailment and the liquidity covenant: the interest carried, house loans at their peak of $7,046,499, and the cash low point against the covenant.
- **Home_Builder_4_Cash_and_the_Slowdown.xlsx** (Chapters 5, 12, 15 and 16; Workbook 4): same sheets after Response, then Checks. The response lever by lever: FY2026 closes with a pre-tax profit of $16,168 and cash of $5,975,228; set the response to 0 to stay the course instead (a loss of $8,948, and cash of $4,696,056).
- **Home_Builder_Toolkit.docx**: the 6 check-lists of Appendix B, editable (1. Buying lots: option or purchase; 2. Launching a spec; 3. Signing and closing a sale; 4. The monthly review; 5. The slowdown trigger and the response; 6. The year-end close with the accountant).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. The first sheet of each workbook holds the inputs it is about and its outputs; Case inputs holds every other assumption; Month by month, Houses and Loan balances do the calculations; Results gives the three fiscal years. Change one input at a time, note the output, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. Each of the 10 exercises of Appendix A moves the inputs of the workbook it names.

Each workbook runs the whole case, because a change in one house moves the three years. There is no circular reference: each month is computed from the month before, one row a month, and each house loan from its own previous month, one row a loan.

Two inputs to try first:

1. In Home_Builder_2_Pace_and_Spec_Inventory.xlsx, on Pace, set the spec target to 6: closings in FY2025 do not move, and FY2026 ends with more profit.
2. In Home_Builder_4_Cash_and_the_Slowdown.xlsx, on Response, set the first month of the response to 24 (October 2025): no aged spec is left to discount.

The workbooks are separate files with no link between them.

## A word of caution

Corvellan Homes, LLC, Tallowmere Ridge, Fernmoor Glen, the town of Hessendale, Kestlow Community Bank and every party in the case are fictional. Prices, costs, lot prices, rates, loan terms, incentives, commissions and overhead are teaching assumptions, not market norms or recommendations. State law on warranties, liens, deposits and licensing differs and changes: check it with counsel. Tax rules must be read in their current text with your outside accountant. Nothing here is legal, tax or accounting advice.
