{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Accounting","BV-1231","KJ-1212","RC-1000","JH-9393","RT-2391","NA-1231","HG-1231","JD-1231","DL-10100","JJ-1000","Potential Project Portfolio"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Accounting","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Name of the Item","Initial Capital Cost","Depreciation Period","Depreciation per Year","Operating Hours Per Year","Charge Rate Per Hour",null,"Job Type","Rate per Month",null,"Materials","Cost"]
[null,null,"Laser","10000","3","","300","11.1111111111111",null,"Truck Driver",5000,null,"Nintendo","10000"]
[null,null,"Truck","100000","20",5000,"100","50",null,"Machinist",2000,null,"Brickhouse","1000"]
[null,null,"Beryllium Melter","10000","10",1000,"100","10",null,"Technician",1000,null,"Wii","1000"]
["Number of Years to Develop:",null,"Proton Smasher","40000","10",4000,"700","5.71428571428571",null,"Engineer",5000,null,"Gold","10"]
[4,null,"Processor","50000","10",5000,"500",10,null,"Technologist",1000]
[null,null,"Minesweeper","50000","20",2500,"2000",1.25,null,"Accountant",10000]
[null,null,"Gun","1000","10",100,"1000",0.10000000149011612,null,"Manager",5000]
[null,null,"Dance Floor","10000","10",1000,"1000",1,null,"Courier","1000"]
[null,null,"Big Truck","10000","10",1000,"100",10,null,"Laser Technician","1000"]
["Years for Forecast:"]
[2]
[]
["Discount Rate:"]
[0.2]
[]
["Manufacturing Overhead Rate:"]
[0.3]

