{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Required Reserves rehab-replace"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,6],[5,4,5,5],[46,0,46,6],[2,4,2,6]]}
["Budgeting Worksheet"]
[]
["Water System:"]
[]
["Completed by:"]
[]
["Budget Period:"]
[]
["Revenues"]
[]
[null,null,"Service Fees: …………………………………………………"]
[null,null,"Fees and Service Charges (late, connection, fire, etc.): ….."]
[null,null,"Impact Fees (demand, system development, etc.): ……….."]
[null,null,"Secured Funding: ……………………………………………."]
[null,null,"Interest: ……………………………………………………….."]
[null,null,"Other: …………………………………………………………."]
[]
[null,"Total Revenue:",null,null,null,null,{"$f":"SUM(G11:G16)","v":0}]
[]
["Expenses"]
[]
[null,null,"Maintenance: …………………………………………………."]
[null,null,"Utilities: ……………………………………………………….."]
[null,null,"Salaries and Benefits: ……………………………………….."]
[null,null,"Equipment Cost: ………………………………………………"]
[null,null,"Chemicals: ……………………………………………………."]
[null,null,"Monitoring and Testing: ………………………………………"]
[null,null,"Rent or Mortgage: ……………………………………………."]
[null,null,"Insurance: …………………………………………………….."]
[null,null,"Professional Services (legal, engineering, etc.): ………….."]
[null,null,"Training Costs: ……………………………………………….."]
[null,null,"Billing Costs: ………………………………………………….."]
[null,null,"Fees (permit, franchise, conservation, etc.): ……………….."]
[null,null,"Security: ………………………………………………………."]
[null,null,"Debt Payments: ………………………………………………"]
[null,null,"Other (taxes, misc., etc.): ……………………………………."]
[]
[null,null,"Total Expenses:",null,null,null,{"$f":"SUM(G22:G36)","v":0}]
[]
["Income (Revenue - Expenses):",null,null,null,null,null,{"$f":"(G18-G38)","v":0}]
[]
["Total Required Reserves (from reserves worksheet):"]
[]
["Net Income (income - required reserves):",null,null,null,null,null,{"$f":"IF(G40>G42,G40-G42,0)","v":0}]
[]
["Additional Revenue/Reserves Needed (reserves - income):",null,null,null,null,null,{"$f":"IF(G40<G42,G42-G40,\" \")","v":" "}]

{"sheet":"Required Reserves rehab-replace","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Required Reserve Worksheet"]
[]
["Date Completed:",null,"Note: Years for Action must have an integer value of at least 1."]
["Asset","Activity","Years for Action","Cost of Action","Reserve Required Current Year"]
[null,null,null,null,{"$f":"IF(D5>0,D5/C5,\" \")","v":" "}]
[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,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,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,null,null,null," "]
[null,null,null,null," "]
[null,null,null,null," "]
[null,null,null,null," "]
[null,null,null,null," "]
[]
[null,null,"Total Reserve for Current Year:",null,{"$f":"SUM(E5:E30)","v":0}]