{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PLEASE READ ME","Page 1","Page 2","Tax Authority List","County Wide Bonded Debt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"PLEASE READ ME","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[0,0,0,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[5,0,5,1]]}
["REMINDERS:"]
["1.","Use only whole numbers, round up or down as needed."]
["2.","Use only positive numbers. Formulas are in the subtotal/total cells to do the math for you."]
["3.","Fill in only highlighted areas, as applicable."]
[]
["INSTRUCTIONS:"]
["1.","If you receive a security warning, click \"Enable Content\"."]
["2.","Page 1: Select the proper tax authority from the drop-down list."]
["3.","If there are debt levies, go to Page 2. It will auto-fill with the debt schedule that was provided when the bonds were certified."]
["4.","Fill in the \"Budget Requirement\" column.  If this amount is less than what is scheduled you will need to provide a reason and a resolution."]
["5.","If you have additional bonds that did not auto-fill, please use the rows that are highlighted in yellow under the category they belong in."]
["6.","Go back to Page 1. Fill in the non-debt levy amounts as applicable."]
["7.","You may fax or email an advanced copy."]
["8.","Remember to sign and date the form before interofficing to the Taxation Division."]
[]
["Email Address:  PRTS-Taxation-Mailbox@washingtoncountymn.gov"]
["Fax Number:  (651) 430-6155"]
["Phone Number:  (651) 430-6155"]
["Mailing Address:  Washington County, Taxation Division, PO Box 6, Stillwater, MN 55082"]

{"sheet":"Page 1","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,0,25,4],[0,0,0,4],[1,0,1,4],[18,0,18,4],[19,1,19,4],[2,0,2,4],[3,1,3,3],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,0,24,4],[6,2,6,3],[9,2,10,3],[37,0,37,4],[26,0,26,4],[28,0,28,4],[29,0,29,4],[30,0,30,2],[31,0,31,2],[32,0,32,2],[32,3,32,4],[33,0,33,2],[33,3,33,4],[34,0,34,4],[35,0,35,4],[36,0,36,4],[27,0,27,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[41,0,41,4],[42,0,42,4]]}
["WASHINGTON COUNTY"]
["Payable Year 2026 FINAL Property Tax Levy Certification Form"]
["DUE:  December 29, 2025"]
[null,"Select a tax authority from drop-down list"]
["Expenditure\nCategory","(A)\nBudget\nRequirement","(B)\nState Aid\n(CPA)","(C)\nOther\nResources","(D)\nCertified Levy\n(A-B-C=D)"]
["General",null,null,null,{"$f":"B6-C6-D6","v":0}]
["Debt (see page 2)",{"$f":"IF(ISBLANK('Page 2'!E24),\"\",'Page 2'!E24)","v":0},null,null,{"$f":"B7-C7-D7","v":0}]
["Road & Bridge",null,null,null,0]
["Library",null,null,null,0]
["Library Debt Pre 2011 & Post 2017",{"$f":"'Page 2'!E34","v":0},null,null,0]
["Library Debt 2011-2017 (see page 2)",{"$f":"'Page 2'!E42","v":0},null,null,0]
["Social Services",null,null,null,0]
["Social Services - Admin",null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["TOTAL NET TAX CAPACITY LEVY",{"$f":"SUM(B6:B15)","v":0},{"$f":"SUM(C6:C15)","v":0},{"$f":"SUM(D6:D15)","v":0},0]
["Referenda Market Value Levy",null,null,null,0]
["TOTAL LEVY",{"$f":"SUM(B16:B17)","v":0},{"$f":"SUM(C16:C17)","v":0},{"$f":"SUM(D16:D17)","v":0},0]
[]
["A - Budget Requirement…………………………….","Amount needed to fund services."]
["B - State Aid (CPA)……………………………………………..","Certified to the taxing district by the Department of Revenue.  The aid can be used to reduce any individual budget requirement item or a combination of items; or may be deducted proportionally from all budget requirement items."]
["C - Other Resources………………………………………….","All other resources that will be used to finance your taxing district budget - including but not limited to other aids, interest income, prior year reserves, grants, etc."]
["D - Certified Levy…………………………………………………","Levy certified to the county auditor."]
[null,"The Taxation Division will deduct Fiscal Disparities from all certified levies"]
[]
[]
["Before signing, please verify the following:"]
["- AMOUNTS REPORTED MATCH ANY OTHER SUPPORTING DOCUMENTATION INCLUDED (i.e. Resolution, etc.)"]
[]
["I, the authorized representative of the above indicated taxing district, certify that the foregoing information is accurate to the best of my knowledge:"]
[]
["Signature of authorized representative",null,null,"Date","Phone"]
[]
["Print Name/Title",null,null,"E-mail"]
[]
["AN ORIGINAL SIGNED FORM MUST BE MAILED OR HAND DELIVERED TO WASHINGTON COUNTY TAXATION DIVISION BY 12/29/2025"]
[]
["You may submit an advance copy by FAX to (651) 430-6155 or E-mail to PRTS-Taxation-Mailbox@washingtoncountymn.gov"]
["Please mail the original signed form to:"]
["Washington County - Taxation Division"]
["14949 62nd St N, PO Box 6, Stillwater MN 55082-0006"]
[]
["Questions? Call (651) 430-6155"]

{"sheet":"Page 2","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,0,41,2],[42,0,42,5],[43,0,43,2],[24,0,24,5],[25,0,25,5],[26,0,26,5],[34,0,34,5],[33,0,33,2],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[6,0,6,5],[8,0,8,5],[19,0,19,5],[23,0,23,2],[5,0,5,5]]}
[{"$f":"'Page 1'!A1:E1","v":"WASHINGTON COUNTY"}]
[{"$f":"'Page 1'!A2:E2","v":"Payable Year 2026 FINAL Property Tax Levy Certification Form"}]
["DEBT SERVICE SCHEDULE"]
[]
[{"$f":"IF('Page 1'!B4=\"Select a tax authority from drop-down list\",\"Please select a tax authority from drop-down list on page 1\",'Page 1'!B4)","v":"Please select a tax authority from drop-down list on page 1"}]
["Only fill in the yellow highlighted areas, if they apply.  PLEASE NOTE:  IF THE AMOUNT IN THE BUDGET REQUIREMENT COLUMN IS LESS THAN THE AMOUNT IN THE BOND LEVY SCHEDULE COLUMN YOU MUST PROVIDE AN EXPLANATION AND A RESOLUTION."]
[]
["Bond\nDescription","Additional\nDescription","Bond #","Bond\nLevy\nSchedule","Budget\nRequirement","Explanation of Differences\nof Levy Schedule and\nActual Levy Amounts"]
["DEBT SERVICE - COUNTY-WIDE:"]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],3,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],3,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],4,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],4,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],2,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],2,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],5,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],5,FALSE))","v":""},{"$f":"D10","v":""}]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],7,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],7,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],8,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],8,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],6,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],6,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],9,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],9,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],11,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],11,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],12,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],12,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],10,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],10,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],13,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],13,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],15,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],15,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],16,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],16,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],14,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],14,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],17,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],17,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],19,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],19,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],20,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],20,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],18,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],18,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],21,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],21,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],23,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],23,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],24,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],24,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],22,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],22,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],25,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],25,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],27,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],27,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],28,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],28,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],26,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],26,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],29,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],29,FALSE))","v":""},{"$f":"D16","v":""}]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],31,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],31,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],32,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],32,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],30,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],30,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],33,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],33,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],35,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],35,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],36,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],36,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],34,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],34,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],37,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],37,FALSE))","v":""},""]
[{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],39,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],39,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],40,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],40,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],38,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],38,FALSE))","v":""},{"$f":"IF(ISBLANK(VLOOKUP('Page 1'!$B$4,Bonds[],41,FALSE)),\"\",VLOOKUP('Page 1'!$B$4,Bonds[],41,FALSE))","v":""},""]
["County-Wide Debt not listed above:"]
[]
[]
[]
["TOTAL COUNTY-WIDE DEBT",null,null,{"$f":"SUM(D10:D19,D21:D23)","v":0},{"$f":"SUM(E10:E19,E21:E23)","v":0}]
[]
["DEBT SERVICE - LIBRARY DISTRICT"]
["Pre 2011 & Post 2017 Library Debt:"]
[]
[]
[]
[]
[]
[]
["TOTAL PRE 2011 & POST 2017 LIBRARY DEBT",null,null,{"$f":"SUM(D28:D33)","v":0},{"$f":"SUM(E28:E33)","v":0}]
["2011 - 2017 Library Debt:"]
[]
[]
[]
[]
[]
[]
["TOTAL 2011 - 2017 LIBRARY DEBT",null,null,{"$f":"SUM(D36:D41)","v":0},{"$f":"SUM(E36:E41)","v":0}]
[]
["TOTAL DEBT",null,null,{"$f":"D24+D34+D42","v":0},{"$f":"E24+E34+E42","v":0}]

