{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Description","Inputs","Econ Analysis","OneCost","OnePayment","AnnualPayments","Cropland Trends","Programs","TaxInfo","Budget","NPV"],"not_rendered":{"charts":3,"images":54,"macros":1,"external_links":1,"defined_names":33,"comments":5,"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":"Introduction","index":0,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[58,5,58,7],[58,9,58,10],[62,1,64,11],[66,1,68,11],[30,1,30,4],[32,1,37,11],[38,1,40,11],[44,1,50,11],[51,1,52,11],[57,17,57,18],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11]]}
[]
[]
[null,"KSU-Streambank Stabilization"]
[]
[null,"An Excel spreadsheet program to estimate the economic benefits and costs of streambank stabilization projects."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 3.1.2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"This program is designed to analyze streambank stabilization projects based upon the economic benefits and costs at the individual level (i.e., societal benefits and costs are not included in the analysis). "]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly."]
[null,"Visit the Description sheet which  displays examples of streambank projects. When you proceed to the Inputs sheet, enter your crop field and stabilization project data into the purple cells. IMPORTANT - Answer all questions in order from top to bottom and take note of the units assigned to each input. There are links to worksheets that can help you determine your one-time and annual costs and payments. After entering your data, click on the Perform Economic Analysis button to read the estimated results of stabilizing a streambank on your crop field. The following sheets (Budget and Result) contain \"background\" data for the program. The Programs sheet exhibits the different funding programs available for the vegetative portion of the stabilization area. This sheet is a resource to view as you think about applying for financial assistance. The turquoise cells represent the funding programs typically utilized for vegetative buffers."]
[]
[]
[]
[]
[]
[null,"Some of the sheets contain a Print Screen button. Clicking on this button will print only the screen that you are viewing. On the Inputs sheet, there is a Print Entire Report button which will print every sheet in the workbook. "]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Several of the cells have a red triangle in the upper right hand corner of the cell. By moving your mouse cursor over this triangle, a brief description of the cell will be displayed on the screen.  "]
[]
[]
[]
[]
[]
[]
[null,"If you have questions, please contact:"]
[]
[]
[null,"Robin Reid",null,null,null,"Jeff Williams",null,null,null,"Originally Developed by:"]
[null,"Extension Associate",null,null,null,"Professor",null,null,null,"Craig Smith"]
[null,"Dept. of Agricultural Economics",null,null,null,"Dept. of Agricultural Economics",null,null,null,"Watershed Economist"]
[null,"Kansas State University",null,null,null,"Kansas State University",null,null,null,"Kansas State University"]
[null,"robinreid@ksu.edu",null,null,null,"jwilliam@ksu.edu"]
[null,"785-532-0964",null,null,null,"785-532-4491"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The developers would like to express their appreciation for the helpful comments and contributions of Katie Burke, Andrew Klein, John Leatherman, Phil Balch, Paul Clark, Richard Llewelyn, and Doug Blex on this or earlier versions of this spreadsheet."]
[]
[]
[]
[null,"Funded in part through the Kansas Department of Health and Environment by U.S. EPA Section 319 Funds in support of Kansas Watershed Restoration and Protection Strategies (WRAPS)."]
[]
[]
[null,"Copyright 2017 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Description","index":1,"n_rows":109,"n_cols":12,"rows_kept":109,"cut":false,"hidden":false,"merged":[[5,1,9,19],[104,1,106,20],[108,1,109,20]]}
[]
[]
[]
[]
[]
[null,"Streambank Stabilization projects can reduce the amount of streambank erosion and help prevent the loss of valuable cropland. Reducing streambank erosion can result in economic benefits at both the individual (e.g., preserving cropland) and societal level (e.g., reducing reservoir sedimentation). This spreadsheet program can help estimate the economic benefits and costs at the individual level. The following figures give a description of one type of streambank stabilization project using bendway weirs or rock vanes in combination with the establishment of riparian area vegetation."]
[]
[]
[]
[]
[]
[null,"Figure 1: Example Streambank Stabilization Profile",null,null,null,null,null,null,null,null,null,"Figure 2: Bendway Weir Theory -- One option for stabilizing a streambank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 3: Initial condition",null,null,null,null,null,null,null,null,null,"Figure 4: After grading and weir installation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 5: After stabilization and vegetation planting",null,null,null,null,null,null,null,null,null,"Figure 6: After large flow events"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This Decision-Assistance Tool will help you evaluate the economic benefits and costs of a streambank stabilization project."]
[null,"In general, the benefits of a streambank stabilization project come in the form of: value of acres not lost to erosion, income from being able to crop the preserved acres not in CCRP acres, cost-share and incentive payments, and tax breaks from the reclassification of ag land. "]
[]
[]
[]
[null,"The costs of a streambank stabilization project come in the form of: one time installation costs, annual maintenance costs, and the initial loss of cropping income from cropland being taken out of production and enrolled into CCRP."]

{"sheet":"Inputs","index":2,"n_rows":178,"n_cols":6,"rows_kept":178,"cut":false,"hidden":false,"merged":[[31,1,31,3],[38,1,38,3],[43,1,43,3],[1,1,1,3],[11,1,11,3],[18,1,18,3],[25,1,25,3]]}
[null,null,null,"*Pay attention to Units!"]
[null,"Field Inputs"]
[null,"Kansas County","MARSHALL","County"]
[null,"Total Size of Field",80,"acres"]
[null,"Cropland Value",5500,"dollars / acre"]
[null,"Annual Cropland Value Growth Rate",4.1000000000000002E-2,"percent"]
[null,"Cropland Rental Rate - not CCRP rental rate",80,"dollars / acre / year"]
[null,"Annual Cropland Rental Growth Rate",2.1999999999999999E-2,"percent"]
[null,{"$f":"IF(C2=\"Cash-Rent Tenant\",\"N/A\",\"Property Taxes\")","v":"Property Taxes"},12,"dollars / acre"]
[null,"Opportunity Cost of Your Money",0.05,"percent"]
[]
[null,"Project Information"]
[null,"Project Length",1200,"feet"]
[null,"Project Width",66,"feet"]
[null,"Project Area",{"$f":"((C13*C14)/43560)*1.2","v":2.1818181818181817},"acres"]
[null,"Estimated Acreage Lost to Erosion",10,"acres"]
[null,"Time Period over which this Loss  Occurred",15,"years"]
[]
[null,"One Time Costs"]
[null,"Engineering and Design",{"$f":"OneCost!L7","v":18175},"dollars"]
[null,"Streambank Stabilization Costs",{"$f":"OneCost!L34","v":49085.5},"dollars"]
[null,"Vegetative Buffer Costs",{"$f":"OneCost!L59","v":5138.375},"dollars"]
[null,"Other Costs",500,"dollars"]
[null,"TOTAL ONE TIME COSTS",{"$f":"SUM(C20:C23)","v":72898.875},"dollars"]
[]
[null,"Annual Costs"]
[null,"Annual Maintenance Costs",0,"dollars / acre / year"]
[null,"Other Annual Costs",0,"dollars / acre / year"]
[null,"Inflation Rate of Annual Costs",0.04,"percent"]
[null,"TOTAL ANNUAL COSTS",{"$f":"SUM(C27:C28)","v":0},"dollars / acre / year"]
[]
[null,"One Time Payments Received"]
[null,"One Time Cost-share / Incentive Payments",{"$f":"OnePayment!$J$18","v":71495.494318181823},"dollars"]
[null,"Other Payments",0,"dollars"]
[null,"Management Payment",{"$f":"(2/3*C15)*(87.5)+(1/3*C15)*(33+8.5)","v":157.45454545454544},"dollars"]
[null,"Contract Year Received",8]
[null,"TOTAL ONE TIME PAYMENTS",{"$f":"SUM(C33:C34)","v":71495.494318181823},"dollars"]
[null,null,{"$f":"AnnualPayments!$J$8","v":114.36361477485438}]
[null,"Annual Payments Received"]
[null,"Annual Rental / Incentive Payments",{"$f":"AnnualPayments!$J$8","v":114.36361477485438},"dollars / acre / year"]
[null,"Other Annual Payments",0,"dollars / acre / year"]
[null,"TOTAL ANNUAL PAYMENTS",{"$f":"SUM(C40:C41)","v":114.36361477485438},"dollars / acre / year"]
[]
[null,"Financial Assistance"]
[null,"Continuous CRP Contract Length - Time period for Economic Analysis",15,"years"]
[null,"Property Tax Reduction",0,"percent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,10]
[null,null,null,null,null,11]
[null,null,null,null,null,12]
[null,{"$f":"VLOOKUP(C3,B74:C178,2)","v":95.303012312378655},null,null,null,13]
[null,null,null,null,null,14]
[null,{"$f":"AnnualPayments!B27","v":"ALLEN"},{"$f":"AnnualPayments!D27","v":68.121284016118111},null,null,15]
[null,{"$f":"AnnualPayments!B28","v":"ANDERSON"},{"$f":"AnnualPayments!D28","v":79.216470910960595}]
[null,{"$f":"AnnualPayments!B29","v":"ATCHISON"},{"$f":"AnnualPayments!D29","v":106.87621057321608}]
[null,{"$f":"AnnualPayments!B30","v":"BARBER"},{"$f":"AnnualPayments!D30","v":49.793104789886151}]
[null,{"$f":"AnnualPayments!B31","v":"BARTON"},{"$f":"AnnualPayments!D31","v":47.450644579790612}]
[null,{"$f":"AnnualPayments!B32","v":"BOURBON"},{"$f":"AnnualPayments!D32","v":71.64968184936113}]
[null,{"$f":"AnnualPayments!B33","v":"BROWN"},{"$f":"AnnualPayments!D33","v":118.21333151717518}]
[null,{"$f":"AnnualPayments!B34","v":"BUTLER"},{"$f":"AnnualPayments!D34","v":65.02759801163009}]
[null,{"$f":"AnnualPayments!B35","v":"CHASE"},{"$f":"AnnualPayments!D35","v":76.475042024978819}]
[null,{"$f":"AnnualPayments!B36","v":"CHAUTAUQUA"},{"$f":"AnnualPayments!D36","v":58.235508669123419}]
[null,{"$f":"AnnualPayments!B37","v":"CHEROKEE"},{"$f":"AnnualPayments!D37","v":72.276650735597059}]
[null,{"$f":"AnnualPayments!B38","v":"CHEYENNE"},{"$f":"AnnualPayments!D38","v":43.159940837218194}]
[null,{"$f":"AnnualPayments!B39","v":"CLARK"},{"$f":"AnnualPayments!D39","v":44.650118400257817}]
[null,{"$f":"AnnualPayments!B40","v":"CLAY"},{"$f":"AnnualPayments!D40","v":73.349706637622759}]
[null,{"$f":"AnnualPayments!B41","v":"CLOUD"},{"$f":"AnnualPayments!D41","v":68.120942005741028}]
[null,{"$f":"AnnualPayments!B42","v":"COFFEY"},{"$f":"AnnualPayments!D42","v":73.383539393673189}]
[null,{"$f":"AnnualPayments!B43","v":"COMANCHE"},{"$f":"AnnualPayments!D43","v":42.276706131151123}]
[null,{"$f":"AnnualPayments!B44","v":"COWLEY"},{"$f":"AnnualPayments!D44","v":55.339937923444644}]
[null,{"$f":"AnnualPayments!B45","v":"CRAWFORD"},{"$f":"AnnualPayments!D45","v":68.412367698914125}]
[null,{"$f":"AnnualPayments!B46","v":"DECATUR"},{"$f":"AnnualPayments!D46","v":49.230444077403426}]
[null,{"$f":"AnnualPayments!B47","v":"DICKINSON"},{"$f":"AnnualPayments!D47","v":68.391808522058767}]
[null,{"$f":"AnnualPayments!B48","v":"DONIPHAN"},{"$f":"AnnualPayments!D48","v":138.60079309245688}]
[null,{"$f":"AnnualPayments!B49","v":"DOUGLAS"},{"$f":"AnnualPayments!D49","v":83.28374534430921}]
[null,{"$f":"AnnualPayments!B50","v":"EDWARDS"},{"$f":"AnnualPayments!D50","v":45.764334641946142}]
[null,{"$f":"AnnualPayments!B51","v":"ELK"},{"$f":"AnnualPayments!D51","v":66.104385808522025}]
[null,{"$f":"AnnualPayments!B52","v":"ELLIS"},{"$f":"AnnualPayments!D52","v":46.353464447323631}]
[null,{"$f":"AnnualPayments!B53","v":"ELLSWORTH"},{"$f":"AnnualPayments!D53","v":56.249867533589459}]
[null,{"$f":"AnnualPayments!B54","v":"FINNEY"},{"$f":"AnnualPayments!D54","v":53.495363082589705}]
[null,{"$f":"AnnualPayments!B55","v":"FORD"},{"$f":"AnnualPayments!D55","v":46.463523777101308}]
[null,{"$f":"AnnualPayments!B56","v":"FRANKLIN"},{"$f":"AnnualPayments!D56","v":77.679981901399145}]
[null,{"$f":"AnnualPayments!B57","v":"GEARY"},{"$f":"AnnualPayments!D57","v":79.507636753785135}]
[null,{"$f":"AnnualPayments!B58","v":"GOVE"},{"$f":"AnnualPayments!D58","v":50.316864145125777}]
[null,{"$f":"AnnualPayments!B59","v":"GRAHAM"},{"$f":"AnnualPayments!D59","v":50.200665226427283}]
[null,{"$f":"AnnualPayments!B60","v":"GRANT"},{"$f":"AnnualPayments!D60","v":45.137219215279302}]
[null,{"$f":"AnnualPayments!B61","v":"GRAY"},{"$f":"AnnualPayments!D61","v":63.580020878597324}]
[null,{"$f":"AnnualPayments!B62","v":"GREELEY"},{"$f":"AnnualPayments!D62","v":42.664372563629101}]
[null,{"$f":"AnnualPayments!B63","v":"GREENWOOD"},{"$f":"AnnualPayments!D63","v":70.180363620659875}]
[null,{"$f":"AnnualPayments!B64","v":"HAMILTON"},{"$f":"AnnualPayments!D64","v":40.546647348774655}]
[null,{"$f":"AnnualPayments!B65","v":"HARPER"},{"$f":"AnnualPayments!D65","v":47.176912185725911}]
[null,{"$f":"AnnualPayments!B66","v":"HARVEY"},{"$f":"AnnualPayments!D66","v":57.131719040645265}]
[null,{"$f":"AnnualPayments!B67","v":"HASKELL"},{"$f":"AnnualPayments!D67","v":48.481912882531837}]
[null,{"$f":"AnnualPayments!B68","v":"HODGEMAN"},{"$f":"AnnualPayments!D68","v":47.187493261835357}]
[null,{"$f":"AnnualPayments!B69","v":"JACKSON"},{"$f":"AnnualPayments!D69","v":89.230936433910543}]
[null,{"$f":"AnnualPayments!B70","v":"JEFFERSON"},{"$f":"AnnualPayments!D70","v":84.55038460827744}]
[null,{"$f":"AnnualPayments!B71","v":"JEWELL"},{"$f":"AnnualPayments!D71","v":63.093441506083686}]
[null,{"$f":"AnnualPayments!B72","v":"JOHNSON"},{"$f":"AnnualPayments!D72","v":73.868919640409217}]
[null,{"$f":"AnnualPayments!B73","v":"KEARNY"},{"$f":"AnnualPayments!D73","v":60.661060712516992}]
[null,{"$f":"AnnualPayments!B74","v":"KINGMAN"},{"$f":"AnnualPayments!D74","v":48.403644328102715}]
[null,{"$f":"AnnualPayments!B75","v":"KIOWA"},{"$f":"AnnualPayments!D75","v":46.023317850449587}]
[null,{"$f":"AnnualPayments!B76","v":"LABETTE"},{"$f":"AnnualPayments!D76","v":66.854686822480318}]
[null,{"$f":"AnnualPayments!B77","v":"LANE"},{"$f":"AnnualPayments!D77","v":47.412029470635616}]
[null,{"$f":"AnnualPayments!B78","v":"LEAVENWORTH"},{"$f":"AnnualPayments!D78","v":87.633342568424752}]
[null,{"$f":"AnnualPayments!B79","v":"LINCOLN"},{"$f":"AnnualPayments!D79","v":66.36127043348597}]
[null,{"$f":"AnnualPayments!B80","v":"LINN"},{"$f":"AnnualPayments!D80","v":75.055934931196319}]
[null,{"$f":"AnnualPayments!B81","v":"LOGAN"},{"$f":"AnnualPayments!D81","v":44.939711229045272}]
[null,{"$f":"AnnualPayments!B82","v":"LYON"},{"$f":"AnnualPayments!D82","v":65.282172928144334}]
[null,{"$f":"AnnualPayments!B83","v":"MCPHERSON"},{"$f":"AnnualPayments!D83","v":56.884833187358872}]
[null,{"$f":"AnnualPayments!B84","v":"MARION"},{"$f":"AnnualPayments!D84","v":55.909176838135267}]
[null,{"$f":"AnnualPayments!B85","v":"MARSHALL"},{"$f":"AnnualPayments!D85","v":95.303012312378655}]
[null,{"$f":"AnnualPayments!B86","v":"MEADE"},{"$f":"AnnualPayments!D86","v":48.321360683273895}]
[null,{"$f":"AnnualPayments!B87","v":"MIAMI"},{"$f":"AnnualPayments!D87","v":68.702407734453047}]
[null,{"$f":"AnnualPayments!B88","v":"MITCHELL"},{"$f":"AnnualPayments!D88","v":69.638235619214967}]
[null,{"$f":"AnnualPayments!B89","v":"MONTGOMERY"},{"$f":"AnnualPayments!D89","v":66.086069915254242}]
[null,{"$f":"AnnualPayments!B90","v":"MORRIS"},{"$f":"AnnualPayments!D90","v":63.404382439901603}]
[null,{"$f":"AnnualPayments!B91","v":"MORTON"},{"$f":"AnnualPayments!D91","v":41.146443174043277}]
[null,{"$f":"AnnualPayments!B92","v":"NEMAHA"},{"$f":"AnnualPayments!D92","v":111.78230490428894}]
[null,{"$f":"AnnualPayments!B93","v":"NEOSHO"},{"$f":"AnnualPayments!D93","v":64.09156456011894}]
[null,{"$f":"AnnualPayments!B94","v":"NESS"},{"$f":"AnnualPayments!D94","v":49.733666924431446}]
[null,{"$f":"AnnualPayments!B95","v":"NORTON"},{"$f":"AnnualPayments!D95","v":45.587315952604968}]
[null,{"$f":"AnnualPayments!B96","v":"OSAGE"},{"$f":"AnnualPayments!D96","v":71.237232429023962}]
[null,{"$f":"AnnualPayments!B97","v":"OSBORNE"},{"$f":"AnnualPayments!D97","v":61.905315410068873}]
[null,{"$f":"AnnualPayments!B98","v":"OTTAWA"},{"$f":"AnnualPayments!D98","v":66.036245963757864}]
[null,{"$f":"AnnualPayments!B99","v":"PAWNEE"},{"$f":"AnnualPayments!D99","v":47.699358985662748}]
[null,{"$f":"AnnualPayments!B100","v":"PHILLIPS"},{"$f":"AnnualPayments!D100","v":54.334837654963607}]
[null,{"$f":"AnnualPayments!B101","v":"POTTAWATOMIE"},{"$f":"AnnualPayments!D101","v":90.234336900633977}]
[null,{"$f":"AnnualPayments!B102","v":"PRATT"},{"$f":"AnnualPayments!D102","v":42.931823634197947}]
[null,{"$f":"AnnualPayments!B103","v":"RAWLINS"},{"$f":"AnnualPayments!D103","v":46.843793438976924}]
[null,{"$f":"AnnualPayments!B104","v":"RENO"},{"$f":"AnnualPayments!D104","v":57.921847378218274}]
[null,{"$f":"AnnualPayments!B105","v":"REPUBLIC"},{"$f":"AnnualPayments!D105","v":72.359654083686081}]
[null,{"$f":"AnnualPayments!B106","v":"RICE"},{"$f":"AnnualPayments!D106","v":55.134974369378746}]
[null,{"$f":"AnnualPayments!B107","v":"RILEY"},{"$f":"AnnualPayments!D107","v":85.672361718646442}]
[null,{"$f":"AnnualPayments!B108","v":"ROOKS"},{"$f":"AnnualPayments!D108","v":54.080152795570527}]
[null,{"$f":"AnnualPayments!B109","v":"RUSH"},{"$f":"AnnualPayments!D109","v":49.596535519481819}]
[null,{"$f":"AnnualPayments!B110","v":"RUSSELL"},{"$f":"AnnualPayments!D110","v":50.117942326415381}]
[null,{"$f":"AnnualPayments!B111","v":"SALINE"},{"$f":"AnnualPayments!D111","v":61.38300342046697}]
[null,{"$f":"AnnualPayments!B112","v":"SCOTT"},{"$f":"AnnualPayments!D112","v":49.782503661515321}]
[null,{"$f":"AnnualPayments!B113","v":"SEDGWICK"},{"$f":"AnnualPayments!D113","v":55.705044255780358}]
[null,{"$f":"AnnualPayments!B114","v":"SEWARD"},{"$f":"AnnualPayments!D114","v":43.798596376814203}]
[null,{"$f":"AnnualPayments!B115","v":"SHAWNEE"},{"$f":"AnnualPayments!D115","v":93.220591391695038}]
[null,{"$f":"AnnualPayments!B116","v":"SHERIDAN"},{"$f":"AnnualPayments!D116","v":50.449522506771814}]
[null,{"$f":"AnnualPayments!B117","v":"SHERMAN"},{"$f":"AnnualPayments!D117","v":44.952089693022884}]
[null,{"$f":"AnnualPayments!B118","v":"SMITH"},{"$f":"AnnualPayments!D118","v":58.341833953869376}]
[null,{"$f":"AnnualPayments!B119","v":"STAFFORD"},{"$f":"AnnualPayments!D119","v":55.634669123336707}]
[null,{"$f":"AnnualPayments!B120","v":"STANTON"},{"$f":"AnnualPayments!D120","v":39.362882506747511}]
[null,{"$f":"AnnualPayments!B121","v":"STEVENS"},{"$f":"AnnualPayments!D121","v":40.313546855583496}]
[null,{"$f":"AnnualPayments!B122","v":"SUMNER"},{"$f":"AnnualPayments!D122","v":52.181789029623069}]
[null,{"$f":"AnnualPayments!B123","v":"THOMAS"},{"$f":"AnnualPayments!D123","v":46.932956674926551}]
[null,{"$f":"AnnualPayments!B124","v":"TREGO"},{"$f":"AnnualPayments!D124","v":43.869040795356426}]
[null,{"$f":"AnnualPayments!B125","v":"WABAUNSEE"},{"$f":"AnnualPayments!D125","v":87.444131809603618}]
[null,{"$f":"AnnualPayments!B126","v":"WALLACE"},{"$f":"AnnualPayments!D126","v":42.720892282748935}]
[null,{"$f":"AnnualPayments!B127","v":"WASHINGTON"},{"$f":"AnnualPayments!D127","v":84.053413464795625}]
[null,{"$f":"AnnualPayments!B128","v":"WICHITA"},{"$f":"AnnualPayments!D128","v":50.646710235922107}]
[null,{"$f":"AnnualPayments!B129","v":"WILSON"},{"$f":"AnnualPayments!D129","v":68.648140856643948}]
[null,{"$f":"AnnualPayments!B130","v":"WOODSON"},{"$f":"AnnualPayments!D130","v":67.214412768255229}]
[null,{"$f":"AnnualPayments!B131","v":"WYANDOTTE"},{"$f":"AnnualPayments!D131","v":100}]

{"sheet":"Econ Analysis","index":3,"n_rows":162,"n_cols":19,"rows_kept":162,"cut":false,"hidden":false,"merged":[[161,1,175,10],[145,1,145,12],[143,1,144,12],[22,1,23,12],[26,3,26,6],[136,1,138,12],[140,1,141,12]]}
[]
[null,"Streambank Stabilization: Economic Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2017-03-14T09:20:18.630"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(S2)","v":2017}]
[null,{"$f":"\"Your project area is located in \"&Inputs!C3 &\" County, Kansas on a \"&Inputs!C4 &\" acre field.\"","v":"Your project area is located in MARSHALL County, Kansas on a 80 acre field."},null,null,null,null,null,"Your project area is:",{"$f":"Inputs!C15","v":2.1818181818181817},"acres in size."]
[]
[null,"The results are based upon the following assumptions:"]
[]
[null,"One time Costs:",{"$f":"SUM(Inputs!$C$20:$C$23)","v":72898.875},null,null,"One time Cost-Share Payments:",{"$f":"SUM(Inputs!$C$33:$C$35)","v":71652.948863636368},null,null,"Time Period Selected:",{"$f":"Inputs!C45","v":15},"years"]
[null,"Annual Costs:",{"$f":"Budget!D25","v":0},null,null,"Annual Incentive Payments:",{"$f":"Budget!H25","v":249.52061405422774},null,null,"Opportunity Cost of Your Money:",{"$f":"Inputs!C10","v":0.05}]
[]
[null,"The first year out-of-pocket costs of the streambank project would be",null,null,null,null,{"$f":"IF(NPV!C4-NPV!E4>0,NPV!C4-NPV!E4,0)","v":1403.3806818181765},"this accounts for any cost-share payments you may receive."]
[null,"Based on the information you have provided, a streambank stabilization project could potentially save",null,null,null,null,null,null,{"$f":"Budget!L17","v":0.66666666666666663},"acres annually."]
[]
[null,"TAKE HOME MESSAGE:"]
[null,"If you consider the asset value of the land that is preserved by the streambank stabilization project, then the take-home message is:"]
[null,"You would be ",{"$f":"NPV!C29","v":4967.847369776714},"per year",{"$f":"IF(C16>0, \"better off\", \"worse off\")","v":"better off"},"by stabilizing this streambank versus doing nothing."]
[null,"A streambank project would",null,{"$f":"IF(NPV!C28>0,\"return\",\"lose\")","v":"return"},{"$f":"NPV!C28","v":51564.556884157188},{"$f":"\"in total over the \"&Inputs!C45& \" year time period you have selected.\"","v":"in total over the 15 year time period you have selected."}]
[]
[null,"If you DO NOT consider the asset value of the land that is preserved by the streambank stabilization project, then the take-home message is:"]
[null,"You would be ",{"$f":"NPV!F29","v":310.90246042544646},"per year",{"$f":"IF(C20>0, \"better off\", \"worse off\")","v":"better off"},"by stabilizing this streambank versus doing nothing."]
[null,"A streambank project would",null,{"$f":"IF(NPV!F28>0,\"return\",\"lose\")","v":"return"},{"$f":"NPV!F28","v":3227.0612224451097},{"$f":"\"in total over the \"&Inputs!C45& \" year time period you have selected.\"","v":"in total over the 15 year time period you have selected."}]
[]
[null,"The asset value of the land that is preserved by the project is a real value that should probably be considered in your decision-making. It is, however, a value that would not be realized as cash until the property is sold."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In general, the benefits of a streambank stabilization project come in the form of: value of acres not lost to erosion, income from being able to crop the preserved acres not in CCRP acres, cost-share and incentive payments, and tax breaks from the reclassification of ag land. "]
[]
[]
[]
[null,"The costs of a streambank stabilization project come in the form of: one time installation costs, annual maintenance costs, and the initial loss of cropping income from cropland being taken out of production and enrolled into CCRP."]
[]
[]
[null,{"$f":"\"In order to effectively compare scenarios which occur over multiple years (10 to 15 years), we must convert all costs and returns to today's dollars (e.g., \"&S3 &\" dollars).\"","v":"In order to effectively compare scenarios which occur over multiple years (10 to 15 years), we must convert all costs and returns to today's dollars (e.g., 2017 dollars)."}]
[]
[null,"Net Present Value calculations convert future values into today's dollars. The net present value analysis uses a discount factor to equate a series of future cash flows into an equivalent amount of cash today. For example, if you are considering enrolling land into a 15 year Continuous Conservation Reserve Program (CRP) program, the projected net income in years 2 through 15 is discounted back to its equivalent value in today’s dollars. Because a dollar today can earn interest until next year, it will be valued more highly than a dollar received in the future"]
[]
[null,"For streambank stabilization assistance, be sure to contact your local county conservation district. A Kansas Conservation District Directory"]
[null,"can be found at:","http://www.kacdnet.org/districts.html"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Limitation of Liability:"]
[]
[null,"This computer program is distrubuted by Kansas State University on an \"as is\" basis, without warranty. Kansas State University and the authors of this software will have no liability or responsibility to the cooperator or any other person or entity with respect to any liability, loss, or damage caused, or alleged to be caused, directly or indirectly by programs sold or given away by Kansas State University or the authors.  This includes but is not limited to, any interruption of service, loss of business or anticipatory profits, or consequential damages resulting from user or operation, and in no event will Kansas State University or the authors be liable for loss of profits or indirect, special, or consequential damages arising from the use of the software provided by Kansas State University or the authors."]

{"sheet":"OneCost","index":4,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,1,1,11],[60,6,60,10],[3,1,3,2],[7,1,7,2],[34,1,34,2],[2,1,2,11]]}
[]
[null,"One Time Construction Costs Worksheet"]
[null,"Enter Values in Purple Cells Only!!!"]
[null,"Engineering and Design",null,null,null,null,null,null,null,"Total"]
[null,null,"Bank Stabilization",null,null,null,null,null,null,18175]
[null,null,"Vegetation/CCRP Area",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J5:J6)","v":18175},null,{"$f":"J7","v":18175}]
[null,"Bank Stabilization Costs"]
[null,null,"Equipment",null,"Hours","@","$ / hour"]
[null,null,"     Excavator",null,80,null,175,null,null,{"$f":"E10*G10","v":14000}]
[null,null,"     Dozer",null,20,null,125,null,null,2500]
[null,null,"     Loader",null,20,null,125,null,null,2500]
[null,null,"     Dump Truck",null,12,null,125,null,null,1500]
[null,null,"     Tractor",null,null,null,85,null,null,0]
[null,null,"     Seeding/Mulching",null,0,null,0,null,null,0]
[null,null,"     Other",null,null,null,95,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J16)","v":20500},null,{"$f":"J17","v":20500}]
[null,null,"Materials",null,"Tons","@","$ / ton"]
[null,null,"     LPSTP","Shot Rock",1770,null,9.5,null,null,{"$f":"E19*G19","v":16815}]
[null,null,"     Weir 1","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 2","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 3","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 4","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 5","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 6","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 7","Shot Rock",177,null,9.5,null,null,1681.5]
[null,null,"     Weir 8","Shot Rock",0,null,0,null,null,0]
[null,null,"     Weir 9","Shot Rock",0,null,0,null,null,0]
[null,null,"     Other",null,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J19:J29)","v":28585.5},null,{"$f":"J30","v":28585.5}]
[null,null,"Other Labor Costs",null,"Hours","@","$ / hour"]
[null,null,"    Other Labor",null,0,null,0,null,null,{"$f":"E32*G32","v":0},null,{"$f":"J32","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L33)","v":49085.5}]
[null,"Vegetative Buffer Costs"]
[null,null,"Equipment",null,"Acres","@","$ / acre"]
[null,null,"     Site Preparation",null,2.2000000000000002,null,190,null,null,{"$f":"E37*G37","v":418.00000000000006}]
[null,null,"     Drill Cover Crop",null,1.85,null,310,null,null,573.5]
[null,null,"     Herbicide application",null,1.85,null,125,null,null,231.25]
[null,null,"     Drill Grass",null,0.33,null,1100,null,null,363]
[null,null,"     Tree & Shrub Planting",null,1.85,null,952,null,null,{"$f":"E41*G41","v":1761.2}]
[null,null,"     Producer/Landowner",null,null,null,0,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J42)","v":3346.95},null,{"$f":"J43","v":3346.95}]
[]
[null,null,"Materials",null,"Units","@","$ / unit"]
[null,null,"     Cover Crop Seed",null,1.85,null,55,null,null,{"$f":"E46*G46","v":101.75}]
[null,null,"     Herbicide",null,1.85,null,8.5,null,null,{"$f":"E47*G47","v":15.725000000000001}]
[null,null,"     Grass Seed",null,0.33,null,115,null,null,37.950000000000003]
[null,null,"     Mulch",null,0,null,0,null,null,0]
[null,null,"     Live Stakes",null,0,null,0,null,null,0]
[null,null,"     Bare Roots",null,1258,null,1,null,null,1258]
[null,null,"     Trees",null,0,null,0,null,null,0]
[null,null,"     Tree Shelters",null,0,null,0,null,null,0]
[null,null,"     Other Material",null,1,null,378,null,null,378]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J46:J54)","v":1791.425},null,{"$f":"J55","v":1791.425}]
[null,null,"Other Labor Costs",null,"Hours","@","$ / hour"]
[null,null,"    Other Labor",null,0,null,0,null,null,{"$f":"E57*G57","v":0},null,{"$f":"J57","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L37:L57)","v":5138.375}]
[]
[null,null,null,null,null,null,"Total One Time Construction Costs",null,null,null,null,{"$f":"L7+L34+L59","v":72398.875}]

{"sheet":"OnePayment","index":5,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,8,8,9],[20,1,24,7],[9,8,10,9],[15,1,16,7],[15,8,16,9],[17,6,17,8],[11,1,12,7],[11,8,12,9],[13,1,14,7],[13,8,14,9],[7,1,7,7],[8,1,8,7],[10,1,10,7],[9,1,9,7],[1,1,1,9],[3,8,4,9],[5,8,6,9],[2,1,2,9],[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7]]}
[]
[null,"One Time Payments Worksheet"]
[null,"Enter Values in Purple Cells Only!!!"]
[null,"Kansas Department of Agriculture Streambank Protection Program",null,null,null,null,null,null,{"$f":"OneCost!J5+OneCost!L34","v":67260.5}]
[null,"(100% of streambank stabilization costs and design)"]
[null,"Continuous Conservation Reserve Program (CCRP) for vegetation establishment",null,null,null,null,null,null,{"$f":"(OneCost!L59-OneCost!J38-OneCost!J46)*0.5","v":2231.5625}]
[null,"(One time payment, FSA, 50% of county average cost for buffer costs excluding cover crop)"]
[null,"CCRP-Practice Incentive Payment",null,null,null,null,null,null,{"$f":"(OneCost!L59-OneCost!J38-OneCost!J46)*0.4","v":1785.25}]
[null,"(One time payment, FSA, 40% of county average cost for  buffer costs excluding cover crop)  "]
[null,"CCRP-Sign-up Incentive Payment",null,null,null,null,null,null,{"$f":"100*Inputs!C15","v":218.18181818181816}]
[null,"(One time payment, FSA, $100/acre for CCRP area)"]
[null,"Kansas Alliance for Wetlands and Streams (KAWS): One time payment, various amounts",null,null,null,null,null,null,0]
[]
[null,"Regional Conservation Partnership Program: flat rat per unit or acre installed, must qualify",null,null,null,null,null,null,0]
[]
[null,"Other (WRAPS, Watershed Land Trust, etc.)",null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Total One Time Payments",null,null,{"$f":"SUM(I4:J17)","v":71495.494318181823}]
[]
[]
[null,"* Default values are estimations only - calculated by multiplying the cost-share percentages by the one time cost values you entered previously (on the OneCost worksheet). Cost-share payment rates are actually based on the lesser of actual or county average costs, so please consult with you local conservation district to obtain accurate values."]

{"sheet":"AnnualPayments","index":6,"n_rows":131,"n_cols":15,"rows_kept":131,"cut":false,"hidden":false,"merged":[[2,1,2,9],[1,1,1,10],[27,4,27,10],[40,4,41,7],[38,4,38,6],[7,6,7,8],[31,4,36,10]]}
[]
[null,"Annual Payments Worksheet"]
[null,"You May Enter Values in any of the Purple Cells"]
[null,"CCRP rental rate w/out added incentives",null,null,null,null,null,null,null,{"$f":"Inputs!B72","v":95.303012312378655},"per acre /year"]
[null,"Is the project area located in a designated TMDL Watershed?",null,null,null,null,null,null,null,"NO",null,null,null,null,"NO"]
[null,"Annual Rental Payment (% of county rental rate)",null,null,null,null,null,null,null,{"$f":"IF(J5=\"yes\",1.56,1.2)","v":1.2},null,null,null,null,"YES"]
[]
[null,null,null,null,null,null,"Total Annual Payments",null,null,{"$f":"J4*J6","v":114.36361477485438},"per acre / year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Estimated Continuous Conservation Reserve Program (CCRP) Rental Rates"]
[null,"COUNTY","Upland CRP Weighted Average Rental Rates*","Adjusted CCRP Rental Rates for vegetative buffer soils**"]
[null,"ALLEN",54.497027212894487,{"$f":"C27*$H$39+C27","v":68.121284016118111}]
[null,"ANDERSON",63.37317672876847,79.216470910960595,"*These values represent a simple weighted average of year 2015 \"Upland\" CRP rental rates. "]
[null,"ATCHISON",85.500968458572871,106.87621057321608,null,"Year:",2015]
[null,"BARBER",39.834483831908919,49.793104789886151,null,"Source:","USDA Farm Service Agency"]
[null,"BARTON",37.960515663832489,47.450644579790612]
[null,"BOURBON",57.319745479488908,71.64968184936113,"**These values have been adjusted to represent a more realistic CCRP rental rate for vegetative buffer sites. These soils are estimated to pay higher rental rates than Upland soils, due to their higher erosive potential. This does not include any of the added incentive payments. NOTE: This is only an estimate; check with your local Conservation District for specific rental rates. Make changes on the Assumptions sheet. "]
[null,"BROWN",94.570665213740142,118.21333151717518]
[null,"BUTLER",52.022078409304072,65.02759801163009]
[null,"CHASE",61.180033619983057,76.475042024978819]
[null,"CHAUTAUQUA",46.588406935298735,58.235508669123419]
[null,"CHEROKEE",57.821320588477647,72.276650735597059]
[null,"CHEYENNE",34.527952669774557,43.159940837218194]
[null,"CLARK",35.720094720206255,44.650118400257817,"Adjustment Factor =",null,null,0.25]
[null,"CLAY",58.679765310098212,73.349706637622759]
[null,"CLOUD",54.496753604592818,68.120942005741028]
[null,"COFFEY",58.70683151493855,73.383539393673189]
[null,"COMANCHE",33.821364904920898,42.276706131151123]
[null,"COWLEY",44.271950338755715,55.339937923444644]
[null,"CRAWFORD",54.729894159131298,68.412367698914125]
[null,"DECATUR",39.384355261922742,49.230444077403426]
[null,"DICKINSON",54.713446817647011,68.391808522058767]
[null,"DONIPHAN",110.88063447396551,138.60079309245688]
[null,"DOUGLAS",66.626996275447368,83.28374534430921]
[null,"EDWARDS",36.611467713556912,45.764334641946142]
[null,"ELK",52.883508646817617,66.104385808522025]
[null,"ELLIS",37.082771557858905,46.353464447323631]
[null,"ELLSWORTH",44.999894026871566,56.249867533589459]
[null,"FINNEY",42.796290466071767,53.495363082589705]
[null,"FORD",37.170819021681048,46.463523777101308]
[null,"FRANKLIN",62.143985521119312,77.679981901399145]
[null,"GEARY",63.606109403028114,79.507636753785135]
[null,"GOVE",40.253491316100622,50.316864145125777]
[null,"GRAHAM",40.160532181141825,{"$f":"C59*$H$39+C59","v":50.200665226427283}]
[null,"GRANT",36.109775372223439,45.137219215279302]
[null,"GRAY",50.864016702877862,63.580020878597324]
[null,"GREELEY",34.131498050903282,42.664372563629101]
[null,"GREENWOOD",56.144290896527899,70.180363620659875]
[null,"HAMILTON",32.437317879019723,40.546647348774655]
[null,"HARPER",37.741529748580732,47.176912185725911]
[null,"HARVEY",45.705375232516211,57.131719040645265]
[null,"HASKELL",38.785530306025471,48.481912882531837]
[null,"HODGEMAN",37.749994609468288,47.187493261835357]
[null,"JACKSON",71.384749147128431,89.230936433910543]
[null,"JEFFERSON",67.640307686621952,84.55038460827744]
[null,"JEWELL",50.47475320486695,63.093441506083686]
[null,"JOHNSON",59.095135712327377,73.868919640409217]
[null,"KEARNY",48.528848570013594,60.661060712516992]
[null,"KINGMAN",38.72291546248217,48.403644328102715]
[null,"KIOWA",36.818654280359667,46.023317850449587]
[null,"LABETTE",53.48374945798426,66.854686822480318]
[null,"LANE",37.92962357650849,47.412029470635616]
[null,"LEAVENWORTH",70.106674054739798,87.633342568424752]
[null,"LINCOLN",53.089016346788775,66.36127043348597]
[null,"LINN",60.044747944957059,75.055934931196319]
[null,"LOGAN",35.951768983236221,44.939711229045272]
[null,"LYON",52.22573834251547,65.282172928144334]
[null,"MCPHERSON",45.507866549887098,56.884833187358872]
[null,"MARION",44.727341470508215,55.909176838135267]
[null,"MARSHALL",76.242409849902927,95.303012312378655]
[null,"MEADE",38.657088546619114,48.321360683273895]
[null,"MIAMI",54.96192618756244,68.702407734453047]
[null,"MITCHELL",55.710588495371972,69.638235619214967]
[null,"MONTGOMERY",52.868855932203395,66.086069915254242]
[null,"MORRIS",50.723505951921283,63.404382439901603]
[null,"MORTON",32.917154539234623,{"$f":"C91*$H$39+C91","v":41.146443174043277}]
[null,"NEMAHA",89.425843923431145,111.78230490428894]
[null,"NEOSHO",51.273251648095155,64.09156456011894]
[null,"NESS",39.78693353954516,49.733666924431446]
[null,"NORTON",36.469852762083974,45.587315952604968]
[null,"OSAGE",56.989785943219168,71.237232429023962]
[null,"OSBORNE",49.524252328055098,61.905315410068873]
[null,"OTTAWA",52.828996771006288,66.036245963757864]
[null,"PAWNEE",38.1594871885302,47.699358985662748]
[null,"PHILLIPS",43.467870123970883,54.334837654963607]
[null,"POTTAWATOMIE",72.187469520507179,90.234336900633977]
[null,"PRATT",34.345458907358356,42.931823634197947]
[null,"RAWLINS",37.475034751181539,46.843793438976924]
[null,"RENO",46.337477902574619,57.921847378218274]
[null,"REPUBLIC",57.887723266948861,72.359654083686081]
[null,"RICE",44.107979495502995,55.134974369378746]
[null,"RILEY",68.537889374917157,85.672361718646442]
[null,"ROOKS",43.264122236456423,54.080152795570527]
[null,"RUSH",39.677228415585454,49.596535519481819]
[null,"RUSSELL",40.094353861132305,50.117942326415381]
[null,"SALINE",49.106402736373575,61.38300342046697]
[null,"SCOTT",39.826002929212258,49.782503661515321]
[null,"SEDGWICK",44.564035404624285,55.705044255780358]
[null,"SEWARD",35.038877101451362,43.798596376814203]
[null,"SHAWNEE",74.57647311335603,93.220591391695038]
[null,"SHERIDAN",40.359618005417452,50.449522506771814]
[null,"SHERMAN",35.961671754418305,44.952089693022884]
[null,"SMITH",46.673467163095502,58.341833953869376]
[null,"STAFFORD",44.507735298669367,55.634669123336707]
[null,"STANTON",31.490306005398008,39.362882506747511]
[null,"STEVENS",32.2508374844668,40.313546855583496]
[null,"SUMNER",41.745431223698453,52.181789029623069]
[null,"THOMAS",37.546365339941239,{"$f":"C123*$H$39+C123","v":46.932956674926551}]
[null,"TREGO",35.095232636285139,43.869040795356426]
[null,"WABAUNSEE",69.955305447682889,87.444131809603618]
[null,"WALLACE",34.176713826199148,42.720892282748935]
[null,"WASHINGTON",67.242730771836506,84.053413464795625]
[null,"WICHITA",40.517368188737684,50.646710235922107]
[null,"WILSON",54.918512685315164,68.648140856643948]
[null,"WOODSON",53.771530214604184,67.214412768255229]
[null,"WYANDOTTE",80,100]

{"sheet":"Cropland Trends","index":7,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[34,1,34,11],[1,1,1,8],[2,2,2,7],[31,1,31,4],[31,6,31,9]]}
[]
[null,"KANSAS LAND VALUES & CASH RENTS 2001-2015 "]
[null,"source:","https://quickstats.nass.usda.gov/"]
[]
[null,"Non-Irrigated Cropland Values",null,null,null,null,"Non-Irrigated Cropland Rents"]
[null,"Year","Value","% change from previous year",null,null,"Year","Value","% change from previous year"]
[null,2001,635,null,null,null,2001,36]
[null,2002,640,{"$f":"(C8-C7)/C7","v":7.874015748031496E-3},null,null,2002,36,{"$f":"(H8-H7)/H7","v":0}]
[null,2003,645,{"$f":"(C9-C8)/C8","v":7.8125E-3},null,null,2003,36,0]
[null,2004,650,7.7519379844961239E-3,null,null,2004,37.5,4.1666666666666664E-2]
[null,2005,770,0.18461538461538463,null,null,2005,38.5,2.6666666666666668E-2]
[null,2006,820,6.4935064935064929E-2,null,null,2006,39,1.2987012987012988E-2]
[null,2007,880,7.3170731707317069E-2,null,null,2007,41,5.128205128205128E-2]
[null,2008,980,0.11363636363636363,null,null,2008,42.5,3.6585365853658534E-2]
[null,2009,981,1.0204081632653062E-3,null,null,2009,43.5,2.3529411764705882E-2]
[null,2010,1060,8.0530071355759431E-2,null,null,2010,43.5,0]
[null,2011,1290,0.21698113207547171,null,null,2011,44,1.1494252873563218E-2]
[null,2012,1590,0.23255813953488372,null,null,2012,52.5,0.19318181818181818]
[null,2013,1840,0.15723270440251572,null,null,2013,53,9.5238095238095247E-3]
[null,2014,2150,0.16847826086956522,null,null,2014,54,1.8867924528301886E-2]
[null,2015,2090,-2.7906976744186046E-2,null,null,2015,58,7.407407407407407E-2]
[null,"15-year average =",null,{"$f":"AVERAGE(D8:D21)","v":9.2049267020280934E-2},null,null,"15-year average =",null,{"$f":"AVERAGE(I8:I21)","v":3.5704218171594922E-2}]
[]
[null,"36-year average = ",null,4.1000000000000002E-2,null,null,"36-year average = ",null,2.1999999999999999E-2]
[]
[]
[]
[]
[]
[]
[null,"For county rental rates and values go to:"]
[null,"AgManager.info Land Values",null,null,null,null,"AgManager.info Rental Rates"]
[]
[]
[null,"Historical Kansas Land Values 1880 to 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: NASS, compiled by Dr. Mykel Taylor, 2017"]

{"sheet":"Programs","index":8,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,6],[12,0,12,1],[14,0,15,6],[16,0,16,3],[17,0,17,4]]}
["Available Funding for the Vegetative Portion of a Streambank Stabilization Project"]
["Program","Agency","Cost Share","Annual Rental Payment (percentage of County Soil Rental Rate)","One Time Bonus","Annual Maintenace Cost Assistance","Additional Notes**"]
["CRP Continuous Sign-up (CCRP)","FSA",0.5,1,null,null,"Landowners can also apply for a reduction in assessed value of land for tax purposes"]
["CRP Continuous Sign-up (CCRP)","FSA",null,0.2,null,null,"added incentive for contiuous sign-up"]
["CRP Continuous Sign-up (CCRP)","FSA",null,0.1,null,null,"added incentive for land in EPA \"wellhead protection areas\""]
["CCRP-SIP","FSA",null,null,"$10 per acre X years of contract ($100 per acre)",null,"upfront signing incentive payment - bonus"]
["CCRP-PIP","FSA",0.4,null,null,null,"practice incentive payment for eligible installation costs"]
["KS WQ Buffer Initiative","SCC",null,"30% (multiplied by the total CCRP rental payment with all added incentives)",null,null,"must meet continous CRP requirements AND be in a TMDL Watershed"]
["RCPP/EQIP*","NRCS","Flat rate per unit or acre installed",null,null,null,"Only in eligible areas. See your local USDA service center/NRCS for details"]
["Watershed Land Trust**","The Land Trust","Market value of land - with limitations",null,null,null,"Long-term easement; contact (913) 685-4600"]
["Clean Water Farms Project","KS Rural Center","up to $5000 in matching funds",null,"$250 for completing farm assessment",null,"must be in a Category 1 \"high-priority\" watershed"]
["Partners for Fish & Wildlife","Fish and Wildlife Service","10% - 90%",null,null,null,"dependent on: length of agreement, total acres, wildlife & environmental benefits"]
["Example Totals: ",null,0.9,1.56,100,4]
[]
["NOTE:  The turquoise cells represent the funding programs typically utilized for vegetative buffers. The other programs can definitely be used, but they are more site and region specific."]
[]
["*Cannot be used with any CRP program"]
["**more requirements may apply, contact the respective agency to find out all the details"]

