{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Budget by yr2020-2024 PARIS","Details for Budget 2020-2024","Budget by yr2019-2023 PARIS ","Details for Budget 2019-2023","Details for Budget"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget by yr2020-2024 PARIS","index":0,"n_rows":37,"n_cols":17,"rows_kept":37}
[{"$nulls":5},"Onondaga Tobacco Asset Securitization Corporation",{"$nulls":4},"As Per"]
["BUDGET-OTASC",null,"2020-2024",{"$nulls":7},"Debt Service"]
[{"$nulls":3},"Actual ","Budget","Actual ","Budget","Actual","Budget","Actual","Budget","Budget","Budget","Budget","Budget","Budget","Budget"]
[{"$nulls":3},2012,2013,2013,2014,2014,2015,2015,2017,2018,2020,2021,2022,2023,2024]
["OPERATING REVENUES:"]
[null,"Tobacco settlement proceeds",null,{"v":6821381,"d":"6,821,381"},{"v":6555000,"d":"6,555,000"},{"v":6817145,"d":"6,817,145"},{"v":7700000,"d":"7,700,000"},{"v":7712439,"d":"7,712,439"},{"v":6750000,"d":"6,750,000"},{"v":6600031,"d":"6,600,031"},{"v":6506000,"d":"6,506,000"},{"v":6320988,"d":"6,320,988"},{"v":6100000,"d":"6,100,000"},{"v":6700000,"d":"6,700,000"},{"v":6600000,"d":"6,600,000"},{"v":6500000,"d":"6,500,000"},{"v":6500000,"d":"6,500,000"}]
[null,"Interest income",null,{"v":482808,"d":"482,808"},{"v":460000,"d":"460,000"},{"v":465825,"d":"465,825"},{"$f":"+E7","v":{"v":460000,"d":"460,000"}},{"v":463458,"d":"463,458"},{"$f":"G7","v":{"v":460000,"d":"460,000"}},{"v":451578,"d":"451,578"},{"v":36000,"d":"36,000"},{"v":70000,"d":"70,000"},{"v":60000,"d":"60,000"},{"v":60000,"d":"60,000"},{"v":80000,"d":"80,000"},{"v":90000,"d":"90,000"},{"v":90000,"d":"90,000"}]
[null,null,"Total operating revenues",{"$f":"SUM(D6:D7)","v":{"v":7304189,"d":"7,304,189"}},{"$f":"SUM(E6:E7)","v":{"v":7015000,"d":"7,015,000"}},{"$f":"SUM(F6:F7)","v":{"v":7282970,"d":"7,282,970"}},{"v":8160000,"d":"8,160,000"},{"v":8175897,"d":"8,175,897"},{"v":7210000,"d":"7,210,000"},{"$f":"SUM(J6:J7)","v":{"v":7051609,"d":"7,051,609"}},{"v":6542000,"d":"6,542,000"},{"v":6390988,"d":"6,390,988"},{"v":6160000,"d":"6,160,000"},{"v":6760000,"d":"6,760,000"},{"v":6680000,"d":"6,680,000"},{"v":6590000,"d":"6,590,000"},{"$f":"SUM(Q6:Q7)","v":{"v":6590000,"d":"6,590,000"}}]
[]
["OPERATING EXPENSES:"]
[null,"Insurance expense",null,{"v":4294,"d":"4,294"},{"v":5500,"d":"5,500"},{"v":4243,"d":"4,243"},{"v":5000,"d":"5,000"},{"v":4029,"d":"4,029"},{"v":5000,"d":"5,000"},{"v":4035,"d":"4,035"},{"v":5000,"d":"5,000"},{"v":5100,"d":"5,100"},{"v":5200,"d":"5,200"},{"v":5200,"d":"5,200"},{"v":5300,"d":"5,300"},{"v":5300,"d":"5,300"},{"v":5400,"d":"5,400"}]
[null,"Audit fee",null,{"v":8000,"d":"8,000"},{"v":6000,"d":"6,000"},{"v":5500,"d":"5,500"},{"v":6500,"d":"6,500"},{"v":6500,"d":"6,500"},{"v":7000,"d":"7,000"},{"v":6500,"d":"6,500"},{"v":12000,"d":"12,000"},{"v":6600,"d":"6,600"},{"v":6700,"d":"6,700"},{"v":6700,"d":"6,700"},{"v":6800,"d":"6,800"},{"v":6800,"d":"6,800"},{"v":6800,"d":"6,800"}]
[null,"Legal fees",null,{"v":3500,"d":"3,500"},{"v":4500,"d":"4,500"},{"v":3500,"d":"3,500"},{"v":4000,"d":"4,000"},{"v":3500,"d":"3,500"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4100,"d":"4,100"},{"v":4100,"d":"4,100"},{"v":4200,"d":"4,200"},{"v":4200,"d":"4,200"},{"v":4200,"d":"4,200"}]
[null,"Trustee fee",null,{"v":7557,"d":"7,557"},{"v":8000,"d":"8,000"},{"v":7557,"d":"7,557"},{"v":8000,"d":"8,000"},{"v":4807,"d":"4,807"},{"v":8000,"d":"8,000"},{"v":10307,"d":"10,307"},{"v":8000,"d":"8,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6500,"d":"6,500"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"}]
[null,"Administrative agency fee",null,{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":35500,"d":"35,500"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30500,"d":"30,500"},{"v":30600,"d":"30,600"},{"v":30600,"d":"30,600"},{"v":30600,"d":"30,600"}]
[null,"Rating agency fee",null,{"v":6238,"d":"6,238"},{"v":13250,"d":"13,250"},{"v":10175,"d":"10,175"},{"v":12000,"d":"12,000"},{"v":10175,"d":"10,175"},{"v":12000,"d":"12,000"},{"v":11326,"d":"11,326"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7100,"d":"7,100"},{"v":7200,"d":"7,200"},{"v":7200,"d":"7,200"},{"v":7200,"d":"7,200"}]
[null,"General and administrative costs",null,{"v":41984,"d":"41,984"},{"v":48750,"d":"48,750"},{"v":48549,"d":"48,549"},{"v":55000,"d":"55,000"},{"v":56547,"d":"56,547"},{"$f":"+G17+2000","v":{"v":57000,"d":"57,000"}},{"v":57000,"d":"57,000"},{"v":61000,"d":"61,000"},{"v":63000,"d":"63,000"},{"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"}]
[null,"OTASC - Bond Payment",null,{"v":5212594,"d":"5,212,594"},{"v":5131825,"d":"5,131,825"},{"v":5102294,"d":"5,102,294"},{"v":5016700,"d":"5,016,700"},{"v":4961838,"d":"4,961,838"},{"v":4954806,"d":"4,954,806"},{"v":4820406,"d":"4,820,406"},{"v":420000,"d":"420,000"},{"v":1080000,"d":"1,080,000"},{"v":1100000,"d":"1,100,000"},{"v":1320000,"d":"1,320,000"},{"v":1400000,"d":"1,400,000"},{"v":1480000,"d":"1,480,000"},{"v":1565000,"d":"1,565,000"}]
[null,"Interest - Cash (Slow Pay)",null,{"$f":"SUM(D11:D18)","v":{"v":5314105,"d":"5,314,105"}},{"$f":"SUM(E11:E18)","v":{"v":5247825,"d":"5,247,825"}},{"$f":"SUM(F11:F18)","v":{"v":5211756,"d":"5,211,756"}},{"$f":"SUM(G11:G18)","v":{"v":5137200,"d":"5,137,200"}},{"v":8278381,"d":"8,278,381"},{"$f":"SUM(I11:I18)","v":{"v":5077806,"d":"5,077,806"}},{"$f":"SUM(J11:J18)","v":{"v":4943512,"d":"4,943,512"}},{"v":5536170.833333334,"d":"5,536,171"},{"v":5110318,"d":"5,110,318"},{"v":3962199.4755345094,"d":"3,962,199"},{"v":3894136.9755345094,"d":"3,894,137"},{"v":3817636.9755345094,"d":"3,817,637"},{"v":3736636.9755345094,"d":"3,736,637"},{"v":3650996.3505345094,"d":"3,650,996"}]
[]
[]
[null,null,"Total operating expenses",{"$f":"D8-D19","v":{"v":1990084,"d":"1,990,084"}},{"$f":"E8-E19","v":{"v":1767175,"d":"1,767,175"}},{"$f":"F8-F19","v":{"v":2071214,"d":"2,071,214"}},{"$f":"G8-G19","v":{"v":3022800,"d":"3,022,800"}},{"v":-102484,"d":"(102,484)"},{"$f":"I8-I19","v":{"v":2132194,"d":"2,132,194"}},{"$f":"+J8-J19","v":{"v":2108097,"d":"2,108,097"}},{"$f":"SUM(K11:K20)","v":{"v":6088670.833333334,"d":"6,088,671"}},{"$f":"SUM(L11:L20)","v":{"v":6312018,"d":"6,312,018"}},{"$f":"SUM(M11:M20)","v":{"v":5188199.47553451,"d":"5,188,199"}},{"$f":"SUM(N11:N20)","v":{"v":5343236.97553451,"d":"5,343,237"}},{"$f":"SUM(O11:O19)","v":{"v":5349336.97553451,"d":"5,349,337"}},{"$f":"SUM(P11:P19)","v":{"v":5350336.97553451,"d":"5,350,337"}},{"$f":"SUM(Q11:Q19)","v":{"v":5351796.35053451,"d":"5,351,796"}}]
[]
["INCREASE (DECREASE)IN NET DEFICIT",{"$nulls":9},{"$f":"+K8-K22","v":{"v":453329.16666666605,"d":"453,329"}},{"v":78970,"d":"78,970"},{"v":971800.5244654901,"d":"971,801"},{"v":1416763.0244654901,"d":"1,416,763"},{"v":1330663.0244654901,"d":"1,330,663"},{"$f":"+P8-P22","v":{"v":1239663.0244654901,"d":"1,239,663"}},{"$f":"+Q8-Q22","v":{"v":1238203.6494654901,"d":"1,238,204"}}]
["FUND BALANCE/NET DEFICIT -"]
["  BEGINNING OF YEAR",null,null,{"v":-123881006,"d":"(123,881,006)"},{"$f":"+D27","v":{"$error":"#REF!"}},{"$f":"+D27","v":{"$error":"#REF!"}},{"$f":"+F27","v":{"$error":"#REF!"}},{"$f":"+F27","v":{"$error":"#REF!"}},{"$f":"G27","v":{"$error":"#REF!"}},{"v":-127909510,"d":"(127,909,510)"},{"v":6633174,"d":"6,633,174"},{"v":6554074,"d":"6,554,074"},{"v":6619706,"d":"6,619,706"},{"$f":"+M27","v":{"v":7591506.52446549,"d":"7,591,507"}},{"$f":"+N27","v":{"v":9008269.54893098,"d":"9,008,270"}},{"$f":"+O27","v":{"v":10338932.57339647,"d":"10,338,933"}},{"$f":"+P27","v":{"v":11578595.59786196,"d":"11,578,596"}}]
["FUND BALANCE/NET DEFICIT -",null,null,{"$f":"D26+D22+#REF!","v":{"$error":"#REF!"}},{"$f":"E26+E22","v":{"$error":"#REF!"}},{"$f":"+F26+F22","v":{"$error":"#REF!"}},{"$f":"G26+G22","v":{"$error":"#REF!"}},{"$f":"+H22+H26","v":{"$error":"#REF!"}},{"$f":"I26+I22","v":{"$error":"#REF!"}},{"$f":"+J22+J26","v":{"v":-125801413,"d":"(125,801,413)"}},{"$f":"+K24+K26","v":{"v":7086503.166666666,"d":"7,086,503"}},{"v":6633044,"d":"6,633,044"},{"v":7591506.52446549,"d":"7,591,507"},{"v":9008269.54893098,"d":"9,008,270"},{"v":10338932.57339647,"d":"10,338,933"},{"$f":"SUM(P24:P26)","v":{"v":11578595.59786196,"d":"11,578,596"}},{"$f":"+Q24+Q26","v":{"v":12816799.24732745,"d":"12,816,799"}}]
["  END OF YEAR"]
[{"$nulls":5},{"$f":"+F18+#REF!+F34","v":{"$error":"#REF!"}}]
[]
[]
["Bonds payable 2005 - Bal Beginning of year",null,null,{"v":93100000,"d":"93,100,000"},{"v":91140000,"d":"91,140,000"},{"$f":"+E32","v":{"v":91140000,"d":"91,140,000"}},{"$f":"+F32+F34","v":{"v":89070000,"d":"89,070,000"}},{"$f":"+G32+G34","v":{"v":88065000,"d":"88,065,000"}},{"v":85975000,"d":"85,975,000"},{"v":85975000,"d":"85,975,000"},{"v":10478166,"d":"10,478,166"},{"$f":"4963972+6244320","v":{"v":11208292,"d":"11,208,292"}},{"$f":"4963972+7860549","v":{"v":12824521,"d":"12,824,521"}},{"$f":"+M32+M36","v":{"v":13718039.1,"d":"13,718,039"}},{"$f":"+N32+N36","v":{"v":14673811.35,"d":"14,673,811"}},{"$f":"+O32+O36","v":{"v":15696175.17,"d":"15,696,175"}},{"$f":"+P32+P36","v":{"v":16789770.21,"d":"16,789,770"}}]
["Bonds payable 2016 - Bal Beginning of year",null,null,{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":95590000,"d":"95,590,000"},{"$f":"+K33-325000","v":{"v":95265000,"d":"95,265,000"}},{"v":93080000,"d":"93,080,000"},{"$f":"+M33+M34","v":{"v":91980000,"d":"91,980,000"}},{"$f":"+N33+N34","v":{"v":90660000,"d":"90,660,000"}},{"$f":"+O33+O34","v":{"v":89260000,"d":"89,260,000"}},{"$f":"+P33+P34","v":{"v":87780000,"d":"87,780,000"}}]
["Assumed Bond Payment - Prin -Slow Pay-",null,null,{"v":-1960000,"d":"(1,960,000.00)"},-945000,{"v":-2070000,"d":"(2,070,000.00)"},{"$f":"-'[1]Debt Service'!C4","v":-1005000},-3095000,{"$f":"-'[1]Debt Service'!C5","v":-1100000},-2040000,325000,-1080000,{"$f":"-M18","v":{"v":-1100000,"d":"(1,100,000)"}},{"$f":"-N18","v":{"v":-1320000,"d":"(1,320,000)"}},{"$f":"-O18","v":{"v":-1400000,"d":"(1,400,000)"}},{"$f":"-P18","v":{"v":-1480000,"d":"(1,480,000)"}},{"$f":"-Q18","v":{"v":-1565000,"d":"(1,565,000)"}}]
["     Subtotal",null,null,{"$f":"SUM(D32:D34)","v":{"v":119665438,"d":"119,665,438"}},{"v":118720438,"d":"118,720,438"},{"v":117595438,"d":"117,595,438"},{"v":116590438,"d":"116,590,438"},{"$f":"SUM(H32:H34)","v":{"v":113495438,"d":"113,495,438"}},{"v":113400438,"d":"113,400,438"},{"$f":"SUM(J32:J34)","v":{"v":112460438,"d":"112,460,438"}},{"v":106393166,"d":"106,393,166"},{"v":105393292,"d":"105,393,292"},{"$f":"SUM(M32:M34)","v":{"v":104804521,"d":"104,804,521"}},{"$f":"SUM(N32:N34)","v":{"v":104378039.1,"d":"104,378,039"}},{"$f":"SUM(O32:O34)","v":{"v":103933811.35,"d":"103,933,811"}},{"$f":"SUM(P32:P34)","v":{"v":103476175.17,"d":"103,476,175"}},{"$f":"SUM(Q32:Q34)","v":{"v":103004770.21000001,"d":"103,004,770"}}]
["Add: - Accretion Bal at Year end",null,null,{"v":16390707,"d":"16,390,707"},{"v":19367566,"d":"19,367,566"},{"v":19367566,"d":"19,367,566"},{"v":22536506,"d":"22,536,506"},{"v":22536506,"d":"22,536,506"},{"v":25919799,"d":"25,919,799"},{"v":25919719,"d":"25,919,719"},{"v":730045.9199999999,"d":"730,046"},{"v":780910.4499999993,"d":"780,910"},{"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"}]
["Total bonds payable and accreted interest-Y/E",null,null,{"$f":"D36+D35","v":{"v":136056145,"d":"136,056,145"}},{"v":138088004,"d":"138,088,004"},{"v":136963004,"d":"136,963,004"},{"v":139126944,"d":"139,126,944"},{"$f":"SUM(H35:H36)","v":{"v":136031944,"d":"136,031,944"}},{"v":139320237,"d":"139,320,237"},{"$f":"SUM(J35:J36)","v":{"v":138380157,"d":"138,380,157"}},{"v":107123211.92,"d":"107,123,212"},{"v":106174202.45,"d":"106,174,202"},{"$f":"SUM(M35:M36)","v":{"v":105698039.1,"d":"105,698,039"}},{"$f":"SUM(N35:N36)","v":{"v":105333811.35,"d":"105,333,811"}},{"$f":"+O35+O36","v":{"v":104956175.16999999,"d":"104,956,175"}},{"$f":"SUM(P35:P36)","v":{"v":104569770.21000001,"d":"104,569,770"}},{"$f":"SUM(Q35:Q36)","v":{"v":104174559.37,"d":"104,174,559"}}]

{"sheet":"Details for Budget 2020-2024","index":1,"n_rows":63,"n_cols":12,"rows_kept":63}
[]
["1) Drastically reduce interest due to COVID- back to pre rate upswing and lowered market value increase",{"$nulls":10},"Much of the OTASC budget is an educated guess"]
["      will use 2017 interest as a basis ",null,null,{"v":60000,"d":"60,000.00"},{"$nulls":7},"No clear direction on MSA payments in the future or expense growth"]
[]
["2) Calc of 2nd credit to PMs - good through 2019 - our"]
["    MSA payment should go up then:"]
[]
["Payment in 2019 increased due to credits that will no longer apply to Participating manufacturers"]
{"$rows_empty":8}
["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 &",null,"Net "]
[null,"2016 A-1","2016 A-1","2016 A-2B","2016 A-2B","Total",null,"Premium","Def Inflow",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(B21:E21)","v":{"v":2508928.125,"d":"2,508,928.13"}}]
[null,{"v":640828.125,"d":"640,828.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":2477990.625,"d":"2,477,990.63"}}]
[{"$nulls":5},{"$f":"SUM(F21:F22)","v":{"v":4986918.75,"d":"4,986,918.75"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F23+H23+I23","v":{"v":3962199.4755345094,"d":"3,962,199.48"}}]
["2021 Interest",{"v":640828.125,"d":"640,828.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B24:E24)","v":{"v":2477990.625,"d":"2,477,990.63"}}]
[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(B25:E25)","v":{"v":2440865.625,"d":"2,440,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F24:F25)","v":{"v":4918856.25,"d":"4,918,856.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F26+H26+I26","v":{"v":3894136.9755345094,"d":"3,894,136.98"}}]
["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(B27:E27)","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(B28:E28)","v":{"v":2401490.625,"d":"2,401,490.63"}}]
[{"$nulls":5},{"$f":"SUM(F27:F28)","v":{"v":4842356.25,"d":"4,842,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F29+H29+I29","v":{"v":3817636.9755345094,"d":"3,817,636.98"}}]
["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(B30:E30)","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(B31:E31)","v":{"v":2359865.625,"d":"2,359,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F30:F31)","v":{"v":4761356.25,"d":"4,761,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F32+H32+I32","v":{"v":3736636.9755345094,"d":"3,736,636.98"}}]
["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(B33:E33)","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(B34:E34)","v":{"v":2315850,"d":"2,315,850.00"}}]
[{"$nulls":5},{"$f":"SUM(F33:F34)","v":{"v":4675715.625,"d":"4,675,715.63"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F35+H35+I35","v":{"v":3650996.3505345094,"d":"3,650,996.35"}}]
[]
[]
["Per BLX- Slow ay Schedule -2019 Audit"]
["5) Calc of Prin Payments",null,"Estimate"]
[null,"Slow Pay","MSA Payt"]
[2020,{"v":1100000,"d":"1,100,000"},{"v":6100000,"d":"6,100,000"},"Actual 2020 payment just released -6,868,000- no further credits on participating manufacturers"]
[2021,{"v":1320000,"d":"1,320,000"},{"v":6700000,"d":"6,700,000"}]
[2022,{"v":1400000,"d":"1,400,000"},{"v":6600000,"d":"6,600,000"}]
[2023,{"v":1480000,"d":"1,480,000"},{"v":6500000,"d":"6,500,000"}]
[2024,{"v":1565000,"d":"1,565,000"},{"v":6500000,"d":"6,500,000"}]
[]
["6) Admin costs- allowable for $2k increase each year"]
[]
[]
["7) Assume increase in expenses by 2020-2024"]
["     Insurance - audit - legal fees etc"]
[]
["8) Accreted Interest- added to 2005 Bonds"]
[" accreted interest",{"$nulls":3},{"v":893518.0999999996,"d":"893,518"}]
["2020-12-31",{"v":13717959.42,"d":"13,717,959"},{"v":13717959.422441121,"d":"13,717,959"}]
[" 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"}]

{"sheet":"Budget by yr2019-2023 PARIS ","index":2,"n_rows":37,"n_cols":17,"rows_kept":37}
[{"$nulls":5},"Onondaga Tobacco Asset Securitization Corporation",{"$nulls":4},"As Per"]
["BUDGET-OTASC",null,"2019-2023",{"$nulls":7},"Debt Service"]
[{"$nulls":3},"Actual ","Budget","Actual ","Budget","Actual","Budget","Actual","Budget","Budget","Budget","Budget","Budget","Budget","Budget"]
[{"$nulls":3},2012,2013,2013,2014,2014,2015,2015,2017,2018,2019,2020,2021,2022,2023]
["OPERATING REVENUES:"]
[null,"Tobacco settlement proceeds",null,{"v":6821381,"d":"6,821,381"},{"v":6555000,"d":"6,555,000"},{"v":6817145,"d":"6,817,145"},{"v":7700000,"d":"7,700,000"},{"v":7712439,"d":"7,712,439"},{"v":6750000,"d":"6,750,000"},{"v":6600031,"d":"6,600,031"},{"v":6506000,"d":"6,506,000"},{"v":6320988,"d":"6,320,988"},{"v":6350000,"d":"6,350,000"},{"v":6100000,"d":"6,100,000"},{"v":6000000,"d":"6,000,000"},{"v":6000000,"d":"6,000,000"},{"v":5900000,"d":"5,900,000"}]
[null,"Interest income",null,{"v":482808,"d":"482,808"},{"v":460000,"d":"460,000"},{"v":465825,"d":"465,825"},{"$f":"+E7","v":{"v":460000,"d":"460,000"}},{"v":463458,"d":"463,458"},{"$f":"G7","v":{"v":460000,"d":"460,000"}},{"v":451578,"d":"451,578"},{"v":36000,"d":"36,000"},{"v":70000,"d":"70,000"},{"$f":"L7","v":{"v":70000,"d":"70,000"}},{"v":100000,"d":"100,000"},{"v":90000,"d":"90,000"},{"v":80000,"d":"80,000"},{"v":90000,"d":"90,000"}]
[null,null,"Total operating revenues",{"$f":"SUM(D6:D7)","v":{"v":7304189,"d":"7,304,189"}},{"$f":"SUM(E6:E7)","v":{"v":7015000,"d":"7,015,000"}},{"$f":"SUM(F6:F7)","v":{"v":7282970,"d":"7,282,970"}},{"v":8160000,"d":"8,160,000"},{"v":8175897,"d":"8,175,897"},{"v":7210000,"d":"7,210,000"},{"$f":"SUM(J6:J7)","v":{"v":7051609,"d":"7,051,609"}},{"v":6542000,"d":"6,542,000"},{"$f":"SUM(L6:L7)","v":{"v":6390988,"d":"6,390,988"}},{"v":6420000,"d":"6,420,000"},{"v":6200000,"d":"6,200,000"},{"v":6090000,"d":"6,090,000"},{"v":6080000,"d":"6,080,000"},{"v":5990000,"d":"5,990,000"}]
[]
["OPERATING EXPENSES:"]
[null,"Insurance expense",null,{"v":4294,"d":"4,294"},{"v":5500,"d":"5,500"},{"v":4243,"d":"4,243"},{"v":5000,"d":"5,000"},{"v":4029,"d":"4,029"},{"v":5000,"d":"5,000"},{"v":4035,"d":"4,035"},{"v":5000,"d":"5,000"},{"v":5100,"d":"5,100"},{"v":5100,"d":"5,100"},{"v":5200,"d":"5,200"},{"v":5200,"d":"5,200"},{"v":5300,"d":"5,300"},{"v":5300,"d":"5,300"}]
[null,"Audit fee",null,{"v":8000,"d":"8,000"},{"v":6000,"d":"6,000"},{"v":5500,"d":"5,500"},{"v":6500,"d":"6,500"},{"v":6500,"d":"6,500"},{"v":7000,"d":"7,000"},{"v":6500,"d":"6,500"},{"v":12000,"d":"12,000"},{"v":6600,"d":"6,600"},{"v":6600,"d":"6,600"},{"v":6700,"d":"6,700"},{"v":6700,"d":"6,700"},{"v":6700,"d":"6,700"},{"v":6700,"d":"6,700"}]
[null,"Legal fees",null,{"v":3500,"d":"3,500"},{"v":4500,"d":"4,500"},{"v":3500,"d":"3,500"},{"v":4000,"d":"4,000"},{"v":3500,"d":"3,500"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4100,"d":"4,100"},{"v":4100,"d":"4,100"},{"v":4100,"d":"4,100"},{"v":4100,"d":"4,100"}]
[null,"Trustee fee",null,{"v":7557,"d":"7,557"},{"v":8000,"d":"8,000"},{"v":7557,"d":"7,557"},{"v":8000,"d":"8,000"},{"v":4807,"d":"4,807"},{"v":8000,"d":"8,000"},{"v":10307,"d":"10,307"},{"v":8000,"d":"8,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6000,"d":"6,000"},{"v":6500,"d":"6,500"},{"v":6500,"d":"6,500"},{"v":6500,"d":"6,500"}]
[null,"Administrative agency fee",null,{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":30000,"d":"30,000"},{"v":29938,"d":"29,938"},{"v":35500,"d":"35,500"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30500,"d":"30,500"},{"v":30500,"d":"30,500"},{"v":30500,"d":"30,500"}]
[null,"Rating agency fee",null,{"v":6238,"d":"6,238"},{"v":13250,"d":"13,250"},{"v":10175,"d":"10,175"},{"v":12000,"d":"12,000"},{"v":10175,"d":"10,175"},{"v":12000,"d":"12,000"},{"v":11326,"d":"11,326"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7100,"d":"7,100"},{"v":7100,"d":"7,100"},{"v":7100,"d":"7,100"}]
[null,"General and administrative costs",null,{"v":41984,"d":"41,984"},{"v":48750,"d":"48,750"},{"v":48549,"d":"48,549"},{"v":55000,"d":"55,000"},{"v":56547,"d":"56,547"},{"$f":"+G17+2000","v":{"v":57000,"d":"57,000"}},{"v":57000,"d":"57,000"},{"v":61000,"d":"61,000"},{"v":63000,"d":"63,000"},{"v":65000,"d":"65,000"},{"v":67000,"d":"67,000"},{"v":69000,"d":"69,000"},{"v":71000,"d":"71,000"},{"v":73000,"d":"73,000"}]
[null,"OTASC - Bond Payment",null,{"v":5212594,"d":"5,212,594"},{"v":5131825,"d":"5,131,825"},{"v":5102294,"d":"5,102,294"},{"v":5016700,"d":"5,016,700"},{"v":4961838,"d":"4,961,838"},{"v":4954806,"d":"4,954,806"},{"v":4820406,"d":"4,820,406"},{"v":420000,"d":"420,000"},{"v":1080000,"d":"1,080,000"},{"v":960000,"d":"960,000"},{"v":1245000,"d":"1,245,000"},{"v":1320000,"d":"1,320,000"},{"v":1400000,"d":"1,400,000"},{"v":1480000,"d":"1,480,000"}]
[null,"Interest - Cash (Slow Pay)",null,{"$f":"SUM(D11:D18)","v":{"v":5314105,"d":"5,314,105"}},{"$f":"SUM(E11:E18)","v":{"v":5247825,"d":"5,247,825"}},{"$f":"SUM(F11:F18)","v":{"v":5211756,"d":"5,211,756"}},{"$f":"SUM(G11:G18)","v":{"v":5137200,"d":"5,137,200"}},{"v":8278381,"d":"8,278,381"},{"$f":"SUM(I11:I18)","v":{"v":5077806,"d":"5,077,806"}},{"$f":"SUM(J11:J18)","v":{"v":4943512,"d":"4,943,512"}},{"v":5536170.833333334,"d":"5,536,171"},{"v":5110318,"d":"5,110,318"},{"v":5053012.5,"d":"5,053,013"},{"v":4990996.875,"d":"4,990,997"},{"v":4918856.25,"d":"4,918,856"},{"v":4842356,"d":"4,842,356"},{"$f":"+'Details for Budget 2019-2023'!F35","v":{"v":4761356.25,"d":"4,761,356"}}]
[]
[]
[null,null,"Total operating expenses",{"$f":"D8-D19","v":{"v":1990084,"d":"1,990,084"}},{"$f":"E8-E19","v":{"v":1767175,"d":"1,767,175"}},{"$f":"F8-F19","v":{"v":2071214,"d":"2,071,214"}},{"$f":"G8-G19","v":{"v":3022800,"d":"3,022,800"}},{"v":-102484,"d":"(102,484)"},{"$f":"I8-I19","v":{"v":2132194,"d":"2,132,194"}},{"$f":"+J8-J19","v":{"v":2108097,"d":"2,108,097"}},{"$f":"SUM(K11:K20)","v":{"v":6088670.833333334,"d":"6,088,671"}},{"$f":"SUM(L11:L20)","v":{"v":6312018,"d":"6,312,018"}},{"$f":"SUM(M11:M20)","v":{"v":6136712.5,"d":"6,136,713"}},{"$f":"SUM(N11:N20)","v":{"v":6361996.875,"d":"6,361,997"}},{"$f":"SUM(O11:O20)","v":{"v":6367956.25,"d":"6,367,956"}},{"$f":"SUM(P11:P19)","v":{"v":6373556,"d":"6,373,556"}},{"$f":"SUM(Q11:Q19)","v":{"v":6374556.25,"d":"6,374,556"}}]
[]
["INCREASE (DECREASE)IN NET DEFICIT",{"$nulls":9},{"$f":"+K8-K22","v":{"v":453329.16666666605,"d":"453,329"}},{"v":78970,"d":"78,970"},{"v":283287.5,"d":"283,288"},{"v":-161996.875,"d":"(161,997)"},{"v":-277956.25,"d":"(277,956)"},{"v":-293556,"d":"(293,556)"},{"$f":"+Q8-Q22","v":{"v":-384556.25,"d":"(384,556)"}}]
["FUND BALANCE/NET DEFICIT -"]
["  BEGINNING OF YEAR",null,null,{"v":-123881006,"d":"(123,881,006)"},{"$f":"+D27","v":{"$error":"#REF!"}},{"$f":"+D27","v":{"$error":"#REF!"}},{"$f":"+F27","v":{"$error":"#REF!"}},{"$f":"+F27","v":{"$error":"#REF!"}},{"$f":"G27","v":{"$error":"#REF!"}},{"v":-127909510,"d":"(127,909,510)"},{"v":6633174,"d":"6,633,174"},{"v":6554074,"d":"6,554,074"},{"$f":"L27","v":{"v":6633044,"d":"6,633,044"}},{"$f":"+M27","v":{"v":6916331.5,"d":"6,916,332"}},{"$f":"+N27","v":{"v":6754334.625,"d":"6,754,335"}},{"$f":"+O27","v":{"v":6476378.375,"d":"6,476,378"}},{"$f":"+P27","v":{"v":6182822.375,"d":"6,182,822"}}]
["FUND BALANCE/NET DEFICIT -",null,null,{"$f":"D26+D22+#REF!","v":{"$error":"#REF!"}},{"$f":"E26+E22","v":{"$error":"#REF!"}},{"$f":"+F26+F22","v":{"$error":"#REF!"}},{"$f":"G26+G22","v":{"$error":"#REF!"}},{"$f":"+H22+H26","v":{"$error":"#REF!"}},{"$f":"I26+I22","v":{"$error":"#REF!"}},{"$f":"+J22+J26","v":{"v":-125801413,"d":"(125,801,413)"}},{"$f":"+K24+K26","v":{"v":7086503.166666666,"d":"7,086,503"}},{"v":6633044,"d":"6,633,044"},{"v":6916331.5,"d":"6,916,332"},{"v":6754334.625,"d":"6,754,335"},{"v":6476378.375,"d":"6,476,378"},{"v":6182822.375,"d":"6,182,822"},{"$f":"SUM(Q24:Q26)","v":{"v":5798266.125,"d":"5,798,266"}}]
["  END OF YEAR"]
[{"$nulls":5},{"$f":"+F18+#REF!+F34","v":{"$error":"#REF!"}}]
[]
[]
["Bonds payable 2005 - Bal Beginning of year",null,null,{"v":93100000,"d":"93,100,000"},{"v":91140000,"d":"91,140,000"},{"$f":"+E32","v":{"v":91140000,"d":"91,140,000"}},{"$f":"+F32+F34","v":{"v":89070000,"d":"89,070,000"}},{"$f":"+G32+G34","v":{"v":88065000,"d":"88,065,000"}},{"v":85975000,"d":"85,975,000"},{"v":85975000,"d":"85,975,000"},{"v":10478166,"d":"10,478,166"},{"$f":"4963972+6244320","v":{"v":11208292,"d":"11,208,292"}},{"$f":"+L32+L36","v":{"v":11989202.45,"d":"11,989,202"}},{"$f":"+M32+M36","v":{"v":12824521.33,"d":"12,824,521"}},{"$f":"+N32+N36","v":{"v":13718039.43,"d":"13,718,039"}},{"$f":"+O32+O36","v":{"v":14673811.68,"d":"14,673,812"}},{"$f":"+P32+P36","v":{"v":15696175.5,"d":"15,696,176"}}]
["Bonds payable 2016 - Bal Beginning of year",null,null,{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":28525438,"d":"28,525,438"},{"v":95590000,"d":"95,590,000"},{"$f":"+K33-325000","v":{"v":95265000,"d":"95,265,000"}},{"$f":"+L33+L34","v":{"v":94185000,"d":"94,185,000"}},{"$f":"+M33+M34","v":{"v":93225000,"d":"93,225,000"}},{"$f":"+N33+N34","v":{"v":91980000,"d":"91,980,000"}},{"$f":"+O33+O34","v":{"v":90660000,"d":"90,660,000"}},{"$f":"+P33+P34","v":{"v":89260000,"d":"89,260,000"}}]
["Assumed Bond Payment - Prin -Slow Pay-",null,null,{"v":-1960000,"d":"(1,960,000.00)"},-945000,{"v":-2070000,"d":"(2,070,000.00)"},{"$f":"-'[1]Debt Service'!C4","v":-1005000},-3095000,{"$f":"-'[1]Debt Service'!C5","v":-1100000},-2040000,325000,-1080000,{"$f":"-M18","v":{"v":-960000,"d":"(960,000)"}},{"$f":"-N18","v":{"v":-1245000,"d":"(1,245,000)"}},{"$f":"-O18","v":{"v":-1320000,"d":"(1,320,000)"}},{"$f":"-P18","v":{"v":-1400000,"d":"(1,400,000)"}},{"$f":"-Q18","v":{"v":-1480000,"d":"(1,480,000)"}}]
["     Subtotal",null,null,{"$f":"SUM(D32:D34)","v":{"v":119665438,"d":"119,665,438"}},{"v":118720438,"d":"118,720,438"},{"v":117595438,"d":"117,595,438"},{"v":116590438,"d":"116,590,438"},{"$f":"SUM(H32:H34)","v":{"v":113495438,"d":"113,495,438"}},{"v":113400438,"d":"113,400,438"},{"$f":"SUM(J32:J34)","v":{"v":112460438,"d":"112,460,438"}},{"v":106393166,"d":"106,393,166"},{"v":105393292,"d":"105,393,292"},{"v":105214202.45,"d":"105,214,202"},{"$f":"SUM(N32:N34)","v":{"v":104804521.33,"d":"104,804,521"}},{"$f":"SUM(O32:O34)","v":{"v":104378039.43,"d":"104,378,039"}},{"$f":"SUM(P32:P34)","v":{"v":103933811.68,"d":"103,933,812"}},{"$f":"SUM(Q32:Q34)","v":{"v":103476175.5,"d":"103,476,176"}}]
["Add: - Accretion Bal at Year end",null,null,{"v":16390707,"d":"16,390,707"},{"v":19367566,"d":"19,367,566"},{"v":19367566,"d":"19,367,566"},{"v":22536506,"d":"22,536,506"},{"v":22536506,"d":"22,536,506"},{"v":25919799,"d":"25,919,799"},{"v":25919719,"d":"25,919,719"},{"v":730045.9199999999,"d":"730,046"},{"v":780910.4499999993,"d":"780,910"},{"v":835318.8800000008,"d":"835,319"},{"v":893518.0999999996,"d":"893,518"},{"v":955772.25,"d":"955,772"},{"v":1022363.8200000003,"d":"1,022,364"},{"v":1093595,"d":"1,093,595"}]
["Total bonds payable and accreted interest-Y/E",null,null,{"$f":"D36+D35","v":{"v":136056145,"d":"136,056,145"}},{"v":138088004,"d":"138,088,004"},{"v":136963004,"d":"136,963,004"},{"v":139126944,"d":"139,126,944"},{"$f":"SUM(H35:H36)","v":{"v":136031944,"d":"136,031,944"}},{"v":139320237,"d":"139,320,237"},{"$f":"SUM(J35:J36)","v":{"v":138380157,"d":"138,380,157"}},{"v":107123211.92,"d":"107,123,212"},{"v":106174202.45,"d":"106,174,202"},{"v":106049521.33,"d":"106,049,521"},{"$f":"SUM(N35:N36)","v":{"v":105698039.42999999,"d":"105,698,039"}},{"$f":"SUM(O35:O36)","v":{"v":105333811.68,"d":"105,333,812"}},{"$f":"+P35+P36","v":{"v":104956175.5,"d":"104,956,176"}},{"$f":"SUM(Q35:Q36)","v":{"v":104569770.5,"d":"104,569,771"}}]

{"sheet":"Details for Budget 2019-2023","index":3,"n_rows":62,"n_cols":12,"rows_kept":62}
[]
["1) Base interest income on 2018-2019- estimate- $100,000- rates are slowly declining now - Fed cutting rates",{"$nulls":10},"Much of the OTASC budget is an educated guess"]
["      Anticipation of recession in next few years - reduce to $90K",{"$nulls":10},"No clear direction on MSA payments in the future or expense growth"]
[]
["2) Calc of 2nd credit to PMs - good through 2019 - our"]
["    MSA payment should go up then:"]
[]
["Per Email from Dana B - Credit in 2017",{"$nulls":4},{"v":87643971,"d":"87,643,971.00"}]
[null,"OTASC portion of MSA Payt",{"$nulls":3},{"v":0.00972,"d":"0.972%"}]
[null,"Otasc Portion of credit",{"$nulls":3},{"$f":"+F8*F9","v":{"v":851899.3981199999,"d":"851,899.40"}}]
[]
[null,"Will use a bump of $700K to be conservative"]
[]
[]
[]
[]
["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 &",null,"Net "]
[null,"2016 A-1","2016 A-1","2016 A-2B","2016 A-2B","Total",null,"Premium","Def Inflow",null,"Interest"]
["2019 Interest",{"v":699890.625,"d":"699,890.63"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B21:E21)","v":{"v":2537053.125,"d":"2,537,053.13"}}]
[null,{"v":675843.75,"d":"675,843.75"},{"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":2513006.25,"d":"2,513,006.25"}}]
[{"$nulls":5},{"$f":"SUM(F21:F22)","v":{"v":5050059.375,"d":"5,050,059.38"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F23+H23+I23","v":{"v":4025340.1005345094,"d":"4,025,340.10"}}]
["2020 Interest",{"v":675843.75,"d":"675,843.75"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B24:E24)","v":{"v":2513006.25,"d":"2,513,006.25"}}]
[null,{"v":640828.125,"d":"640,828.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":2477990.625,"d":"2,477,990.63"}}]
[{"$nulls":5},{"$f":"SUM(F24:F25)","v":{"v":4990996.875,"d":"4,990,996.88"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F26+H26+I26","v":{"v":3966277.6005345094,"d":"3,966,277.60"}}]
["2021 Interest",{"v":640828.125,"d":"640,828.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B27:E27)","v":{"v":2477990.625,"d":"2,477,990.63"}}]
[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(B28:E28)","v":{"v":2440865.625,"d":"2,440,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F27:F28)","v":{"v":4918856.25,"d":"4,918,856.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F29+H29+I29","v":{"v":3894136.9755345094,"d":"3,894,136.98"}}]
["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(B30:E30)","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(B31:E31)","v":{"v":2401490.625,"d":"2,401,490.63"}}]
[{"$nulls":5},{"$f":"SUM(F30:F31)","v":{"v":4842356.25,"d":"4,842,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F32+H32+I32","v":{"v":3817636.9755345094,"d":"3,817,636.98"}}]
["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(B33:E33)","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(B34:E34)","v":{"v":2359865.625,"d":"2,359,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F33:F34)","v":{"v":4761356.25,"d":"4,761,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F35+H35+I35","v":{"v":3736636.9755345094,"d":"3,736,636.98"}}]
[]
[]
["Per BLX- Slow ay Schedule -2018 Audit"]
["5) Calc of Prin Payments",null,"Estimate"]
[null,"Slow Pay","MSA Payt"]
[2019,{"v":960000,"d":"960,000"},{"v":6350000,"d":"6,350,000"},"Actual for 2019 was 5,989,000- should be slightly higher due to no other MS credits- however-tobacco co. are investing more into vaping- marijauna content"]
[2020,{"v":1245000,"d":"1,245,000"},{"v":6100000,"d":"6,100,000"}]
[2021,{"v":1320000,"d":"1,320,000"},{"v":6000000,"d":"6,000,000"}]
[2022,{"v":1400000,"d":"1,400,000"},{"v":6000000,"d":"6,000,000"}]
[2023,{"v":1480000,"d":"1,480,000"},{"v":5900000,"d":"5,900,000"}]
[]
["6) Admin costs- allowable for $2k increase each year"]
[]
[]
["7) Assume increase in expenses by 2020-2023"]
["     Insurance - audit - legal fees etc"]
[]
["8) Accreted Interest- added to 2005 Bonds"]
["2019-12-31",{"v":12824441.32,"d":"12,824,441"},{"v":12824441.320771422,"d":"12,824,441"}]
[" accreted interest",{"$nulls":3},{"v":893518.0999999996,"d":"893,518"}]
["2020-12-31",{"v":13717959.42,"d":"13,717,959"},{"v":13717959.422441121,"d":"13,717,959"}]
[" 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"}]

{"sheet":"Details for Budget","index":4,"n_rows":49,"n_cols":13,"rows_kept":49}
[]
["1) Base interest income on 2017- estimate- $70,000",{"$nulls":10},"Emails - Justin Gagnon- BLX on Future Payments/Expenses"]
[]
[{"$nulls":11},"Hi Lori,"]
["2) Calc of 2nd credit to PMs - good through 2019 - our"]
["    MSA payment should go up then:",{"$nulls":10},"Based on the most recent projection of TSRs available ($6,314,245), the amount of principal to be paid on June 1 is $1,175,000.  "]
[{"$nulls":11},"This number is just an estimate at this time.  I am not aware of any fee increases for operating expenses (trustee, admin, rating agency)."]
["Per Email from Dana B - Credit in 2017",{"$nulls":4},{"v":87643971,"d":"87,643,971.00"},{"$nulls":5},"I will use Slow pay of 1,080,000- and future years"]
[null,"OTASC portion of MSA Payt",{"$nulls":3},{"v":0.00972,"d":"0.972%"}]
[null,"Otasc Portion of credit",{"$nulls":3},{"$f":"+F8*F9","v":{"v":851899.3981199999,"d":"851,899.40"}}]
[{"$nulls":11},"It does seem high when looking at the principal paid last year, but not when you factor in the interest "]
[null,"Will use a bump of $700K to be conservative",{"$nulls":9},"expense.  The 2016 A-2B bonds had a long first interest payment date of 6/1/17 (rather than on 12/1/16 like "]
[{"$nulls":11},"the 2016 A-1 bonds), resulting in a decrease of interest expense in 2018 of $430K.  If you add the $477K in "]
["3) 2017 Prin Payt - NYCTT VI",{"$nulls":4},{"v":325000,"d":"325,000"},{"$nulls":5},"additional TSRs for 2018, last year’s principal payment of $325K, and the $430K or reduced interest cost, you arrive in the neighborhood of the $1,175K of principal.  "]
["    2018- Estimate will be similar as MSA will be similar to 2017",{"$nulls":4},{"v":350000,"d":"350,000"}]
[]
["4) 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 &",null,"Net "]
[null,"2016 A-1","2016 A-1","2016 A-2B","2016 A-2B","Total",null,"Premium","Def Inflow",null,"Interest"]
["2018 Interest",{"v":733218.75,"d":"733,218.75"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B21:E21)","v":{"v":2570381.25,"d":"2,570,381.25"}},{"$nulls":6},{"$f":"6320000-5837000","v":483000}]
[null,{"v":702843.75,"d":"702,843.75"},{"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":2540006.25,"d":"2,540,006.25"}}]
[{"$nulls":5},{"$f":"SUM(F21:F22)","v":{"v":5110387.5,"d":"5,110,387.50"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F23+H23+I23","v":{"v":4085668.2255345094,"d":"4,085,668.23"}}]
["2019 Interest",{"v":702843.75,"d":"702,843.75"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B24:E24)","v":{"v":2540006.25,"d":"2,540,006.25"}}]
[null,{"v":675843.75,"d":"675,843.75"},{"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":2513006.25,"d":"2,513,006.25"}}]
[{"$nulls":5},{"$f":"SUM(F24:F25)","v":{"v":5053012.5,"d":"5,053,012.50"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F26+H26+I26","v":{"v":4028293.2255345094,"d":"4,028,293.23"}}]
["2020 Interest",{"v":675843.75,"d":"675,843.75"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B27:E27)","v":{"v":2513006.25,"d":"2,513,006.25"}}]
[null,{"v":640828.125,"d":"640,828.13"},{"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":2477990.625,"d":"2,477,990.63"}}]
[{"$nulls":5},{"$f":"SUM(F27:F28)","v":{"v":4990996.875,"d":"4,990,996.88"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F29+H29+I29","v":{"v":3966277.6005345094,"d":"3,966,277.60"}}]
["2021 Interest",{"v":640828.125,"d":"640,828.13"},{"v":822537.5,"d":"822,537.50"},{"v":315125,"d":"315,125.00"},{"v":699500,"d":"699,500.00"},{"$f":"SUM(B30:E30)","v":{"v":2477990.625,"d":"2,477,990.63"}}]
[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(B31:E31)","v":{"v":2440865.625,"d":"2,440,865.63"}}]
[{"$nulls":5},{"$f":"SUM(F30:F31)","v":{"v":4918856.25,"d":"4,918,856.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"},null,{"$f":"+F32+H32+I32","v":{"v":3894136.9755345094,"d":"3,894,136.98"}}]
["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(B33:E33)","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(B34:E34)","v":{"v":2401490.625,"d":"2,401,490.63"}}]
[{"$nulls":5},{"$f":"SUM(F33:F34)","v":{"v":4842356.25,"d":"4,842,356.25"}},null,{"v":-266049,"d":"(266,049.00)"},{"v":-758670.2744654906,"d":"(758,670.27)"}]
[]
["5) Calc of Prin Payments",null,"Estimate"]
[null,"Slow Pay","MSA Payt"]
[2017,{"v":420000,"d":"420,000"},{"v":420000,"d":"420,000"},{"v":325000,"d":"325,000"},"Due to lower MSA pays - 2017 to 2019"]
[2018,{"v":985000,"d":"985,000"},{"v":350000,"d":"350,000"},null,"will be lower  - see above explanation"]
[2019,{"v":960000,"d":"960,000"},{"v":400000,"d":"400,000"}]
[2020,{"v":1245000,"d":"1,245,000"},{"v":1400000,"d":"1,400,000"}]
[2021,{"v":1320000,"d":"1,320,000"},{"v":1450000,"d":"1,450,000"}]
[]
["6) Admin costs- allowable for $2k increase each year"]
[]
[]
["7) Assume increase in expenses by 2020-2022"]
["     Insurance - audit - legal fees etc"]