{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Cover","FP Sum","Cty Res","Dashboard","Rev Assum","Rev Var","Rev Var State","NonOp Assum","NonOp Var","Agency Assum","Agency Var"," MCG Assum"," MCG Var"," MCG Compensation","Bal Sheet","Dash Data","Rev Data","NonOp Data","Rev Sum All Years"," Trends","Per v Op"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FP Sum","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,4],[1,1,1,4]]}
[]
[null,"       APPROVED FY14-FY19 FISCAL PLAN"]
[]
[null,"       Summary"]
[]
[]
[null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)"]
[null,"Revenues",{"$f":"'Rev Data'!D25","v":4193.7},{"$f":"'Rev Data'!K25","v":3.1721015187839097E-2},{"$f":"'Rev Data'!I25","v":4902.4000000000005}]
[null,"Non-Operating Expenses",{"$f":"'NonOp Data'!D10","v":450.2},{"$f":"'NonOp Data'!K10","v":0.1010745770869399},{"$f":"'NonOp Data'!I10","v":728.6}]
[null,"Resources Available for Agency Use ",{"$f":"C8-C9","v":3743.5},{"$f":"((1+((E10-C10)/C10))^(1/5))-1","v":2.1999679141602391E-2},{"$f":"E8-E9","v":4173.8}]
[null,"MCPS",2084.3000000000002]
[null,"Montgomery College",228.5]
[null,"MNCPPC",104.7]
[null,"County Government",1325.9]
[null,"Surplus / Deficit",0,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"Cells C11 - C14 (from fiscal plan summary)"]

{"sheet":"Cty Res","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"COUNTY RESOURCES FOR AGENCY USE"]
[]
[]
[]
[null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)"]
[null,"County Resources Available \nfor Agency Use ",{"$f":"SUM(C8:C11)","v":3026.4000000000005},{"$f":"((1+((E7-C7)/C7))^(1/5))-1","v":2.6950675723319995E-2},{"$f":"'Rev Data'!I25-'NonOp Data'!I10-'Rev Data'!I14","v":3456.8}]
[null,"MCPS",{"$f":"'FP Sum'!C11-'Rev Data'!D15","v":1479.3000000000002}]
[null,"Montgomery College",{"$f":"'FP Sum'!C12-'Rev Data'!D16","v":196.8}]
[null,"MNCPPC",{"$f":"'FP Sum'!C13","v":104.7}]
[null,"County Government",{"$f":"'FP Sum'!C14-'Rev Data'!I17","v":1245.6000000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"None"]

{"sheet":"Dashboard","index":3,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,2,1,20],[21,11,21,12],[22,3,22,9],[2,14,2,20],[22,12,22,20],[4,3,4,9],[3,3,3,9],[21,3,21,9],[3,13,3,19],[4,13,4,19],[21,13,21,19]]}
[]
[null,null,"DASHBOARD"]
[]
[null,null,null,"1. Revenue ",null,null,null,null,null,null,null,null,null,"2. Non-Operating Expenses"]
[null,null,null,"Annual Growth Rate (FY14-FY19)",null,null,null,null,null,null,null,null,null,"Annual Growth Rate (FY14-FY19)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"3. Local Agency Funding    ",null,null,null,null,null,null,null,null,null,"4. County Government Budget"]
[null,null,null,"Annual Growth Rates (FY14-FY19)",null,null,null,null,null,null,null,null,"Annual Growth Rates (FY14-FY19)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L57>1.5,\"Surplus\",\"  \")","v":"  "},null,{"$f":"IF(AND($L$57>-1.5,$L$57<1.5),\"Balanced\",$L$57)","v":"Balanced"},null,{"$f":"IF($L$57<-1.5,\"Deficit\",\"  \")","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"UPDATE REQUIREMENTS",null,null,null,null,null,null,null,{"$f":"'Rev Var'!$M$12+'Rev Var State'!M11-'NonOp Var'!$L$14-'Agency Var'!$N$13","v":7.2475359047530219E-13}]
[null,null,null,"Adjust x-axis scales, move arrows"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rev Var'!$M$12","v":7.1207841355317214E-2}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rev Var State'!M11","v":1.9726923248271078E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'NonOp Var'!$L$14","v":4.7745411364985557E-3}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Agency Var'!$N$13","v":6.8405992542921013E-2}]

{"sheet":"Rev Assum","index":4,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,4,4,5],[12,7,16,7],[6,7,9,7]]}
[]
[]
[null,null,"                                       1. REVENUE ASSUMPTIONS"]
[]
[null,null,null,null,"Approved Fiscal Plan"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)",null,"Major Fiscal Plan Assumptions"]
[null,null,"Property Tax",{"$f":"'Rev Data'!D6","v":1504.9},{"$f":"'Rev Data'!K6","v":3.095566385248727E-2},{"$f":"'Rev Data'!I6","v":1752.7},null,"  • Retention of current tax rates\n\n  • Property taxes at Charter limit (with income tax offset)\n\n  • Annual average population growth of 0.9%\n\n  • Annual average growth in assessable base of 3.9%\n\n  • Annual average growth in per capita income of 4.2%\n\n "]
[null,null,"Income Tax",{"$f":"'Rev Data'!D7","v":1299.2},{"$f":"'Rev Data'!K7","v":5.4676412797857843E-2},{"$f":"'Rev Data'!I7","v":1695.4}]
[null,null,"Energy Tax",{"$f":"'Rev Data'!D10","v":210.7},{"$f":"'Rev Data'!K10","v":1.095795957233392E-2},{"$f":"'Rev Data'!I10","v":222.5}]
[null,null,"Other Local\nRevenue ",{"$f":"D11-D7-D8-D9","v":446.79999999999978},{"$f":"((1+(F10-D10)/D10)^(1/5))-1","v":2.8738692758400797E-2},{"$f":"F11-F7-F8-F9","v":514.80000000000064}]
[null,null," Total",{"$f":"'Rev Data'!D25-'Rev Data'!D15-'Rev Data'!D16-'Rev Data'!D17","v":3461.6},{"$f":"((1+(F11-D11)/D11)^(1/5))-1","v":3.8704510593160046E-2},{"$f":"'Rev Data'!I25-'Rev Data'!I15-'Rev Data'!I16-'Rev Data'!I17","v":4185.4000000000005}]
[]
[null,null,"State Aid to County\nGovt. and MNCPPC",{"$f":"'Rev Data'!D17","v":95.40000000000002},{"$f":"((1+(F13-D13)/D13)^(1/5))-1","v":-3.3874746822276092E-2},{"$f":"'Rev Data'!I17","v":80.3},null,"  \n  • Reduction in Mass Transit Aid to County\n\n  • No change in State aid to MCPS  \n\n  • No change in State aid to Montgomery College"]
[null,null,"State Aid to MCPS",{"$f":"'Rev Data'!D15","v":605},0,{"$f":"'Rev Data'!I15","v":605}]
[null,null,"State Aid to College",{"$f":"'Rev Data'!D16","v":31.7},0,{"$f":"'Rev Data'!I16","v":31.7}]
[]
[null,null,"TOTAL REVENUE",{"$f":"D7+D8+D9+D10+D13+D14+D15","v":4193.7},{"$f":"((1+(F17-D17)/D17)^(1/5))-1","v":3.1721015187839097E-2},{"$f":"F7+F8+F9+F10+F13+F14+F15","v":4902.4000000000015}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"All assumptions"]

{"sheet":"Rev Var","index":5,"n_rows":31,"n_cols":33,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,5,10,9],[9,5,9,9],[7,5,7,9],[10,10,10,11],[8,5,8,9],[7,10,7,11],[8,10,8,11],[4,4,4,9],[6,5,6,9],[6,10,6,11],[8,32,8,36],[5,10,5,11],[5,5,5,9],[4,14,5,17],[9,32,9,36],[9,10,9,11],[4,10,4,12],[6,14,6,18],[7,14,7,18],[6,32,6,36],[7,32,7,36],[9,14,9,18],[8,14,8,18]]}
[]
[]
[null,null,"                           1. REVENUE ASSUMPTIONS - Local Sources"]
[]
[null,null,null,null,"Approved Fiscal Plan",null,null,null,null,null,"Variable",null,null,null,"Click Boxes Below for \nHighest & Lowest 5-Year \n  Average (since FY88)  "]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)",null,null,null,null,"Avg. Annual Growth Rate",null,"FY19 Amount\n($ millions)"]
[null,null,"Property Tax",{"$f":"'Rev Data'!D6","v":1504.9},{"$f":"'Rev Data'!K6","v":3.095566385248727E-2},{"$f":"'Rev Data'!I6","v":1752.7},null,null,null,null,{"$f":"W7/100000","v":3.0960000000000001E-2},null,{"$f":"D7*((1+K7)^5)","v":1752.7368591489558},null,{"$f":"IF($AF$7=TRUE,AG7,\"  \")","v":"  "},null,null,null,null,null,null,null,3096,3096,null,null,null,null,null,null,false,false,"High: 6.7% (FY04-09)\nLow: 1.8% (FY94-99)"]
[null,null,"Income Tax",{"$f":"'Rev Data'!D7","v":1299.2},{"$f":"'Rev Data'!K7","v":5.4676412797857843E-2},{"$f":"'Rev Data'!I7","v":1695.4},null,null,null,null,{"$f":"(W8/100000)-0.025","v":5.4679999999999999E-2},null,{"$f":"D8*((1+K8)^5)","v":1695.4288324637257},null,{"$f":"IF($AF$8=TRUE,AG8,\"  \")","v":"  "},null,null,null,null,null,null,null,7968,7968,null,null,null,null,null,null,false,false,"High: 8.6% (FY01-06)\nLow: -0.2% (FY06-11)"]
[null,null,"Energy Tax",{"$f":"'Rev Data'!D10","v":210.7},{"$f":"'Rev Data'!K10","v":1.095795957233392E-2},{"$f":"'Rev Data'!I10","v":222.5},null,null,null,null,{"$f":"(W9/100000)-0.1","v":1.0959999999999998E-2},null,{"$f":"D9*((1+K9)^5)","v":222.50224538015669},null,{"$f":"IF($AF$9=TRUE,AG9,\"  \")","v":"  "},null,null,null,null,null,null,null,11096,11096,null,null,null,null,null,null,false,false,"High: 39.7% (FY00-05)\nLow: -17.2% (FY93-98)"]
[null,null,"Other Local\nRevenue ",{"$f":"D11-D7-D8-D9","v":446.79999999999978},{"$f":"((1+(F10-D10)/D10)^(1/5))-1","v":2.8738692758400575E-2},{"$f":"'Rev Data'!I8+'Rev Data'!I9+'Rev Data'!I11+'Rev Data'!I12+'Rev Data'!I13+'Rev Data'!I18+'Rev Data'!I22+'Rev Data'!I24","v":514.79999999999995},null,null,null,null,{"$f":"W10/100000","v":2.8740000000000002E-2},null,{"$f":"D10*((1+K10)^5)","v":514.80327084851797},null,{"$f":"IF(AF10=TRUE,AG10,\"  \")","v":"  "},null,null,null,null,null,null,null,2874,2874,null,null,null,null,null,null,false,false,"High: 8.6% (FY01-06)\nLow: -0.1% (FY06-11)"]
[null,null," Total",{"$f":"'Rev Data'!D25-'Rev Data'!D15-'Rev Data'!D16-'Rev Data'!D17","v":3461.6},{"$f":"((1+(F11-D11)/D11)^(1/5))-1","v":3.8704510593160046E-2},{"$f":"F7+F8+F9+F10","v":4185.4000000000005},null,null,null,null,{"$f":"((1+(M11-D11)/D11)^(1/5))-1","v":3.8708044946037301E-2},null,{"$f":"SUM(M7:M10)","v":4185.4712078413559}]
[null,null,null,null,null,null,null,null,null,null,null,"Revenue More / Less than Approved Fiscal Plan:",{"$f":"M11-F11","v":7.1207841355317214E-2}]
[]
[]
[null,null,null,null,null,{"$f":"IF(Dashboard!$L$57>1.5,\"Surplus      \",\"  \")","v":"  "},null,{"$f":"Dashboard!L40","v":"Balanced"},null,{"$f":"IF(Dashboard!$L$57<-1.5,\"   Deficit\",\"  \")","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"Cells X7 - X10 (approved fiscal plan average annual growth rates to four digits, no decimal, correct to allow negatives)"]
[null,null,"Highs & Lows"]

{"sheet":"Rev Var State","index":6,"n_rows":33,"n_cols":33,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,32,6,36],[8,32,8,36],[7,14,7,16],[6,14,6,16],[8,14,8,16],[7,32,7,36],[5,5,5,9],[4,14,5,16],[8,5,8,9],[7,10,7,11],[8,10,8,11],[7,5,7,9],[6,10,6,11],[4,4,4,9],[6,5,6,9],[4,10,4,12],[5,10,5,11]]}
[]
[]
[null,null,"                               1. REVENUE ASSUMPTIONS - State Aid"]
[]
[null,null,null,null,"Approved Fiscal Plan",null,null,null,null,null,"Variable",null,null,null,"Click Boxes Below for \nFY09 - 14 Avg. Annual\nRate of Growth"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)",null,null,null,null,"Avg. Annual Growth Rate",null,"FY19 Amount\n($ millions)"]
[null,null,"State Aid\nto County Govt.\nand MNCPPC",{"$f":"'Rev Data'!D17","v":95.40000000000002},{"$f":"((1+(F7-D7)/D7)^(1/5))-1","v":-3.3874746822276092E-2},{"$f":"'Rev Data'!I17","v":80.3},null,null,null,null,{"$f":"(W7/100000)-0.1","v":-3.3870000000000011E-2},null,{"$f":"D7*((1+K7)^5)","v":80.301972692324824},null,{"$f":"IF(AF7=TRUE,AG7,\"  \")","v":"  "},null,null,null,null,null,null,null,6613,6613,null,null,null,null,null,null,false,false,"- 12.9%"]
[null,null,"State Aid \nto MCPS",{"$f":"'Rev Data'!D15","v":605},0,{"$f":"'Rev Data'!I15","v":605},null,null,null,null,{"$f":"(W8/1000)-0.05","v":0},null,{"$f":"D8*((1+K8)^5)","v":605},null,{"$f":"IF(AF8=TRUE,AG8,\"  \")","v":"  "},null,null,null,null,null,null,null,50,50,null,null,null,null,null,null,false,false,"+ 7.3%"]
[null,null,"State Aid\nto College",{"$f":"'Rev Data'!D16","v":31.7},0,{"$f":"'Rev Data'!I16","v":31.7},null,null,null,null,{"$f":"(W9/1000)-0.05","v":0},null,{"$f":"D9*((1+K9)^5)","v":31.7},null,{"$f":"IF(AF9=TRUE,AG9,\"  \")","v":"  "},null,null,null,null,null,null,null,50,50,null,null,null,null,null,null,false,false,"+ 0.9%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Revenue More / Less than Approved Fiscal Plan:",{"$f":"M7-F7","v":1.9726923248271078E-3}]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(Dashboard!$L$57>1.5,\"Surplus      \",\"  \")","v":"  "},null,{"$f":"Dashboard!L40","v":"Balanced"},null,{"$f":"IF(Dashboard!$L$57<-1.5,\"   Deficit\",\"  \")","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"Cells E8 - E9 (approved fiscal plan average annual growth rates to four digits, no decimal, correct to allow negatives)"]
[null,null,"Cell X7 (approved fiscal plan average annual growth rate to four digits, no decimal)"]
[null,null,"FY09-14"]

{"sheet":"NonOp Assum","index":7,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,4,5,5],[8,7,10,7]]}
[]
[]
[]
[null,null,"                    2. NON-OPERATING EXPENSES ASSUMPTIONS"]
[]
[null,null,null,null,"Approved Fiscal Plan"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)"]
[null,null,"Debt Service",{"$f":"'NonOp Data'!D5","v":313.3},{"$f":"'NonOp Data'!K5","v":4.8388512768665404E-2},{"$f":"'NonOp Data'!I5","v":396.8},null,"Major Fiscal Plan Assumptions\n"]
[null,null,"OPEB \nPre-Funding",{"$f":"'NonOp Data'!D6","v":138},{"$f":"'NonOp Data'!K6","v":2.8476285758364916E-2},{"$f":"'NonOp Data'!I6","v":158.80000000000001},null,"  • Debt service consistent with \n    current borrowing policy\n\n  • Full funding of OPEB requirement \n    beginning in FY15\n\n  • PAYGO at 10% of borrowing costs\n"]
[null,null,"PAYGO / \nCIP Current \nRevenue",{"$f":"'NonOp Data'!D7","v":83.7},{"$f":"'NonOp Data'!K7","v":7.3812584761584699E-2},{"$f":"'NonOp Data'!I7","v":119.5}]
[null,null,"Stabilization \nFund /\nSet Aside",{"$f":"'NonOp Data'!D8","v":21.999999999999986},{"$f":"'NonOp Data'!K8","v":0.1554072922851748},{"$f":"'NonOp Data'!I8","v":45.299999999999955}]
[null,null,"Change in \nReserves",{"$f":"'NonOp Data'!D9","v":-106.80000000000001},"--",{"$f":"'NonOp Data'!I9","v":8.1999999999999993}]
[null,null," Total ",{"$f":"SUM(D8:D12)","v":450.2},{"$f":"'NonOp Data'!K10","v":0.1010745770869399},{"$f":"SUM(F8:F12)","v":728.6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"All assumptions"]

{"sheet":"NonOp Var","index":8,"n_rows":38,"n_cols":23,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,10,5,11],[6,6,6,8],[11,5,11,9],[12,5,12,9],[7,5,7,9],[5,4,5,9],[9,5,9,9],[8,5,8,9],[10,5,10,9]]}
[]
[]
[]
[null,null,"                    2. NON-OPERATING EXPENSES ASSUMPTIONS"]
[]
[null,null,null,null,"Approved Fiscal Plan",null,null,null,null,null,"Variable"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate",null,"FY19 Amount\n($ millions)",null,null,null,"Avg. Annual Growth Rate","FY19 Amount\n($ millions)"]
[null,null,"Debt Service",{"$f":"'NonOp Data'!D5","v":313.3},{"$f":"'NonOp Data'!K5","v":4.8388512768665404E-2},{"$f":"'NonOp Data'!I5","v":396.8},null,null,null,null,{"$f":"V8/100000","v":4.8390000000000002E-2},{"$f":"D8*((1+K8)^5)","v":396.80281448652227},null,null,null,null,null,null,null,null,null,4839,4839]
[null,null,"OPEB \nPre-Funding",{"$f":"'NonOp Data'!D6","v":138},{"$f":"'NonOp Data'!K6","v":2.8476285758364916E-2},{"$f":"'NonOp Data'!I6","v":158.80000000000001},null,null,null,null,{"$f":"(V9/100000)","v":2.8479999999999998E-2},{"$f":"D9*((1+K9)^5)","v":158.80286747414607},null,null,null,null,null,null,null,null,null,2848,2848]
[null,null,"PAYGO / \nCIP Current \nRevenue",{"$f":"'NonOp Data'!D7","v":83.7},{"$f":"'NonOp Data'!K7","v":7.3812584761584699E-2},{"$f":"'NonOp Data'!I7","v":119.5},null,null,null,null,{"$f":"V10/100000","v":7.3810000000000001E-2},{"$f":"D10*((1+K10)^5)","v":119.49856177173392},null,null,null,null,null,null,null,null,null,7381,7381]
[null,null,"Stabilization \nFund /\nSet Aside",{"$f":"'NonOp Data'!D8","v":21.999999999999986},{"$f":"'NonOp Data'!K8","v":0.1554072922851748},{"$f":"'NonOp Data'!I8","v":45.299999999999955},null,null,null,null,{"$f":"(V11/100000)","v":0.15540999999999999},{"$f":"D11*((1+K11)^5)","v":45.300530808734308},null,null,null,null,null,null,null,null,null,15541,15541]
[null,null,"Change in \nReserves",{"$f":"'NonOp Data'!D9","v":-106.80000000000001},"--",{"$f":"'NonOp Data'!I9","v":8.1999999999999993},null,null,null,null,"--",{"$f":"F12","v":8.1999999999999993}]
[null,null," Total ",{"$f":"SUM(D8:D12)","v":450.2},{"$f":"'NonOp Data'!K10","v":0.1010745770869399},{"$f":"'NonOp Data'!I10","v":728.6},null,null,null,null,{"$f":"((1+(L13-D13)/D13)^(1/5))-1","v":0.10107602015915584},{"$f":"SUM(L8:L12)","v":728.60477454113652}]
[null,null,null,null,null,null,null,null,null,null,"Spending More / Less than Approved Fiscal Plan:",{"$f":"L13-F13","v":4.7745411364985557E-3}]
[]
[]
[null,null,null,null,null,{"$f":"IF(Dashboard!$L$57>1.5,\"Surplus      \",\"  \")","v":"  "},null,{"$f":"Dashboard!L40","v":"Balanced"},null,{"$f":"IF(Dashboard!$L$57<-1.5,\"   Deficit\",\"  \")","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"Cells W8 - W11 (approved fiscal plan average annual growth rates to four digits, no decimal, correct to allow negatives)"]

{"sheet":"Agency Assum","index":9,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,4,6,5],[9,7,11,9],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[8,7,8,9]]}
[]
[]
[null,null,"3. LOCAL RESOURCES AVAILABLE FOR AGENCY USE"]
[]
[null,null,"  Change in Available Resources from Fiscal Plan",null,null,null,null,{"$f":"'Rev Var'!$M$12+'Rev Var State'!$M$11-'NonOp Var'!$L$14","v":6.8405992543645766E-2},"million"]
[]
[null,null,null,null,"Fiscal Plan at MOE"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)"]
[null,"Available \nCounty Resoures",null,{"$f":"'Cty Res'!C7","v":3026.4000000000005},{"$f":"((1+((F9-D9)/D9))^(1/5))-1","v":2.6950675723319995E-2},{"$f":"'Cty Res'!E7","v":3456.8},null,"Assumptions (not in Fiscal Plan)\n"]
[null,"MCPS",null,{"$f":"'Cty Res'!C8","v":1479.3000000000002},1.3299999999999999E-2,{"$f":"D10*(1+E10)^5","v":1580.3252183817833},null,"  • MCPS funding at MOE level\n     (increases proportional to rate of \n     enrollment growth)\n\n  • MCPS funding includes pension transfer \n    from State\n\n  • Montgomery College funding at MOE level\n     (minimum fixed dollar amount)\n"]
[null,"Montgomery \nCollege",null,{"$f":"'Cty Res'!C9","v":196.8},0,{"$f":"D11*(1+E11)^5","v":196.8}]
[null,"County Gov't / \nMNCPPC",null,{"$f":"'Cty Res'!C10+'Cty Res'!C11","v":1350.3000000000002},{"$f":"((1+(F12-D12)/D12)^(1/5))-1","v":4.4621564364268007E-2},{"$f":"F9-F10-F11","v":1679.6747816182169}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"All assumptions"]

{"sheet":"Agency Var","index":10,"n_rows":55,"n_cols":36,"rows_kept":55,"cut":false,"hidden":false,"merged":[[11,13,11,14],[8,1,8,2],[11,5,11,9],[10,13,10,14],[10,1,10,2],[9,1,9,2],[11,1,11,2],[11,10,11,12],[10,10,10,12],[10,5,10,9],[9,13,9,14],[9,5,9,9],[9,10,9,12],[4,12,4,13],[8,13,8,14],[6,4,6,9],[6,10,6,14],[7,16,8,16],[8,5,8,9],[7,5,7,9],[8,10,8,12],[7,10,7,12],[7,13,7,14]]}
[]
[]
[null,null,"3. LOCAL RESOURCES AVAILABLE FOR AGENCY USE"]
[]
[null,null,"  Change in Available Resources from Fiscal Plan",null,null,null,null,null,null,null,null,{"$f":"'Rev Var'!$M$12+'Rev Var State'!$M$11-'NonOp Var'!$L$14","v":6.8405992543645766E-2},"million"]
[]
[null,null,null,null,"Fiscal Plan at MOE",null,null,null,null,null,"Variable"]
[null,null,null,"FY14 Amount\n($ millions)","Avg. Annual Growth Rate","FY19 Amount\n($ millions)",null,null,null,null,"Avg. Annual Growth Rate",null,null,"FY19 Amount\n($ millions)",null,null,"Overall Annual Avg. Annual Growth Rate (incl. State Aid)"]
[null,"Available \nCounty Resoures",null,{"$f":"'Cty Res'!C7","v":3026.4000000000005},{"$f":"((1+((F9-D9)/D9))^(1/5))-1","v":2.6950675723319995E-2},{"$f":"'Cty Res'!E7","v":3456.8},null,null,null,null,{"$f":"((1+((N9-D9)/D9))^(1/5))-1","v":2.6954740119536691E-2},null,null,{"$f":"N10+N11+N12","v":3456.8684059925431},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY14","FY19"]
[null,"MCPS",null,{"$f":"'Cty Res'!C8","v":1479.3000000000002},1.3299999999999999E-2,{"$f":"D10*(1+E10)^5","v":1580.3252183817833},null,null,null,null,{"$f":"AA10/10000","v":1.3299999999999999E-2},null,null,{"$f":"D10*(1+K10)^5","v":1580.3252183817833},null,null,{"$f":"AJ10","v":9.5112655815763336E-3},null,null,null,null,null,null,null,null,null,133,133,null,null,null,null,null,{"$f":"'Cty Res'!C8+'Rev Assum'!D14","v":2084.3000000000002},{"$f":"N10+'Rev Var State'!M8","v":2185.3252183817831},{"$f":"((1+(AI10-AH10)/AH10)^(1/5))-1","v":9.5112655815763336E-3}]
[null,"Montgomery \nCollege",null,{"$f":"'Cty Res'!C9","v":196.8},0,{"$f":"D11*(1+E11)^5","v":196.8},null,null,null,null,{"$f":"AA11/1000","v":0},null,null,{"$f":"D11*(1+K11)^5","v":196.8},null,null,{"$f":"AJ11","v":0},null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,{"$f":"'Cty Res'!C9+'Rev Assum'!D15","v":228.5},{"$f":"N11+'Rev Var State'!M9","v":228.5},{"$f":"((1+(AI11-AH11)/AH11)^(1/5))-1","v":0}]
[null,"County Gov't / \nMNCPPC",null,{"$f":"'Cty Res'!C10+'Cty Res'!C11","v":1350.3000000000002},{"$f":"((1+(F12-D12)/D12)^(1/5))-1","v":4.4621564364268007E-2},{"$f":"F9-F10-F11","v":1679.6747816182169},null,null,null,null,{"$f":"Z12/100000","v":4.4630072822176008E-2},null,null,{"$f":"D12*(1+K12)^5","v":1679.7431876107598},null,null,{"$f":"AJ12","v":4.0133600508707179E-2},null,null,null,null,null,null,null,null,{"$f":"AA12-5000","v":4463.0072822176007},9463.0072822176007,{"$f":"(AC12*100000)+5000","v":9463.0072822176007},{"$f":"((1+(AD12-D12)/D12)^(1/5))-1","v":4.4630072822176015E-2},{"$f":"F9+L5-N10-N11","v":1679.7431876107607},null,{"$f":"(N12-D12)*(1314/1418.4)","v":305.19483116225194},null,{"$f":"'Cty Res'!C10+'Cty Res'!C11+'Rev Assum'!D13","v":1445.7000000000003},{"$f":"N12+'Rev Var State'!M7","v":1760.0451603030847},{"$f":"((1+(AI12-AH12)/AH12)^(1/5))-1","v":4.0133600508707179E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Spending More / Less than Approved Fiscal Plan:",{"$f":"N9-F9","v":6.8405992542921013E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA14*100000+5000","v":8963.0000000000055}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9630000000000054E-2]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,{"$f":"IF(Dashboard!$L$57>1.5,\"Surplus      \",\"  \")","v":"  "},null,{"$f":"Dashboard!L40","v":"Balanced"},null,{"$f":"IF(Dashboard!$L$57<-1.5,\"   Deficit\",\"  \")","v":"  "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"Projected annual MCPS enrollment growth rate (cell E10)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4.0329099234626131E-2]

{"sheet":" MCG Assum","index":11,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,3,30,10],[13,1,13,3],[14,1,14,3],[27,4,27,8],[15,7,15,8],[10,10,10,13],[14,11,14,12],[10,1,10,4],[15,11,15,12],[11,1,11,3],[11,10,11,12],[14,9,14,10],[15,9,15,10],[12,1,12,3],[13,7,13,10],[13,11,13,12],[14,7,14,8],[12,10,12,12],[2,1,2,13],[7,10,7,12],[8,10,8,12],[5,1,5,3],[7,1,7,3],[4,10,4,13],[4,1,4,4],[8,1,8,3],[5,10,5,12]]}
[]
[]
[null,"4. COUNTY GOVERNMENT BUDGET"]
[]
[null,"Employee Pay",null,null,null,null,null,null,null,null,"Workforce Size"]
[null,"FY14 Average Salary",null,null,69020,null,null,null,null,null,"FY14 FTEs \n(Tax Supported)",null,null,{"$f":"ROUND((5222.64+2503.36),-1)","v":7730}]
[]
[]
[]
[]
[null,"Employee Benefits",null,null,null,null,null,null,null,null,"Operating Expenses"]
[null,"FY14 Average \nBenefit Cost",null,null,32320,null,null,null,null,null,"FY14 Operating Expenses \n(Tax Supported $ millions)",null,null,{"$f":"'Per v Op'!G7/1000000","v":492.01329500000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"benefit load assumption in cells E6 and E11"]

{"sheet":" MCG Var","index":12,"n_rows":44,"n_cols":33,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,13],[6,10,6,12],[7,10,7,12],[5,1,5,3],[6,1,6,3],[7,1,7,3],[5,10,5,12],[4,10,4,13],[4,1,4,4],[6,7,7,7],[12,1,12,3],[12,10,12,12],[9,1,9,4],[9,10,9,13],[10,1,10,3],[10,10,10,12],[11,1,11,3],[11,10,11,12]]}
[]
[]
[null,"4. COUNTY GOVERNMENT BUDGET"]
[]
[null,"Employee Pay",null,null,null,null,null,null,null,null,"Workforce Size",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Agency Var'!K12","v":4.4630072822176008E-2},4.4630072822176008E-2,{"$f":"AA5*10000","v":446.3007282217601}]
[null,"FY14 Average Salary",null,null,69020,null,null,null,null,null,"FY14 FTEs \n(Tax Supported)",null,null,{"$f":"ROUND((5222.64+2503.36),-1)","v":7730}]
[null,"Avg. Annual Growth Rate",null,null,{"$f":"AA7","v":0.08},null,null,null,null,null,"Avg. Annual Growth Rate",null,null,{"$f":"AE7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((AB7)/10000)-0.03","v":0.08},1100,{"$f":"$AC$5+300","v":746.3007282217601},null,{"$f":"((AF7)/10000)-0.03","v":0},300,300]
[null,"Average Annual Change \nin Salary",null,null,{"$f":"E7*E6","v":5521.6},null,null,null,null,null,"Average Annual Change \nin FTEs",null,null,{"$f":"N7*N6","v":0}]
[]
[null,"Employee Benefits",null,null,null,null,null,null,null,null,"Operating Expenses"]
[null,"FY14 Average \nBenefit Cost",null,null,32320,null,null,null,null,null,"FY14 Operating Expenses \n(Tax Supported $ millions)",null,null,{"$f":"'Per v Op'!G7/1000000","v":492.01329500000003}]
[null,"Avg. Annual Growth Rate",null,null,{"$f":"AA12","v":4.4630072822176015E-2},null,null,null,null,null,"Avg. Annual Growth Rate",null,null,{"$f":"AE12","v":4.4630072822176015E-2},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((AB12)/10000)-0.03","v":4.4630072822176015E-2},746.3007282217601,{"$f":"$AC$5+300","v":746.3007282217601},null,{"$f":"((AF12)/10000)-0.03","v":4.4630072822176015E-2},746.3007282217601,{"$f":"$AC$5+300","v":746.3007282217601}]
[null,"Average Annual Change \nin Benefit Cost",null,null,{"$f":"E12*E11","v":1442.4439536127288},null,null,null,null,null,"Average Annual Change \n(Tax Supported $ millions)",null,null,{"$f":"N12*N11","v":21.958589185328773}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Overall Average Annual Growth Rate:",{"$f":"M40","v":5.9568553327897122E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"UPDATE REQUIREMENTS"]
[null,null,"benefit load assumption in cells E6 and E11"]
[null,null,"cell N6"]
[]
[null,null,null,null,{"$f":"(L34*'Per v Op'!$H$6*0.65*(1+E7)^5)-(L34*'Per v Op'!$H$6*0.65)","v":237.43467389524557},null,null,null,null,null,null,{"$f":"'Cty Res'!C11","v":1245.6000000000001},null,{"$f":"((L34*'Per v Op'!H6*0.65*(1+E7))+(L34*'Per v Op'!H6*0.35*(1+E12)))*(((1+N7)^5)-1)","v":0}]
[]
[null,null,null,null,{"$f":"(L34*'Per v Op'!$H$6*0.35*(1+E12)^5)-(L34*'Per v Op'!$H$6*0.35)","v":66.461870086461147},null,null,null,null,null,null,null,null,{"$f":"(L34*'Per v Op'!$H$7*(1+N12)^5)-(L34*'Per v Op'!$H$7)","v":114.00765733125615}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"E34+E36+N34+N36","v":417.90420131296287},{"$f":"((1+L40/L34)^(1/5))-1","v":5.9568553327897122E-2}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(L34*(1+(AB5))^5)-L34","v":303.8987147211451},{"$f":"((1+L41/L34)^(1/5))-1","v":4.4630072822176015E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(L41-L40)*-1","v":114.00548659181777}]

{"sheet":" MCG Compensation","index":13,"n_rows":59,"n_cols":27,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,3,5],[13,2,13,4],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6]]}
[]
[]
[null,"COUNTY GOVERNMENT PAY ADJUSTEMENTS"]
[null,"Average Annual Adjustments"]
[]
[null,null,"MCGEO","FOP","IAFF","Non-Represented"]
[null,"General Wage \nAdjustment (COLA)",{"$f":"N7","v":3.2500000000000001E-2},2.1000000000000001E-2,2.75E-2,3.2500000000000001E-2,null,null,null,null,null,null,null,{"$f":"S7/10000","v":3.2500000000000001E-2},2.1000000000000001E-2,2.75E-2,3.2500000000000001E-2,null,325,210,275,325,null,325,210,275,325]
[null,"Service Increment\n(Step Increase)",3.5000000000000003E-2,{"$f":"O8","v":3.5000000000000003E-2},3.5000000000000003E-2,3.5000000000000003E-2,null,null,null,null,null,null,null,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,null,350,350,350,350,null,350,350,350,350]
[null,"Longevity Increase",{"$f":"IF(S9=1,\"No\",\"Yes (3.0%)\")","v":"Yes (3.0%)"},{"$f":"IF(T9=1,\"No\",\"Yes (3.5%)\")","v":"Yes (3.5%)"},{"$f":"IF(U9=1,\"No\",\"Yes (3.5%)\")","v":"Yes (3.5%)"},{"$f":"IF(V9=1,\"No\",\"Yes (2.0%)\")","v":"Yes (2.0%)"},null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,0,0,0,0]
[]
[null,null,null,null,"Annual Change in County Government Salary Costs:",{"$f":"C59","v":5.6289940089865209E-2},null,null,null,null,null,null,null,{"$f":"(F11*10000)+300","v":862.89940089865206}]
[]
[]
[null,null,"            (excludes additional FY14 and FY15 increments negotiated with FOP and IAFF)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS",null,null,null,null,null,null,null,null,{"$f":"(K9*5)*((#REF!*(1+#REF!)^5)+(#REF!*(1+#REF!)^5))/1000000","v":{"$error":"#REF!"}}]
[null,"cells: S7 - AA9"]
[null,"          C51 - F54",null,null,null,null,null,null,null,null,{"$f":"((1+K12)^5*#REF!)-#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,{"$f":"#REF!+#REF!+K34+K36","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"'Agency Var'!AF12","v":305.19483116225194}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"(I39-I38)*-1","v":{"$error":"#REF!"}}]
[]
[]
[null,{"$f":"SUM(C47:F47)","v":8012},4196,970,966,1880]
[null,{"$f":"SUM(C48:F48)","v":1},{"$f":"C47/B47","v":0.52371442835746385},{"$f":"D47/B47","v":0.12106839740389416},{"$f":"E47/B47","v":0.12056914628057913},{"$f":"F47/B47","v":0.23464802795806292}]
[]
[null,null,"MCGEO","FOP","IAFF","Non-Represented"]
[null,"Percent of Workforce",{"$f":"C48","v":0.52371442835746385},{"$f":"D48","v":0.12106839740389416},{"$f":"E48","v":0.12056914628057913},{"$f":"F48","v":0.23464802795806292}]
[null,"Percent of Eligible for Increment",{"$f":"3221/C47","v":0.7676358436606292},{"$f":"583/D47","v":0.60103092783505152},{"$f":"631/E47","v":0.65320910973084889},{"$f":"1237/F47","v":0.65797872340425534}]
[null,"Percent of Eligible for Longevity",{"$f":"67/C47","v":1.5967588179218305E-2},{"$f":"107/D47","v":0.11030927835051546},{"$f":"61/E47","v":6.3146997929606624E-2},{"$f":"9/F47","v":4.7872340425531915E-3}]
[null,"Longevity Increase",0.03,3.5000000000000003E-2,3.5000000000000003E-2,0.02]
[null,"General Wage \nAdjustment (COLA)",{"$f":"C7*C51","v":1.7020718921617575E-2},{"$f":"D7*D51","v":2.5424363454817776E-3},{"$f":"E7*E51","v":3.3156515227159263E-3},{"$f":"F7*F51","v":7.6260609086370454E-3}]
[null,"Increment\n(Step Increase)",{"$f":"C51*C52*C8","v":1.4070768846729908E-2},{"$f":"D51*D52*D8","v":2.5468047928107842E-3},{"$f":"E51*E52*E8","v":2.7564902646030958E-3},{"$f":"F51*F52*F8","v":5.4037693459810295E-3}]
[null,"Longevity Increase",{"$f":"IF(S9=0,C51*C54*C53,0)","v":2.5087368946580133E-4},{"$f":"IF(T9=0,D51*D54*D53,0)","v":4.6742386420369457E-4},{"$f":"IF(U9=0,E51*E54*E53,0)","v":2.6647528706939594E-4},{"$f":"IF(V9=0,F51*F54*F53,0)","v":2.2466300549176236E-5}]
[]
[null,null,{"$f":"SUM(C55:F57)","v":5.6289940089865209E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Bal Sheet","index":14,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,8],[4,6,4,7],[5,6,5,7],[5,4,5,5],[12,6,14,7],[4,4,4,5],[7,4,7,5],[6,4,6,5],[8,4,8,5],[6,6,6,7],[7,6,7,7],[8,6,8,7],[11,6,11,7]]}
[]
[null,"BALANCE SHEET"]
[null,"(summary of assumptions inputted in model)"]
[]
[null,"LOCAL REVENUE","Change from Fiscal Plan \n($ million)",null,"NON-OPERATING EXPENSES",null,"Change from Fiscal Plan \n($ million)"]
[null,"Property Tax",{"$f":"'Rev Var'!M7-'Rev Var'!F7","v":3.6859148955727505E-2},null,"Debt Service",null,{"$f":"'NonOp Var'!L8-'NonOp Var'!F8","v":2.8144865222543558E-3}]
[null,"Income Tax",{"$f":"'Rev Var'!M8-'Rev Var'!F8","v":2.8832463725620983E-2},null,"OPEB Pre-Funding",null,{"$f":"'NonOp Var'!L9-'NonOp Var'!F9","v":2.8674741460577025E-3}]
[null,"Energy Tax",{"$f":"'Rev Var'!M9-'Rev Var'!F9","v":2.2453801566939546E-3},null,"PAYGO / CIP Current Revenue",null,{"$f":"'NonOp Var'!L10-'NonOp Var'!F10+0.0015","v":6.1771733918135428E-5}]
[null,"Other Local Revenue ",{"$f":"'Rev Var'!M10-'Rev Var'!F10","v":3.2708485180137359E-3},null,"Stabilization Fund / Set Aside",null,{"$f":"'NonOp Var'!L11-'NonOp Var'!F11","v":5.3080873435362719E-4}]
[]
[]
[null,"STATE AID","Change from Fiscal Plan \n($ million)",null,"AGENCY FUNDING","Avg. Annual \nGrowth Rate","Change from Fiscal Plan \n($ million)"]
[null,"MCPS",{"$f":"'Rev Var State'!M8-'Rev Var State'!F8","v":0},null,"MCPS",{"$f":"'Agency Var'!K10","v":1.3299999999999999E-2},{"$f":"'Agency Var'!N13","v":6.8405992542921013E-2}]
[null,"College",{"$f":"'Rev Var State'!M9-'Rev Var State'!F9","v":0},null,"College",{"$f":"'Agency Var'!K11","v":0}]
[null,"County Govt. / MNCPPC",{"$f":"'Rev Var State'!M7-'Rev Var State'!F7","v":1.9726923248271078E-3},null,"County Govt. / MNCPPC",{"$f":"'Agency Var'!K12","v":4.4630072822176008E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,{"$f":"IF(Dashboard!$L$57>1.5,\"Surplus\",\"  \")","v":"  "},{"$f":"Dashboard!L40","v":"Balanced"},{"$f":"IF(Dashboard!$L$57<-1.5,\"Deficit\",\"  \")","v":"  "}]

{"sheet":"Dash Data","index":15,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Revenue",{"$f":"I6","v":3.1724095370756933E-2},{"$f":"0.065-D6","v":3.3275904629243069E-2},null,null,{"$f":"'Rev Var'!D11+'Rev Var State'!D7+'Rev Var State'!D8+'Rev Var State'!D9","v":4193.7},{"$f":"((1+(J6-H6)/H6)^(1/5))-1","v":3.1724095370756933E-2},{"$f":"'Rev Var'!M11+'Rev Var State'!M7+'Rev Var State'!F8+'Rev Var State'!F9","v":4902.4731805336805}]
[]
[null,null,"Non Op",{"$f":"'NonOp Var'!K13","v":0.10107602015915584},{"$f":"0.12-D8","v":1.8923979840844152E-2}]
[]
[]
[null,null,"County Govt / MNCPPC",{"$f":"'Agency Var'!K12","v":4.4630072822176008E-2},{"$f":"6%-D11","v":1.536992717782399E-2}]
[null,null,"College",{"$f":"'Agency Var'!K11","v":0},{"$f":"6%-D12","v":0.06}]
[null,null,"MCPS",{"$f":"'Agency Var'!K10","v":1.3299999999999999E-2},{"$f":"6%-D13","v":4.6699999999999998E-2}]
[]
[]
[null,null,"Operating Expenses",{"$f":"' MCG Var'!N12","v":4.4630072822176015E-2},{"$f":"6%-D16","v":1.5369927177823983E-2}]
[null,null,"FTEs",{"$f":"' MCG Var'!N7","v":0},{"$f":"6%-D17","v":0.06}]
[null,null,"Salaries / Benefits",{"$f":"(' MCG Var'!E7*0.65)+(' MCG Var'!E12*0.35)","v":6.762052548776161E-2},{"$f":"6%-D18","v":-7.6205254877616119E-3}]

{"sheet":"Rev Data","index":16,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[]
["REVENUES"]
[]
["Updated",null,"FY13","FY14","FY15","FY16","FY17","FY18","FY19",null,"Avg. Annual Growth Rate FY14-FY19"]
[null,"TAX REVENUE",{"$f":"SUM(C6:C13)","v":3215.3},3223,3255.9999999999995,3440.5,3595.9,3767.8999999999996,3927.1,null,{"$f":"((1+(I5-D5)/D5)^(1/5))-1","v":4.030894072951785E-2}]
["ü","Property Tax",1461.4,1504.9,1544.3,1587.8,1633.6,1688.6,1752.7,null,{"$f":"((1+(I6-D6)/D6)^(1/5))-1","v":3.095566385248727E-2}]
["ü","Income Tax",1331.4,1299.2,1285.7,1415.4,1511.7,1613.6,1695.4,null,{"$f":"((1+(I7-D7)/D7)^(1/5))-1","v":5.4676412797857843E-2}]
["ü","Transfer Tax",82,85.7,88,92.9,99.7,108.2,115.7,null,6.1867936723134509E-2]
["ü","Recordation Tax",54.5,56.6,57.9,60.8,64.7,69.7,74.099999999999994,null,5.535933350822253E-2]
["ü","Fuel / Energy Tax",219.1,210.7,214.2,217.6,220,221.3,222.5,null,1.095795957233392E-2]
["ü","Telephone Tax",45.4,45.1,44.6,44.2,43.9,43.7,43.5,null,-7.198229430024794E-3]
["ü","Hotel / Motel Tax",18.600000000000001,17.8,18.2,18.5,18.899999999999999,19.3,19.600000000000001,null,1.9453013097845862E-2]
["ü","Admission Tax",2.9,3,3.1,3.3,3.4,3.5,3.6,null,3.7137289336648172E-2]
["ü","INTERGOVERNMENTAL AID",708.3,732.1,733.4,717,717,717,717,null,-4.159580092399473E-3]
["ü","State Aid to MCPS",590.5,605,605,605,605,605,605,null,0]
["ü","State Aid to Mont. College",30.3,31.7,31.7,31.7,31.7,31.7,31.7,null,0]
[null,"Other State Aid",{"$f":"C14-C15-C16","v":87.499999999999957},{"$f":"D14-D15-D16","v":95.40000000000002},96.699999999999974,80.3,80.3,80.3,80.3,null,-3.3874746822276092E-2]
[null,"FEES & FINES",{"$f":"SUM(C19:C21)","v":173.6},189.89999999999998,195.29999999999998,202.1,204.4,207.1,209.89999999999998,null,2.0228602008869778E-2]
["ü","Mont. College Tuition",85.6,87.3,90.8,95.6,95.6,95.6,95.6,null,1.8330448894922746E-2]
["ü","Charges for Services",54.9,69.3,70.599999999999994,72.099999999999994,73.900000000000006,76,78.3,null,2.4721162872832769E-2]
["ü","Other Fees & Fines",{"$f":"11.4+21.7","v":33.1},{"$f":"11.4+21.9","v":33.299999999999997},{"$f":"11.6+22.3","v":33.9},{"$f":"11.8+22.6","v":34.400000000000006},{"$f":"11.9+23","v":34.9},{"$f":"12.1+23.4","v":35.5},{"$f":"12.3+23.7","v":36},null,1.5714502603950908E-2]
["ü","MISCELLANEOUS INCOME",11.5,10.3,10.6,11.2,12.1,12.8,13.6,null,5.7159061519035159E-2]
[null,"TOTAL REVENUES  ",{"$f":"C22+C18+C14+C5","v":4108.7},4155.3,4195.2999999999993,4370.8,4529.3999999999996,4704.7999999999993,4867.6000000000004,null,3.2149246105771967E-2]
["ü","INTERFUND TRANSFERS IN",49.1,38.4,30.6,31.5,32.5,33.6,34.799999999999997,null,{"$f":"((1+(I24-D24)/D24)^(1/5))-1","v":-1.9495471272725995E-2},"Variable Rate","FY19 at Var Rate"]
[null,"AVAILABLE RESOURCES",{"$f":"+C24+C23","v":4157.8},4193.7,4225.8999999999996,4402.3,4561.8999999999996,4738.3999999999996,{"$f":"I24+I23","v":4902.4000000000005},null,{"$f":"((1+(I25-D25)/D25)^(1/5))-1","v":3.1721015187839097E-2},{"$f":"'Rev Var'!K11","v":3.8708044946037301E-2},{"$f":"D25*(1+L25)^5","v":5070.6640294442741}]
[]
[null,null,null,{"$f":"D25-D14","v":3461.6}]
[null,"Source:  Fiscal Plan, Pages 1, 50;  Approved Fiscal Plan (following budget approval) "]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"All entries "]

{"sheet":"NonOp Data","index":17,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
[]
["NON-OPERATING USES"]
[]
["Updated",null,"FY13","FY14","FY15","FY16","FY17","FY18","FY19",null,"Avg. Annual Growth Rate FY14-FY19"]
["ü","Debt Service",297.60000000000002,313.3,348.6,370.7,386.4,391.4,396.8,null,{"$f":"((1+(I5-D5)/D5)^(1/5))-1","v":4.8388512768665404E-2}]
["ü","OPEB Pre-Funding",105.4,138,182.4,177.7,172.5,166.3,158.80000000000001,null,2.8476285758364916E-2]
["ü","PAYGO / CIP Current Revenue",{"$f":"29.5+49.8","v":79.3},{"$f":"29.5+54.2","v":83.7},{"$f":"40.5+61.1","v":101.6},{"$f":"40.5+59.6","v":100.1},{"$f":"58.1+50.5","v":108.6},{"$f":"50.5+69","v":119.5},{"$f":"50.5+69","v":119.5},null,7.3812584761584699E-2]
["ü","Stabilization Fund / Set Aside",{"$f":"C10-C9-C5-C6-C7","v":33.799999999999997},21.999999999999986,41.999999999999886,42.800000000000097,43.600000000000051,44.500000000000057,45.299999999999955,null,0.1554072922851748]
["ü","Change in Reserves",{"$f":"-0.8-1.4+1.2+17.8+11.2","v":28},{"$f":"-(8.3+4.7+27+6.6+60.2)","v":-106.80000000000001},{"$f":"-4.8-0.1+1.6","v":-3.2999999999999994},1.3,8.9,7.5,8.1999999999999993,null,null,"Variable Rate","FY19 at Var Rate"]
["ü","Non-Operating Total ",544.1,450.2,671.3,692.6,720,729.2,728.6,null,0.1010745770869399,{"$f":"'NonOp Var'!K13","v":0.10107602015915584},{"$f":"D10*(1+L10)^5","v":728.60477454113675}]
[]
[]
[null,"Source:  Fiscal Plan, Page 1; Approved Fiscal Plan (following budget approval) "]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"All entries "]

{"sheet":"Rev Sum All Years","index":18,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,0,2,10]]}
[]
[]
["Fiscal Plan Projections: Revenues ($ millions)"]
[]
[null,null,"FY13","FY14","FY15","FY16","FY17","FY18","FY19","Avg. Annual Growth Rate"]
[null,"Total Revenues",{"$f":"'Rev Data'!C23","v":4108.7},{"$f":"'Rev Data'!D25","v":4193.7},{"$f":"'Rev Data'!E25","v":4225.8999999999996},{"$f":"'Rev Data'!F25","v":4402.3},{"$f":"'Rev Data'!G25","v":4561.8999999999996},{"$f":"'Rev Data'!H25","v":4738.3999999999996},{"$f":"'Rev Data'!I25","v":4902.4000000000005},{"$f":"((1+(I6-D6)/D6)^(1/5))-1","v":3.1721015187839097E-2}]
[null,"Property Tax",null,{"$f":"'Rev Data'!D6","v":1504.9},{"$f":"'Rev Data'!E6","v":1544.3},{"$f":"'Rev Data'!F6","v":1587.8},{"$f":"'Rev Data'!G6","v":1633.6},{"$f":"'Rev Data'!H6","v":1688.6},{"$f":"'Rev Data'!I6","v":1752.7},3.095566385248727E-2]
[null,"Income Tax",null,{"$f":"'Rev Data'!D7","v":1299.2},{"$f":"'Rev Data'!E7","v":1285.7},{"$f":"'Rev Data'!F7","v":1415.4},{"$f":"'Rev Data'!G7","v":1511.7},{"$f":"'Rev Data'!H7","v":1613.6},{"$f":"'Rev Data'!I7","v":1695.4},5.4676412797857843E-2]
[null,"State Aid to MCPS",null,{"$f":"'Rev Data'!D15","v":605},{"$f":"'Rev Data'!E15","v":605},{"$f":"'Rev Data'!F15","v":605},{"$f":"'Rev Data'!G15","v":605},{"$f":"'Rev Data'!H15","v":605},{"$f":"'Rev Data'!I15","v":605},0]
[null,"Energy Tax",null,{"$f":"'Rev Data'!D10","v":210.7},{"$f":"'Rev Data'!E10","v":214.2},{"$f":"'Rev Data'!F10","v":217.6},{"$f":"'Rev Data'!G10","v":220},{"$f":"'Rev Data'!H10","v":221.3},{"$f":"'Rev Data'!I10","v":222.5},1.095795957233392E-2]
[null,"Other Revenues ",null,{"$f":"D6-D7-D8-D9-D10","v":573.89999999999964},576.69999999999936,576.49999999999989,591.59999999999968,609.89999999999986,626.80000000000064,1.7790874345261942E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"None"]

{"sheet":" Trends","index":19,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CE Rec Budget"]
[null,"Page 5-15"]
[]
[]
[null,null,"FY14","FY19"]
[null,"Assessable Base",163305,198047,{"$f":"((1+(D7-C7)/C7)^(1/5))-1","v":3.9330703495852548E-2}]
[null,"Per Capita Personal Income",76920,94340,{"$f":"((1+(D8-C8)/C8)^(1/5))-1","v":4.1672788462626231E-2}]
[null,"Population",1007311,1055249,{"$f":"((1+(D9-C9)/C9)^(1/5))-1","v":9.3418358544641311E-3}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"All FY data"]

{"sheet":"Per v Op","index":20,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Schedule B-4"]
[]
[null,"FY14"]
[null,null,"General Fund","Special Funds","Total Tax Supported","OPEB","Total Tax Supported"]
[null,"Personnel",562760330,256736597,{"$f":"D6+C6","v":819496927},null,{"$f":"SUM(C6:D6)","v":819496927},{"$f":"G6/G9","v":0.62484982065202688}]
[null,"Operating",{"$f":"516011992+1749636","v":517761628},118370138,{"$f":"D7+C7","v":636131766},{"$f":"E14","v":144118471},{"$f":"C7+D7-F7","v":492013295},{"$f":"G7/G9","v":0.37515017934797307}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G6:G7)","v":1311510222}]
[]
[]
[]
[null,null,null,null,"OPEB"]
[null,null,null,null,{"$f":"SUM(E15:E18)","v":144118471}]
[null,null,null,null,51319040]
[null,null,null,null,87836000]
[null,null,null,null,2489000]
[null,null,null,null,2474431]
[]
[]
[]
[]
[]
[]
[null,"UPDATE REQUIREMENTS"]
[null,"cells: C6 - F7"]