{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["BCBE Financial Plan"],"not_rendered":{"charts":2,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"BCBE Financial Plan","index":0,"n_rows":71,"n_cols":19,"rows_kept":71,"merged":[[4,2,4,5],[4,7,4,10],[4,12,5,12],[4,13,4,18],[25,0,25,1]]}
["Baldwin County School System"]
["Five Year Financial Plan"]
["General Fund FY 2015"]
[]
[null,null,"Actual",{"$nulls":3},"Budgeted","Projected",{"$nulls":4},{"$f":"\"Avg Ann Increase\"&\" \"&C6&\"- present\"","v":"Avg Ann Increase 2011- present"},"Assumptions"]
[null,null,2011,2012,2013,2014,2015,2016,{"$f":"H6+1","v":2017},{"$f":"I6+1","v":2018},{"$f":"J6+1","v":2019},{"$f":"K6+1","v":2020},null,{"$f":"H6","v":2016},{"$f":"I6","v":2017},{"$f":"J6","v":2018},{"$f":"K6","v":2019},2020,"Description"]
["Revenues"]
[null,"State Revenue",{"v":96444623.54,"d":"96,444,624"},{"v":104908320.04,"d":"104,908,320"},{"v":117928733.13,"d":"117,928,733"},{"v":128172408.46,"d":"128,172,408"},{"v":134120172,"d":"134,120,172"},{"$f":"IF(N8=\"\",\"\",G8*(1+N8))","v":{"v":136802575.44,"d":"136,802,575"}},{"v":139538626.9488,"d":"139,538,627"},{"v":142329399.487776,"d":"142,329,399"},{"v":145175987.47753152,"d":"145,175,987"},{"v":148079507.22708216,"d":"148,079,507"},{"$f":"IF(C8=\"\",\"\",IF(AND(G8>=0,G8<>\"\",C8>0),(G8/C8)^(1/4)-1,IF(AND(F8>=0,C8>0),(F8/C8)^(1/3)-1,\"N/A\")))","v":{"v":0.08593547279618496,"d":"9%"}},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"Federal Revenue",0,0,0,0,0,"","","","","",{"$f":"IF(C9=\"\",\"\",IF(AND(G9>=0,G9<>\"\",C9>0),(G9/C9)^(1/4)-1,IF(AND(F9>=0,C9>0),(F9/C9)^(1/3)-1,\"N/A\")))","v":"N/A"}]
[null,"Local Revenue",{"v":113202604.73,"d":"113,202,605"},{"v":109092907.31,"d":"109,092,907"},{"v":112235094.51,"d":"112,235,095"},{"v":113051806.5,"d":"113,051,807"},{"v":107597676.64,"d":"107,597,677"},{"v":109749630.1728,"d":"109,749,630"},{"v":101518407.90984,"d":"101,518,408"},{"v":82229910.40697041,"d":"82,229,910"},{"v":69895423.84592485,"d":"69,895,424"},{"v":70594378.0843841,"d":"70,594,378"},{"$f":"IF(C10=\"\",\"\",IF(AND(G10>=0,G10<>\"\",C10>0),(G10/C10)^(1/4)-1,IF(AND(F10>=0,C10>0),(F10/C10)^(1/3)-1,\"N/A\")))","v":{"v":-0.012614788161207868,"d":"-1%"}},{"v":0.02,"d":"2%"},{"v":-0.075,"d":"-8%"},{"v":-0.19,"d":"-19%"},{"v":-0.15,"d":"-15%"},{"v":0.01,"d":"1%"}]
[null,"Other Revenue",{"v":1105427.29,"d":"1,105,427"},{"v":1265406.15,"d":"1,265,406"},{"v":1181122.76,"d":"1,181,123"},{"v":977945.98,"d":"977,946"},{"v":367000,"d":"367,000"},{"v":367000,"d":"367,000"},{"v":367000,"d":"367,000"},{"v":367000,"d":"367,000"},{"v":367000,"d":"367,000"},{"v":367000,"d":"367,000"},{"$f":"IF(C11=\"\",\"\",IF(AND(G11>=0,G11<>\"\",C11>0),(G11/C11)^(1/4)-1,IF(AND(F11>=0,C11>0),(F11/C11)^(1/3)-1,\"N/A\")))","v":{"v":-0.24092625436648907,"d":"-24%"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Total Revenues and Other Sources*",{"$f":"SUM(C8:C11)","v":{"v":210752655.56,"d":"$210,752,656"}},{"v":215266633.50000003,"d":"$215,266,634"},{"v":231344950.39999998,"d":"$231,344,950"},{"v":242202160.93999997,"d":"$242,202,161"},{"v":242084848.64,"d":"$242,084,849"},{"v":246919205.6128,"d":"$246,919,206"},{"v":241424034.85864002,"d":"$241,424,035"},{"v":224926309.89474642,"d":"$224,926,310"},{"v":215438411.32345638,"d":"$215,438,411"},{"v":219040885.31146628,"d":"$219,040,885"},{"$f":"IF(C12=\"\",\"\",IF(AND(G12>=0,G12<>\"\",C12>0),(G12/C12)^(1/4)-1,IF(AND(F12>=0,C12>0),(F12/C12)^(1/3)-1,\"N/A\")))","v":{"v":0.03525810288741238,"d":"4%"}},{"$f":"IF(G12<=0,\"\",(H12-G12)/G12)","v":{"v":0.019969680052092403,"d":"2%"}},{"$f":"IF(H12<=0,\"\",(I12-H12)/H12)","v":{"v":-0.022254934526142522,"d":"-2%"}},{"$f":"IF(I12<=0,\"\",(J12-I12)/I12)","v":{"v":-0.06833505609146759,"d":"-7%"}},{"$f":"IF(J12<=0,\"\",(K12-J12)/J12)","v":{"v":-0.042182253270992974,"d":"-4%"}},{"$f":"IF(K12<=0,\"\",(L12-K12)/K12)","v":{"v":0.016721595586783235,"d":"2%"}}]
[]
["Expenditures by Object"]
[null,"Instructional Services",{"v":117340205.85,"d":"117,340,206"},{"v":115171871.2,"d":"115,171,871"},{"v":122506518.27,"d":"122,506,518"},{"v":130664041.28,"d":"130,664,041"},{"v":138930954.22,"d":"138,930,954"},{"$f":"IF(N15=\"\",\"\",G15*(1+N15))","v":{"v":141709573.3044,"d":"141,709,573"}},{"v":144543764.770488,"d":"144,543,765"},{"v":147434640.06589776,"d":"147,434,640"},{"v":150383332.86721572,"d":"150,383,333"},{"v":153390999.52456003,"d":"153,391,000"},{"$f":"IF(C15=\"\",\"\",IF(AND(G15>=0,G15<>\"\",C15>0),(G15/C15)^(1/4)-1,IF(AND(F15>=0,C15>0),(F15/C15)^(1/3)-1,\"N/A\")))","v":{"v":0.043129057230163026,"d":"4%"}},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"Instructional Support Services",{"v":28364247.34,"d":"28,364,247"},{"v":35141364.79,"d":"35,141,365"},{"v":34948181.47,"d":"34,948,181"},{"v":36701575.69,"d":"36,701,576"},{"v":38954707.32,"d":"38,954,707"},{"v":39733801.4664,"d":"39,733,801"},{"v":40528477.495728,"d":"40,528,477"},{"v":41339047.04564256,"d":"41,339,047"},{"v":42165827.98655541,"d":"42,165,828"},{"v":43009144.54628652,"d":"43,009,145"},{"v":0.08254802111138937,"d":"8%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"Operations & Maintenance",{"v":10567764.66,"d":"10,567,765"},{"v":10830783.59,"d":"10,830,784"},{"v":11134413.11,"d":"11,134,413"},{"v":12392911.21,"d":"12,392,911"},{"$f":"17750463.08-5000000","v":{"v":12750463.079999998,"d":"12,750,463"}},{"v":13005472.341599999,"d":"13,005,472"},{"v":13265581.788431998,"d":"13,265,582"},{"v":13530893.42420064,"d":"13,530,893"},{"v":13801511.292684652,"d":"13,801,511"},{"v":14077541.518538345,"d":"14,077,542"},{"v":0.048058938424086595,"d":"5%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"Auxilliary Services",{"v":8508810.99,"d":"8,508,811"},{"v":9560811.91,"d":"9,560,812"},{"v":10482506.31,"d":"10,482,506"},{"v":11077939.55,"d":"11,077,940"},{"v":10755895.68,"d":"10,755,896"},{"v":10971013.5936,"d":"10,971,014"},{"v":11190433.865472,"d":"11,190,434"},{"v":11414242.54278144,"d":"11,414,243"},{"v":11642527.39363707,"d":"11,642,527"},{"v":11875377.941509811,"d":"11,875,378"},{"v":0.0603382452120349,"d":"6%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"General Administrative Services",{"v":6474076.04,"d":"6,474,076"},{"v":6302379.41,"d":"6,302,379"},{"v":7764040.65,"d":"7,764,041"},{"v":9118697.47,"d":"9,118,697"},{"v":8770988.75,"d":"8,770,989"},{"v":8858698.6375,"d":"8,858,699"},{"v":8947285.623875,"d":"8,947,286"},{"v":9036758.48011375,"d":"9,036,758"},{"v":9127126.064914888,"d":"9,127,126"},{"v":9218397.325564036,"d":"9,218,397"},{"v":0.07886645405549153,"d":"8%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"}]
[null,"Capital Outlay",{"v":92691.9,"d":"92,692"},{"v":496166.65,"d":"496,167"},{"v":10928.84,"d":"10,929"},0,0,{"$nulls":5},{"v":-1,"d":"-100%"},"---","---","---","---",null,"Based on capital plan"]
[null,"Debt Service (Leases)",{"$f":"293723.26+4147997.65","v":{"v":4441720.91,"d":"4,441,721"}},{"v":6634409.3,"d":"6,634,409"},{"v":4571231.76,"d":"4,571,232"},{"v":7762215,"d":"7,762,215"},{"v":10361473.93,"d":"10,361,474"},{"v":7934077.21,"d":"7,934,077"},{"v":6120119,"d":"6,120,119"},{"$f":"IF(P21=\"\",\"\",I21*(1+P21))","v":{"v":6181320.19,"d":"6,181,320"}},{"v":6243133.3919,"d":"6,243,133"},{"v":6305564.725819,"d":"6,305,565"},{"v":0.23585513943658265,"d":"24%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"},{"v":0.01,"d":"1%"}]
[null,"Other Expenditures",{"v":2973976.7,"d":"2,973,977"},{"v":3000598.28,"d":"3,000,598"},{"v":3011243.81,"d":"3,011,244"},{"v":3067052.21,"d":"3,067,052"},{"v":3316096.5,"d":"3,316,097"},{"v":3415579.395,"d":"3,415,579"},{"v":3483890.9829,"d":"3,483,891"},{"v":3553568.802558,"d":"3,553,569"},{"v":3624640.1786091602,"d":"3,624,640"},{"v":3697132.9821813437,"d":"3,697,133"},{"v":0.027595987158189672,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
[null,"Interfund Transfers (Net)",{"v":13875258.3,"d":"13,875,258"},{"v":21773592.35,"d":"21,773,592"},{"v":28534750.34,"d":"28,534,750"},{"v":27697115.01,"d":"27,697,115"},{"$f":"11879609.17+5000000","v":{"v":16879609.17,"d":"16,879,609"}},{"v":17723589.628500003,"d":"17,723,590"},{"v":18432533.213640004,"d":"18,432,533"},{"v":14746026.570912004,"d":"14,746,027"},{"v":15188407.368039364,"d":"15,188,407"},{"v":15644059.589080546,"d":"15,644,060"},{"v":0.050220103882695044,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.04,"d":"4%"},{"v":-0.2,"d":"-20%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"}]
[null,"Total Expenditures and Other Uses*",{"$f":"SUM(C15:C23)","v":{"v":192638752.69,"d":"$192,638,753"}},{"v":208911977.48000002,"d":"$208,911,977"},{"v":222963814.56000003,"d":"$222,963,815"},{"v":238481547.42000002,"d":"$238,481,547"},{"v":240720188.65000004,"d":"$240,720,189"},{"v":243351805.57700002,"d":"$243,351,806"},{"v":246512086.74053496,"d":"$246,512,087"},{"v":247236497.12210616,"d":"$247,236,497"},{"v":252176506.54355627,"d":"$252,176,507"},{"$f":"SUM(L15:L23)","v":{"v":257218218.15353963,"d":"$257,218,218"}},{"$f":"IF(AND(G24>0,C24>0),(G24/C24)^(1/4)-1,IF(AND(G24<=0,C24>0),(F24/C24)^(1/3)-1,\"\"))","v":{"v":0.057285349547586906,"d":"6%"}},{"$f":"IF(G24<=0,\"\",(H24-G24)/G24)","v":{"v":0.01093226514052911,"d":"1%"}},{"$f":"IF(H24<=0,\"\",(I24-H24)/H24)","v":{"v":0.012986470990185362,"d":"1%"}},{"$f":"IF(I24<=0,\"\",(J24-I24)/I24)","v":{"v":0.002938640417796949,"d":"0%"}},{"$f":"IF(J24<=0,\"\",(K24-J24)/J24)","v":{"v":0.0199809068602453,"d":"2%"}},{"$f":"IF(K24<=0,\"\",(L24-K24)/K24)","v":{"v":0.01999278869823087,"d":"2%"}}]
[null,"(*Interfunds Transfers not shown)"]
["Surplus (Deficit)",null,{"$f":"C12-C24","v":{"v":18113902.870000005,"d":"$18,113,903"}},{"v":6354656.020000011,"d":"$6,354,656"},{"v":8381135.839999944,"d":"$8,381,136"},{"v":3720613.519999951,"d":"$3,720,614"},{"v":1364659.98999995,"d":"$1,364,660"},{"v":3567400.03579998,"d":"$3,567,400"},{"v":-5088051.881894946,"d":"($5,088,052)"},{"v":-22310187.227359742,"d":"($22,310,187)"},{"v":-36738095.220099896,"d":"($36,738,095)"},{"v":-38177332.84207335,"d":"($38,177,333)"}]
[]
["Budgetary Reserves"]
[null,"General Fund, Beg. Fund Balance",{"v":1369044.15,"d":"$1,369,044"},{"v":19439508.52,"d":"$19,439,509"},{"v":26043526.84,"d":"$26,043,527"},{"v":34423264.68,"d":"$34,423,265"},{"v":38206486.14,"d":"$38,206,486"},{"$f":"G30","v":{"v":39571146.13,"d":"39,571,146 "}},{"$f":"IF(H30=\"\",\"\",H30)","v":{"v":43138546.16579998,"d":"$43,138,546"}},{"$f":"IF(I30=\"\",\"\",I30)","v":{"v":38050494.28390504,"d":"$38,050,494"}},{"$f":"IF(J30=\"\",\"\",J30)","v":{"v":15740307.056545295,"d":"$15,740,307"}},{"$f":"IF(K30=\"\",\"\",K30)","v":{"v":-20997788.1635546,"d":"($20,997,788)"}}]
[null,"General Fund, Ending Fund Balance",{"v":19482947.02,"d":"19,482,947 "},{"v":25794163.86,"d":"25,794,164 "},{"v":34424662.68,"d":"34,424,663 "},{"v":38132152.29,"d":"38,132,152 "},{"v":39571146.13,"d":"39,571,146 "},{"$f":"IF(H29=\"\",\"\",H26+H29)","v":{"v":43138546.16579998,"d":"43,138,546 "}},{"$f":"IF(I29=\"\",\"\",I26+I29)","v":{"v":38050494.28390504,"d":"38,050,494 "}},{"$f":"IF(J29=\"\",\"\",J26+J29)","v":{"v":15740307.056545295,"d":"15,740,307 "}},{"$f":"IF(K29=\"\",\"\",K26+K29)","v":{"v":-20997788.1635546,"d":"(20,997,788)"}},{"$f":"IF(L29=\"\",\"\",L26+L29)","v":{"v":-59175121.00562795,"d":"(59,175,121)"}}]
[null,"State Required One Month Reserve",{"v":16500000,"d":"16,500,000 "},{"v":17000000,"d":"17,000,000 "},{"v":18000000,"d":"18,000,000 "},{"v":19500000,"d":"19,500,000 "},{"v":20060015.72,"d":"20,060,016 "},{"$f":"(G31*0.02)+G31","v":{"v":20461216.034399997,"d":"20,461,216 "}},{"$f":"(H31*0.02)+H31","v":{"v":20870440.355087996,"d":"20,870,440 "}},{"$f":"(I31*0.02)+I31","v":{"v":21287849.162189756,"d":"21,287,849 "}},{"$f":"(J31*0.02)+J31","v":{"v":21713606.145433553,"d":"21,713,606 "}},{"$f":"(K31*0.02)+K31","v":{"v":22147878.268342223,"d":"22,147,878 "}}]
[null,"Unrestricted Fund Balance",{"$f":"IF(C29=\"\",\"\",C30-C31)","v":{"v":2982947.0199999996,"d":"2,982,947 "}},{"v":8794163.86,"d":"8,794,164 "},{"v":16424662.68,"d":"16,424,663 "},{"v":18632152.29,"d":"18,632,152 "},{"v":19511130.410000004,"d":"19,511,130 "},{"v":22677330.131399985,"d":"22,677,330 "},{"v":17180053.92881704,"d":"17,180,054 "},{"v":-5547542.105644461,"d":"(5,547,542)"},{"v":-42711394.308988154,"d":"(42,711,394)"},{"$f":"IF(L29=\"\",\"\",L30-L31)","v":{"v":-81322999.27397017,"d":"(81,322,999)"}}]
[null,"UFB as % of Expenditures*",{"$f":"IF(C24>0,C32/C24,\"\")","v":{"v":0.015484667432415566,"d":"1.5%"}},{"$f":"IF(D24>0,D32/D24,\"\")","v":{"v":0.04209506781793734,"d":"4.2%"}},{"v":0.07366514926385101,"d":"7.4%"},{"v":0.07812827655460539,"d":"7.8%"},{"v":0.08105315353656774,"d":"8.1%"},{"v":0.09318743322093229,"d":"9.3%"},{"v":0.06969254187888896,"d":"7.0%"},{"v":-0.02243820054975386,"d":"-2.2%"},{"v":-0.1693710286275656,"d":"-16.9%"},{"$f":"IF(L24>0,L32/L24,\"\")","v":{"v":-0.3161634500765671,"d":"-31.6%"}}]
[]
["Number of Employees",null,{"v":3098,"d":"3,098"},{"v":3115,"d":"3,115"},{"v":3501,"d":"3,501"},{"v":3561,"d":"3,561"},{"v":3667,"d":"3,667"},{"$f":"IF(N35=\"\",\"\",G35*(1+N35))","v":{"v":3740.34,"d":"3,740"}},{"v":3815.1468000000004,"d":"3,815"},{"v":3891.4497360000005,"d":"3,891"},{"v":3969.2787307200006,"d":"3,969"},{"v":4048.6643053344005,"d":"4,049"},{"$f":"IF(AND(G35>0,C35>0),(G35/C35)^(1/4)-1,IF(AND(G35<=0,C35>0),(F35/C35)^(1/3)-1,\"\"))","v":{"v":0.04305539598850561,"d":"4%"}},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
["ADM (State Funded Student Enrollment)",null,{"v":28367,"d":"28,367"},{"v":28611,"d":"28,611"},{"v":29462,"d":"29,462"},{"v":30302,"d":"30,302"},{"v":30643,"d":"30,643"},{"v":31255.86,"d":"31,256"},{"v":31880.9772,"d":"31,881"},{"v":32518.596744000002,"d":"32,519"},{"v":33168.96867888,"d":"33,169"},{"v":33832.3480524576,"d":"33,832"},{"$f":"IF(AND(G36>0,C36>0),(G36/C36)^(1/4)-1,IF(AND(G36<=0,C36>0),(F36/C36)^(1/3)-1,\"\"))","v":{"v":0.019481779009807187,"d":"2%"}},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"},{"v":0.02,"d":"2%"}]
{"$rows_empty":24}
[{"$nulls":5},"2015 12 mills",{"v":42096686,"d":"42,096,686"}]
[{"$nulls":6},{"v":90000,"d":"90,000"},null,104362848.33]
[{"$nulls":6},{"v":3303962,"d":"3,303,962"}]
[{"$nulls":6},{"$f":"SUM(G61:G63)","v":{"v":45490648,"d":"45,490,648"}}]
[{"$nulls":6},{"$f":"G64/12","v":{"v":3790887.3333333335,"d":"3,790,887.33"}}]
[{"$nulls":5},"Loss",{"$f":"G65*2","v":{"v":7581774.666666667,"d":"7,581,774.67"}}]
[]
[]
[]
[]
[{"$nulls":6},{"$f":"G24/12","v":{"v":20060015.720833335,"d":"$20,060,015.72"}},{"$f":"H24/12","v":{"v":20279317.131416667,"d":"$20,279,317.13"}},{"$f":"I24/12","v":{"v":20542673.89504458,"d":"$20,542,673.90"}}]