# The General Contractor Business Owner: companion files

Julian R. Sterling

## What is here

- **General_Contractor_1_Job_Cost.xlsx** (Chapters 9 and 10; Job Cost workbook of Appendix A): sheets Estimate and Actual, Change Orders, then Checks. J08's five cost lines, estimate against actual: a fade of $73,203 and a gross profit of $44,297 against $117,500 at bid; the five change orders, their markup and gross profit.
- **General_Contractor_2_Bid_Decision.xlsx** (Chapters 5 and 8; Bid Decision workbook): sheets Go No-Go, then Checks. The eight criteria of the go/no-go sheet scored for J14 (13 of 16, bid) and D1 (6 of 16, declined), against the threshold of 11.
- **General_Contractor_3_Overhead_and_Breakeven.xlsx** (Chapters 3 and 6; Overhead and Breakeven workbook): sheets Overhead, Breakeven, Margin Rule, then Checks. The twelve overhead lines ($1,250,000 then $1,468,000), the breakeven revenue ($11,808,208 then $13,128,724) and the FY2026 bid margin rule (11.47 percent).
- **General_Contractor_4_WIP.xlsx** (Chapter 13; WIP workbook): sheets WIP 2026, then Checks. J13, J14 and J15 at 30 September 2026: percent complete, earned, overbilled and underbilled, estimated gross profit; J13 overbilled by $162,658.
- **General_Contractor_5_Cash_and_Retainage.xlsx** (Chapters 12 and 14; Cash and Retainage workbook): sheets J09 Cash, Retainage, then Checks. J09's own cash month by month, down to $343,100 below zero and back to $247,900, and its retainage both ways.
- **General_Contractor_6_Bonding_Capacity.xlsx** (Chapter 15; Bonding Capacity workbook): sheets Working Capital, Limits, then Checks. Working capital ($1,062,357 then $1,415,318), the aggregate program and the single job limit ($5,099,314 then $6,793,526), and D1 against it.
- **General_Contractor_Toolkit.docx**: the 6 check-lists of Appendix B, editable (Go/no-go; Subcontractor prequalification and buyout; Job start; Monthly job review; Closeout; The owner's month-end review).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a figure read from another sheet of the same workbook. Change one input at a time, note the result, 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 is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. No date function, workday count or lookup formula is used, and months are typed as labels. When a figure is rounded, the note at the top of the sheet says so.

Two inputs to try first:

1. In General_Contractor_3_Overhead_and_Breakeven.xlsx, on Breakeven, lower the FY2026 gross profit by one point of revenue: the breakeven line moves by far more than the overhead would move it.
2. In General_Contractor_2_Bid_Decision.xlsx, on Go No-Go, raise D1's margin score as high as it goes: the total still stays below the threshold, because the company could not staff or bond the job.

The workbooks are separate files with no link between them: a figure two workbooks share (the overhead budget, D1's bid amount) is typed again where it is used.

## A word of caution

Treversham Builders, Inc., the city of Stannerby, Ellisbrae Properties, Fenhallow Community Bank and every party in the case are fictional. Contract amounts, bid margins, cost shares, overhead lines, retainage rates, payment terms, scores and the surety guideline are teaching assumptions, not market norms or recommendations; real sureties set their own terms. Federal rules change: read them in their current text, with your state and city rules, your outside CPA and your counsel. No software, bank, surety or real company is described or recommended. Nothing here is legal, tax or accounting advice.
