{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Return-on-investment analysis"],"not_rendered":{"macros":1,"external_links":1,"defined_names":24},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Return-on-investment analysis","index":0,"n_rows":64,"n_cols":6,"rows_kept":64,"merged":[[1,1,1,2],[12,1,15,3],[19,1,20,1],[19,2,19,5],[34,2,36,2]],"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Capital budgeting—return-on-investment (ROI) analysis"]
[null,"<Date>"]
[]
[null,"Data cell key"]
[null,"User data entry or item description"]
[null,"Formula cells: Totals are calculated and filled in automatically."]
[]
[null,"Investment overview"]
[null,"Project name:    <Project name>"]
[null,"Project sponsor: <Project sponsor>"]
[null,"Date of request: <Date>"]
[null,"General description of benefits: <Description of benefits>"]
[]
[]
[]
[]
[]
[null,"Cash flow and ROI statement"]
[null,"BENEFIT DRIVERS","YEAR"]
[null,null,0,1,2,3]
[null,"Greater margin driven by higher production capacity",null,{"v":500000,"d":"$500,000"},{"v":1000000,"d":"$1,000,000"},{"v":1250000,"d":"$1,250,000"}]
[null,"Improved cycle time benefits:"]
[null,"Reduced energy cost due to less running time",null,{"v":125000,"d":"125,000 "},{"v":125000,"d":"125,000 "},{"v":125000,"d":"125,000 "}]
[null,"Reduced labor cost due to less running time",null,{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "}]
[null,"Fewer accidents, resulting in less workers' compensation",null,{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "}]
[null,"Improved quality benefits:"]
[null,"Fewer defects, resulting in less rework",null,{"v":250000,"d":"250,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "}]
[null,"Fewer customer returns, resulting in less reprocessing costs ",null,{"v":50000,"d":"50,000 "},{"v":75000,"d":"75,000 "},{"v":75000,"d":"75,000 "}]
[null,"Reduced time spent handling customer complaints",null,{"v":50000,"d":"50,000 "},{"v":75000,"d":"75,000 "},{"v":75000,"d":"75,000 "}]
[null,"<Benefit driver>"]
[null,"<Benefit driver>"]
[null,"<Benefit driver>"]
[null,"<Benefit driver>"]
[null,"Total annual benefits",null,{"v":1575000,"d":"$1,575,000"},{"v":2175000,"d":"$2,175,000"},{"v":2425000,"d":"$2,425,000"}]
[null,"Implementation filter",null,{"v":0.85,"d":"85%"},{"v":0.9,"d":"90%"},{"v":0.95,"d":"95%"}]
[null,"Total benefits realized",null,{"v":1338750,"d":"$1,338,750"},{"v":1957500,"d":"$1,957,500"},{"v":2303750,"d":"$2,303,750"}]
[]
[null,"Costs","Year 0","Year 1","Year 2","Year 3"]
[null,"Total",{"v":1650000,"d":"$1,650,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"}]
[]
[null,"Benefits","Year 0","Year 1","Year 2","Year 3"]
[null,"Annual benefit flow",{"v":-1650000,"d":"($1,650,000)"},{"v":1213750,"d":"$1,213,750"},{"v":1832500,"d":"$1,832,500"},{"v":2178750,"d":"$2,178,750"}]
[null,"Cumulative benefit flow",{"v":-1650000,"d":"(1,650,000)"},{"v":-436250,"d":"(436,250)"},{"v":1396250,"d":"1,396,250 "},{"v":3575000,"d":"3,575,000 "}]
[]
[null,"Discounted benefit flow","Year 0","Year 1","Year 2","Year 3"]
[null,"Discounted costs",{"v":1650000,"d":"$1,650,000"},{"v":108695.65217391305,"d":"$108,696"},{"v":94517.95841209832,"d":"$94,518"},{"v":82189.52905399854,"d":"$82,190"}]
[null,"Discounted benefits",{"v":0,"d":"0 "},{"v":1164130.4347826089,"d":"1,164,130 "},{"v":1480151.2287334595,"d":"1,480,151 "},{"v":1514753.020465193,"d":"1,514,753 "}]
[null,"Total discounted benefit flow",{"v":-1650000,"d":"(1,650,000)"},{"v":1055434.7826086958,"d":"1,055,435 "},{"v":1385633.2703213613,"d":"1,385,633 "},{"v":1432563.4914111944,"d":"1,432,563 "}]
[null,"Total cumulative discounted benefit flow",{"v":-1650000,"d":"(1,650,000)"},{"v":-594565.2173913042,"d":"(594,565)"},{"v":791068.052930057,"d":"791,068 "},{"v":2223631.5443412513,"d":"2,223,632 "}]
[]
[null,"Initial investment","Year 0","Year 1","Year 2","Year 3"]
[null,"Initial investment",{"v":1200000,"d":"$1,200,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Implementation costs",{"v":400000,"d":"400,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Ongoing support costs",{"v":0,"d":"0 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "}]
[null,"Training costs",{"v":50000,"d":"50,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "}]
[null,"Other costs",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total costs",{"v":1650000,"d":"$1,650,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"},{"v":125000,"d":"$125,000"}]
[]
[null,"ROI measures"]
[null,"Cost of capital",{"v":0.15,"d":"15%"}]
[null,"Net present value",{"v":2223631.5443412517,"d":"$2,223,632"},null," "]
[null,"Return on investment",null,{"v":0.661928306551298,"d":"66%"},{"v":1.4268628551027696,"d":"143%"},{"v":2.1489242209015185,"d":"215%"}]
[null,"Payback (in years)",{"v":1.23806275579809,"d":"1.24"}]