{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Decal 1, 2","Decal 3, 4","Long Decal","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Decal 1, 2","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["DECISION ANALYSIS 1",null,null,null,null,null,null,"IRR = CTRL-t"]
[null,null,null,null,null,{"$f":"IF(F3=1,\"Annual\",IF(F3=4,\"Quarterly\",IF(F3=12,\"Monthly\",\"\")))","v":"Annual"}]
[null," Minimum % Return:",6,"Periods/Yr:",{"$f":"C3/F3/100","v":0.06},1,"Effective =>",{"$f":"(1+E3)^F3-1","v":6.0000000000000053E-2}]
[]
["Item","First","Last","Dollars",null,"PV Rec.","PV Exp.","Cash"]
["Stave Silo",0,null,-60000,{"$f":"IF(C6-B6<=0,D6/(1+$E$3)^B6,(PV($E$3,C6-B6+1,-D6)/(1+$E$3)^(B6-1)))","v":-60000},{"$f":"IF(E6<=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":0},{"$f":"IF(E6>=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":-60000},{"$f":"IF(C6-B6<=0,D6,IF(B6=\"\",D6,D6*(C6-B6+1)))","v":-60000}]
["Salvage",20,null,{"$f":"-D6*(1-2/B7)^B7","v":7294.5992754341642},{"$f":"IF(C7-B7<=0,D7/(1+$E$3)^B7,(PV($E$3,C7-B7+1,-D7)/(1+$E$3)^(B7-1)))","v":2274.4905348201778},2274.4905348201778,0,7294.5992754341642]
["Repairs",1,20,{"$f":"2%*D6","v":-1200},-13763.905462278317,0,-13763.905462278317,-24000]
["Taxes/Insurance",1,20,{"$f":"1.5%*D6","v":-900},-10322.929096708736,0,-10322.929096708736,-18000]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
["Net PV",null,{"$f":"IF(F3=1,\"Net/Yr\",IF(F3=4,\"Net/Qtr\",IF(F3=12,\"Net/Mo\",\"Net/Period\")))","v":"Net/Yr"},"Net AV",{"$f":"MAX(MAX(B6:B19),MAX(C6:C19))","v":20},"Net FV","B/C Ratio","Net Cash"]
[{"$f":"SUM(F6:F19)+SUM(G6:G19)","v":-81812.344024166887},"",{"$f":"A21*E3*(1+E3)^E20/((1+E3)^E20-1)","v":-7132.7729689847456},{"$f":"C21*((1+E3)^F3-1)/E3","v":-7132.772968984752},"",{"$f":"A21*(1+E3)^E20","v":-262383.27058478643},{"$f":"IF(SUM(G6:G19)=0,NA(),SUM(F6:F19)/SUM(G6:G19)*(-1))","v":2.7049306193404378E-2},{"$f":"SUM(H6:H19)","v":-94705.400724565843}]
[]
[]
[]
[]
[]
[]
[]
[]
["DECISION ANALYSIS 2",null,null,null,null,null,null,"IRR = CTRL-u"]
[null,null,null,null,null,{"$f":"IF(F32=1,\"Annual\",IF(F32=4,\"Quarterly\",IF(F32=12,\"Monthly\",\"\")))","v":"Annual"}]
[null," Minimum % Return:",6,"Periods/Yr:",{"$f":"C32/F32/100","v":0.06},1,"Effective =>",{"$f":"(1+E32)^F32-1","v":6.0000000000000053E-2}]
[]
["Item","First","Last","Dollars",null,"PV Rec.","PV Exp.","Cash"]
["Unloader",0,null,-6800,{"$f":"IF(C35-B35<=0,D35/(1+$E$32)^B35,(PV($E$32,C35-B35+1,-D35)/(1+$E$32)^(B35-1)))","v":-6800},{"$f":"IF(E35<=0,0,IF(B35=\"\",D35/(1+$E$32)^C35,E35))","v":0},{"$f":"IF(E35>=0,0,IF(B35=\"\",D35/(1+$E$32)^C35,E35))","v":-6800},{"$f":"IF(C35-B35<=0,D35,IF(B35=\"\",D35,D35*(C35-B35+1)))","v":-6800}]
["Salvage",null,null,0,{"$f":"IF(C36-B36<=0,D36/(1+$E$32)^B36,(PV($E$32,C36-B36+1,-D36)/(1+$E$32)^(B36-1)))","v":0},{"$f":"IF(E36<=0,0,IF(B36=\"\",D36/(1+$E$32)^C36,E36))","v":0},{"$f":"IF(E36>=0,0,IF(B36=\"\",D36/(1+$E$32)^C36,E36))","v":0},0]
["Repairs",1,8,{"$f":"5%*D35","v":-340},-2111.3298957296502,0,-2111.3298957296502,-2720]
["Taxes/Insurance",1,8,{"$f":"1.5%*D35","v":-102},-633.39896871889505,0,-633.39896871889505,-816]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
["Net PV",null,{"$f":"IF(F32=1,\"Net/Yr\",IF(F32=4,\"Net/Qtr\",IF(F32=12,\"Net/Mo\",\"Net/Period\")))","v":"Net/Yr"},"Net AV",{"$f":"MAX(MAX(B35:B48),MAX(C35:C48))","v":8},"Net FV","B/C Ratio","Net Cash"]
[{"$f":"SUM(F35:F48)+SUM(G35:G48)","v":-9544.7288644485452},"",{"$f":"A50*E32*(1+E32)^E49/((1+E32)^E49-1)","v":-1537.0444100072771},{"$f":"C50*((1+E32)^F32-1)/E32","v":-1537.0444100072784},"",{"$f":"A50*(1+E32)^E49","v":-15212.847722520266},{"$f":"IF(SUM(G35:G48)=0,NA(),SUM(F35:F48)/SUM(G35:G48)*(-1))","v":0},{"$f":"SUM(H35:H48)","v":-10336}]

{"sheet":"Decal 3, 4","index":1,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["DECISION ANALYSIS 3",null,null,null,null,null,null,"IRR = CTRL-w"]
[null,null,null,null,null,{"$f":"IF(F3=1,\"Annual\",IF(F3=4,\"Quarterly\",IF(F3=12,\"Monthly\",\"\")))","v":"Annual"}]
[null," Minimum % Return:",6,"Periods/Yr:",{"$f":"C3/F3/100","v":0.06},1,"Effective =>",{"$f":"(1+E3)^F3-1","v":6.0000000000000053E-2}]
[]
["Item","First","Last","Dollars",null,"PV Rec.","PV Exp.","Cash"]
["Stave Silo",0,null,-60000,{"$f":"IF(C6-B6<=0,D6/(1+$E$3)^B6,(PV($E$3,C6-B6+1,-D6)/(1+$E$3)^(B6-1)))","v":-60000},{"$f":"IF(E6<=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":0},{"$f":"IF(E6>=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":-60000},{"$f":"IF(C6-B6<=0,D6,IF(B6=\"\",D6,D6*(C6-B6+1)))","v":-60000}]
["Salvage",20,null,{"$f":"-D6*(1-2/B7)^B7","v":7294.5992754341642},{"$f":"IF(C7-B7<=0,D7/(1+$E$3)^B7,(PV($E$3,C7-B7+1,-D7)/(1+$E$3)^(B7-1)))","v":2274.4905348201778},2274.4905348201778,0,7294.5992754341642]
["Repairs",1,20,{"$f":"2%*D6","v":-1200},-13763.905462278317,0,-13763.905462278317,-24000]
["Taxes/Insurance",1,20,{"$f":"1.5%*D6","v":-900},-10322.929096708736,0,-10322.929096708736,-18000]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
["Net PV",null,{"$f":"IF(F3=1,\"Net/Yr\",IF(F3=4,\"Net/Qtr\",IF(F3=12,\"Net/Mo\",\"Net/Period\")))","v":"Net/Yr"},"Net AV",{"$f":"MAX(MAX(B6:B19),MAX(C6:C19))","v":20},"Net FV","B/C Ratio","Net Cash"]
[{"$f":"SUM(F6:F19)+SUM(G6:G19)","v":-81812.344024166887},"",{"$f":"A21*E3*(1+E3)^E20/((1+E3)^E20-1)","v":-7132.7729689847456},{"$f":"C21*((1+E3)^F3-1)/E3","v":-7132.772968984752},"",{"$f":"A21*(1+E3)^E20","v":-262383.27058478643},{"$f":"IF(SUM(G6:G19)=0,NA(),SUM(F6:F19)/SUM(G6:G19)*(-1))","v":2.7049306193404378E-2},{"$f":"SUM(H6:H19)","v":-94705.400724565843}]
[]
[]
[]
[]
[]
[]
[]
[]
["DECISION ANALYSIS 4",null,null,null,null,null,null,"IRR = CTRL-x"]
[null,null,null,null,null,{"$f":"IF(F32=1,\"Annual\",IF(F32=4,\"Quarterly\",IF(F32=12,\"Monthly\",\"\")))","v":"Annual"}]
[null," Minimum % Return:",6,"Periods/Yr:",{"$f":"C32/F32/100","v":0.06},1,"Effective =>",{"$f":"(1+E32)^F32-1","v":6.0000000000000053E-2}]
[]
["Item","First","Last","Dollars",null,"PV Rec.","PV Exp.","Cash"]
["Unloader",0,null,-6800,{"$f":"IF(C35-B35<=0,D35/(1+$E$32)^B35,(PV($E$32,C35-B35+1,-D35)/(1+$E$32)^(B35-1)))","v":-6800},{"$f":"IF(E35<=0,0,IF(B35=\"\",D35/(1+$E$32)^C35,E35))","v":0},{"$f":"IF(E35>=0,0,IF(B35=\"\",D35/(1+$E$32)^C35,E35))","v":-6800},{"$f":"IF(C35-B35<=0,D35,IF(B35=\"\",D35,D35*(C35-B35+1)))","v":-6800}]
["Salvage",null,null,0,{"$f":"IF(C36-B36<=0,D36/(1+$E$32)^B36,(PV($E$32,C36-B36+1,-D36)/(1+$E$32)^(B36-1)))","v":0},{"$f":"IF(E36<=0,0,IF(B36=\"\",D36/(1+$E$32)^C36,E36))","v":0},{"$f":"IF(E36>=0,0,IF(B36=\"\",D36/(1+$E$32)^C36,E36))","v":0},0]
["Repairs",1,8,{"$f":"5%*D35","v":-340},-2111.3298957296502,0,-2111.3298957296502,-2720]
["Taxes/Insurance",1,8,{"$f":"1.5%*D35","v":-102},-633.39896871889505,0,-633.39896871889505,-816]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
["Net PV",null,{"$f":"IF(F32=1,\"Net/Yr\",IF(F32=4,\"Net/Qtr\",IF(F32=12,\"Net/Mo\",\"Net/Period\")))","v":"Net/Yr"},"Net AV",{"$f":"MAX(MAX(B35:B48),MAX(C35:C48))","v":8},"Net FV","B/C Ratio","Net Cash"]
[{"$f":"SUM(F35:F48)+SUM(G35:G48)","v":-9544.7288644485452},"",{"$f":"A50*E32*(1+E32)^E49/((1+E32)^E49-1)","v":-1537.0444100072771},{"$f":"C50*((1+E32)^F32-1)/E32","v":-1537.0444100072784},"",{"$f":"A50*(1+E32)^E49","v":-15212.847722520266},{"$f":"IF(SUM(G35:G48)=0,NA(),SUM(F35:F48)/SUM(G35:G48)*(-1))","v":0},{"$f":"SUM(H35:H48)","v":-10336}]

{"sheet":"Long Decal","index":2,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["DECISION ANALYSIS 5",null,null,null,null,null,null,"IRR = CTRL-y"]
[null,null,null,null,null,{"$f":"IF(F3=1,\"Annual\",IF(F3=4,\"Quarterly\",IF(F3=12,\"Monthly\",\"\")))","v":"Annual"}]
[null," Minimum % Return:",6,"Periods/Yr:",{"$f":"C3/F3/100","v":0.06},1,"Effective =>",{"$f":"(1+E3)^F3-1","v":6.0000000000000053E-2}]
[]
["Item","First","Last","Dollars",null,"PV Rec.","PV Exp.","Cash"]
["Investment",0,null,-60000,{"$f":"IF(C6-B6<=0,D6/(1+$E$3)^B6,(PV($E$3,C6-B6+1,-D6)/(1+$E$3)^(B6-1)))","v":-60000},{"$f":"IF(E6<=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":0},{"$f":"IF(E6>=0,0,IF(B6=\"\",D6/(1+$E$3)^C6,E6))","v":-60000},{"$f":"IF(C6-B6<=0,D6,IF(B6=\"\",D6,D6*(C6-B6+1)))","v":-60000}]
["Salvage",20,null,{"$f":"-D6*(1-2/B7)^B7","v":7294.5992754341642},2274.4905348201778,2274.4905348201778,0,7294.5992754341642]
["Income",1,20,7500,86024.409139239477,86024.409139239477,0,150000]
["Expenses",1,10,{"$f":"1.5%*D6","v":-900},-6624.0783462732315,0,-6624.0783462732315,-9000]
["Expenses",11,20,-1100,-4520.8175838656161,0,-4520.8175838656161,-11000]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,{"$f":"IF(C17-B17<=0,D17/(1+$E$3)^B17,(PV($E$3,C17-B17+1,-D17)/(1+$E$3)^(B17-1)))","v":0},{"$f":"IF(E17<=0,0,IF(B17=\"\",D17/(1+$E$3)^C17,E17))","v":0},{"$f":"IF(E17>=0,0,IF(B17=\"\",D17/(1+$E$3)^C17,E17))","v":0},{"$f":"IF(C17-B17<=0,D17,IF(B17=\"\",D17,D17*(C17-B17+1)))","v":0}]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,{"$f":"IF(C28-B28<=0,D28/(1+$E$3)^B28,(PV($E$3,C28-B28+1,-D28)/(1+$E$3)^(B28-1)))","v":0},{"$f":"IF(E28<=0,0,IF(B28=\"\",D28/(1+$E$3)^C28,E28))","v":0},{"$f":"IF(E28>=0,0,IF(B28=\"\",D28/(1+$E$3)^C28,E28))","v":0},{"$f":"IF(C28-B28<=0,D28,IF(B28=\"\",D28,D28*(C28-B28+1)))","v":0}]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,0,0,0,0]
[null,null,null,null,{"$f":"IF(C46-B46<=0,D46/(1+$E$3)^B46,(PV($E$3,C46-B46+1,-D46)/(1+$E$3)^(B46-1)))","v":0},{"$f":"IF(E46<=0,0,IF(B46=\"\",D46/(1+$E$3)^C46,E46))","v":0},{"$f":"IF(E46>=0,0,IF(B46=\"\",D46/(1+$E$3)^C46,E46))","v":0},{"$f":"IF(C46-B46<=0,D46,IF(B46=\"\",D46,D46*(C46-B46+1)))","v":0}]
[null,null,null,null,{"$f":"IF(C47-B47<=0,D47/(1+$E$3)^B47,(PV($E$3,C47-B47+1,-D47)/(1+$E$3)^(B47-1)))","v":0},{"$f":"IF(E47<=0,0,IF(B47=\"\",D47/(1+$E$3)^C47,E47))","v":0},{"$f":"IF(E47>=0,0,IF(B47=\"\",D47/(1+$E$3)^C47,E47))","v":0},{"$f":"IF(C47-B47<=0,D47,IF(B47=\"\",D47,D47*(C47-B47+1)))","v":0}]
[null,null,null,null,{"$f":"IF(C48-B48<=0,D48/(1+$E$3)^B48,(PV($E$3,C48-B48+1,-D48)/(1+$E$3)^(B48-1)))","v":0},{"$f":"IF(E48<=0,0,IF(B48=\"\",D48/(1+$E$3)^C48,E48))","v":0},{"$f":"IF(E48>=0,0,IF(B48=\"\",D48/(1+$E$3)^C48,E48))","v":0},{"$f":"IF(C48-B48<=0,D48,IF(B48=\"\",D48,D48*(C48-B48+1)))","v":0}]
["Net PV",null,{"$f":"IF(F3=1,\"Net/Yr\",IF(F3=4,\"Net/Qtr\",IF(F3=12,\"Net/Mo\",\"Net/Period\")))","v":"Net/Yr"},"Net AV",{"$f":"MAX(MAX(B6:B48),MAX(C6:C48))","v":20},"Net FV","B/C Ratio","Net Cash"]
[{"$f":"SUM(F6:F48)+SUM(G6:G48)","v":17154.003743920795},"",{"$f":"A50*E3*(1+E3)^E49/((1+E3)^E49-1)","v":1495.5642167929848},{"$f":"C50*((1+E3)^F3-1)/E3","v":1495.5642167929861},"",{"$f":"A50*(1+E3)^E49","v":55015.213897600384},{"$f":"IF(SUM(G6:G48)=0,NA(),SUM(F6:F48)/SUM(G6:G48)*(-1))","v":1.2411136248026178},{"$f":"SUM(H6:H48)","v":77294.599275434157}]

