Free Excel templates

A free vending machine profit and break-even calculator in Excel

Machines, vends, prices, product cost, losses, the host's commission, card fees, telemetry, service visits, leases and fixed costs. The contribution margin per machine, the result of the month and the break-even.

Twelve machines selling 140 items a week each at $2.10 make $277.36 of net sales a week per machine and leave $110.25 of it once products, losses, the host, card fees and telemetry are paid. Against service visits, leases and $2,400 of other fixed costs, the month ends $528.89 ahead, with a break-even of $251.77 of net sales a week per machine, or 9.8 machines. The calculator lays it out, ready for your own figures.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Vending_Machine_Calculator.xlsx (8 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This calculator uses the same cells as Workbook 3 of The Vending Machine Business Owner, which follows one vending route through two fiscal years: commissions on net sales, losses on their own line, cashless fees, route days and drivers, three micro markets, a second route and its SBA loan, and what the route is worth.

Paperback PDF edition, $19.99

What is in the file

Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.

1. Inputs
Machines in service; vends a week per machine; the average posted price with sales tax inside it and the sales tax rate; the average cost of one product; the host's commission rate on net sales; the loss rate (losses / cost of products sold); telemetry per machine a month; the share of gross sales paid by card and its processing fee; service visits a week per machine and the route cost of one visit; the lease payment per machine; the other fixed costs of the month.
2. Calc
Gross sales, sales tax and net sales a week per machine; cost of products sold, gross margin, losses, commission, cashless fees and telemetry; the contribution margin and its ratio; the margin a month for all machines, the fixed costs of the month and the result; the break-even in net sales a week per machine and in machines.
3. Checks
Rates between 0 and 1, the contribution margin rebuilt from its lines, the break-even reinjected to the cent in both forms, and machines, vends, prices, costs and fixed costs not negative. Checks!B2 adds up the failures.

What the worked example returns

MeasureExample
Gross sales a week per machine$294.00
Net sales a week per machine$277.36
Contribution margin a week per machine$110.25
Contribution margin ratio39.75 percent
Contribution margin a month, 12 machines$5,732.89
Fixed costs of the month (other fixed costs, service visits, leases)$5,204
Result a month$528.89
Break-even, net sales a week per machine$251.77
Margin a month per machine after its own visits and lease$244.07
Break-even, machines at this mix9.8

The example is fictional and separate from the book's case: 12 machines, 140 vends a week at $2.10 with 6 percent sales tax inside the price, products at $0.88, losses of 3.50 percent, a host on 10 percent of net sales, 65 percent of sales by card at a 5 percent fee, telemetry at $10.00 a month, one service visit a week at $32.00, a lease of $95.00 per machine a month and $2,400.00 of other fixed costs.

How to use it on your own route

  1. Enter the posted price as the buyer pays it, sales tax included, and the tax rate of your location: the calculator takes the tax out before anything else.
  2. Enter the commission rate on net sales, as your location agreement should say. If your agreement uses another base, read it with your counsel before you compare.
  3. Put the owner's salary in the other fixed costs if the owner is paid one, so the break-even does not treat her route days as free.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

Education only, not legal, tax or financial advice: your own machines, agreements and books govern, and your advisers decide.

Questions people ask

What does the vending machine calculator do?

From the machines in service, the vends a week, the average posted price with sales tax inside it, the average product cost, the host's commission rate on net sales, the loss rate (losses / cost of products sold), telemetry, the cashless share and its fee, service visits and their cost, the lease per machine and the other fixed costs, it returns net sales and the contribution margin per machine, the result of the month and the break-even.

Which break-even does it compute?

The book's one definition, in two forms. In net sales a week per machine: the fixed costs of the month divided by the machines in service, by the contribution margin ratio and by the weeks in the month. In machines: the other fixed costs divided by the margin a month of one machine after its own service visits and lease. Each reads not reached when the margin is zero or negative.

What does it leave out?

Machines of different types at different locations, micro markets, drivers and route days, overtime, cash timing, loans and a second route. The book's six workbooks cover them on one route.

Can I rely on it for a business plan?

Use it for a first pass and to learn the mechanics. Your prices come from your own machines, your costs from your own books and your rates from your own location agreements, and the conclusions belong to you and your advisers.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The six free workbooks of The Vending Machine Business Owner go further: one machine's month; a location agreement and its commission; the route month with route days, drivers and the cost of a service visit; a second route and its SBA loan; SDE, adjusted EBITDA and cash at closing.

See the book and its free files →

Related reading