{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget by yr2018-2022 PARIS ","Details for Budget"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget by yr2018-2022 PARIS ","index":0,"n_rows":38,"n_cols":16,"rows_kept":38}
[{"$nulls":5},"Onondaga Tobacco Asset Securitization Corporation",{"$nulls":4},"As Per"]
["BUDGET-OTASC",null,"2018-2022",{"$nulls":7},"Debt Service"]
[{"$nulls":3},"Actual ","Budget","Actual ","Budget","Actual","Budget","Actual","Budget","Budget","Budget","Budget","Budget","Budget"]
[{"$nulls":3},2012,2013,2013,2014,2014,2015,2015,2017,2018,2019,2020,2021,2022]
["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":6500000,"d":"6,500,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"},{"$f":"L7","v":{"v":70000,"d":"70,000"}},{"v":73000,"d":"73,000"},{"$f":"N7","v":{"v":73000,"d":"73,000"}},{"v":73000,"d":"73,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"}},{"$f":"SUM(M6:M7)","v":{"v":6420000,"d":"6,420,000"}},{"$f":"SUM(N6:N7)","v":{"v":6573000,"d":"6,573,000"}},{"$f":"SUM(O6:O7)","v":{"v":6573000,"d":"6,573,000"}},{"$f":"SUM(P6:P7)","v":{"v":6573000,"d":"6,573,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"}]
[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"}]
[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"}]
[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":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":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":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"}]
[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"}]
[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"}]
[]
[]
[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":6363096.875,"d":"6,363,097"}},{"$f":"SUM(O11:O20)","v":{"v":6367956.25,"d":"6,367,956"}},{"$f":"SUM(P11:P19)","v":{"v":6373556,"d":"6,373,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":209903.125,"d":"209,903"},{"v":205043.75,"d":"205,044"},{"v":199444,"d":"199,444"}]
["FUND BALANCE/NET DEFICIT -"]
["  BEGINNING OF YEAR",null,null,{"v":-123881006,"d":"(123,881,006)"},{"$f":"+D28","v":{"v":-124021571,"d":"(124,021,571)"}},{"$f":"+D28","v":{"v":-124021571,"d":"(124,021,571)"}},{"$f":"+F28","v":{"v":-121950357,"d":"(121,950,357)"}},{"$f":"+F28","v":{"v":-121950357,"d":"(121,950,357)"}},{"$f":"G28","v":{"v":-118927557,"d":"(118,927,557)"}},{"v":-127909510,"d":"(127,909,510)"},{"v":6633174,"d":"6,633,174"},{"v":6554074,"d":"6,554,074"},{"$f":"L28","v":{"v":6633044,"d":"6,633,044"}},{"$f":"+M28","v":{"v":6916331.5,"d":"6,916,332"}},{"$f":"+N28","v":{"v":7126234.625,"d":"7,126,235"}},{"$f":"+O28","v":{"v":7331278.375,"d":"7,331,278"}}]
["*Adjmt for change in accounting GASB 65",null,null,{"v":-2130649,"d":"(2,130,649)"}]
["FUND BALANCE/NET DEFICIT -",null,null,{"$f":"D26+D22+D27","v":{"v":-124021571,"d":"(124,021,571)"}},{"$f":"E26+E22","v":{"v":-122254396,"d":"(122,254,396)"}},{"$f":"+F26+F22","v":{"v":-121950357,"d":"(121,950,357)"}},{"$f":"G26+G22","v":{"v":-118927557,"d":"(118,927,557)"}},{"$f":"+H22+H26","v":{"v":-122052841,"d":"(122,052,841)"}},{"$f":"I26+I22","v":{"v":-116795363,"d":"(116,795,363)"}},{"$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":7126234.625,"d":"7,126,235"},{"v":7331278.375,"d":"7,331,278"},{"v":7530722.375,"d":"7,530,722"}]
["  END OF YEAR"]
[{"$nulls":5},{"$f":"+F18+#REF!+F35","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":"+E33","v":{"v":91140000,"d":"91,140,000"}},{"$f":"+F33+F35","v":{"v":89070000,"d":"89,070,000"}},{"$f":"+G33+G35","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":"+L33+L37","v":{"v":11989202.45,"d":"11,989,202"}},{"$f":"+M33+M37","v":{"v":12824521.33,"d":"12,824,521"}},{"$f":"+N33+N37","v":{"v":13718039.43,"d":"13,718,039"}},{"$f":"+O33+O37","v":{"v":14673811.68,"d":"14,673,812"}}]
["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":"+K34-325000","v":{"v":95265000,"d":"95,265,000"}},{"$f":"+L34+L35","v":{"v":94185000,"d":"94,185,000"}},{"$f":"+M34+M35","v":{"v":93225000,"d":"93,225,000"}},{"$f":"+N34+N35","v":{"v":91980000,"d":"91,980,000"}},{"$f":"+O34+O35","v":{"v":90660000,"d":"90,660,000"}}]
["Assumed Bond Payment - Prin -Slow Pay-",null,null,{"v":-1960000,"d":"(1,960,000)"},{"v":-945000,"d":"(945,000)"},{"v":-2070000,"d":"(2,070,000)"},{"$f":"-'[1]Debt Service'!C4","v":{"v":-1005000,"d":"(1,005,000)"}},{"v":-3095000,"d":"(3,095,000)"},{"$f":"-'[1]Debt Service'!C5","v":{"v":-1100000,"d":"(1,100,000)"}},{"v":-2040000,"d":"(2,040,000)"},{"v":325000,"d":"325,000"},{"v":-1080000,"d":"(1,080,000)"},{"$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)"}}]
["     Subtotal",null,null,{"$f":"SUM(D33:D35)","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(H33:H35)","v":{"v":113495438,"d":"113,495,438"}},{"v":113400438,"d":"113,400,438"},{"$f":"SUM(J33:J35)","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(N33:N35)","v":{"v":104804521.33,"d":"104,804,521"}},{"$f":"SUM(O33:O35)","v":{"v":104378039.43,"d":"104,378,039"}},{"$f":"SUM(P33:P35)","v":{"v":103933811.68,"d":"103,933,812"}}]
["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"}]
["Total bonds payable and accreted interest-Y/E",null,null,{"$f":"D37+D36","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(H36:H37)","v":{"v":136031944,"d":"136,031,944"}},{"v":139320237,"d":"139,320,237"},{"$f":"SUM(J36:J37)","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(N36:N37)","v":{"v":105698039.42999999,"d":"105,698,039"}},{"$f":"SUM(O36:O37)","v":{"v":105333811.68,"d":"105,333,812"}},{"$f":"+P36+P37","v":{"v":104956175.5,"d":"104,956,176"}}]

{"sheet":"Details for Budget","index":1,"n_rows":49,"n_cols":12,"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"}}]
[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"]