{"sheet":"BV-1231","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,2],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[6,0,6,1],[10,0,10,5],[11,2,11,3],[11,4,11,5],[26,0,26,1],[39,0,39,2]]}
["Project:","BV-1231"]
["Description:","lkjkj"]
["Date of Project:","kjjk"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount"]
["Technician",1000,10,10000,10,10000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount"]
["Laser",11.1111111111111]
["Truck",50,10,500,10,500]
["Beryllium Melter",10,10,100,10,100]
["Proton Smasher",5.71428571428571,10,57.143000000000001,10,57.143000000000001]
["Processor",10,10,100,10,100]
[]
["Total:",null,null,10757,null,10757]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1"]
["New Sales - Units",1]
["New Sales - Unit Price",1]
["New Sales Revenue",{"$f":"B29*B30","v":1}]
["Cannibalized Sales - Units",1]
["Cannibalized Sales - Unit Price",1]
["Cannibalized Sales Amount",{"$f":"B32*B33","v":1}]
["Unit Cost - Material & Labor",1]
["G&A - Overhead",{"$f":"B35*Accounting!$A$22","v":0.3}]
["Cost per Unit",{"$f":"B36+B35","v":1.3}]
["Gross Profit",{"$f":"B31-B34-B29*B37","v":-1.3}]
[]
["Net Present Value at 20% Discount Rate:",null,null,-16435.208333333336]
["Internal Rate of Return",null,null,0.16]

{"sheet":"KJ-1212","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[41,0,41,2],[42,0,42,2],[10,0,10,9],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[28,0,28,4]]}
["Project:","KJ-1212"]
["Description:","ki"]
["Date of Project:","lk"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1",null,"Year 2",null,"Year 3"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount","Man Months","Amount","Man Months","Amount"]
["Machinist",2000,10,20000,10,20000,10,20000,10,20000]
["Accountant",10000,10,100000,10,100000,10,100000,10,100000]
["Technologist",1000,10,10000,10,10000,10,10000,10,10000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount"]
["Truck",50,100,5000,100,5000,100,5000,100,5000]
["Beryllium Melter",10,100,1000,100,1000,100,1000,100,1000]
["Proton Smasher",5.71428571428571,100,571.42999999999995,100,571.42999999999995,100,571.42999999999995,100,571.42999999999995]
["Minesweeper",1.25,100,125,100,125,100,125,100,125]
["Processor",10,100,1000,100,1000,100,1000,100,1000]
[]
["Total:",null,null,137696,null,137696,null,137696,null,137696]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2","Year 3","Year 4"]
["New Sales - Units",11,11,11,11]
["New Sales - Units",1,111111,111111,111111]
["New Sales Revenue",{"$f":"B31*B32","v":11},{"$f":"C31*C32","v":1222221},{"$f":"D31*D32","v":1222221},{"$f":"E31*E32","v":1222221}]
["Cannibalized Sales - Units",1,1,1,1]
["Cannibalized Sales - Unit Price",1,1,1,1]
["Cannibalized Sales Amount",{"$f":"B34*B35","v":1},{"$f":"C34*C35","v":1},{"$f":"D34*D35","v":1},{"$f":"E34*E35","v":1}]
["Unit Cost - Material & Labor",1,1,1,1]
["G&A - Overhead",{"$f":"B37*Accounting!$A$22","v":0.3},{"$f":"C37*Accounting!$A$22","v":0.3},{"$f":"D37*Accounting!$A$22","v":0.3},{"$f":"E37*Accounting!$A$22","v":0.3}]
["Cost per Unit",{"$f":"B38+B37","v":1.3},{"$f":"C38+C37","v":1.3},{"$f":"D38+D37","v":1.3},{"$f":"E38+E37","v":1.3}]
["Gross Profit",{"$f":"B33-B36-B31*B39","v":-4.3000000000000007},{"$f":"C33-C36-C31*C39","v":1222205.7},{"$f":"D33-D36-D31*D39","v":1222205.7},{"$f":"E33-E36-E31*E39","v":1222205.7}]
[]
["Net Present Value at 20% Discount Rate:",null,null,2280180.0588348769]
["Internal Rate of Return",null,null,7.8761162270508418]

{"sheet":"RC-1000","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,2],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[6,0,6,1],[10,0,10,5],[11,2,11,3],[11,4,11,5],[22,0,22,1],[35,0,35,2]]}
["New Sales - Unit Price","RC-1000"]
["Description:","Core laser design"]
["Date of Project:","Sept 18 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount"]
["Technician",1000,10,10000,10,10000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount"]
["Truck",50,10,500,10,500]
[]
["Total:",null,null,10500,null,10500]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1"]
["New Sales - Units",10]
["New Sales - Unit Price",100000]
["New Sales Revenue",{"$f":"B25*B26","v":1000000}]
["Cannibalized Sales - Units",100]
["Cannibalized Sales - Unit Price",0]
["Cannibalized Sales Amount",{"$f":"B28*B29","v":0}]
["Unit Cost - Material & Labor",1000]
["G&A - Overhead",{"$f":"B31*Accounting!$A$22","v":300}]
["Cost per Unit",{"$f":"B32+B31","v":1300}]
["Gross Profit",{"$f":"B27-B30-B25*B33","v":987000}]
[]
["Net Present Value at 20% Discount Rate:",null,null,669375]
["Internal Rate of Return",null,null,92]

{"sheet":"JH-9393","index":4,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[10,0,10,3],[11,2,11,3],[22,0,22,7],[35,0,35,2],[36,0,36,2],[6,0,6,1],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1]]}
["Project:","JH-9393"]
["Description:","a;kdjf"]
["Date of Project:","kjk"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount"]
["Machinist",2000,1]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount"]
["Processor",10,1,10]
[]
["Total:",null,null,10]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7"]
["New Sales - Units",10,10,10,10,10,10,10]
["New Sales - Unit Price",10000,10000,10000,10000,10000,10000,10000]
["New Sales Revenue",100000,{"$f":"C25*C26","v":100000},100000,100000,100000,100000,100000]
["Cannibalized Sales - Units",1,1,1,1,1,1,1]
["Cannibalized Sales - Unit Price",11111,11111,11111,11111,11111,11111,11111]
["Cannibalized Sales Amount",{"$f":"B28*B29","v":11111},11111,11111,11111,11111,11111,11111]
["Unit Cost - Material & Labor",111,111,111,111,111,111,111]
["G&A - Overhead",{"$f":"B31*Accounting!$A$22","v":33.299999999999997},{"$f":"C31*Accounting!$A$22","v":33.299999999999997},{"$f":"D31*Accounting!$A$22","v":33.299999999999997},{"$f":"E31*Accounting!$A$22","v":33.299999999999997},{"$f":"F31*Accounting!$A$22","v":33.299999999999997},{"$f":"G31*Accounting!$A$22","v":33.299999999999997},{"$f":"H31*Accounting!$A$22","v":33.299999999999997}]
["Cost per Unit",{"$f":"B32+B31","v":144.30000000000001},144.30000000000001,144.30000000000001,144.30000000000001,144.30000000000001,144.30000000000001,144.30000000000001]
["Gross Profit",{"$f":"B27-B30-B25*B33","v":87446},87446,87446,87446,87446,87446,87446]
[]
["Net Present Value at 20% Discount Rate:",null,null,262664.27615002479]
["Internal Rate of Return",null,null,2.2200000000000002]

{"sheet":"RT-2391","index":5,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[43,0,43,2],[44,0,44,2],[10,0,10,9],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[30,0,30,7]]}
["Project:","RT-2391"]
["Description:","High Definition Laser Photography"]
["Date of Project:","Sept 10, 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1",null,"Year 2",null,"Year 3"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount","Man Months","Amount","Man Months","Amount"]
["Truck Driver",5000,10,50000,10,50000,10,50000,10,50000]
["Machinist",2000,1,2000,10,20000,8,16000,7,14000]
["Technician",1000,1,1000,6,6000,4,4000,8,8000]
["Engineer",5000,6,30000,4,20000,7,35000,5,25000]
["Technologist",1000,5,5000,8,8000,4,4000,11,11000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount"]
["Laser",11.1111111111111,1,11.1111,3,33.333300000000001,2,22.222200000000001,2,22.222200000000001]
["Truck",50,200,10000,200,10000,200,10000,200,10000]
["Beryllium Melter",10,200,2000,200,2000,200,2000,200,2000]
["Proton Smasher",5.71428571428571,5,28.5715,50,285.71499999999997,50,285.71499999999997,50,285.71499999999997]
["Processor",10,50,500,50,500,50,500,50,500]
[]
["Total:",null,null,100540,null,116819,null,121808,null,120808]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7"]
["New Sales - Units",10,10,10,10,10,10,10]
["New Sales - Unit Price",100000,100000,100000,100000,100000,100000,100000]
["New Sales Revenue",{"$f":"B33*B34","v":1000000},1000000,1000000,1000000,1000000,1000000,1000000]
["Cannibalized Sales - Units",0,0,0,1,0,1,1]
["Cannibalized Sales - Unit Price",0,0,0,50000,0,50000,50000]
["Cannibalized Sales Amount",{"$f":"B36*B37","v":0},0,0,50000,0,50000,50000]
["Unit Cost - Material & Labor",5000,5000,5000,5000,5000,5000,5000]
["G&A - Overhead",{"$f":"B39*Accounting!$A$22","v":1500},{"$f":"C39*Accounting!$A$22","v":1500},{"$f":"D39*Accounting!$A$22","v":1500},{"$f":"E39*Accounting!$A$22","v":1500},{"$f":"F39*Accounting!$A$22","v":1500},{"$f":"G39*Accounting!$A$22","v":1500},{"$f":"H39*Accounting!$A$22","v":1500}]
["Cost per Unit",{"$f":"B40+B39","v":6500},6500,6500,6500,6500,6500,6500]
["Gross Profit",{"$f":"B35-B38-B33*B41","v":935000},935000,935000,885000,935000,885000,885000]
[]
["Net Present Value at 20% Discount Rate:",null,null,2469242.9758944907]
["Internal Rate of Return",null,null,8.1335381132783269]

{"sheet":"NA-1231","index":6,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,2],[10,0,10,7],[11,2,11,3],[11,4,11,5],[11,6,11,7],[26,0,26,2],[39,0,39,2],[6,0,6,1],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1]]}
["Project:","NA-1231"]
["Description:","Triple Laser"]
["Date of Project:","Sept 12 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1",null,"Year 2"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount","Man Months","Amount"]
["Machinist",2000,10,20000,10,20000,10,20000]
["Technician",1000,10,10000,10,10000,10,10000]
["Engineer",5000,10,50000,10,50000,10,50000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount"]
["Laser",11.1111111111111,10,111.111,10,111.111,10,111.111]
["Truck",50,10,500,10,500,10,500]
["Beryllium Melter",10,10,100,10,100,10,100]
[]
["Total:",null,null,80711,null,80711,null,80711]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2"]
["New Sales - Units",null,11]
["New Sales - Unit Price",1111111,111111]
["New Sales Revenue",{"$f":"B29*B30","v":0},{"$f":"C29*C30","v":1222221}]
["Cannibalized Sales - Units",1,1]
["Cannibalized Sales - Unit Price",1,1]
["Cannibalized Sales Amount",{"$f":"B32*B33","v":1},{"$f":"C32*C33","v":1}]
["Unit Cost - Material & Labor",1,1]
["G&A - Overhead",{"$f":"B35*Accounting!$A$22","v":0.3},{"$f":"C35*Accounting!$A$22","v":0.3}]
["Cost per Unit",{"$f":"B36+B35","v":1.3},{"$f":"C36+C35","v":1.3}]
["Gross Profit",{"$f":"B31-B34-B29*B37","v":-1},{"$f":"C31-C34-C29*C37","v":1222205.7}]
[]
["Net Present Value at 20% Discount Rate:",null,null,537278.04398148146]
["Internal Rate of Return",null,null,2.2938037817989825]

{"sheet":"HG-1231","index":7,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,2],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[6,0,6,1],[10,0,10,5],[11,2,11,3],[11,4,11,5],[26,0,26,3],[39,0,39,2]]}
["Project:","HG-1231"]
["Description:","Mercury Balance"]
["Date of Project:","Sept 8 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount"]
["Truck Driver",5000,10,50000,10,50000]
["Machinist",2000,10,20000,10,20000]
["Technician",1000,10,10000,10,10000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount"]
["Laser",11.1111111111111]
["Truck",50,100,5000,100,5000]
["Beryllium Melter",10,100,1000,100,1000]
[]
["Total:",null,null,86000,null,86000]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2","Year 3"]
["New Sales - Units",10,10,10]
["New Sales - Unit Price",100000,100000,100000]
["New Sales Revenue",{"$f":"B29*B30","v":1000000},{"$f":"C29*C30","v":1000000},{"$f":"D29*D30","v":1000000}]
["Cannibalized Sales - Units",0,0,0]
["Cannibalized Sales - Unit Price",0,0,0]
["Cannibalized Sales Amount",{"$f":"B32*B33","v":0},{"$f":"C32*C33","v":0},{"$f":"D32*D33","v":0}]
["Unit Cost - Material & Labor",0,0,0]
["G&A - Overhead",{"$f":"B35*Accounting!$A$22","v":0},{"$f":"C35*Accounting!$A$22","v":0},{"$f":"D35*Accounting!$A$22","v":0}]
["Cost per Unit",{"$f":"B36+B35","v":0},{"$f":"C36+C35","v":0},{"$f":"D36+D35","v":0}]
["Gross Profit",{"$f":"B31-B34-B29*B37","v":1000000},{"$f":"C31-C34-C29*C37","v":1000000},{"$f":"D31-D34-D29*D37","v":1000000}]
[]
["Net Present Value at 20% Discount Rate:",null,null,1624012.3456790124]
["Internal Rate of Return",null,null,10.706083833050752]

{"sheet":"JD-1231","index":8,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,2],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[6,0,6,1],[10,0,10,5],[11,2,11,3],[11,4,11,5],[25,0,25,2],[38,0,38,2]]}
["Project:","JD-1231"]
["Description:","New Silver Reflector"]
["Date of Project:","Sept 12 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount"]
["Machinist",2000,10,20000,10,20000]
["Technologist",1000,10,10000,10,10000]
["Manager",5000,10,50000,10,50000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount"]
["Beryllium Melter",10,100,1000,100,1000]
["Truck",50,100,5000,100,5000]
[]
["Total:",null,null,86000,null,86000]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2"]
["New Sales - Units",10,10]
["New Sales - Unit Price",111111,111111]
["New Sales Revenue",{"$f":"B28*B29","v":1111110},{"$f":"C28*C29","v":1111110}]
["Cannibalized Sales - Units",1,1]
["Cannibalized Sales - Unit Price",100000,100000]
["Cannibalized Sales Amount",{"$f":"B31*B32","v":100000},{"$f":"C31*C32","v":100000}]
["Unit Cost - Material & Labor",10000,50000]
["G&A - Overhead",{"$f":"B34*Accounting!$A$22","v":3000},{"$f":"C34*Accounting!$A$22","v":15000}]
["Cost per Unit",{"$f":"B35+B34","v":13000},{"$f":"C35+C34","v":65000}]
["Gross Profit",{"$f":"B30-B33-B28*B36","v":881110},{"$f":"C30-C33-C28*C36","v":361110}]
[]
["Net Present Value at 20% Discount Rate:",null,null,689468.75000000012]
["Internal Rate of Return",null,null,8.6792738456655592]

{"sheet":"DL-10100","index":9,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[38,0,38,2],[39,0,39,2],[10,0,10,9],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[25,0,25,2]]}
["Project:","DL-10100"]
["Description:","Nintendo"]
["Date of Project:","Spet 10 2010"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1",null,"Year 2",null,"Year 3"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount","Man Months","Amount","Man Months","Amount"]
["Truck Driver",5000,10,50000,10,50000,10,50000,10,50000]
["Machinist",2000,10,20000,10,20000,10,20000,10,20000]
["Technician",1000,10,10000,10,10000,10,10000,10,10000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount"]
["Truck",50,100,5000,100,5000,100,5000,100,5000]
["Proton Smasher",5.71428571428571,100,571.42999999999995,100,571.42999999999995,100,571.42999999999995,100,571.42999999999995]
[]
["Total:",null,null,85571,null,85571,null,85571,null,85571]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2"]
["New Sales - Units",10,10]
["New Sales - Unit Price",100000,100000]
["New Sales Revenue",{"$f":"B28*B29","v":1000000},{"$f":"C28*C29","v":1000000}]
["Cannibalized Sales - Units",1,1]
["Cannibalized Sales - Unit Price",10000,10000]
["Cannibalized Sales Amount",{"$f":"B31*B32","v":10000},{"$f":"C31*C32","v":10000}]
["Unit Cost - Material & Labor",1000,1000]
["G&A - Overhead",{"$f":"B34*Accounting!$A$22","v":300},{"$f":"C34*Accounting!$A$22","v":300}]
["Cost per Unit",{"$f":"B35+B34","v":1300},{"$f":"C35+C34","v":1300}]
["Gross Profit",{"$f":"B30-B33-B28*B36","v":977000},{"$f":"C30-C33-C28*C36","v":977000}]
[]
["Net Present Value at 20% Discount Rate:",null,null,1022345.1350308643]
["Internal Rate of Return",null,null,10.329151589891097]

{"sheet":"JJ-1000","index":10,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,2],[38,0,38,2],[10,0,10,9],[11,2,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[24,0,24,2],[0,1,0,7],[1,1,1,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[6,0,6,1]]}
["Project:","JJ-1000"]
["Description:","w"]
["Date of Project:","adf"]
[]
["Assumptions:"]
["G&A and O/H Rate",null,{"$f":"Accounting!A22","v":0.3}]
["Discount Rate",null,{"$f":"Accounting!A19","v":0.2}]
[]
[]
[]
["Development Cost"]
[null,null,"Year 0",null,"Year 1",null,"Year 2",null,"Year 3"]
["Labor Costs","Monthly Wage Rate","Man Months","Amount","Man Months","Amount","Man Months","Amount","Man Months","Amount"]
["Truck Driver",5000,10,50000,10,50000,10,50000,10,50000]
["Machinist",2000,10,20000,10,20000,10,20000,10,20000]
[]
[]
["Capital Inputs","Hourly Rate","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount","Hours per Year","Amount"]
["Laser",11.1111111111111,100,1111.1099999999999,100,1111.1099999999999,100,1111.1099999999999,100,1111.1099999999999]
["Truck",50,100,5000,100,5000,100,5000,100,5000]
[]
["Total:",null,null,76111,null,76111,null,76111,null,76111]
[]
[]
["Revenue and Profit Forecast"]
[null,"Year 1","Year 2"]
["New Sales - Units",10,10]
["New Sales - Unit Price",100000,100000]
["New Sales Revenue",{"$f":"B27*B28","v":1000000},{"$f":"C27*C28","v":1000000}]
["Cannibalized Sales - Units",1,1]
["Cannibalized Sales - Unit Price",10000,10000]
["Cannibalized Sales Amount",{"$f":"B30*B31","v":10000},{"$f":"C30*C31","v":10000}]
["Unit Cost - Material & Labor",1000,1000]
["G&A - Overhead",{"$f":"B33*Accounting!$A$22","v":300},{"$f":"C33*Accounting!$A$22","v":300}]
["Cost per Unit",{"$f":"B34+B33","v":1300},{"$f":"C34+C33","v":1300}]
["Gross Profit",{"$f":"B29-B32-B27*B35","v":977000},{"$f":"C29-C32-C27*C35","v":977000}]
[]
["Net Present Value at 20% Discount Rate:",null,null,1046834.56404321]
["Internal Rate of Return",null,null,11.758133719770235]

{"sheet":"Potential Project Portfolio","index":11,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Potential Project Portfolio"]
["Potential Project","Camera Type","Market Drivers","Target Customers","Target Sales Price","Units per Year Average","NPV","IRR","Project Status"]
["BV-1231",null,null,null,null,1,-16435.208299999998,0.16]
["KJ-1212",null,null,null,null,11,2280180.0588000002,7.8761162270508418]
["RC-1000",null,null,null,null,10,669375,92]
["JH-9393",null,null,null,null,10,262664.27620000002,2.2200000000000002]
["RT-2391",null,null,null,null,10,2469242.9759,8.1335381132783269]
["NA-1231",null,null,null,null,5.5,537278.04399999999,2.2938037817989825]
["HG-1231",null,null,null,null,10,1624012.3456999999,10.706083833050752]
["JD-1231",null,null,null,null,10,689468.75,8.6792738456655592]
["DL-10100",null,null,null,null,10,1022345.135,10.329151589891097]
["JJ-1000",null,null,null,null,10,1046834.564,11.758133719770235]