# Start here: companion files of The Vending Machine Business Owner (Julian R. Sterling)

Seven Excel files, each with three tabs: Inputs (blue cells, type your own values), Calc (formulas only) and Checks (each line reads 0 when the check passes; Checks!B2 adds them up).

- `Vending_1_Machine_Month.xlsx`: Workbook 1: One Machine's Month. From the vends of a month, the posted price and the sales tax to gross and net sales, and from the cost of products, losses, the location's commission, cashless fees and telemetry to the contribution margin of one machine, a month and a week. Filled with the combo machine at location L38 in October 2025.
- `Vending_2_Location_Commission.xlsx`: Workbook 2: A Location Agreement and Its Commission. From a location's gross and net sales to the commission of its agreement (tiered rate on net sales), and the gap if the rates were applied to gross sales or to sales after cashless fees. Filled with Ollerby Distribution.
- `Vending_3_Profit_and_Break_Even.xlsx`: Workbook 3: Machine Profit and Break-Even. From machines, vends, prices, costs, losses, commission, cashless and telemetry fees, service visits, leases and fixed costs to the contribution margin per machine a week, the result a month and the break-even in net sales a week per machine and in machines. Filled with the first year with seven used machines, a scenario.
- `Vending_4_Route_Month.xlsx`: Workbook 4: The Route Month: Route Days, Drivers and the Cost of a Service Visit. From the stops a week and the stops a route day can hold to route days, drivers' hours, overtime above 40 hours a week (a van above the small vehicle limit is flagged for counsel), pay and payroll taxes, vehicle running costs, the cost per service visit and route utilization. Filled with the route in October 2025.
- `Vending_5_Second_Route.xlsx`: Workbook 5: Second Route and SBA Loan. From the loan's amount, rate and term to the payment, the first eight payments and the balance, and from route B's run-rate EBITDA to its result after debt service and the payback of the price. Filled with route B, bought on 1 June 2026, loan disbursed in June 2026.
- `Vending_6_Value.xlsx`: Workbook 6: SDE, Adjusted EBITDA and Cash at Closing. From EBITDA to SDE and adjusted EBITDA, from the multiple to the enterprise value, and from the enterprise value to the cash at closing after the loans, fees and escrow. Filled with the regional operator's offer, a scenario read in November 2026.
- `Vending_Machine_Calculator.xlsx`: Vending Machine Profit and Break-Even Calculator, the free calculator, filled with example values that are not the case of the book.

The values typed in the files are the book's fictional case and scenarios: teaching assumptions, not market figures. Change one input at a time and read the result again. Rely on nothing while Checks!B2 is above zero.
