{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Customer Lifecycle Value","List"],"not_rendered":{"images":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Customer Lifecycle Value","index":0,"n_rows":25,"n_cols":7,"rows_kept":25}
[{"$nulls":6}," "]
[]
[null,"Customer Data"]
[null,"Enter historical customer data or your best estimates in the shaded cells below."]
[]
[null,null,"Average Service Frequency",1,"per month"]
[]
[null,null,"Average Cost per Service",{"v":500,"d":"$500.00"}]
[]
[null,null,"Average Customer Life",10,"year(s)"]
[]
[null,null,"Average Gross Margin",{"v":0.1,"d":"10.00%"}]
[]
[null,"Acquisition Cost"]
[null,"Enter average cost to acquire new customers."]
[]
[null,null,"Average Acquisition Cost",{"v":200,"d":"$200.00"}]
[]
[null,"Customer Lifecycle Value"]
[]
[null,null,"Customer Lifecycle Value",{"$f":"(Cost_per_Service*Gross_Margin)*(Frequency*VLOOKUP(Frequency_Period,Table_Options[],3,FALSE))*(Customer_Life/VLOOKUP(Customer_Life_Period,Table_Options_2,2,FALSE))-Acquisition_Cost","v":{"v":5800,"d":"$5,800.00"}}]
[]
[null,null,"Breakeven Payback Period",{"$f":"TEXT(Acquisition_Cost/(Frequency*Cost_per_Service*Gross_Margin),\"0.0\") & \" \" & VLOOKUP(Frequency_Period,Table_Options[],2,FALSE)","v":"4.0 month(s)"}]
[]
[null,"Notes:"]

{"sheet":"List","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"hidden":true}
["List Options 1","List Options 2","Year Multiplier"]
["per day","day(s)",365]
["per week","week(s)",72]
["per month","month(s)",12]
["per year","year(s)",1]