Farrier cost is quoted per visit and budgeted per year, and the conversion between them is where barn budgets go wrong. A five-week cycle is not twelve visits a year, it is 10.4 — and on a barn with shod horses that gap is a four-figure surprise. One formula fixes it permanently.
Four horses in full shoes on a five-week cycle at $210 a visit is 41.6 visits and $8,736 a year.
The example
Three groups in the same barn, on three different cycles because they do three different jobs.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Group | Cycle wks | Horses | $/visit | Visits/yr | Visits billed | Annual cost |
| 2 | Barefoot trims | 8 | 14 | $55 | 6.50 | 91.0 | $5,005 |
| 3 | Front shoes | 6 | 6 | $145 | 8.67 | 52.0 | $7,540 |
| 4 | Full set | 5 | 4 | $210 | 10.40 | 41.6 | $8,736 |
The formula
Three columns, because “visits per year” is the one people get wrong:
How it works
Read it as a rate conversion, because that is what it is:
52/B2converts a cycle length into a frequency. Six weeks gives 8.67 visits a year, not 8 — the extra two-thirds of a visit is real and lands as a thirteenth appointment every eighteen months.*C2scales to the group. Horses on the same cycle are usually done on the same day, which is also why the farrier gives a barn rate rather than a call-out per horse.*D2applies the cost. Keep trims, front shoes and full sets in separate rows — the price difference is three or four times, and averaging them hides the horse that is expensive.- Sum the annual column for the barn total. That is the number a boarding rate has to cover, or the number an owner has to be quoted honestly at intake.
Add a contingency row for lost shoes and emergency call-outs. Two or three unscheduled visits a year across a barn is normal, and they are billed at a premium.
Try it: interactive demo
Enter the shoeing cycle, the number of horses on it, and the price per visit.
Variations
Monthly accrual
Divide the annual figure by twelve so the boarding rate carries a level farrier component instead of spiking on shoeing weeks.
Cost per horse per month
The number to quote a prospective boarder. Drop the horse count and divide by twelve.
Pitfalls & errors
Cycles lengthen in winter and shorten in summer as hoof growth changes. If your barn genuinely runs six weeks in July and eight in January, average the cycle rather than using the summer figure all year.
Use 52 weeks, not 12 months. A “six-week cycle” converted as “every month and a half” gives 8 visits instead of 8.67, and the missing two-thirds of a visit compounds into a real gap over a few years.
Do not budget therapeutic shoeing at the standard rate. Pads, bar shoes and corrective work can double a visit, and a horse on that programme needs its own row rather than being folded into the full-set group.
Practice workbook
Frequently asked questions
Why 52 weeks rather than 12 months?
Should the boarding rate include farrier work?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class