{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["ROMI Hurdle Rate"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ROMI Hurdle Rate","index":0,"n_rows":55,"n_cols":3,"rows_kept":55,"merged":[[54,0,54,2]],"flags":["formulas_cached_only"]}
["[Company name]"]
["ROMI Hurdle Rate Calculation Worksheet"]
["[Date]"]
[]
["[Company name] CONFIDENTIAL"]
["Gray cells will be calculated for you and do not require any entry. "]
["Program Details","Your ROMI Hurdle Rate"]
["Enter entity for product line, business unit, division, company, or other.","Product line"]
["Enter ROMI type (revenue, margin, discounted cash flow).","Revenue"]
["Enter margin if for margin ROMI.",{"v":0.33,"d":"33.0%"}]
["Enter revenue by source."]
["Existing customers",{"v":90000000,"d":"$90,000,000"}]
["New customer acquisition",{"v":8000000,"d":"$8,000,000"}]
["Customer rescue",{"v":500000,"d":"$500,000"}]
["Brand",{"v":3000000,"d":"$3,000,000"}]
["Other, including infrastructure",{"v":250000,"d":"$250,000"}]
["Enter marketing spend by revenue source"]
["Existing customers",{"v":250000,"d":"$250,000"}]
["New customer acquisition",{"v":1000000,"d":"$1,000,000"}]
["Customer rescue",{"v":300000,"d":"$300,000"}]
["Brand",{"v":1000000,"d":"$1,000,000"}]
["Other, including infrastructure",{"v":100000,"d":"$100,000"}]
["Calculated results"]
["Existing customers",{"v":360,"d":"360.0"}]
["New customer acquisition",{"v":8,"d":"8.0"}]
["Customer rescue",{"v":1.6666666666666667,"d":"1.7"}]
["Brand",{"v":3,"d":"3.0"}]
["Other, including infrastructure",2.5]
["Planning contingency factor"]
["Existing customers",{"v":0,"d":"0.0%"}]
["New customer acquisition",{"v":0.1,"d":"10.0%"}]
["Customer rescue",{"v":0.1,"d":"10.0%"}]
["Brand",{"v":0.1,"d":"10.0%"}]
["Other, including infrastructure",{"v":0,"d":"0.0%"}]
["Low-risk hurdle rates","Revenue","Margin"]
["Existing customers",{"v":360,"d":"360.0"},118.8]
["New customer acquisition",8.8,{"v":2.9040000000000004,"d":"2.9"}]
["Customer rescue",{"v":1.8333333333333335,"d":"1.8"},{"v":0.605,"d":"0.6"}]
["Brand",3.3,{"v":1.0890000000000002,"d":"1.1"}]
["Other, including infrastructure",2.5,{"v":0.825,"d":"0.8"}]
["Medium-risk hurdle rates"]
["Medium-risk adder over low-risk hurdle rate",{"v":0.2,"d":"20.0%"}]
["Existing customers",{"v":432,"d":"432.0"},{"v":142.56,"d":"142.6"}]
["New customer acquisition",{"v":10.56,"d":"10.6"},{"v":3.4848000000000003,"d":"3.5"}]
["Customer rescue",2.2,{"v":0.7260000000000001,"d":"0.7"}]
["Brand",{"v":3.96,"d":"4.0"},{"v":1.3068,"d":"1.3"}]
["Other, including infrastructure",{"v":3,"d":"3.0"},{"v":0.99,"d":"1.0"}]
["High-risk hurdle rates"]
["High-risk adder over low-risk hurdle rate",{"v":0.5,"d":"50.0%"}]
["Existing customers",{"v":540,"d":"540.0"},178.2]
["New customer acquisition",13.2,{"v":4.356000000000001,"d":"4.4"}]
["Customer rescue",{"v":2.75,"d":"2.8"},{"v":0.9075,"d":"0.9"}]
["Brand",{"v":4.95,"d":"5.0"},{"v":1.6335000000000002,"d":"1.6"}]
["Other, including infrastructure",{"v":3.75,"d":"3.8"},{"v":1.2375,"d":"1.2"}]
["Note: Customer rescue revenue includes revenue streams that would be lost if there were no customer rescue marketing effort."]