{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OwnerOperator Cost Benefit "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"OwnerOperator Cost Benefit ","index":0,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[34,0,34,4],[56,0,57,4],[10,0,10,4],[0,3,0,4],[5,3,8,4],[11,2,14,2],[11,1,14,1],[11,0,14,0],[11,3,14,3],[11,4,14,4],[35,4,38,4],[35,1,38,1],[35,3,38,3],[35,0,38,0],[35,2,38,2]]}
["Owner/Operator Cost Benefit Analysis",null,"Name/Descriptn:"]
["For Applying Conservation Practices",null,"Date:",{"$f":"TODAY()","v":"2022-09-13"}]
["Enter data on underscored light green fields",null,"Groundbreaking is Year 0.  Use Current-Year $."]
["Discount Rate*:",null,"*Normally use loan % if borrowing, CD % if using own $"]
["Project Lifespan (yrs)**:",null,"**Normally use program or loan duration"]
["Annualized Benefits:",{"$f":"+E51","v":0},"Notes:"]
["Annualized Costs:",{"$f":"+E33","v":0}]
["Annualized Net Benefits:",{"$f":"+B6-B7","v":0}]
["Benefit/Cost Ratio:",{"$f":"IF(B7=0,\"Awaiting Input\",IF(B6<=0,\"Not Meaningful\",B6/B7))","v":"Awaiting Input"}]
[null,null,"Press Ctrl+k to clear all data entry cells"]
["COSTS",null,null,null,null,"A"]
["Cost Description","Dollar Value            of Costs","Enter Year of                       Occurrence            or A = Annual     or 0 = Initial","Present Dollar         Value of Costs","Annualized Dollar    Value of Costs",0]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,{"$f":"IF(C16=0,B16,IF(C16=\"A\",-PV($B$4,$B$5,$B16),IF(C16>$B$5, \"year outside lifespan\",(B16/((1+$B$4)^$C16)))))","v":0},{"$f":"IF(G16=TRUE,\"$0\",-PMT($B$4,$B$5,D16))","v":"$0"},4,{"$f":"ISERROR(-PMT($B$4,$B$5,D16))","v":true}]
[null,null,null,{"$f":"IF(C17=0,B17,IF(C17=\"A\",-PV($B$4,$B$5,$B17),IF(C17>$B$5, \"year outside lifespan\",(B17/((1+$B$4)^$C17)))))","v":0},{"$f":"IF(G17=TRUE,\"$0\",-PMT($B$4,$B$5,D17))","v":"$0"},5,{"$f":"ISERROR(-PMT($B$4,$B$5,D17))","v":true}]
[null,null,null,0,"$0",6,true]
[null,null,null,0,"$0",7,true]
[null,null,null,0,"$0",8,true]
[null,null,null,0,"$0",9,true]
[null,null,null,0,"$0",10,true]
[null,null,null,0,"$0",11,true]
[null,null,null,0,"$0",12,true]
[null,null,null,0,"$0",13,true]
[null,null,null,0,"$0",14,true]
[null,null,null,0,"$0",15,true]
[null,null,null,0,"$0",16,true]
[null,null,null,0,"$0",17,true]
[null,null,null,0,"$0",18,true]
[null,null,null,0,"$0",19,true]
[null,null,null,0,"$0",20,true]
["Totals",null,null,null,{"$f":"+SUM(E16:E32)","v":0},21,true]
[null,null,null,null,null,22]
["BENEFITS",null,null,null,null,23]
["Benefit Description","Dollar Value            of Benefits","Enter Year of              Occurrence            or A = Annual     or 0 = Initial","Present Dollar         Value of Benefits","Annualized Dollar    Value of Benefits",24]
[null,null,null,null,null,25]
[null,null,null,null,null,26]
[null,null,null,null,null,27]
[null,null,null,{"$f":"IF(C40=0,B40,IF(C40=\"A\",-PV($B$4,$B$5,$B40),IF(C40>$B$5, \"year outside lifespan\",(B40/((1+$B$4)^$C40)))))","v":0},{"$f":"IF(G40=TRUE,\"$0\",-PMT($B$4,$B$5,D40))","v":"$0"},28,{"$f":"ISERROR(-PMT($B$4,$B$5,D40))","v":true}]
[null,null,null,{"$f":"IF(C41=0,B41,IF(C41=\"A\",-PV($B$4,$B$5,$B41),IF(C41>$B$5, \"year outside lifespan\",(B41/((1+$B$4)^$C41)))))","v":0},"$0",29,true]
[null,null,null,0,"$0",30,true]
[null,null,null,0,"$0",31,true]
[null,null,null,0,"$0",32,true]
[null,null,null,0,"$0",33,true]
[null,null,null,0,"$0",34,true]
[null,null,null,0,"$0",35,true]
[null,null,null,0,"$0",36,true]
[null,null,null,0,"$0",37,true]
[null,null,null,0,"$0",38,true]
["Totals",null,null,null,{"$f":"+SUM(E40:E50)","v":0},39]
["For an electronic copy of this Excel format spreadsheet call Dale Pekar at 717-237-2218 or email Dale.Pekar@pa.usda.gov",null,null,null,null,40]
[null,null,null,null,null,41]
[null,null,null,null,null,42]
[null,null,null,null,null,43]
[null,null,null,null,null,44]
[null,null,null,null,null,45]
[null,null,null,null,null,46]
[null,null,null,null,null,47]
[null,null,null,null,null,48]
[null,null,null,null,null,49]
[null,null,null,null,null,50]
[null,null,null,null,null,51]
[null,null,null,null,null,52]
[null,null,null,null,null,53]
[null,null,null,null,null,54]
[null,null,null,null,null,55]
[null,null,null,null,null,56]
[null,null,null,null,null,57]
[null,null,null,null,null,58]
[null,null,null,null,null,59]
[null,null,null,null,null,60]
[null,null,null,null,null,61]
[null,null,null,null,null,62]
[null,null,null,null,null,63]
[null,null,null,null,null,64]
[null,null,null,null,null,65]
[null,null,null,null,null,66]
[null,null,null,null,null,67]
[null,null,null,null,null,68]
[null,null,null,null,null,69]
[null,null,null,null,null,70]
[null,null,null,null,null,71]
[null,null,null,null,null,72]
[null,null,null,null,null,73]
[null,null,null,null,null,74]
[null,null,null,null,null,75]
[null,null,null,null,null,76]
[null,null,null,null,null,77]
[null,null,null,null,null,78]
[null,null,null,null,null,79]
[null,null,null,null,null,80]
[null,null,null,null,null,81]
[null,null,null,null,null,82]
[null,null,null,null,null,83]
[null,null,null,null,null,84]
[null,null,null,null,null,85]
[null,null,null,null,null,86]
[null,null,null,null,null,87]
[null,null,null,null,null,88]
[null,null,null,null,null,89]
[null,null,null,null,null,90]
[null,null,null,null,null,91]
[null,null,null,null,null,92]
[null,null,null,null,null,93]
[null,null,null,null,null,94]
[null,null,null,null,null,95]
[null,null,null,null,null,96]
[null,null,null,null,null,97]
[null,null,null,null,null,98]
[null,null,null,null,null,99]
[null,null,null,null,null,100]