COD Profit & RTO Calculator (Excel + Google Sheets)

Know your real profit per order before you scale your ads.

In Cash-on-Delivery you pay for the ad, the product, the packaging and the delivery attempt before you know if the customer will pay. This calculator shows what you actually keep after unconfirmed leads, refused parcels, return fees and lost stock.

What's inside

• Calculator: compare 3 scenarios side by side (today, better confirmation, target). See net profit, margin, profit per lead and per delivered order, ROAS and the direct cost of returns.
• Break-even: the maximum you can pay per lead, and the lowest confirmation and delivery rates that still make money.
• Sensitivity grid: profit per 100 leads at every confirmation rate (30–90%) and delivery rate (40–90%), coloured red to green.
• Product List: compare up to 20 products and see the break-even ad cost per lead for each.
• Daily Tracker: log ad spend, leads, confirmed, delivered and returned. Profit calculates automatically.

Works in Excel and Google Sheets, in any currency (examples are in MAD). Yellow cells are inputs; everything else is formula-driven.

Example: with the same product and the same ad budget, moving from 55% confirmation / 60% delivery to 75% / 80% takes profit from 1,820 to 6,200 MAD per 100 leads. The calculator shows you where your store sits and which lever is worth the most.

Instant download: 1 .xlsx file.