{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["NPV Calculator","Cash Flow Chart"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"NPV Calculator","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[20,1,20,3],[20,4,20,7]],"flags":["formulas_cached_only"]}
["[Company Name]"]
["Net Present Value — [Equipment]"]
["[Date]"]
[]
["Operational Costs",null,"Value"]
["Cost of equipment",null,{"v":14500,"d":"$14,500"}]
["Fixed costs",null,{"v":0,"d":"$0"}]
["Vehicle insurance",null,{"v":1600,"d":"$1,600"}]
["Driver pay",null,{"v":16200,"d":"$16,200"}]
["Miscellaneous",null,{"v":0,"d":"$0"}]
["Maintenance",null,"Variable"]
["Depreciation",null,"N/A"]
["New sales",null,125]
["Profit per sale",null,{"v":5,"d":"$5"}]
["Courier delivery charge",null,{"v":16,"d":"$16"}]
["Number of deliveries",null,{"v":1250,"d":"1,250"}]
["Sale of equipment",null,{"v":2300,"d":"$2,300"}]
["Interest rate",null,{"v":0.05,"d":"5%"}]
[]
["Gray cells will be calculated for you and do not require any entry.",{"$nulls":8},"[Company Name] CONFIDENTIAL"]
[null,"Expenses",null,null,"Income"]
["Term in years","Fixed costs","Other costs","Total","Money saved \nby project","New sales generated by project","Equipment sales","Total","Cash flow","Cumulative cash flow"]
[0,{"v":14500,"d":"$14,500"},null,{"v":14500,"d":"$14,500"},{"$nulls":4},{"v":-14500,"d":"$14,500"},{"v":-14500,"d":"$14,500"}]
[1,{"v":17800,"d":"17,800"},{"v":200,"d":"$200"},{"v":18000,"d":"18,000"},{"v":20000,"d":"$20,000"},{"v":625,"d":"$625"},null,{"v":20625,"d":"$20,625"},{"v":2625,"d":"2,625"},{"v":-11875,"d":"11,875"}]
[2,{"v":17800,"d":"17,800"},250,{"v":18050,"d":"18,050"},{"v":20000,"d":"20,000"},625,null,{"v":20625,"d":"20,625"},{"v":2575,"d":"2,575"},{"v":-9300,"d":"9,300"}]
[3,{"v":17800,"d":"17,800"},300,{"v":18100,"d":"18,100"},{"v":20000,"d":"20,000"},625,null,{"v":20625,"d":"20,625"},{"v":2525,"d":"2,525"},{"v":-6775,"d":"6,775"}]
[4,{"v":17800,"d":"17,800"},400,{"v":18200,"d":"18,200"},{"v":20000,"d":"20,000"},625,null,{"v":20625,"d":"20,625"},{"v":2425,"d":"2,425"},{"v":-4350,"d":"4,350"}]
[5,{"v":17800,"d":"17,800"},550,{"v":18350,"d":"18,350"},{"v":20000,"d":"20,000"},625,null,{"v":20625,"d":"20,625"},{"v":2275,"d":"2,275"},{"v":-2075,"d":"2,075"}]
[6,{"v":17800,"d":"17,800"},700,{"v":18500,"d":"18,500"},{"v":20000,"d":"20,000"},625,{"v":2300,"d":"2,300"},{"v":22925,"d":"22,925"},{"v":4425,"d":"4,425"},{"v":2350,"d":"2,350"}]
[7,null,null,0,{"$nulls":3},0,0,0]
[8,null,null,0,{"$nulls":3},0,0,0]
[9,null,null,0,{"$nulls":3},0,0,0]
[10,null,null,0,{"$nulls":3},0,0,0]
[{"$nulls":8},{"v":2350,"d":"2,350"}]
[]
[{"$nulls":7},"NPV = ",{"v":-403.63049647541084,"d":"$404"}]

{"sheet":"Cash Flow Chart","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}