{"sheet":"TaxInfo","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Budget","index":10,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[19,1,19,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[28,8,29,8],[28,7,29,7],[28,6,29,6],[7,1,7,3],[8,1,8,3],[9,1,9,3],[11,1,11,4],[20,1,20,4],[27,13,27,14],[28,3,29,3],[28,18,29,18],[27,1,29,1],[27,2,29,2],[28,14,29,14],[28,13,29,13],[28,12,29,12],[28,11,29,11],[28,10,29,10],[28,5,29,5],[28,4,29,4],[28,17,29,17],[28,16,29,16],[28,15,29,15],[28,9,29,9]]}
[]
[null,"General Data For Streambank Stabilization"]
[]
[null,"Discount Rate",null,null,{"$f":"Inputs!C10","v":0.05}]
[null,{"$f":"Inputs!B5","v":"Cropland Value"},null,null,{"$f":"Inputs!C5","v":5500},"per acre"]
[null,{"$f":"Inputs!B6","v":"Annual Cropland Value Growth Rate"},null,null,{"$f":"Inputs!C6","v":4.1000000000000002E-2}]
[null,{"$f":"Inputs!B7","v":"Cropland Rental Rate - not CCRP rental rate"},null,null,{"$f":"Inputs!C7","v":80},"per acre / year"]
[null,{"$f":"Inputs!B8","v":"Annual Cropland Rental Growth Rate"},null,null,{"$f":"Inputs!C8","v":2.1999999999999999E-2}]
[null,"Total Annual Costs",null,null,{"$f":"Inputs!C30","v":0},"per acre / year"]
[null,{"$f":"Inputs!B29","v":"Inflation Rate of Annual Costs"},null,null,{"$f":"Inputs!C29","v":0.04}]
[]
[null,"Project Length (feet)",null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C13","v":1200}]
[null,"Project Width (feet)",null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C14","v":66}]
[null,"Acres (length x width/43,560)",null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C15","v":2.1818181818181817}]
[null,"Estimated acreage lost over time period",null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C16","v":10}]
[null,"Value of estimated acreage lost",null,null,null,null,{"$f":"L15","v":10},"acres","@",{"$f":"E5","v":5500},"per acre",{"$f":"J16*L15","v":55000}]
[null,"Estimated average annual acreage lost over period of",null,null,null,null,{"$f":"Inputs!C17","v":15},"yr.",null,null,null,{"$f":"IF(G17=0,0,G16/G17)","v":0.66666666666666663}]
[null,"Estimated acreage preserved over ",null,null,null,null,{"$f":"Inputs!C45","v":15},"yr.",null,null,null,{"$f":"IF(L17=\"-\", L17, L17*G18)","v":10}]
[null,"Value of estimated acres preserved",null,null,null,null,{"$f":"L18","v":10},"acres"," @",{"$f":"J16*(1+E6)^G18","v":10049.0181853308},"per acre",{"$f":"IF(L18=\"-\", \"-\", L18*J19)","v":100490.18185330801}]
[null,"Cropland Property Tax ($/acre)",null,null,null,null,null,null,null,null,null,{"$f":"Inputs!C9","v":12}]
[null,"Tame Grass Property Tax ($/acre)",null,null,null,null,null,null,null,null,null,{"$f":"L20*(1-(Inputs!C46))","v":12}]
[]
[null,"COSTS",null,null,null,"PAYMENTS"]
[null,"Total one-time",null,{"$f":"SUM(Inputs!C20:C23)","v":72898.875},null,"Total one-time",null,{"$f":"Inputs!C33+Inputs!C34+Inputs!C35","v":71652.948863636368}]
[null,"Total annual",null,{"$f":"E9*L14","v":0},null,"Total annual",null,{"$f":"Inputs!C42*L14","v":249.52061405422774}]
[]
[null,"Land Effects"]
[null,"Year","Net Acres for Income",null,null,null,null,null,null,null,null,"With Project",null,"Without Project"]
[null,null,null,"Rental Rate $/Ac","Rental Rate Effect","Total Acres Preserved","Land Value $/Ac","Total Additional Value","Property Tax Cropland $/Ac","Property Tax Tame Grass $/Ac","CCRP Acres","Crop Acres","Property Tax","Crop Acres","Property Tax","Net Property Tax Impact","CCRP Acres","Net Cropland Preserved","Total Saved"]
[]
[null,0,{"$f":"L14*-1","v":-2.1818181818181817},{"$f":"E7","v":80},{"$f":"C31*D31","v":-174.54545454545453},0,{"$f":"J16","v":5500},null,{"$f":"L20","v":12},{"$f":"L21","v":12},{"$f":"L14","v":2.1818181818181817},{"$f":"IF(L18=\"-\",0,L18-K31)","v":7.8181818181818183},{"$f":"(K31*J31)+(L31*I31)","v":120},{"$f":"IF(L18=\"-\",0,L18)","v":10},{"$f":"N31*I31","v":120},{"$f":"M31-O31","v":0},{"$f":"L14","v":2.1818181818181817},{"$f":"IF(B31<=$G$18,IF(C31>0,C31,0),\"-\")","v":0},{"$f":"IF(B31<=$G$18,Q31+R31,\"-\")","v":2.1818181818181817}]
[null,1,{"$f":"IF(B32<=$G$18,(IF($L$17=\"-\",0,C31+$L$17)),\"-\")","v":-1.5151515151515151},{"$f":"IF(B32<=$G$18,($E$7*(1+$E$8)^B32),\"-\")","v":81.760000000000005},{"$f":"IF(B32<=$G$18,C32*D32,\"-\")","v":-123.87878787878789},{"$f":"IF(B32<=$G$18,(IF($L$17=\"-\",0,$L$17*B32)),\"-\")","v":0.66666666666666663},{"$f":"IF(B32<=$G$18,(G31*(1+$E$6)),\"-\")","v":5725.5},{"$f":"IF(B32=$G$18,((C32*$J$19)+($L$14*($L$21/$L$20)*$J$19)),0)","v":0},{"$f":"IF(B32<=$G$18,(I31*(1+$E$8)),\"-\")","v":12.263999999999999},{"$f":"IF(B32<=$G$18,J31*(1+$E$8),\"-\")","v":12.263999999999999},{"$f":"IF(B32<=$G$18,K31,\"-\")","v":2.1818181818181817},{"$f":"IF(B32<=$G$18,L31,\"-\")","v":7.8181818181818183},{"$f":"IF(B32<=$G$18,(K32*J32)+(L32*I32),\"-\")","v":122.64},{"$f":"N31","v":10},{"$f":"IF(B32<=$G$18,N32*I32,\"-\")","v":122.63999999999999},{"$f":"IF(B32<=$G$18,M32-O32,\"-\")","v":1.4210854715202004E-14},{"$f":"IF(B32<=$G$18,Q31,\"-\")","v":2.1818181818181817},{"$f":"IF(B32<=$G$18,IF(C32>0,C32,0),\"-\")","v":0},{"$f":"IF(B32<=$G$18,Q32+R32,\"-\")","v":2.1818181818181817}]
[null,2,{"$f":"IF(B33<=$G$18,(IF($L$17=\"-\",0,C32+$L$17)),\"-\")","v":-0.84848484848484851},{"$f":"IF(B33<=$G$18,($E$7*(1+$E$8)^B33),\"-\")","v":83.558719999999994},{"$f":"IF(B33<=$G$18,C33*D33,\"-\")","v":-70.898307878787875},{"$f":"IF(B33<=$G$18,(IF($L$17=\"-\",0,$L$17*B33)),\"-\")","v":1.3333333333333333},{"$f":"IF(B33<=$G$18,(G32*(1+$E$6)),\"-\")","v":5960.2455},{"$f":"IF(B33=$G$18,((C33*$J$19)+($L$14*($L$21/$L$20)*$J$19)),0)","v":0},{"$f":"IF(B33<=$G$18,(I32*(1+$E$8)),\"-\")","v":12.533807999999999},{"$f":"IF(B33<=$G$18,J32*(1+$E$8),\"-\")","v":12.533807999999999},{"$f":"IF(B33<=$G$18,K32,\"-\")","v":2.1818181818181817},{"$f":"IF(B33<=$G$18,L32,\"-\")","v":7.8181818181818183},{"$f":"IF(B33<=$G$18,(K33*J33)+(L33*I33),\"-\")","v":125.33807999999999},{"$f":"IF(B33<=$G$18,N32-$L$17,\"-\")","v":9.3333333333333339},{"$f":"IF(B33<=$G$18,N33*I33,\"-\")","v":116.982208},{"$f":"IF(B33<=$G$18,M33-O33,\"-\")","v":8.3558719999999909},{"$f":"IF(B33<=$G$18,Q32,\"-\")","v":2.1818181818181817},0,2.1818181818181817]
[null,3,-0.18181818181818188,85.397011840000005,-15.526729425454551,2,6204.6155654999993,0,12.809551775999999,12.809551775999999,2.1818181818181817,7.8181818181818183,128.09551775999998,{"$f":"IF(B34<=$G$18,N33-$L$17,\"-\")","v":8.6666666666666679},111.016115392,17.079402367999975,2.1818181818181817,0,2.1818181818181817]
[null,4,0.48484848484848475,87.275746100480006,42.315513260838785,2.6666666666666665,6459.0048036854987,0,13.091361915072,13.091361915072,2.1818181818181817,7.8181818181818183,130.91361915072,8.0000000000000018,104.73089532057602,26.182723830143971,2.1818181818181817,0.48484848484848475,2.6666666666666665]
[null,5,1.1515151515151514,89.195812514690559,102.71032956237093,3.333333333333333,6723.8240006366041,0,13.379371877203583,13.379371877203583,2.1818181818181817,7.8181818181818183,133.79371877203585,7.3333333333333348,98.115393766159627,35.678325005876218,2.1818181818181817,1.1515151515151514,3.333333333333333]
[null,6,1.8181818181818179,91.15812039001375,165.74203707275225,4,6999.5007846627041,0,13.673718058502063,13.673718058502063,2.1818181818181817,7.8181818181818183,136.73718058502064,6.6666666666666679,91.158120390013764,45.579060195006875,2.1818181818181817,1.8181818181818179,3.9999999999999996]
[null,7,2.4848484848484844,93.163599038594057,231.49742791408215,4.6666666666666661,7286.480316833874,0,13.974539855789109,13.974539855789109,2.1818181818181817,7.8181818181818183,139.74539855789109,6.0000000000000009,83.847239134734664,55.898159423156429,2.1818181818181817,2.4848484848484844,4.6666666666666661]
[null,8,3.1515151515151509,95.213198217443136,300.06583680648743,5.333333333333333,7585.2260098240622,0,14.28197973261647,14.28197973261647,2.1818181818181817,7.8181818181818183,142.81979732616472,5.3333333333333339,76.170558573954523,66.649238752210195,2.1818181818181817,3.1515151515151509,5.3333333333333321]
[null,9,3.8181818181818175,97.30788857822688,371.539210935048,6,7896.220276226848,0,14.596183286734034,14.596183286734034,2.1818181818181817,7.8181818181818183,145.96183286734032,4.666666666666667,68.11552200475883,77.84631086258149,2.1818181818181817,3.8181818181818175,5.9999999999999991]
[null,10,4.4848484848484844,99.44866212694788,446.01218166025103,6.6666666666666661,8219.9653075521474,0,14.917299319042183,14.917299319042183,2.1818181818181817,7.8181818181818183,149.17299319042183,4,59.669197276168731,89.503795914253104,2.1818181818181817,4.4848484848484844,6.6666666666666661]
[null,11,5.1515151515151514,101.63653269374073,523.58213811927044,7.333333333333333,8556.9838851617842,0,15.245479904061112,15.245479904061112,2.1818181818181817,7.8181818181818183,152.45479904061111,3.3333333333333335,50.818266346870374,101.63653269374073,2.1818181818181817,5.1515151515151514,7.333333333333333]
[null,12,5.8181818181818183,103.87253641300303,604.34930276656314,8,8907.8202244534168,0,15.580880461950457,15.580880461950457,2.1818181818181817,7.8181818181818183,155.80880461950457,2.666666666666667,41.549014565201226,114.25979005430335,2.1818181818181817,5.8181818181818183,8]
[null,13,6.4848484848484853,106.15773221408909,688.41680890348687,8.6666666666666661,9273.0408536560062,0,15.923659832113367,15.923659832113367,2.1818181818181817,7.8181818181818183,159.23659832113367,2.0000000000000004,31.847319664226742,127.38927865690692,2.1818181818181817,6.4848484848484853,8.6666666666666679]
[null,14,7.1515151515151523,108.49320232279905,775.89078024789637,9.3333333333333321,9653.2355286559014,0,16.273980348419862,16.273980348419862,2.1818181818181817,7.8181818181818183,162.7398034841986,1.3333333333333339,21.698640464559826,141.04116301963879,2.1818181818181817,7.1515151515151523,9.3333333333333339]
[null,15,7.8181818181818192,{"$f":"IF(B46<=$G$18,($E$7*(1+$E$8)^B46),\"-\")","v":110.88005277390064},866.88041259595059,10,10049.018185330793,{"$f":"IF(B46=$G$18,((C46*$J$19)+($L$14*($L$21/$L$20)*$J$19)),0)","v":100490.18185330802},16.632007916085097,16.632007916085097,2.1818181818181817,7.8181818181818183,166.32007916085098,0.6666666666666673,11.088005277390076,155.23207388346091,2.1818181818181817,7.8181818181818192,10]

{"sheet":"NPV","index":11,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[32,7,32,10],[26,1,26,2],[26,4,26,5]]}
[]
[null,"Net Present Value Table"]
[null,"Year","One Time Costs","Annual Costs","One Time Payments","Annual Payments","Land Rental\nIncome Effect","Net Property Tax\nImpact","Asset Value of Land Preserved"]
[null,0,{"$f":"Budget!D24","v":72898.875},0,{"$f":"Inputs!C33+Inputs!C34","v":71495.494318181823},0,{"$f":"Budget!E31","v":-174.54545454545453},{"$f":"Budget!P31","v":0},{"$f":"Budget!H31","v":0}]
[null,1,0,{"$f":"Budget!D25","v":0},{"$f":"IF(B5=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B5<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E32","v":-123.87878787878789},{"$f":"Budget!P32","v":1.4210854715202004E-14},{"$f":"Budget!H32","v":0}]
[null,2,0,{"$f":"IF(B6<=Budget!$G$18,D5*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B6=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B6<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E33","v":-70.898307878787875},{"$f":"Budget!P33","v":8.3558719999999909},{"$f":"Budget!H33","v":0}]
[null,3,0,{"$f":"IF(B7<=Budget!$G$18,D6*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B7=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B7<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E34","v":-15.526729425454551},{"$f":"Budget!P34","v":17.079402367999975},{"$f":"Budget!H34","v":0}]
[null,4,0,{"$f":"IF(B8<=Budget!$G$18,D7*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B8=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B8<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E35","v":42.315513260838785},{"$f":"Budget!P35","v":26.182723830143971},{"$f":"Budget!H35","v":0}]
[null,5,0,{"$f":"IF(B9<=Budget!$G$18,D8*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B9=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B9<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E36","v":102.71032956237093},{"$f":"Budget!P36","v":35.678325005876218},{"$f":"Budget!H36","v":0}]
[null,6,0,{"$f":"IF(B10<=Budget!$G$18,D9*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B10=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B10<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E37","v":165.74203707275225},{"$f":"Budget!P37","v":45.579060195006875},{"$f":"Budget!H37","v":0}]
[null,7,0,{"$f":"IF(B11<=Budget!$G$18,D10*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B11=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B11<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E38","v":231.49742791408215},{"$f":"Budget!P38","v":55.898159423156429},{"$f":"Budget!H38","v":0}]
[null,8,0,{"$f":"IF(B12<=Budget!$G$18,D11*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B12=Inputs!$C$36,Inputs!$C$35,0)","v":157.45454545454544},{"$f":"IF(B12<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E39","v":300.06583680648743},{"$f":"Budget!P39","v":66.649238752210195},{"$f":"Budget!H39","v":0}]
[null,9,0,{"$f":"IF(B13<=Budget!$G$18,D12*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B13=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B13<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E40","v":371.539210935048},{"$f":"Budget!P40","v":77.84631086258149},{"$f":"Budget!H40","v":0}]
[null,10,0,{"$f":"IF(B14<=Budget!$G$18,D13*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B14=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B14<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E41","v":446.01218166025103},{"$f":"Budget!P41","v":89.503795914253104},{"$f":"Budget!H41","v":0}]
[null,11,0,{"$f":"IF(B15<=Budget!$G$18,D14*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B15=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B15<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E42","v":523.58213811927044},{"$f":"Budget!P42","v":101.63653269374073},{"$f":"Budget!H42","v":0}]
[null,12,0,{"$f":"IF(B16<=Budget!$G$18,D15*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B16=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B16<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E43","v":604.34930276656314},{"$f":"Budget!P43","v":114.25979005430335},{"$f":"Budget!H43","v":0}]
[null,13,0,{"$f":"IF(B17<=Budget!$G$18,D16*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B17=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B17<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E44","v":688.41680890348687},{"$f":"Budget!P44","v":127.38927865690692},{"$f":"Budget!H44","v":0}]
[null,14,0,{"$f":"IF(B18<=Budget!$G$18,D17*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B18=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B18<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E45","v":775.89078024789637},{"$f":"Budget!P45","v":141.04116301963879},{"$f":"Budget!H45","v":0}]
[null,15,0,{"$f":"IF(B19<=Budget!$G$18,D18*(1+Budget!$E$10),\"-\")","v":0},{"$f":"IF(B19=Inputs!$C$36,Inputs!$C$35,0)","v":0},{"$f":"IF(B19<=Budget!$G$18,Budget!$H$25,\"-\")","v":249.52061405422774},{"$f":"Budget!E46","v":866.88041259595059},{"$f":"Budget!P46","v":155.23207388346091},{"$f":"Budget!H46","v":100490.18185330802}]
[]
[null,"Sum totals",{"$f":"SUM(C4:C19)","v":72898.875},{"$f":"SUM(D5:D19)","v":0},{"$f":"SUM(E4:E19)","v":71652.948863636368},{"$f":"SUM(F5:F19)","v":3742.809210813416},{"$f":"SUM(G4:G19)","v":4734.1527001165132},{"$f":"SUM(H4:H19)","v":1062.3317266592792},{"$f":"SUM(I4:I19)","v":100490.18185330802}]
[]
[null,"PV",{"$f":"NPV($C$25,C5:C19)+C4","v":72898.875},{"$f":"NPV($C$25,D5:D19)+D4","v":0},71602.065752275797,2589.9386473597219,2566.247373202767,632.31555039317641,48337.495661712077]
[]
[null,"Discount Rate",{"$f":"Inputs!C10","v":0.05}]
[]
[null,"Including Value of Land Preserved",null,null,"Not Including Value of Land Preserved"]
[null,"Net Present Value",{"$f":"(-C23-D23+E23+F23+G23-H23+I23)","v":51564.556884157188},null,"Net Present Value",{"$f":"(-C23-D23+E23+F23+G23-H23)","v":3227.0612224451097}]
[null,"Annualized Value",{"$f":"PMT($C$25,$A$50,C28)*-1","v":4967.847369776714},null,"Annualized Value",{"$f":"PMT($C$25,$A$50,F28)*-1","v":310.90246042544646}]
[]
[]
[]
[null,"Net Cropping Area Table",null,null,null,null,null,"Graph Data"]
[null,"Year","CCRP","Acres Preserved","Cropped w/out Project","Actual Cropped","Net Cropped",{"$f":"E34","v":"Cropped w/out Project"},{"$f":"F34","v":"Actual Cropped"},{"$f":"C34","v":"CCRP"},{"$f":"G34","v":"Net Cropped"}]
[{"$f":"IF(B35<=Budget!$G$18,NPV!B35,0)","v":1},1,{"$f":"Budget!K32","v":2.1818181818181817},{"$f":"Budget!F32","v":0.66666666666666663},{"$f":"Inputs!C4-NPV!D35","v":79.333333333333329},{"$f":"Inputs!C4-NPV!C35","v":77.818181818181813},{"$f":"F35-E35","v":-1.5151515151515156},{"$f":"IF($B35=$A35,E35,NA())","v":79.333333333333329},{"$f":"IF($B35=$A35,F35,NA())","v":77.818181818181813},{"$f":"IF($B35=$A35,C35,NA())","v":2.1818181818181817},{"$f":"IF($B35=$A35,G35,NA())","v":-1.5151515151515156}]
[{"$f":"IF(B36<=Budget!$G$18,NPV!B36,\"\")","v":2},2,{"$f":"Budget!K33","v":2.1818181818181817},{"$f":"Budget!F33","v":1.3333333333333333},{"$f":"IF(B36<=Budget!$G$18,E35-$D$35,\"\")","v":78.666666666666657},{"$f":"IF(B36<=Budget!$G$18,F35,\"\")","v":77.818181818181813},{"$f":"IF(B36<=Budget!$G$18,F36-E36,\"-\")","v":-0.84848484848484418},{"$f":"IF($B36=$A36,E36,NA())","v":78.666666666666657},77.818181818181813,{"$f":"IF($B36=$A36,C36,NA())","v":2.1818181818181817},{"$f":"IF($B36=$A36,G36,NA())","v":-0.84848484848484418}]
[{"$f":"IF(B37<=Budget!$G$18,NPV!B37,\"\")","v":3},3,{"$f":"Budget!K34","v":2.1818181818181817},{"$f":"Budget!F34","v":2},{"$f":"IF(B37<=Budget!$G$18,E36-$D$35,\"\")","v":77.999999999999986},{"$f":"IF(B37<=Budget!$G$18,F36,\"\")","v":77.818181818181813},{"$f":"IF(B37<=Budget!$G$18,F37-E37,\"-\")","v":-0.18181818181817277},77.999999999999986,77.818181818181813,2.1818181818181817,-0.18181818181817277]
[{"$f":"IF(B38<=Budget!$G$18,NPV!B38,\"\")","v":4},4,{"$f":"Budget!K35","v":2.1818181818181817},{"$f":"Budget!F35","v":2.6666666666666665},{"$f":"IF(B38<=Budget!$G$18,E37-$D$35,\"\")","v":77.333333333333314},{"$f":"IF(B38<=Budget!$G$18,F37,\"\")","v":77.818181818181813},{"$f":"IF(B38<=Budget!$G$18,F38-E38,\"-\")","v":0.48484848484849863},77.333333333333314,77.818181818181813,2.1818181818181817,0.48484848484849863]
[{"$f":"IF(B39<=Budget!$G$18,NPV!B39,\"\")","v":5},5,{"$f":"Budget!K36","v":2.1818181818181817},{"$f":"Budget!F36","v":3.333333333333333},{"$f":"IF(B39<=Budget!$G$18,E38-$D$35,\"\")","v":76.666666666666643},{"$f":"IF(B39<=Budget!$G$18,F38,\"\")","v":77.818181818181813},{"$f":"IF(B39<=Budget!$G$18,F39-E39,\"-\")","v":1.15151515151517},76.666666666666643,77.818181818181813,2.1818181818181817,1.15151515151517]
[{"$f":"IF(B40<=Budget!$G$18,NPV!B40,\"\")","v":6},6,{"$f":"Budget!K37","v":2.1818181818181817},{"$f":"Budget!F37","v":4},{"$f":"IF(B40<=Budget!$G$18,E39-$D$35,\"\")","v":75.999999999999972},{"$f":"IF(B40<=Budget!$G$18,F39,\"\")","v":77.818181818181813},{"$f":"IF(B40<=Budget!$G$18,F40-E40,\"-\")","v":1.8181818181818414},75.999999999999972,77.818181818181813,2.1818181818181817,1.8181818181818414]
[{"$f":"IF(B41<=Budget!$G$18,NPV!B41,\"\")","v":7},7,{"$f":"Budget!K38","v":2.1818181818181817},{"$f":"Budget!F38","v":4.6666666666666661},{"$f":"IF(B41<=Budget!$G$18,E40-$D$35,\"\")","v":75.3333333333333},{"$f":"IF(B41<=Budget!$G$18,F40,\"\")","v":77.818181818181813},{"$f":"IF(B41<=Budget!$G$18,F41-E41,\"-\")","v":2.4848484848485128},75.3333333333333,77.818181818181813,2.1818181818181817,2.4848484848485128]
[{"$f":"IF(B42<=Budget!$G$18,NPV!B42,\"\")","v":8},8,{"$f":"Budget!K39","v":2.1818181818181817},{"$f":"Budget!F39","v":5.333333333333333},{"$f":"IF(B42<=Budget!$G$18,E41-$D$35,\"\")","v":74.666666666666629},{"$f":"IF(B42<=Budget!$G$18,F41,\"\")","v":77.818181818181813},{"$f":"IF(B42<=Budget!$G$18,F42-E42,\"-\")","v":3.1515151515151842},74.666666666666629,77.818181818181813,2.1818181818181817,3.1515151515151842]
[{"$f":"IF(B43<=Budget!$G$18,NPV!B43,\"\")","v":9},9,{"$f":"Budget!K40","v":2.1818181818181817},{"$f":"Budget!F40","v":6},{"$f":"IF(B43<=Budget!$G$18,E42-$D$35,\"\")","v":73.999999999999957},{"$f":"IF(B43<=Budget!$G$18,F42,\"\")","v":77.818181818181813},{"$f":"IF(B43<=Budget!$G$18,F43-E43,\"-\")","v":3.8181818181818556},73.999999999999957,77.818181818181813,2.1818181818181817,3.8181818181818556]
[{"$f":"IF(B44<=Budget!$G$18,NPV!B44,\"\")","v":10},10,{"$f":"Budget!K41","v":2.1818181818181817},{"$f":"Budget!F41","v":6.6666666666666661},{"$f":"IF(B44<=Budget!$G$18,E43-$D$35,\"\")","v":73.333333333333286},{"$f":"IF(B44<=Budget!$G$18,F43,\"\")","v":77.818181818181813},{"$f":"IF(B44<=Budget!$G$18,F44-E44,\"-\")","v":4.4848484848485271},73.333333333333286,77.818181818181813,2.1818181818181817,4.4848484848485271]
[{"$f":"IF(B45<=Budget!$G$18,NPV!B45,\"\")","v":11},11,{"$f":"Budget!K42","v":2.1818181818181817},{"$f":"Budget!F42","v":7.333333333333333},{"$f":"IF(B45<=Budget!$G$18,E44-$D$35,\"\")","v":72.666666666666615},{"$f":"IF(B45<=Budget!$G$18,F44,\"\")","v":77.818181818181813},{"$f":"IF(B45<=Budget!$G$18,F45-E45,\"-\")","v":5.1515151515151985},72.666666666666615,77.818181818181813,2.1818181818181817,5.1515151515151985]
[{"$f":"IF(B46<=Budget!$G$18,NPV!B46,\"\")","v":12},12,{"$f":"Budget!K43","v":2.1818181818181817},{"$f":"Budget!F43","v":8},{"$f":"IF(B46<=Budget!$G$18,E45-$D$35,\"\")","v":71.999999999999943},{"$f":"IF(B46<=Budget!$G$18,F45,\"\")","v":77.818181818181813},{"$f":"IF(B46<=Budget!$G$18,F46-E46,\"-\")","v":5.8181818181818699},71.999999999999943,77.818181818181813,2.1818181818181817,5.8181818181818699]
[{"$f":"IF(B47<=Budget!$G$18,NPV!B47,\"\")","v":13},13,{"$f":"Budget!K44","v":2.1818181818181817},{"$f":"Budget!F44","v":8.6666666666666661},{"$f":"IF(B47<=Budget!$G$18,E46-$D$35,\"\")","v":71.333333333333272},{"$f":"IF(B47<=Budget!$G$18,F46,\"\")","v":77.818181818181813},{"$f":"IF(B47<=Budget!$G$18,F47-E47,\"-\")","v":6.4848484848485413},71.333333333333272,77.818181818181813,2.1818181818181817,6.4848484848485413]
[{"$f":"IF(B48<=Budget!$G$18,NPV!B48,\"\")","v":14},14,{"$f":"Budget!K45","v":2.1818181818181817},{"$f":"Budget!F45","v":9.3333333333333321},{"$f":"IF(B48<=Budget!$G$18,E47-$D$35,\"\")","v":70.6666666666666},{"$f":"IF(B48<=Budget!$G$18,F47,\"\")","v":77.818181818181813},{"$f":"IF(B48<=Budget!$G$18,F48-E48,\"-\")","v":7.1515151515152127},70.6666666666666,77.818181818181813,2.1818181818181817,7.1515151515152127]
[{"$f":"IF(B49<=Budget!$G$18,NPV!B49,\"\")","v":15},15,{"$f":"Budget!K46","v":2.1818181818181817},{"$f":"Budget!F46","v":10},{"$f":"IF(B49<=Budget!$G$18,E48-$D$35,\"\")","v":69.999999999999929},{"$f":"IF(B49<=Budget!$G$18,F48,\"\")","v":77.818181818181813},{"$f":"IF(B49<=Budget!$G$18,F49-E49,\"-\")","v":7.8181818181818841},69.999999999999929,77.818181818181813,2.1818181818181817,7.8181818181818841]
[{"$f":"MAX(A35:A49)","v":15}]