{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget by yr 2021-2025 PARIS","Details for Budget 2021-2025"],"read":"whole","date_system":"1900"}

{"sheet":"Budget by yr 2021-2025 PARIS","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"merged":[[1,5,1,8]]}
[{"$nulls":4},"Final"]
["BUDGET-OTASC",null,"2021-2025",null,"Admended","Proposed"]
[{"$nulls":3},"Actual","Budget","Budget","Budget","Budget","Budget"]
[{"$nulls":3},2020,2021,2022,2023,2024,2025]
["OPERATING REVENUES:"]
[null,"Tobacco settlement proceeds",null,{"v":6870532,"d":"6,870,532"},{"v":7430102,"d":"7,430,102"},{"v":6800000,"d":"6,800,000"},{"v":6700000,"d":"6,700,000"},{"v":6700000,"d":"6,700,000"},{"v":6500000,"d":"6,500,000"}]
[null,"Interest income",null,{"v":50472,"d":"50,472"},{"v":50000,"d":"50,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":70000,"d":"70,000"},{"v":80000,"d":"80,000"}]
[null,null,"Total operating revenues",{"$f":"SUM(D6:D7)","v":{"v":6921004,"d":"6,921,004"}},{"v":7480102,"d":"7,480,102"},{"v":6860000,"d":"6,860,000"},{"v":6760000,"d":"6,760,000"},{"$f":"SUM(H6:H7)","v":{"v":6770000,"d":"6,770,000"}},{"$f":"SUM(I6:I7)","v":{"v":6580000,"d":"6,580,000"}}]
[]
["OPERATING EXPENSES:"]
[null,"Insurance expense",null,{"v":4779,"d":"4,779"},{"v":5000,"d":"5,000"},{"v":5300,"d":"5,300"},{"v":5300,"d":"5,300"},{"v":5400,"d":"5,400"},{"v":5400,"d":"5,400"}]
[null,"Audit fee",null,{"v":6500,"d":"6,500"},{"v":6500,"d":"6,500"},{"v":6800,"d":"6,800"},{"v":6800,"d":"6,800"},{"v":6800,"d":"6,800"},{"v":6800,"d":"6,800"}]
[null,"Legal fees",null,{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4200,"d":"4,200"},{"v":4200,"d":"4,200"},{"v":4200,"d":"4,200"},{"v":4300,"d":"4,300"}]
[null,"Trustee fee",null,{"v":5250,"d":"5,250"},{"v":6500,"d":"6,500"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"}]
[null,"Administrative agency fee",null,{"v":29058,"d":"29,058"},{"v":30500,"d":"30,500"},{"v":30600,"d":"30,600"},{"v":30600,"d":"30,600"},{"v":30600,"d":"30,600"},{"v":30600,"d":"30,600"}]
[null,"Rating agency fee",null,{"v":6519,"d":"6,519"},{"v":7100,"d":"7,100"},{"v":7200,"d":"7,200"},{"v":7200,"d":"7,200"},{"v":7200,"d":"7,200"},{"v":7200,"d":"7,200"}]
[null,"General and administrative costs",null,{"v":67000,"d":"67,000"},{"v":69000,"d":"69,000"},{"v":71000,"d":"71,000"},{"v":73000,"d":"73,000"},{"v":75000,"d":"75,000"},{"v":77000,"d":"77,000"}]
[null,"OTASC - Bond Payment",null,{"v":1945000,"d":"1,945,000"},{"v":2475000,"d":"2,475,000"},{"$f":"-F34","v":{"v":1400000,"d":"1,400,000"}},{"$f":"-G34","v":{"v":1480000,"d":"1,480,000"}},{"v":1565000,"d":"1,565,000"},{"v":1660000,"d":"1,660,000"}]
[null,"Interest - Cash (Slow Pay)",null,{"v":4963155,"d":"4,963,155"},{"v":4895090.625,"d":"4,895,091"},{"v":4842356.25,"d":"4,842,356"},{"v":4761356.25,"d":"4,761,356"},{"v":4675715.625,"d":"4,675,716"},{"v":4585012.5,"d":"4,585,013"}]
[]
[]
[null,null,"Total operating expenses",{"$f":"SUM(D11:D20)","v":{"v":7031261,"d":"7,031,261"}},{"$f":"SUM(E11:E20)","v":{"v":7498690.625,"d":"7,498,691"}},{"$f":"SUM(F11:F19)","v":{"v":6374056.25,"d":"6,374,056"}},{"$f":"SUM(G11:G19)","v":{"v":6375056.25,"d":"6,375,056"}},{"$f":"SUM(H11:H19)","v":{"v":6376515.625,"d":"6,376,516"}},{"$f":"SUM(I11:I19)","v":{"v":6382912.5,"d":"6,382,913"}}]
[]
["INCREASE (DECREASE)IN NET DEFICIT",null,null,{"$f":"+D8-D22","v":{"v":-110257,"d":"(110,257)"}},{"$f":"+E8-E22","v":{"v":-18588.625,"d":"(18,589)"}},{"$f":"+F8-F22","v":{"v":485943.75,"d":"485,944"}},{"$f":"+G8-G22","v":{"v":384943.75,"d":"384,944"}},{"$f":"+H8-H22","v":{"v":393484.375,"d":"393,484"}},{"$f":"+I8-I22","v":{"v":197087.5,"d":"197,088"}}]
["FUND BALANCE/NET DEFICIT -"]
["  BEGINNING OF YEAR",null,null,{"v":6627283,"d":"6,627,283"},{"$f":"+D27","v":{"v":6517026,"d":"6,517,026"}},{"$f":"+E27","v":{"v":6498437.375,"d":"6,498,437"}},{"$f":"+F27","v":{"v":6984381.125,"d":"6,984,381"}},{"$f":"+G27","v":{"v":7369324.875,"d":"7,369,325"}},{"$f":"+H27","v":{"v":7762809.25,"d":"7,762,809"}}]
["FUND BALANCE/NET DEFICIT -",null,null,{"$f":"+D24+D26","v":{"v":6517026,"d":"6,517,026"}},{"v":6498437.375,"d":"6,498,437"},{"v":6984381.125,"d":"6,984,381"},{"$f":"SUM(G24:G26)","v":{"v":7369324.875,"d":"7,369,325"}},{"$f":"+H24+H26","v":{"v":7762809.25,"d":"7,762,809"}},{"$f":"+I24+I26","v":{"v":7959896.75,"d":"7,959,897"}}]
["  END OF YEAR"]
[]
[]
[]
["Bonds payable 2005 - Bal Beginning of year",null,null,{"$f":"4963972+7860549","v":{"v":12824521,"d":"12,824,521"}},{"$f":"+D32+D36","v":{"v":13718039.1,"d":"13,718,039"}},{"$f":"+E32+E36","v":{"v":14673811.35,"d":"14,673,811"}},{"$f":"+F32+F36","v":{"v":15696175.17,"d":"15,696,175"}},{"$f":"+G32+G36","v":{"v":16789770.21,"d":"16,789,770"}},{"$f":"+H32+H36","v":{"v":17959559.37,"d":"17,959,559"}}]
["Bonds payable 2016 - Bal Beginning of year",null,null,{"v":93080000,"d":"93,080,000"},{"$f":"+D33+D34","v":{"v":91135000,"d":"91,135,000"}},{"$f":"+E33+E34","v":{"v":88660000,"d":"88,660,000"}},{"$f":"+F33+F34","v":{"v":87260000,"d":"87,260,000"}},{"$f":"+G33+G34","v":{"v":85780000,"d":"85,780,000"}},{"$f":"+H33+H34","v":{"v":84215000,"d":"84,215,000"}}]
["Assumed Bond Payment - Prin -Slow Pay-",null,null,{"$f":"-D18","v":{"v":-1945000,"d":"(1,945,000)"}},{"$f":"-'Details for Budget 2021-2025'!B37","v":{"v":-2475000,"d":"(2,475,000)"}},{"$f":"-'Details for Budget 2021-2025'!B38","v":{"v":-1400000,"d":"(1,400,000)"}},{"$f":"-'Details for Budget 2021-2025'!B39","v":{"v":-1480000,"d":"(1,480,000)"}},{"$f":"-'Details for Budget 2021-2025'!B40","v":{"v":-1565000,"d":"(1,565,000)"}},{"$f":"-'Details for Budget 2021-2025'!B41","v":{"v":-1660000,"d":"(1,660,000)"}}]
["     Subtotal",null,null,{"$f":"SUM(D32:D34)","v":{"v":103959521,"d":"103,959,521"}},{"$f":"SUM(E32:E34)","v":{"v":102378039.1,"d":"102,378,039"}},{"$f":"SUM(F32:F34)","v":{"v":101933811.35,"d":"101,933,811"}},{"v":101476175.17,"d":"101,476,175"},{"v":101004770.21000001,"d":"101,004,770"},{"v":100514559.37,"d":"100,514,559"}]
["Add: - Accretion Bal at Year end",null,null,{"v":893518.0999999996,"d":"893,518"},{"v":955772.25,"d":"955,772"},{"v":1022363.8200000003,"d":"1,022,364"},{"v":1093595.040000001,"d":"1,093,595"},{"v":1169789.1600000001,"d":"1,169,789"},{"v":1251291.9499999993,"d":"1,251,291.95"}]
["Total bonds payable and accreted interest-Y/E",null,null,{"$f":"SUM(D35:D36)","v":{"v":104853039.1,"d":"104,853,039"}},{"$f":"SUM(E35:E36)","v":{"v":103333811.35,"d":"103,333,811"}},{"$f":"+F35+F36","v":{"v":102956175.16999999,"d":"102,956,175"}},{"$f":"SUM(G35:G36)","v":{"v":102569770.21000001,"d":"102,569,770"}},{"$f":"SUM(H35:H36)","v":{"v":102174559.37,"d":"102,174,559"}},{"$f":"SUM(I35:I36)","v":{"v":101765851.32000001,"d":"101,765,851"}}]

{"sheet":"Details for Budget 2021-2025","index":1,"n_rows":59,"n_cols":14,"rows_kept":59}
[]
["1) Drastically reduce interest due to COVID- back to pre rate upswing and lowered market value increase",{"$nulls":12},"Much of the OTASC budget is an estimated"]
["      will use 2017 interest as a basis ",null,null,{"v":60000,"d":"60,000.00"},{"$nulls":9},"No clear direction on MSA payments in the future or expense growth"]
[]
["2) 2021 Independent auditor determined that the number of Native American manufactured cigarates sold, decreased"]
["which resulted in a lower credit to the PMs, and therefore increased payments to NYS. "]
[]
[]
["3) Calc of Interest Expense - Payments - 2016 Debt - Minus Prmium and Deferred Inflow",{"$nulls":6},"ONLY FOR GOVERNMENTAL"]
[{"$nulls":7},"2016 A-1","2016A-2"]
[null,"Slow Pay Schedule",{"$nulls":6},"Premium &","Accreted ","Accrued ",null,"Net "]
[null,"2016 A-1","2016 A-1","2016 A-2B","2016 A-2B","Total",null,"Premium","Def Inflow","Interest","Interest Adj",null,"Interest"]
["2020 Interest",{"v":671765.625,"d":"671,765.63"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B13:E13)","v":{"v":2508928.125,"d":"2,508,928.13"}}]
[null,{"v":617062.5,"d":"617,062.50"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B14:E14)","v":{"v":2454225,"d":"2,454,225.00"}}]
[{"$nulls":5},{"$f":"SUM(F13:F14)","v":{"v":4963153.125,"d":"4,963,153.13"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},{"v":893518,"d":"893,518.00"},{"v":-9318,"d":"(9,318.00)"},null,{"$f":"+F15+H15+I15+J15+K15","v":{"v":4822633.85053451,"d":"4,822,633.85"}}]
["2021 Interest",{"v":617062.5,"d":"617,062.50"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B16:E16)","v":{"v":2454225,"d":"2,454,225.00"}}]
[null,{"v":603703.125,"d":"603,703.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B17:E17)","v":{"v":2440865.625,"d":"2,440,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F16:F17)","v":{"v":4895090.625,"d":"4,895,090.63"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},{"$f":"E50","v":{"v":955772.25,"d":"955,772.25"}},{"v":-9000,"d":"(9,000.00)"},null,{"$f":"+F18+H18+I18+J18+K18","v":{"v":4817143.60053451,"d":"4,817,143.60"}}]
["2022 Interest",{"v":603703.125,"d":"603,703.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B19:E19)","v":{"v":2440865.625,"d":"2,440,865.63"}}]
[null,{"v":564328.125,"d":"564,328.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B20:E20)","v":{"v":2401490.625,"d":"2,401,490.63"}}]
[{"$nulls":5},{"$f":"SUM(F19:F20)","v":{"v":4842356.25,"d":"4,842,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},{"$f":"E52","v":{"v":1022363.8200000003,"d":"1,022,363.82"}},{"v":-9000,"d":"(9,000.00)"},null,{"$f":"+F21+H21+I21+J21+K21","v":{"v":4831000.79553451,"d":"4,831,000.80"}}]
["2023 Interest",{"v":564328.125,"d":"564,328.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B22:E22)","v":{"v":2401490.625,"d":"2,401,490.63"}}]
[null,{"v":522703.125,"d":"522,703.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B23:E23)","v":{"v":2359865.625,"d":"2,359,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F22:F23)","v":{"v":4761356.25,"d":"4,761,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},{"$f":"E54","v":{"v":1093595.040000001,"d":"1,093,595.04"}},{"v":-9000,"d":"(9,000.00)"},null,{"$f":"+F24+H24+I24+J24+K24","v":{"v":4821232.015534511,"d":"4,821,232.02"}}]
["2024 Interest",{"v":522703.125,"d":"522,703.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B25:E25)","v":{"v":2359865.625,"d":"2,359,865.63"}}]
[null,{"v":478687.5,"d":"478,687.50"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B26:E26)","v":{"v":2315850,"d":"2,315,850.00"}}]
[{"$nulls":5},{"$f":"SUM(F25:F26)","v":{"v":4675715.625,"d":"4,675,715.63"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},{"$f":"E56","v":{"v":1169789.1600000001,"d":"1,169,789.16"}},{"v":-9000,"d":"(9,000.00)"},null,{"$f":"+F27+H27+I27+J27+K27","v":{"v":4811785.51053451,"d":"4,811,785.51"}}]
["2025 Interest",{"v":478687.5,"d":"478,687.50"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B28:E28)","v":{"v":2315850,"d":"2,315,850.00"}}]
[null,{"v":432000,"d":"432,000.00"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B29:E29)","v":{"v":2269162.5,"d":"2,269,162.50"}}]
[{"$nulls":5},{"$f":"SUM(F28:F29)","v":{"v":4585012.5,"d":"4,585,012.50"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.27,"d":"(758,670.27)"},{"$f":"E58","v":{"v":1251291.9499999993,"d":"1,251,291.95"}},{"v":-9000,"d":"(9,000.00)"},null,{"$f":"+F30+H30+I30+J30+K30","v":{"v":4802585.18,"d":"4,802,585.18"}}]
[]
[]
["Per BLX- Slow ay Schedule -2020 Audit"]
["5) Calc of Prin Payments",null,"Estimate"]
[null,"Slow Pay","MSA Payt"]
[2020,{"v":1945000,"d":"1,945,000"},{"v":6870532,"d":"6,870,532"}]
[2021,{"v":2475000,"d":"2,475,000"},{"v":7430102,"d":"7,430,102"},"*Note: Actual MSA Payment and Bond Payment"]
[2022,{"v":1400000,"d":"1,400,000"},{"v":6800000,"d":"6,800,000"}]
[2023,{"v":1480000,"d":"1,480,000"},{"v":6700000,"d":"6,700,000"}]
[2024,{"v":1565000,"d":"1,565,000"},{"v":6700000,"d":"6,700,000"}]
[2025,{"v":1660000,"d":"1,660,000"},{"v":6500000,"d":"6,500,000"}]
[]
["6) Admin costs- allowable for $2k increase each year"]
[]
["7) Assume increase in expenses by 2021-2025"]
["     Insurance - audit - legal fees etc"]
[]
["8) Accreted Interest- added to 2005 Bonds"]
[]
[" accreted interest",{"$nulls":3},{"v":955772.25,"d":"955,772"}]
["2021-12-31",{"v":14673731.67,"d":"14,673,732"},{"v":14673731.666653326,"d":"14,673,732"}]
[" accreted interest",{"$nulls":3},{"v":1022363.8200000003,"d":"1,022,364"}]
["2022-12-31",{"v":15696095.49,"d":"15,696,095"},{"v":15696095.490172295,"d":"15,696,095"}]
[" accreted interest",{"$nulls":3},{"v":1093595.040000001,"d":"1,093,595"}]
["2023-12-31",{"v":16789690.53,"d":"16,789,691"},{"v":16789690.53226504,"d":"16,789,691"}]
[" accreted interest",{"$nulls":3},{"v":1169789.1600000001,"d":"1,169,789"}]
["2024-12-31",{"v":17959479.69,"d":"17,959,480"},{"v":17959479.690075204,"d":"17,959,480"}]
[" accreted interest",{"$nulls":3},{"v":1251291.9499999993,"d":"1,251,292"}]
["2025-12-31",{"v":19210771.64,"d":"19,210,772"},{"v":19210771.640989296,"d":"19,210,772"}]