{"sheet":"Tax Authority List","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Select a tax authority from drop-down list"]
["Washington County"]
["Washington County CDA"]
["Washington County Regional Rail"]

{"sheet":"County Wide Bonded Debt","index":4,"n_rows":6,"n_cols":41,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41]
["Tax Authority","Bond Number 1","Description 1","Additional Description 1","Amount 1","Bond Number 2","Description 2","Additional Description 2","Amount 2","Bond Number 3","Description 3","Additional Description 3","Amount 3","Bond Number 4","Description 4","Additional Description 4","Amount 4","Bond Number 5","Description 5","Additional Description 5","Amount 5","Bond Number 6","Description 6","Additional Description 6","Amount 6","Bond Number 7","Description 7","Additional Description 7","Amount 7","Bond Number 8","Description 8","Additional Description 8","Amount 8","Bond Number 9","Description 9","Additional Description 9","Amount 9","Bond Number 10","Description 10","Additional Description 10","Amount 10"]
["Select a tax authority from drop-down list"]
["Washington County",1843,"Series 2016A","GO Capital Improvement Plan Bonds",980495,1888,"Series 2017A","GO Refunding Bonds",12104550,1928,"Series 2019A","GO Bonds",2086005,2027,"Series 2024A","GO Capital Improvement Plan Bonds",1507537]
["Washington County CDA"]
["Washington County Regional Rail"]