{"sheet":"Instructions","index":3,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"INPUT",null,"<PgDn> for Output Interpretation"]
[]
["  Minimum % return - Enter as an annual percentage rate (%, not decimal)"]
["                     This is the desired rate of return"]
["                     Often known as discount rate or opportunity cost"]
[]
["  Periods per year - Annual basis would be 1, monthly 12"]
["                     If monthly, the end of year 1 is period 12"]
[]
["  Note: For listing of receipts and expenses, today is period 0"]
["  First period is the first period in a sequence"]
["  Last period is the last period in a sequence"]
[]
["  Examples:",null,null,null,null,"First Per","Last Per","Dollars"]
["     Initial purchase of $1,000",null,null,null,null,0,"",-1000]
["     Salvage value of 200 end of yr 5",null,null,null,null,5,"",200]
["     Expenses of 75 each year 1-5",null,null,null,null,1,5,-75]
["     Receipts of 700 each year 3-5",null,null,null,null,3,5,700]
[]
["  Receipts are entered as positive numbers, expenses negative"]
["  IRR is a macro which replaces the %I with the IRR when CTRL-I is pressed"]
[]
[null,null,null,"OUTPUT"]
["  Effective - Annual % effective interest if compounded by periods"]
["  Net PV - (Net Present Value) Sum of discounted receipts and expenses at %I"]
["  Net AV - (Net Annual Value) Net PV amortized over the highest year; $ Return/yr"]
["  Net Per - (Net Period Value) A return per period if periods are not annual"]
["  Net FV - Net Future Value at end of analysis, considering compounding"]
["  B/C Ratio - (Benefit/Cost) PV of receipts divided by PV of expenses"]
["  Net Cash - Sum of cash receipts and expenses, no interest considered"]
["  IRR - Internal or Realized rate of return; %i which makes NPV=0"]
[]
["  Interpretation:",null,null,"Net PV,AV,FV",null,"B/C Ratio",null,"IRR"]
[null,"Profit ==>",null,"Greater than 0",null,"Greater than 1.0",null,"Greater than %I"]
[]
[null,"Breakeven =>",null,"Equal to 0",null,"Equal to 1.0",null,"Equal to %I"]
[]
[null,"Loss ====>",null,"Less than 0",null,"Less than 1.0",null,"Less than %I"]
["  Breakeven earns the interest; a loss may still exceed 0% return (IRR) if net cash>0"]