{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Project Cost Summary"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Project Cost Summary","index":0,"n_rows":44,"n_cols":15,"rows_kept":44,"merged":[[46,1,46,14]]}
[]
[]
[]
[null,"Project Cost Summary"]
[]
[null,"APPROPRIATION DETAIL"]
[null,"Project Title",{"$nulls":3},"Plant Manager",{"$nulls":3},"Product Lines",null,null,"Cost Distribution"]
[]
[null,"Project Number",{"$nulls":3},"Responsibility Center #",{"$nulls":3},"Purpose of Request",null,null,"Completion Date"]
[]
[]
[null,"PROJECT DESCRIPTION"]
[]
[]
[]
[]
[]
[null,"PROJECT JUSTIFICATION"]
[]
[]
[]
[]
[]
[null,"INVESTMENT SUMMARY"]
[{"$nulls":4},"PROJECTED by YEAR",{"$nulls":5},"ACTUAL by YEAR"]
[{"$nulls":3},"START UP","1","2","3","4","5","START UP","1","2","3","4","5"]
[null,null,"Capital Investment ",75152,5200,{"$nulls":4},125852]
[null,null,"Working Capital ",null,35000,31000,22000,14000,13000]
[null,null,"Total Investment ",{"$f":"IF(OR(D27>0,D28>0),D28+D27,\"\")","v":75152},40200,31000,22000,14000,13000,125852,"","","","",""]
[null,null,"Sales ",null,52000,65000,82000,88000,91000]
[null,null,"Net Income ",null,31000,45000,68000,71000,82000]
[null,null,"Cash Flow ",{"$f":"IF(OR(SUM(D31)>0,SUM(D29)>0),D31-D29,\"\")","v":-75152},-9200,14000,46000,57000,69000,-125852,"","","","",""]
[null,null,"Cum. Cash Flow ",{"$f":"IF(SUM(D32),D32,\"\")","v":-75152},-9200,14000,46000,57000,69000,-125852,"","","","",""]
[]
[null,"ANALYSIS"]
[{"$nulls":4},"Discounted Return on Investment ",{"v":0.152,"d":"15.20%"},{"$nulls":3},"Internal Rate of Return ",{"v":0.1375,"d":"13.75%"},null,null,"Payback in Years ",3.5]
[{"$nulls":4},"Profitability Index ",1.2,{"$nulls":3},"Modified Internal Rate of Return ",{"v":0.109,"d":"10.90%"},null,null,"Discounted Payback ",4.2]
[]
[null,"APPROVALS"]
[{"$nulls":8},"VP Finance"]
[null,"PREPARED BY",{"$nulls":3},"SIGNATURE",{"$nulls":7},"SIGNATURE"]
[{"$nulls":8},"President"]
[null,"VP RESPONSIBLE",{"$nulls":3},"SIGNATURE",{"$nulls":7},"SIGNATURE"]
[null,null,"Date",{"$nulls":6},"Date"]