{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Description","Inputs","Econ Analysis","OneCost","OnePayment","AnnualPayments","Cropland Trends","Programs","TaxInfo","Budget"],"not_rendered":{"charts":2,"images":48,"macros":1,"external_links":2,"defined_names":16,"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":[[28,1,29,11],[57,17,57,18],[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],[58,5,58,7],[58,9,58,10],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13]]}
[]
[]
[null,"KSU-Vegetative Buffer"]
[]
[null,"An Excel spreadsheet program to estimate the economic benefits and costs of vegetative buffers."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 3.1.2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"This program is designed to analyze vegetative buffers 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 to see examples of vegetative buffers. When you proceed to the Inputs sheet, enter your crop field and vegetative buffer 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 a vegetative buffer on your crop field. The Budget sheet contains \"background\" data for the program. The Programs sheet exhibits the different funding programs available for vegetative buffers. 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 Thad Rhodes, Katie Burke, Andrew Klein, John Leatherman, Kevin Dhuyvetter, Terry Kastens, Kevin Religa, Bob Lienemann, and Richard Jensen 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":94,"n_cols":27,"rows_kept":94,"cut":false,"hidden":false,"merged":[[5,1,8,18],[9,1,9,11]]}
[]
[]
[]
[]
[]
[null,"A vegetative buffer is an area of land that is maintained in permanent vegetation to help reduce nutrient and sediment loss from agricultural fields, improve runoff water quality, and provide habitat for wildlife. Because of these societal benefits, there are several federal and state programs that encourage the installation and maintenance of vegetative buffers. For detailed information on the establishment of vegetative buffers see \"Establishing Riparian Buffers\"-KSU MF_2489"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/mf2489.pdf"]
[]
[null,"Figure 1: Example Multispecies Riparian Buffer",null,null,null,null,null,null,null,null,null,"Figure 2: Problem - Erosion from rainfall events"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"source: Iowa State University Leopold Center for Agroecology",null,null,null,null,null,null,null,null,null,"L. Betts, NRCS"]
[]
[]
[]
[]
[null,"Figure 3: Before vegetative buffers",null,null,null,null,null,null,null,null,null,"Figure 4: After vegetative buffers"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"L. Betts, NRCS",null,null,null,null,null,null,null,null,null,"L. Betts, NRCS"]
[]
[]
[null,"Figure 5: After vegetative buffer installation",null,null,null,null,null,null,null,null,null,"Figure 6: Multispecies vegetative buffer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"L. Betts, NRCS",null,null,null,null,null,null,null,null,null,"L. Betts, NRCS"]

{"sheet":"Inputs","index":2,"n_rows":175,"n_cols":6,"rows_kept":175,"cut":false,"hidden":false,"merged":[[23,5,23,6],[27,1,27,3],[34,1,34,3],[40,1,40,3],[1,1,1,3],[8,1,8,3],[13,1,13,3],[21,1,21,3]]}
[null,null,null,"*Pay attention to Units!"]
[null,"Field Inputs"]
[null,"Kansas County","MARSHALL","County"]
[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",1000,"feet"]
[null,"Project Width",66,"feet"]
[null,"Project Area",{"$f":"((C10*C11)/43560)*1.2","v":1.8181818181818181},"acres"]
[]
[null,"One Time Costs"]
[null,"Engineering and Design",30,"dollars"]
[null,"Field Operations / Equipment Costs",884.72,"dollars"]
[null,"Labor Costs",0,"dollars"]
[null,"Material Costs",1313.6004,"dollars"]
[null,"Other Costs",0,"dollars"]
[null,"TOTAL ONE TIME COSTS",{"$f":"SUM(C15:C19)","v":2228.3204000000001},"dollars"]
[null,null,{"$f":"OneCost!J30","v":0}]
[null,"Annual Costs"]
[null,"Annual Maintenance Costs",25,"dollars / acre / year"]
[null,"Other Annual Costs",{"$f":"(50*2)/10","v":10},"dollars / acre / year"]
[null,"Inflation Rate of Annual Costs",0.04,"percent"]
[null,"TOTAL ANNUAL COSTS",{"$f":"SUM(C23:C24)","v":35},"dollars / acre / year"]
[]
[null,"One Time Payments Received"]
[null,"One Time Cost-share/Incentive Payments",{"$f":"OnePayment!J16","v":2081.8985418181819},"dollars"]
[null,"Other One Time Payments of Benefits Received",0,"dollars"]
[null,"Management Payment",{"$f":"(2/3*C12)*(87.5)+(1/3*C12)*(33+8.5)","v":131.21212121212119},"dollars"]
[null,"Contract Year Received",7]
[null,"TOTAL ONE TIME PAYMENTS",{"$f":"SUM(C29:C31)","v":2213.1106630303029},"dollars"]
[]
[null,"Annual Payments Received"]
[null,"Annual Rental/Incentive Payments",{"$f":"AnnualPayments!J8","v":148.6726992073107},"dollars / acre / year"]
[null,"Other Annual Payments",0,"dollars / acre / year"]
[null,"Annual Benefits Received",0,"dollars / acre / year"]
[null,"TOTAL ANNUAL PAYMENTS",{"$f":"SUM(C36:C38)","v":148.6726992073107},"dollars / acre / year"]
[]
[null,"Financial Assistance"]
[null,"Continuous CRP Contract Length - Time period for Economic Analysis",10,"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,B71:C175,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":122,"n_cols":19,"rows_kept":122,"cut":false,"hidden":false,"merged":[[121,1,135,10],[22,3,22,6],[98,6,98,10],[110,2,110,4],[101,3,101,9],[96,1,96,12],[94,1,95,12]]}
[]
[null,"Vegetative Buffer: Economic Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2017-03-14T09:15:23.610"}]
[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.\"","v":"Your project area is located in MARSHALL County, Kansas."},null,null,null,null,null,"Your project area (buffer size) is",{"$f":"Inputs!C12","v":1.8181818181818181},"acres."]
[]
[null,"The results are based upon the following assumptions:"]
[]
[null,"One time Costs:",{"$f":"SUM(Inputs!$C$15:$C$19)","v":2228.3204000000001},null,null,"One time Cost-Share Payments:",{"$f":"SUM(Inputs!$C$29:$C$31)","v":2213.1106630303029},null,null,"Time Period Selected:",{"$f":"Inputs!C42","v":10},"years"]
[null,"Annual Costs:",{"$f":"Budget!C19","v":63.636363636363633},null,null,"Annual Incentive Payments:",{"$f":"Budget!F19","v":270.31399855874673},null,null,"Opportunity Cost of Your Money:",{"$f":"Inputs!C7","v":0.05}]
[]
[null,"The first year out-of-pocket costs of the vegetative buffer would be",null,null,null,null,{"$f":"IF(Budget!C50-Budget!E50>0,Budget!C50-Budget!E50,0)","v":146.42185818181815},"this accounts for any cost-share payments you may receive."]
[]
[null,"Based on the information you have provided, a vegetative buffer on the project area would",null,null,null,null,null,{"$f":"IF(Budget!C44>0, \"return\", \"lose\")","v":"return"},{"$f":"Budget!C44","v":103.52106229189924},"per acre annually."]
[null,"Based on the information you have provided, a vegetative buffer on the project area would",null,null,null,null,null,{"$f":"IF(Budget!C71>0, \"return\", \"lose\")","v":"return"},{"$f":"Budget!C71","v":188.22011325799861},"annually."]
[]
[null,"Based on the information you have provided, cropland on the project area would return",null,null,null,null,null,{"$f":"Budget!J44","v":87.633656569651222},"per acre annually."]
[null,"Based on the information you have provided, cropland on the project area would return",null,null,null,null,null,{"$f":"Budget!J71","v":159.3339210357295},"annually."]
[]
[null,"TAKE HOME MESSAGE:"]
[null,"You would be ",{"$f":"Budget!C71-Budget!J71","v":28.886192222269102},"per year",{"$f":"IF(C20>0, \"better off\", \"worse off\")","v":"better off"},"installing this area to a vegetative buffer versus using it for crop production."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 more information regarding the economics of vegetative buffers, check out KSU Guide Sheet MF-2536 \"Using Conservation"]
[null,"Buffers to Protect Water Quality and Enhance Agricultural Profitability.\"",null,null,null,null,"http://www.bookstore.ksre.ksu.edu/pubs/MF2536.pdf"]
[]
[null,"For vegetative buffer assistance, be sure to contact your local county conservation district. A Kansas Conservation District Directory"]
[null,"can be found at:",null,"http://www.kacdnet.org/districts.html"]
[]
[]
[null,"If you have any questions regarding this Decision-Making Tool, please contact:"]
[]
[null,null,"Robin Reid"]
[null,null,"Extension Associate"]
[null,null,"Kansas State University"]
[null,null,"robinreid@ksu.edu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,1,38,3],[1,1,1,10],[3,1,3,2],[6,1,6,2],[2,1,2,10],[32,5,32,9]]}
[]
[null,"One Time Construction Costs Worksheet"]
[null,"Enter Values in Purple Cells Only!!!"]
[null,"Engineering and Design",null,null,null,null,null,null,"Total"]
[null,null,"Vegetation/CCRP Area",null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I5)","v":30},null,{"$f":"I6","v":30}]
[null,"Vegetative Buffer Costs"]
[null,null,"Equipment",null,"Acres","@","$ / acre"]
[null,null,"     Site Preparation",null,1.82,null,146,null,{"$f":"E9*G9","v":265.72000000000003}]
[null,null,"     Drill Cover Crop",null,1.21,null,17,null,20.57]
[null,null,"     Herbicide application",null,0,null,0,null,0]
[null,null,"     Drill Grass",null,0.61,null,17,null,10.37]
[null,null,"     Tree & Shrub Planting",null,1.21,null,{"$f":"450*1.08","v":486.00000000000006},null,{"$f":"E13*G13","v":588.06000000000006}]
[null,null,"     Producer/Landowner",null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I9:I14)","v":884.72},null,{"$f":"I15","v":884.72}]
[]
[null,null,"Materials",null,"Units","@","$ / unit"]
[null,null,"     Cover Crop Seed",null,1.21,null,55,null,{"$f":"E18*G18","v":66.55}]
[null,null,"     Herbicide",null,1.21,null,100,null,{"$f":"E19*G19","v":121}]
[null,null,"     Grass Seed",null,0.61,null,66.64,null,40.650399999999998]
[null,null,"     Mulch",null,0,null,0,null,0]
[null,null,"     Live Stakes",null,0,null,0,null,0]
[null,null,"     Bare Roots",null,{"$f":"450*1.2","v":540},null,0.81,null,437.40000000000003]
[null,null,"     Trees",null,0,null,0,null,0]
[null,null,"     Tree Shelters",null,108,null,6,null,648]
[null,null,"     Other Material",null,0,null,0,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I18:I26)","v":1313.6004},null,{"$f":"I27","v":1313.6004}]
[null,null,"Other Labor Costs",null,"Hours","@","$ / hour"]
[null,null,"    Other Labor",null,0,null,0,null,{"$f":"E29*G29","v":0},null,{"$f":"I29","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K29)","v":2198.3204000000001}]
[]
[null,null,null,null,null,"Total One Time Construction Costs",null,null,null,null,{"$f":"K6+K31","v":2228.3204000000001}]
[]
[]
[]
[]
[null,"** For Recommended Tree Species See \"Establishing Riparian Buffers\" - KSU MF-2489 at:"]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/mf2489.pdf"]

{"sheet":"OnePayment","index":5,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,21,7],[7,1,8,7],[7,8,8,9],[15,6,15,8],[9,1,10,7],[9,8,10,9],[1,1,1,9],[3,1,4,7],[3,8,4,9],[13,1,14,7],[13,8,14,9],[2,1,2,9],[11,1,12,7],[11,8,12,9],[5,1,6,7],[5,8,6,9]]}
[]
[null,"One Time Payments Worksheet"]
[null,"Enter Values in Purple Cells Only!!!"]
[null,"Continuous Conservation Reserve Program (CCRP) for vegetation establishment: One time payment, FSA, 50% of county average cost",null,null,null,null,null,null,{"$f":"0.5*(OneCost!K31-OneCost!I18-OneCost!I10)","v":1055.6001999999999}]
[]
[null,"CCRP-Practice Incentive Payment: One time payment, FSA, 40% of county average cost.  ",null,null,null,null,null,null,{"$f":"0.4*(OneCost!K31-OneCost!I18-OneCost!I10)","v":844.48015999999996}]
[]
[null,"CCRP-Sign-up Incentive Payment: One time payment, FSA, $100/acre for CCRP area",null,null,null,null,null,null,{"$f":"100*Inputs!C12","v":181.81818181818181}]
[]
[null,"Environmental Quality Incentives Program (cannot be used with any CRP program)",null,null,null,null,null,null,0]
[]
[null,"Watershed Restoration and Protection Strategy Payment",null,null,null,null,null,null,0]
[]
[null,"Other One Time Payments",null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Total One Time Payments",null,null,{"$f":"SUM(I4:J15)","v":2081.8985418181819}]
[]
[null,"* Default values are estimations only - calculated by multiplying the cost-share percentages by the one time cost values you entered previously. 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!B69","v":95.303012312378655},"per acre /year"]
[null,"Is the project area located in a designated TMDL Watershed?",null,null,null,null,null,null,null,"YES",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.56},null,null,null,null,"YES"]
[]
[null,null,null,null,null,null,"Total Annual Payments",null,null,{"$f":"J4*J6","v":148.6726992073107},"per acre / year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Estimated Continuous CRP 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,{"$f":"C28*$H$39+C28","v":79.216470910960595},"*These values represent a simple weighted average of year 2014 \"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,{"$f":"C131*$H$39+C131","v":100}]

{"sheet":"Cropland Trends","index":7,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[35,1,35,11],[1,1,1,8],[2,2,2,7],[32,1,32,4],[32,6,32,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,8.0000000000000004E-4,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-2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: NASS, compiled by Dr. Mykel Taylor, 2017"]

{"sheet":"Programs","index":8,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,1,18,5],[1,1,1,7],[13,1,13,2],[15,1,16,7],[17,1,17,4]]}
[]
[null,"Available Funding for the Vegetative Portion of a Streambank Stabilization Project"]
[null,"Program","Agency","Cost Share","Annual Rental Payment (percentage of County Soil Rental Rate)","One Time Bonus","Annual Maintenace Cost Assistance","Additional Notes**"]
[null,"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"]
[null,"CRP Continuous Sign-up (CCRP)","FSA",null,0.2,null,null,"added incentive for contiuous sign-up"]
[null,"CRP Continuous Sign-up (CCRP)","FSA",null,0.1,null,null,"added incentive for land in EPA \"wellhead protection areas\""]
[null,"CCRP-SIP","FSA",null,null,"$10 per acre X years of contract ($100 per acre)",null,"upfront signing incentive payment - bonus"]
[null,"CCRP-PIP","FSA",0.4,null,null,null,"practice incentive payment for eligible installation costs"]
[null,"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"]
[null,"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"]
[null,"Watershed Land Trust**","The Land Trust","Market value of land - with limitations",null,null,null,"Long-term easement; contact (913) 685-4600"]
[null,"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"]
[null,"Partners for Fish & Wildlife","Fish and Wildlife Service","10% - 90%",null,null,null,"dependent on: length of agreement, total acres, wildlife & environmental benefits"]
[null,"Example Totals: ",null,0.9,1.56,100,4]
[]
[null,"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."]
[]
[null,"*Cannot be used with any CRP program"]
[null,"**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":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[5,1,5,3],[6,1,6,3],[7,1,7,3],[3,1,3,3],[4,1,4,3],[14,1,14,3],[20,8,20,9],[47,8,47,9],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[null,"General Data For Vegetative Buffer"]
[]
[null,"Discount Rate",null,null,{"$f":"Inputs!C7","v":0.05}]
[null,{"$f":"Inputs!B4","v":"Cropland Rental Rate - not CCRP rental rate"},null,null,{"$f":"Inputs!C4","v":80},"per acre / year"]
[null,{"$f":"Inputs!B5","v":"Annual Cropland Rental Growth Rate"},null,null,{"$f":"Inputs!C5","v":2.1999999999999999E-2}]
[null,"Total Annual Costs",null,null,{"$f":"Inputs!C26","v":35},"per acre / year"]
[null,{"$f":"Inputs!B25","v":"Inflation Rate of Annual Costs"},null,null,{"$f":"Inputs!C25","v":0.04}]
[]
[null,"Project Length (feet)",null,null,{"$f":"Inputs!C10","v":1000}]
[null,"Project Width (feet)",null,null,{"$f":"Inputs!C11","v":66}]
[null,"Acres (length x width/43,560)",null,null,{"$f":"Inputs!C12","v":1.8181818181818181}]
[null,"Length of analysis (years)",null,null,{"$f":"Inputs!C42","v":10}]
[null,"Cropland Property Tax ($/acre)",null,null,{"$f":"Inputs!C6","v":12}]
[null,"Tame Grass Property Tax ($/acre)",null,null,{"$f":"E14*(1-(Inputs!C43))","v":12}]
[]
[null,"COSTS",null,null,"PAYMENTS RECEIVED"]
[null,"Total one-time",{"$f":"SUM(Inputs!C15:C19)","v":2228.3204000000001},null,"Total one-time",{"$f":"Inputs!C29+Inputs!C30+Inputs!C31","v":2213.1106630303029}]
[null,"Total annual",{"$f":"E7*E12","v":63.636363636363633},null,"Total annual",{"$f":"Inputs!C39*E12","v":270.31399855874673}]
[]
[null,"Net Present Value Table: Vegetative Buffer (per acre)",null,null,null,null,null,null,"NPV Table: Cropland Rent (per acre)"]
[null,"Year","One Time Costs","Annual Costs","One Time Payments","Annual Payments","Net Property Tax\nImpact",null,"Year","Rent"]
[null,0,{"$f":"C18/E12","v":1225.5762200000001},0,{"$f":"(Inputs!C29+Inputs!C30)/E12","v":1145.0441980000001},0,{"$f":"E15-E14","v":0},null,{"$f":"B23","v":0},0]
[null,1,0,{"$f":"C19/E12","v":35},{"$f":"(IF(Inputs!$C$32=Budget!B24,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B24<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},{"$f":"G23*(1+$E$6)","v":0},null,{"$f":"B24","v":1},{"$f":"E5","v":80}]
[null,2,0,{"$f":"IF(B25<=$E$13,D24*(1+$E$8),\"-\")","v":36.4},{"$f":"(IF(Inputs!$C$32=Budget!B25,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B25<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},{"$f":"G24*(1+$E$6)","v":0},null,2,{"$f":"IF(I25<=$E$13,J24*(1+$E$6),\"-\")","v":81.760000000000005}]
[null,3,0,{"$f":"IF(B26<=$E$13,D25*(1+$E$8),\"-\")","v":37.856000000000002},{"$f":"(IF(Inputs!$C$32=Budget!B26,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B26<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,3,83.558720000000008]
[null,4,0,39.370240000000003,{"$f":"(IF(Inputs!$C$32=Budget!B27,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B27<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,4,85.397011840000005]
[null,5,0,40.945049600000004,{"$f":"(IF(Inputs!$C$32=Budget!B28,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B28<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,5,87.275746100480006]
[null,6,0,42.582851584000004,{"$f":"(IF(Inputs!$C$32=Budget!B29,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B29<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,6,89.195812514690573]
[null,7,0,44.286165647360008,{"$f":"(IF(Inputs!$C$32=Budget!B30,Inputs!$C$31,0))/$E$12","v":72.166666666666657},{"$f":"IF(B30<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,7,91.158120390013764]
[null,8,0,46.057612273254406,{"$f":"(IF(Inputs!$C$32=Budget!B31,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B31<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,8,93.163599038594072]
[null,9,0,47.899916764184582,{"$f":"(IF(Inputs!$C$32=Budget!B32,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B32<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,9,95.21319821744315]
[null,10,0,49.81591343475197,{"$f":"(IF(Inputs!$C$32=Budget!B33,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B33<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":148.6726992073107},0,null,10,97.307888578226894]
[null,11,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B34,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B34<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":"-"},0,null,11,"-"]
[null,12,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B35,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B35<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":"-"},0,null,12,"-"]
[null,13,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B36,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B36<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":"-"},0,null,13,"-"]
[null,14,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B37,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B37<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":"-"},0,null,14,"-"]
[null,15,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B38,Inputs!$C$31,0))/$E$12","v":0},{"$f":"IF(B38<=Budget!$E$13,Budget!$F$19/$E$12,\"-\")","v":"-"},0,null,15,"-"]
[]
[null,"Sum totals",{"$f":"SUM(C23:C38)","v":1225.5762200000001},{"$f":"SUM(D23:D38)","v":420.21374930355091},{"$f":"SUM(E23:E38)","v":1217.2108646666668},{"$f":"SUM(F23:F38)","v":1486.7269920731067},{"$f":"SUM(G23:G38)","v":0},null,"Sum totals",{"$f":"SUM(J23:J38)","v":884.03009667944843}]
[null,"Present Value",{"$f":"NPV($E$4,C24:C38)+C23","v":1225.5762200000001},{"$f":"NPV($E$4,D24:D38)+D23","v":319.40445253732628},{"$f":"NPV($E$4,E24:E38)+E23","v":1196.3317006577238},{"$f":"NPV($E$4,F24:F38)+F23","v":1148.0111744852779},{"$f":"NPV($E$4,G24:G38)+G23","v":0},null,"Present Value",{"$f":"NPV($E$4,J24:J38)+J23","v":676.68386690606212}]
[]
[null,"Net Present Value",{"$f":"-C41-D41+E41+F41-G41","v":799.36220260567529},null,null,null,null,null,"Net Present Value",{"$f":"J41","v":676.68386690606212}]
[null,"Annualized Value",{"$f":"-PMT(E4,E13,C43)","v":103.52106229189924},null,null,null,null,null,"Annualized Value",{"$f":"-PMT(E4,E13,J43)","v":87.633656569651222}]
[]
[]
[]
[null,"Net Present Value Table: Vegetative Buffer (total project area)",null,null,null,null,null,null,"NPV Table: Cropland Rental Rate (total project area)"]
[null,"Year","One Time Costs","Annual Costs","One Time Payments","Annual Payments","Net Property Tax\nImpact",null,"Year","Rent"]
[null,0,{"$f":"C18","v":2228.3204000000001},0,{"$f":"Inputs!C29+Inputs!C30","v":2081.8985418181819},0,{"$f":"E15*E12-E14*E12","v":0},null,{"$f":"B50","v":0},{"$f":"J23*$E$12","v":0}]
[null,1,0,{"$f":"C19","v":63.636363636363633},{"$f":"(IF(Inputs!$C$32=Budget!B51,Inputs!$C$31,0))","v":0},{"$f":"IF(B51<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},{"$f":"G50*(1+$E$6)","v":0},null,{"$f":"B51","v":1},{"$f":"IF(I51<=$E$13,J24*$E$12,\"-\")","v":145.45454545454544}]
[null,2,0,{"$f":"IF(B52<=$E$13,D51*(1+$E$8),\"-\")","v":66.181818181818187},{"$f":"(IF(Inputs!$C$32=Budget!B52,Inputs!$C$31,0))","v":0},{"$f":"IF(B52<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},{"$f":"G51*(1+$E$6)","v":0},null,2,{"$f":"IF(I52<=$E$13,J25*$E$12,\"-\")","v":148.65454545454546}]
[null,3,0,68.829090909090922,{"$f":"(IF(Inputs!$C$32=Budget!B53,Inputs!$C$31,0))","v":0},{"$f":"IF(B53<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,3,151.92494545454545]
[null,4,0,71.58225454545456,{"$f":"(IF(Inputs!$C$32=Budget!B54,Inputs!$C$31,0))","v":0},{"$f":"IF(B54<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,4,155.26729425454545]
[null,5,0,74.445544727272747,{"$f":"(IF(Inputs!$C$32=Budget!B55,Inputs!$C$31,0))","v":0},{"$f":"IF(B55<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,5,158.68317472814547]
[null,6,0,77.423366516363657,{"$f":"(IF(Inputs!$C$32=Budget!B56,Inputs!$C$31,0))","v":0},{"$f":"IF(B56<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,6,162.17420457216468]
[null,7,0,80.520301177018212,{"$f":"(IF(Inputs!$C$32=Budget!B57,Inputs!$C$31,0))","v":131.21212121212119},{"$f":"IF(B57<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,7,165.74203707275228]
[null,8,0,83.741113224098939,{"$f":"(IF(Inputs!$C$32=Budget!B58,Inputs!$C$31,0))","v":0},{"$f":"IF(B58<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,8,169.38836188835285]
[null,9,0,87.090757753062903,{"$f":"(IF(Inputs!$C$32=Budget!B59,Inputs!$C$31,0))","v":0},{"$f":"IF(B59<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,9,173.11490584989664]
[null,10,0,90.574388063185424,{"$f":"(IF(Inputs!$C$32=Budget!B60,Inputs!$C$31,0))","v":0},{"$f":"IF(B60<=Budget!$E$13,Budget!$F$19,\"-\")","v":270.31399855874673},0,null,10,176.92343377859436]
[null,11,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B61,Inputs!$C$31,0))","v":0},{"$f":"IF(B61<=Budget!$E$13,Budget!$F$19,\"-\")","v":"-"},0,null,11,{"$f":"IF(I61<=$E$13,J34*$E$12,\"-\")","v":"-"}]
[null,12,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B62,Inputs!$C$31,0))","v":0},{"$f":"IF(B62<=Budget!$E$13,Budget!$F$19,\"-\")","v":"-"},0,null,12,"-"]
[null,13,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B63,Inputs!$C$31,0))","v":0},{"$f":"IF(B63<=Budget!$E$13,Budget!$F$19,\"-\")","v":"-"},0,null,13,"-"]
[null,14,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B64,Inputs!$C$31,0))","v":0},{"$f":"IF(B64<=Budget!$E$13,Budget!$F$19,\"-\")","v":"-"},0,null,14,"-"]
[null,15,0,"-",{"$f":"(IF(Inputs!$C$32=Budget!B65,Inputs!$C$31,0))","v":0},{"$f":"IF(B65<=Budget!$E$13,Budget!$F$19,\"-\")","v":"-"},0,null,15,"-"]
[]
[null,"Sum totals",{"$f":"SUM(C50:C65)","v":2228.3204000000001},{"$f":"SUM(D50:D65)","v":764.02499873372926},{"$f":"SUM(E50:E65)","v":2213.1106630303029},{"$f":"SUM(F50:F65)","v":2703.1399855874674},{"$f":"SUM(G50:G65)","v":0},null,"Sum totals",{"$f":"J40*$E$12","v":1607.3274485080881}]
[null,"Present Value",{"$f":"NPV($E$4,C51:C65)+C50","v":2228.3204000000001},{"$f":"NPV($E$4,D51:D65)+D50","v":580.73536824968414},{"$f":"NPV($E$4,E51:E65)+E50","v":2175.1485466504068},{"$f":"NPV($E$4,F51:F65)+F50","v":2087.2930445186871},{"$f":"NPV($E$4,G51:G65)+G50","v":0},null,"Present Value",{"$f":"J41*$E$12","v":1230.3343034655675}]
[]
[null,"Net Present Value",{"$f":"-C68-D68+E68+F68-G68","v":1453.3858229194097},null,null,null,null,null,"Net Present Value",{"$f":"J43*$E$12","v":1230.3343034655675}]
[null,"Annualized Value",{"$f":"-PMT(E4,E13,C70)","v":188.22011325799861},null,null,null,null,null,"Annualized Value",{"$f":"J44*$E$12","v":159.3339210357295}]