{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Debt Service"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":true,"merged":[[36,0,66,0],[0,0,0,11],[35,0,35,11]]}
["INSTRUCTIONS FOR THE DEBT SERVICE REPORT TEMPLATE"]
[]
["To fill out the Debt Service Report, you will need a copy of each of your debt service schedules "]
["(including, but not limited to, notes, bonds, certificates, mortgages, loans, leases or other"]
["agreements between a lender and a borrower).  Report debt service requirements for each debt "]
["issuance separately.  Fill in the yellow highlighted portions; everything else will be calculated for "]
["you."]
[]
[null,"1.","Fill in the Local Unit Name, Local Unit Code, and Current Fiscal Year End Date."]
[]
[null,"2.","For additional debt issuances, copy and paste the \"Debt Service\" tab as needed."]
[]
[null,"3.","For each debt, fill in the Debt Name, Issuance Date, Issuance Amount, Debt Instrument "]
[null,null,"(or Type), and Repayment Source(s). "]
[]
[null,null,null,"a.","Examples of debt instruments include, but are not limited to, notes, bonds, "]
[null,null,null,null,"certificates, mortgages, loans, leases or other agreements between a lender "]
[null,null,null,null,"and a borrower."]
[]
[null,"4.","Years Ending column - Enter the fiscal year end date in the Years Ending column.  Add "]
[null,null,"more rows as necessary to report all the current and future annual debt service "]
[null,null,"requirements for the debt issuance until it reaches maturity or is paid in full."]
[]
[null,"5.","Principal and Interest columns - Fill in the Principal and Interest amounts off the debt "]
[null,null,"service schedule(s).  "]
[]
[null,"6.","Commentary box - Provide additional information as necessary."]
[]
["Before publishing the Debt Service Report on your website, we highly recommend"]
["you \"Hide\" the \"Instructions\" tab so that this document will be user-friendly.  To hide"]
["a tab (or row), right click on the tab (or row) and select \"Hide\"."]
[]
["Make sure when you print or save this document to a PDF, you print the \"Debt Service\" tab."]
[]
[]
["DEBT SERVICE REPORT EXAMPLE"]

{"sheet":"Debt Service","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,26,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[0,0,0,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[6,2,6,6]]}
["Debt Service Report"]
[]
["Local Unit Name:",null,"Village of Saranac"]
["Local Unit Code:",null,34307]
["Current Fiscal Year End Date:",null,"2020-02-29"]
[]
["Debt Name:",null,"Water Supply & Sewage Disposal System Revenue Bond"]
["Issuance Date:",null,"2007-03-29"]
["Issuance Amount:",null,1400000]
["Debt Instrument (or Type):",null,"Revenue Bond"]
["Repayment Source(s):",null,"Sewer Revenue"]
[]
["Years Ending",null,"Principal",null,"Interest",null,"Total"]
[2020,"$",75000,"$",{"$f":"4996.88*2","v":9993.76},"$",{"$f":"+C14+E14","v":84993.76}]
[2021,"$",75000,"$",{"$f":"4387.5*2","v":8775},"$",83775]
[2022,"$",75000,"$",{"$f":"3778.13*2","v":7556.26},"$",82556.259999999995]
[2023,"$",75000,"$",{"$f":"3168.75*2","v":6337.5},"$",81337.5]
[2024,"$",75000,"$",{"$f":"2559.38*2","v":5118.76},"$",80118.759999999995]
[2025,"$",80000,"$",{"$f":"1950*2","v":3900},"$",83900]
[2026,"$",80000,"$",{"$f":"1300*2","v":2600},"$",82600]
[2027,"$",80000,"$",{"$f":"650*2","v":1300},"$",81300]
["Totals","$",{"$f":"SUM(C14:C21)","v":615000},"$",{"$f":"SUM(E14:E21)","v":45581.280000000006},"$",{"$f":"SUM(G14:G21)","v":660581.28}]
[]
[]
["Commentary:"]