{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["ReadMe","Inputs","Results"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ReadMe","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Purpose","This calculator matches the latest blog. Green cells are editable. Currency: USD."]
["Definitions","Payback (days) = CAPEX / Daily net operating profit. Payback (months) = CAPEX / Monthly EBITDA (30 × daily net). Battery packs are expensed per order via 'Per-order depreciation'."]
["How to use","1) Edit Inputs (green). 2) Review Results. 3)Adjust rentals/station/day, venue share, gateway fee as needed."]

{"sheet":"Inputs","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Parameter","Value","Unit / Note"]
["Stations (qty)",100,"Total number of rental stations"]
["Rentals per station per day",2.2,"Average orders/station/day"]
["Revenue per rental (USD)",2,"Ticket per order"]
["Station unit cost (USD)",355,"Capex per station (chassis)"]
["Logistics per station (USD)",68,"Shipping/handling per station"]
["Standard software (one-time, USD)",7500,"One-off license/activation"]
["Marketing budget (one-time, USD)",0,"Optional"]
["Revenue share to supplier (%)",0,"As % of revenue (if any)"]
["Revenue share to outlets (%)",20,"Venue share % of revenue"]
["Payment gateway fee (%)",3,"Acquirer + tax if applicable"]
["Daily labor cost (USD)",68.97,"Already daily"]
["Daily SIM cost (USD)",10.96,"Already daily"]
["Daily SMS cost (USD)",1.5,"Already daily"]
["Per-order depreciation for battery pack (USD)",0.018,"Pack cost / life, per order"]
["Daily software maintenance cost (USD)",5.48,"Already daily"]

{"sheet":"Results","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Metric","Value","Explanation"]
["Total rentals per day (orders)",{"$f":"Inputs!B2*Inputs!B3","v":220},"Stations × rentals/station/day"]
["Daily revenue (USD)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4","v":440},"Orders × ticket"]
["Revenue share to supplier (USD/day)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100","v":0},"Supplier share % × revenue"]
["Revenue share to outlets (USD/day)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100","v":88},"Venue share % × revenue"]
["Payment gateway fee (USD/day)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100","v":13.2},"Gateway fee % × revenue"]
["Revenue after share (USD/day)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100","v":338.8},"Net revenue after revenue shares & fees"]
["Daily labor cost (USD)",{"$f":"Inputs!B12","v":68.97},"From Inputs (daily)"]
["Daily SIM cost (USD)",{"$f":"Inputs!B13","v":10.96},"From Inputs (daily)"]
["Daily SMS cost (USD)",{"$f":"Inputs!B14","v":1.5},"From Inputs (daily)"]
["Battery pack depreciation per day (USD)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B15","v":3.96},"Per-order dep × total orders/day"]
["Daily software maintenance cost (USD)",{"$f":"Inputs!B16","v":5.48},"From Inputs (daily)"]
["Total daily opex (USD)",{"$f":"Inputs!B12+Inputs!B13+Inputs!B14+Inputs!B2*Inputs!B3*Inputs!B15+Inputs!B16","v":90.87},"Labor + SIM + SMS + battery dep + software maint."]
["Net operating profit per day (USD)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100-Inputs!B12+Inputs!B13+Inputs!B14+Inputs!B2*Inputs!B3*Inputs!B15+Inputs!B16","v":291.73},"Revenue after share − daily opex (EBITDA-like)"]
["CAPEX (one-time, USD)",{"$f":"Inputs!B7+Inputs!B2*(Inputs!B5+Inputs!B6)+Inputs!B8","v":49800},"Software + stations × (unit + logistics) + marketing"]
["Payback (days)",{"$f":"Inputs!B7+Inputs!B2*(Inputs!B5+Inputs!B6)+Inputs!B8/Inputs!B2*Inputs!B3*Inputs!B4-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100-Inputs!B12+Inputs!B13+Inputs!B14+Inputs!B2*Inputs!B3*Inputs!B15+Inputs!B16","v":49651.73},"CAPEX / daily net operating profit"]
["Monthly EBITDA (USD)",{"$f":"Inputs!B2*Inputs!B3*Inputs!B4-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100-Inputs!B12+Inputs!B13+Inputs!B14+Inputs!B2*Inputs!B3*Inputs!B15+Inputs!B16*30","v":450.65},"Daily net × 30"]
["Static payback (months)",{"$f":"Inputs!B7+Inputs!B2*(Inputs!B5+Inputs!B6)+Inputs!B8/Inputs!B2*Inputs!B3*Inputs!B4-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B9/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B10/100-Inputs!B2*Inputs!B3*Inputs!B4*Inputs!B11/100-Inputs!B12+Inputs!B13+Inputs!B14+Inputs!B2*Inputs!B3*Inputs!B15+Inputs!B16*30","v":49810.65},"CAPEX / Monthly EBITDA"]