{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Description","Inputs","Econ Analysis","Budget"],"not_rendered":{"charts":4,"images":23,"macros":1,"external_links":1,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[28,1,29,11],[67,1,67,11],[65,1,66,11],[4,13,5,23],[4,1,5,8],[7,4,7,5],[57,15,57,16],[58,6,58,8],[7,13,8,13],[51,1,52,11],[7,2,7,3],[44,1,50,11],[38,1,40,11],[30,1,30,4],[32,1,37,11],[62,1,63,11],[58,1,58,3]]}
[]
[]
[null,"KSU-HomeWastewaterTreatment"]
[]
[null,"An Excel spreadsheet program to estimate the economic costs of wastewater treatment systems for homeowners."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 5.5.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"KSU-HomeWastewaterTreatment is designed to evaluate the costs of installing a wastewater system over the useful life of the investment. "]
[]
[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 wastewater treatment systems and other resources of information. Then proceed to the Inputs sheet and enter your data on costs of home wastewater treatment systems construction and operation. View Econ Analysis and Budget to see the analysis of these costs."]
[]
[]
[]
[]
[]
[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,"Jeff Williams",null,null,null,null,null,"Originally Developed in Cooperation with:"]
[null,"Professor",null,null,null,null,null,"Craig Smith"]
[null,"Department of Agricultural Economics",null,null,null,null,null,"Watershed Economist"]
[null,"Kansas State University",null,null,null,null,null,"Kansas State University"]
[null,"jwilliam@ksu.edu"]
[null,"785-532-4491"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The developers would like to express their appreciation for the helpful comments and contributions of Morgan Powell, John Leatherman, and Richard Llewelyn 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 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Description","index":1,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[[30,1,30,6],[38,1,38,5],[44,1,44,5],[36,1,36,5],[42,1,42,5],[40,1,40,5],[32,1,32,5],[34,1,34,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[]
[null,"A Homeowner's Guide to Septic Systems"]
[null,"https://www3.epa.gov/npdes/pubs/homeowner_guide_long.pdf"]
[null,"Get to Know Your Septic System"]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/MF2179.pdf"]
[null,"Your Wastewater System Owner/Operator Manual"]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/S90.pdf"]
[null,"Wastewater Flow and Characteristics"]
[null,"http://ehs.ncpublichealth.com/oet/docs/cit/oswpmod/wastewaterCharcFlow.pdf"]
[null,"Why do Onsite Wastewater (Septic) Systems Fail?"]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/MF946.pdf"]
[null,"Wastewater Pond (Lagoon) Design and Construction"]
[null,"http://www.bookstore.ksre.ksu.edu/pubs/MF1044.pdf"]
[null,"Wastewater Pond (Lagoon) Operation, Maintenance and Repair"]
[null,"https://www.bookstore.ksre.ksu.edu/pubs/MF2290.pdf"]
[null,"Septic Tank Maintenance: A Key to Longer Septic System Life"]
[null,"http://bookstore.ksre.k-state.edu/pubs/MF947.pdf"]

{"sheet":"Inputs","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,1,3],[12,1,12,3],[16,1,16,3],[21,1,21,3]]}
[null,"Please contact a contractor for accurate cost estimates.",null,"*Pay attention to Units!"]
[null,"Installation and Construction Costs"]
[null,"Septic Tank",1000,"dollars",null,null,null,null,null,1]
[null,"Absorption Field",2500,"dollars",null,null,null,null,null,2]
[null,"Lagoon Construction",0,"dollars",null,null,null,null,null,3]
[null,"Labor",500,"dollars",null,null,null,null,null,4]
[null,"Machine Hire",350,"dollars",null,null,null,null,null,5]
[null,"Other Materials",220,"dollars",null,null,null,null,null,6]
[null,"Other Costs",230,"dollars",null,null,null,null,null,7]
[null,"Land Cost",0,"dollars",null,null,null,null,null,8]
[null,"TOTAL ONE TIME COSTS",{"$f":"SUM(C3:C10)","v":4800},"dollars",null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[null,"Maintenance Costs",null,null,null,null,null,null,null,11]
[null,"Annual Maintenance Cost",40,"dollars / year",null,null,null,null,null,12]
[null,"Inflation Rate for Maintenance Cost",0.03,"percent",null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,14]
[null,"Financial Assistance",null,null,null,null,null,null,null,15]
[null,"Construction Cost Share Payment",1000,"dollars",null,null,null,null,null,16]
[null,"Annual Incentive Payment",0,"dollars",null,null,null,null,null,17]
[null,"Years for Annual Payment",0,"years",null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,19]
[null,"Other Data",null,null,null,null,null,null,null,20]
[null,"Opportunity Cost of Your Money",0.05,"percent",null,null,null,null,null,21]
[null,"System Life",28,"years",null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,10]
[null,null,null,null,11]
[null,null,null,null,12]
[null,null,null,null,13]
[null,null,null,null,14]
[null,null,null,null,15]

{"sheet":"Econ Analysis","index":3,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,1,75,10],[48,1,48,11],[46,1,47,11],[50,2,50,5]]}
[]
[null,"Wastewater Treatment System: Economic Analysis"]
[null,"The first year out-of-pocket costs of the wastewater treatment system would be",null,null,null,null,{"$f":"Budget!H3","v":3800},"this accounts for any financial assistance you may receive."]
[null,"On average, the wastewater treatment system you described will cost",null,null,null,{"$f":"Budget!F37","v":4632.7284153517203},{"$f":"\"in total over the \"&Inputs!C24&\" year design life of the system.\"","v":"in total over the 28 year design life of the system."}]
[null,"This is equal to a ",{"$f":"Budget!H5","v":311},"cost per year or approximately",{"$f":"Budget!H6","v":26},"per month over the same time period."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In order to effectively evaluate costs and returns which occur over multiple years (2 to 30 years), we must convert all costs and returns to today's 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. 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 home wastewater treatment system assistance, be sure to contact your local health department or extension office. A Health Department Directory"]
[null,"can be found at:","http://www.kdheks.gov/olrh/download/health_directory.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Budget","index":4,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,3,1],[1,1,1,5],[2,2,3,2],[2,4,3,4],[2,5,3,5],[2,3,3,3]]}
[]
[null,"Lifecycle Cost Analysis of Home Wastewater Treatment Systems"]
[null,"Year","Installation & Construction","Financial Assistance","Annual Incentives","Maintenance Costs",null,{"$f":"ROUND(C5-D5,0)","v":3800}]
[null,null,null,null,null,null,null,{"$f":"ROUND(F37,0)","v":4633}]
[null,0,{"$f":"Inputs!C11","v":4800},{"$f":"Inputs!C18","v":1000},null,null,null,{"$f":"ROUND(F38,0)","v":311}]
[null,1,null,null,{"$f":"Inputs!C19","v":0},{"$f":"Inputs!C14","v":40},null,{"$f":"ROUND(F39,0)","v":26}]
[null,2,null,null,{"$f":"IF(B7<=Inputs!$C$20,E6, 0)","v":0},{"$f":"IF(B7<=Inputs!$C$24,F6*(1+Inputs!$C$15),0)","v":41.2}]
[null,3,null,null,{"$f":"IF(B8<=Inputs!$C$20,E7, 0)","v":0},{"$f":"IF(B8<=Inputs!$C$24,F7*(1+Inputs!$C$15),0)","v":42.436000000000007}]
[null,4,null,null,{"$f":"IF(B9<=Inputs!$C$20,E8, 0)","v":0},{"$f":"IF(B9<=Inputs!$C$24,F8*(1+Inputs!$C$15),0)","v":43.709080000000007}]
[null,5,null,null,{"$f":"IF(B10<=Inputs!$C$20,E9, 0)","v":0},{"$f":"IF(B10<=Inputs!$C$24,F9*(1+Inputs!$C$15),0)","v":45.020352400000007}]
[null,6,null,null,{"$f":"IF(B11<=Inputs!$C$20,E10, 0)","v":0},{"$f":"IF(B11<=Inputs!$C$24,F10*(1+Inputs!$C$15),0)","v":46.370962972000008}]
[null,7,null,null,{"$f":"IF(B12<=Inputs!$C$20,E11, 0)","v":0},{"$f":"IF(B12<=Inputs!$C$24,F11*(1+Inputs!$C$15),0)","v":47.762091861160009}]
[null,8,null,null,{"$f":"IF(B13<=Inputs!$C$20,E12, 0)","v":0},{"$f":"IF(B13<=Inputs!$C$24,F12*(1+Inputs!$C$15),0)","v":49.194954616994814}]
[null,9,null,null,{"$f":"IF(B14<=Inputs!$C$20,E13, 0)","v":0},{"$f":"IF(B14<=Inputs!$C$24,F13*(1+Inputs!$C$15),0)","v":50.670803255504659}]
[null,10,null,null,{"$f":"IF(B15<=Inputs!$C$20,E14, 0)","v":0},{"$f":"IF(B15<=Inputs!$C$24,F14*(1+Inputs!$C$15),0)","v":52.190927353169798}]
[null,11,null,null,{"$f":"IF(B16<=Inputs!$C$20,E15, 0)","v":0},{"$f":"IF(B16<=Inputs!$C$24,F15*(1+Inputs!$C$15),0)","v":53.756655173764891}]
[null,12,null,null,{"$f":"IF(B17<=Inputs!$C$20,E16, 0)","v":0},{"$f":"IF(B17<=Inputs!$C$24,F16*(1+Inputs!$C$15),0)","v":55.369354828977841}]
[null,13,null,null,{"$f":"IF(B18<=Inputs!$C$20,E17, 0)","v":0},{"$f":"IF(B18<=Inputs!$C$24,F17*(1+Inputs!$C$15),0)","v":57.030435473847177}]
[null,14,null,null,{"$f":"IF(B19<=Inputs!$C$20,E18, 0)","v":0},{"$f":"IF(B19<=Inputs!$C$24,F18*(1+Inputs!$C$15),0)","v":58.741348538062596}]
[null,15,null,null,{"$f":"IF(B20<=Inputs!$C$20,E19, 0)","v":0},{"$f":"IF(B20<=Inputs!$C$24,F19*(1+Inputs!$C$15),0)","v":60.503588994204478}]
[null,16,null,null,{"$f":"IF(B21<=Inputs!$C$20,E20, 0)","v":0},{"$f":"IF(B21<=Inputs!$C$24,F20*(1+Inputs!$C$15),0)","v":62.318696664030611}]
[null,17,null,null,{"$f":"IF(B22<=Inputs!$C$20,E21, 0)","v":0},{"$f":"IF(B22<=Inputs!$C$24,F21*(1+Inputs!$C$15),0)","v":64.188257563951538}]
[null,18,null,null,{"$f":"IF(B23<=Inputs!$C$20,E22, 0)","v":0},{"$f":"IF(B23<=Inputs!$C$24,F22*(1+Inputs!$C$15),0)","v":66.113905290870079}]
[null,19,null,null,{"$f":"IF(B24<=Inputs!$C$20,E23, 0)","v":0},{"$f":"IF(B24<=Inputs!$C$24,F23*(1+Inputs!$C$15),0)","v":68.097322449596177}]
[null,20,null,null,{"$f":"IF(B25<=Inputs!$C$20,E24, 0)","v":0},{"$f":"IF(B25<=Inputs!$C$24,F24*(1+Inputs!$C$15),0)","v":70.140242123084064}]
[null,21,null,null,{"$f":"IF(B26<=Inputs!$C$20,E25, 0)","v":0},{"$f":"IF(B26<=Inputs!$C$24,F25*(1+Inputs!$C$15),0)","v":72.244449386776594}]
[null,22,null,null,{"$f":"IF(B27<=Inputs!$C$20,E26, 0)","v":0},{"$f":"IF(B27<=Inputs!$C$24,F26*(1+Inputs!$C$15),0)","v":74.411782868379888}]
[null,23,null,null,{"$f":"IF(B28<=Inputs!$C$20,E27, 0)","v":0},{"$f":"IF(B28<=Inputs!$C$24,F27*(1+Inputs!$C$15),0)","v":76.644136354431282}]
[null,24,null,null,{"$f":"IF(B29<=Inputs!$C$20,E28, 0)","v":0},{"$f":"IF(B29<=Inputs!$C$24,F28*(1+Inputs!$C$15),0)","v":78.943460445064218}]
[null,25,null,null,{"$f":"IF(B30<=Inputs!$C$20,E29, 0)","v":0},{"$f":"IF(B30<=Inputs!$C$24,F29*(1+Inputs!$C$15),0)","v":81.311764258416147}]
[null,26,null,null,{"$f":"IF(B31<=Inputs!$C$20,E30, 0)","v":0},{"$f":"IF(B31<=Inputs!$C$24,F30*(1+Inputs!$C$15),0)","v":83.751117186168628}]
[null,27,null,null,{"$f":"IF(B32<=Inputs!$C$20,E31, 0)","v":0},{"$f":"IF(B32<=Inputs!$C$24,F31*(1+Inputs!$C$15),0)","v":86.26365070175369}]
[null,28,null,null,{"$f":"IF(B33<=Inputs!$C$20,E32, 0)","v":0},{"$f":"IF(B33<=Inputs!$C$24,F32*(1+Inputs!$C$15),0)","v":88.851560222806299}]
[null,29,null,null,{"$f":"IF(B34<=Inputs!$C$20,E33, 0)","v":0},{"$f":"IF(B34<=Inputs!$C$24,F33*(1+Inputs!$C$15),0)","v":0}]
[null,30,null,null,{"$f":"IF(B35<=Inputs!$C$20,E34, 0)","v":0},{"$f":"IF(B35<=Inputs!$C$24,F34*(1+Inputs!$C$15),0)","v":0}]
[null,"PV >>",{"$f":"C5","v":4800},{"$f":"D5","v":1000},{"$f":"NPV(Inputs!$C$23,E6:E35)","v":0},{"$f":"NPV(Inputs!$C$23,F6:F35)","v":832.72841535172051}]
[null,null,null,null,"Total Present Value >>>",{"$f":"C36-D36-E36+F36","v":4632.7284153517203}]
[null,null,null,null,"Annualized Cost >>>",{"$f":"(Inputs!$C$23/(1-(1+Inputs!$C$23)^-Inputs!$C$24))*$F$37","v":310.96045398135419}]
[null,null,null,null,"Monthly Cost >>>",{"$f":"((Inputs!$C$23/12)/(1-(1+(Inputs!$C$23/12))^(-Inputs!$C$24*12)))*$F$37","v":25.645577722754265}]