# The Fence Company Owner: companion files

Julian R. Sterling

## What is here

- **Fence_1_Job_Price_and_Margin.xlsx** (Chapters 4 and 5; Workbook 1 of Appendix A): tabs Inputs, Margin, Checks. One typical job of each fence type priced by the foot, with gates and removal, less materials with waste, piece pay, burden, card fees and the loader, then less its share of the year's fixed costs by the crew-day (FY2026: 482.11 dollars of fixed costs a crew-day; a wood privacy fence job leaves 2,722.59 dollars before fixed costs and 1,517.32 after them).
- **Fence_2_Feet_and_Break_Even.xlsx** (Chapter 14; Workbook 2): tabs Inputs, Break-Even, Checks. A closed year's contribution a foot and the break-even in feet a month (FY2026: 2,936 against an actual 5,791, a margin of safety of 49.3 percent; FY2025: 2,547 against 3,264).
- **Fence_3_Installer_Pay.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Pay, Checks. One installer's piece-rate week with the weekly guarantee at the minimum wage, the regular rate and the overtime premium, beside the same hours at the FY2025 wage (week 81: 23.12 dollars an hour, a premium of 92.50 dollars, $1,203 for the week against $1,040; the frozen-ground week 68 needs a top-up of 5.20 dollars).
- **Fence_4_Lead_Cost_by_Channel.xlsx** (Chapter 7; Workbook 4): tabs Inputs, Leads, Checks. Each channel from the request to the job signed: share booked, close rate, cost an estimate, cost a job signed (FY2026: paid estimate requests 412.27 dollars a job signed, all channels 205.54).
- **Fence_5_New_Crew_Payback.xlsx** (Chapter 13; Workbook 5): tabs Inputs, Payback, Checks. What one more crew with its truck, trailer and tools leaves in a quarter and the months that pay back the cash put in (Q4 FY2026: run-rate $231,888, 1.4 months for the down payment, trailer and tools, 4.1 months for the price, trailer and tools).
- **Fence_6_Deposits_Retainage_and_Materials.xlsx** (Chapter 14; Workbook 6): tabs Inputs, Cash Tied Up, Checks. Receivables, retainage, materials paid ahead and stock less the deposits customers advance ($141,272 of deposits held, $39,950 of receivables, $12,945 of retainage; cash tied up at run-rate -16,164 dollars, a negative figure: the deposits finance the rest).
- **Fence_7_Value_and_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from EBITDA to the cash at closing (adjusted EBITDA $487,245, price $1,461,735, SBA loan $1,169,387, cash at closing $1,013,417).
- **Fence_Company_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Licenses, permits, contracts, the three-day notice and the call before digging (chapter 2); The weekly estimates, backlog and crew-days review (chapters 3 and 4); Prices, gates, removal and price changes (chapter 5); Deposits and financing (chapter 6); Leads and reviews (chapter 7); Materials, waste and the depot (chapter 8); Pay, overtime and hiring (chapters 9 and 10); Commercial work, warranties and before answering an offer (chapters 11, 12, 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the three tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date, and a loan payment is an input copied from the lender's schedule. Shares and rates are typed as factors (a burden of 18.55 percent is typed 0.1855, not 18.55), and every division by an input that can be zero is wrapped in IF. An empty input reads as zero. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own company, start with a copy, replace every blue input from the record that owns each figure (the signed contracts, the supplier's invoices, the payroll records, the lead invoices, the statements, the lender's schedule, the letter itself), keep every check at OK, and never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Ravelcourt Fence, Inc., the town of Thrennick, Caldermoss Construction, Pellmorrow Properties, Quarnley Community Bank and every party in the case are fictional. Prices a foot, material costs, waste rates, piece rates, wages, lead costs, delays, loan terms, offer terms and multiples are teaching assumptions, not market norms, not a price list, not the rule of any state and not recommendations. What a state or a city requires (licenses, permits, property lines, the call before digging) is for that state and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
