Skip to content

1-10-24 Presentation

Monthly financial reports · Finance Committee · January 10, 2024 · 28 pages · 4,765 words · all RSU 5 documents · the district's file →

Text copied out by software, not the document itself. Layout, tables and figures may not survive. The district's copy is authoritative; check it before relying on this text.

Item #10.A.

568  %RDUG RI 'LUHFWRUV &RVW 6KDULQJ 'LVFXVVLRQ

'DWH -DQXDU\  

7R 568 1R %RDUG RI 'LUHFWRUV )URP )LQDQFH &RPPLWWHH 5( &RVW 6KDULQJ

$WWDFKHG SOHDVH ILQG EDFNJURXQG LQIRUPDWLRQ IURP SUHYLRXV FRVW VKDULQJ GLVFXVVLRQV WR KHOS SURYLGH FRPPRQ LQIRUPDWLRQ DFURVV DOO WKH ERDUG PHPEHUV DV ZHOO DV SRWHQWLDO VFHQDULRV IRU FRQVLGHUDWLRQ

 &RVW 6KDULQJ   )LQDQFH &RPPLWWHH 3UHVHQWDWLRQ

  568  &RVW 6KDULQJ  6X]DQ %HDXGRLQ 3UHVHQWDWLRQ      568  %RDUG %XGJHW ,PSDFW  6XPPDU\  ('   'DWHG   6FHQDULRV  DQG 

1

&RVW 6KDULQJ  )URP WKH  %RDUG 0HHWLQJ $Q H[SODQDWLRQ RI WKH 568  FRVW VKDULQJ PHWKRG

568  $QQXDO %XGJHW FRQVLVWV RI

5HTXLUHG /RFDO &RQWULEXWLRQ

 /RFDO &RVW 6KDULQJ  7RWDO 2XWVLGH &RQWULEXWLRQ WR WKH 568

7RWDO 568  %XGJHW

Ɣ 5HTXLUHG /RFDO &RQWULEXWLRQ 5/&  WKH DPRXQW UHTXLUHG WR EH UDLVHG ORFDOO\ WR TXDOLI\ IRU VWDWH VXEVLG\ (DFK WRZQ¶V 5/& LV FRPPXQLFDWHG LQ WKH ('  6HFWLRQ &

Ɣ /RFDO &RVW 6KDULQJ LQFOXGHV

ż $GGLWLRQDO /RFDO 0RQH\ $/0 LV ORFDOO\ GHWHUPLQHG HGXFDWLRQ VSHQGLQJ EH\RQG WKH PLQLPXP UHTXLUHG E\ WKH VWDWH ż $Q\ DGGLWLRQDO DPRXQW UDLVHG WR PHHW WKH 0LO ([SHFWDWLRQ EH\RQG WKH 5/& FXUUHQWO\ RQO\ DSSOLFDEOH IRU )UHHSRUW  ,Q WKH 5HRUJDQL]DWLRQ 3ODQ WKH FRPPLWWHH DJUHHG WKDW WKH 7RWDO 5/& IRU HDFK WRZQ ZDV VHW E\ WKH ('  6HFWLRQ % WR DFKLHYH DQ HTXDOL]HG PLO

Ɣ 7RWDO 2XWVLGH &RQWULEXWLRQ WR WKH 568 72& LQFOXGHV DOO UHYHQXH IURP WKH VWDWH H[FHSW VWDWH IXQGHG GHEW VHUYLFH DQG DOO RWKHU UHYHQXHV UHFHLYHG E\ WKH 568 IURP VRXUFHV RWKHU WKDQ PXQLFLSDO WD[ UHYHQXHV

ż 6WDWH VXEVLG\  DPRXQWV GHWHUPLQHG DQQXDOO\ E\ WKH VWDWH ż 0LQLPXP 6SHFLDO (GXFDWLRQ $GMXVWPHQW  DPRXQW GHWHUPLQHG DQQXDOO\ E\ WKH VWDWH ż $Q\ 2WKHU DGMXVWPHQWV IURP (' 

 568 &RVW 6KDULQJ 0HWKRG 3UHVHQWDWLRQ  S  *ORVVDU\ RI 568 &RVW 6KDULQJ 0HWKRG 3UHVHQWDWLRQ  S

2

&XUUHQW &RVW 6KDULQJ )RUPXOD

7KH 568  FRVW VKDULQJ IRUPXOD RQO\ DSSOLHV WR WKH $GGLWLRQDO /RFDO 0RQH\ $/0 SRUWLRQ RI WKH EXGJHW

$GGLWLRQDO /RFDO 0RQH\ $/0 LV ORFDOO\ GHWHUPLQHG HGXFDWLRQ VSHQGLQJ EH\RQG WKH PLQLPXP UHTXLUHG E\ WKH VWDWH 7KLV DPRXQW LV WKH 7RWDO 568 6SHQGLQJ %XGJHW PLQXV 7RWDO 2XWVLGH &RQWULEXWLRQ WR WKH 568 PLQXV 7RWDO 5HTXLUHG /RFDO &RQWULEXWLRQ

([DPSOH )<  WKH WRWDO $/0 ZDV  DERXW  RI WKH WRWDO RSHUDWLQJ EXGJHW RI 

7RWDO 568 6SHQGLQJ %XGJHW  

 7RWDO 2XWVLGH &RQWULEXWLRQ   7RWDO 5HTXLUHG /RFDO &RQWULEXWLRQ 

$GGLWLRQDO /RFDO 0RQH\ 

&XUUHQW EUHDNGRZQ RI KRZ WKH $/0 LV IXQGHG SXUVXDQW WR WKH FRVW VKDULQJ IRUPXOD Ɣ 'XUKDP  Ɣ )UHHSRUW  Ɣ 3RZQDO 

7KHVH DUH 127 WKH SHUFHQWDJHV RI HDFK WRZQ¶V WRWDO FRQWULEXWLRQ WR WKH EXGJHW  WKH DERYH DUH RQO\ DSSOLHG WR $/0

([DPSOH )<  $/0 WRWDO LV  WKHQ 3RZQDO¶V $/0 LV FDOFXODWHG OLNH WKLV

 ; 



7KH 5HRUJDQL]DWLRQ 3ODQQLQJ &RPPLWWHH 53& XVHG WKH SHUFHQWDJHV RI $/0 HDFK WRZQ FRQWULEXWHG WR WKHLU VFKRRO EXGJHW SULRU WR FRQVROLGDWLRQ LQ WKH EDVH \HDU

3

  ,Q RWKHU ZRUGV HDFK WRZQ SD\V WKH VDPH SHUFHQWDJH RI $/0 FRVWV WKDW LW LQFXUUHG WKH \HDU EHIRUH WKH 568 ZDV IRUPHG

0LO UDWHV 0LO UDWH WD[ UDWH SHU  RI YDOXDWLRQ

$SSOLFDEOH 0LO 5DWH 7KH VWDWH XVHV D VWDQGDUG 0LO ([SHFWDWLRQ WR FDOFXODWH 5/& IRU HDFK WRZQ EDVHG XSRQ D  \HDU DYHUDJH RI WKH WRZQ¶V GHWHUPLQHG YDOXDWLRQ DFFRUGLQJ WR WKH 6WDWH 7KLV 6WDWH YDOXDWLRQ GLIIHUV IURP WKH YDOXDWLRQV WKH WRZQV FDOFXODWH LQGLYLGXDOO\

Ɣ 2Q WKH ('  IURP )<  WKH VWDWH XVHV WKH  \HDU DYHUDJH WR GHWHUPLQH HDFK WRZQ¶V YDOXDWLRQ WKHQ PXOWLSOLHV LW E\ WKH PLO UDWH RI  WR HTXDO WKH WRZQ¶V DQQXDO 5/&

([DPSOH )<  6WDWH YDOXHG 'XUKDP DW  DQG DSSOLHG WKH PLO UDWH RI  WR HTXDO 'XUKDP¶V 5/& RI 

 ; 



0LO H[SHFWDWLRQ LV WKH IXOO YDOXH HGXFDWLRQ PLO UDWH OLVWHG LQ 6HFWLRQ % RI WKH (' 

7RZQ PLO UDWH (DFK WRZQ GHWHUPLQHV LWV RZQ PLO UDWH DQQXDOO\ EDVHG RQ LWV RZQ 7RZQ YDOXDWLRQ LQ RUGHU WR UDLVH WKH IXQGV QHHGHG IRU PXQLFLSDO FRXQW\ DQG VFKRRO H[SHQGLWXUHV 7KHVH UDWHV DUH OLVWHG RQ LQGLYLGXDO SURSHUW\ WD[ ELOOV Ɣ $V RI $SULO   WKH UDWHV DUH DV IROORZV

ż 'XUKDP 7RZQ PLO UDWH  ż )UHHSRUW 7RZQ PLO UDWH  ż 3RZQDO 7RZQ PLO UDWH 

 5HRUJDQL]DWLRQ 3ODQQLQJ &RPPLWWHH )$4¶V  S  6HFWLRQ  6WDWH RI 0DLQH '2( ('  

4

.HHS LQ PLQG WKH FRVW VKDULQJ PHWKRG PD\ EH FKDQJHG EXW LV QRW UHTXLUHG WR EH FKDQJHG ,I WKH %RDUG GHFLGHV WR FKDQJH WKH H[LVWLQJ IRUPXOD WKH 5HRUJDQL]DWLRQ 3ODQ GLFWDWHV VSHFLILF FULWHULD WKDW PXVW EH FRQVLGHUHG

5HTXLUHG FULWHULD

7KH 568 %RDUG VKDOO FRQVLGHU DOO IDFWRUV LW GHHPV UHOHYDQW EXW LV UHTXLUHG WR FRQVLGHU WKH IROORZLQJ

ż )DLUQHVV RI WKH FRVW VKDULQJ PHWKRG LQ OLJKW RI DW OHDVW WKH IROORZLQJ IDFWRUV Ŷ 5HODWLYH VWDWH YDOXDWLRQV UHSUHVHQWLQJ HDFK PXQLFLSDOLW\¶V DELOLW\ WR UDLVH UHYHQXH Ŷ 5HODWLYH SRSXODWLRQV UHSUHVHQWLQJ HDFK PXQLFLSDOLW\¶V ERDUG UHSUHVHQWDWLRQ LQ WKH EXGJHWLQJ SURFHVV Ŷ 6WXGHQW KHDGFRXQWV UHSUHVHQWLQJ HDFK PXQLFLSDOLW\¶V VWXGHQW XVDJH RI 568 IDFLOLWLHV DQG SURJUDPV ż (IIHFW RI WKH FRVW VKDULQJ PHWKRG RQ WKH 568¶V DELOLW\ WR UDLVH VXIILFLHQW IXQGV WR VXVWDLQ HGXFDWLRQDO SURJUDPV GHHPHG WR EH LQ WKH EHVW LQWHUHVW RI VWXGHQWV ż &ODULW\ RI WKH PHWKRG LQFOXGLQJ HDVLO\ XQGHUVWRRG E\ WKH SXEOLF HDVLO\ XQGHUVWRRG DQG LPSOHPHQWHG E\ DGPLQLVWUDWLRQ DYRLGLQJ XQFHUWDLQW\ RYHU WKH PHWKRG¶V DSSOLFDWLRQ ż &RQVLVWHQF\ RI WKH PHWKRG ZLWK 568 RSHUDWLQJ DV D VLQJOH FRKHVLYH HQWLW\ ż (IIHFW RI WKH PHWKRG RQ VWDELOLW\ RI 568 UHYHQXH VWUHDPV DQG ORFDO WD[SD\HU REOLJDWLRQV

 5HRUJDQL]DWLRQ 3ODQ 6HFWLRQ ' S 

5

568  7RWDO &RQWULEXWLRQ E\ 0XQLFLSDOLW\ )< 

)<          5/&          $/0          72&           7RWDO &RQWULEXWLRQ    7RWDO         3XSLO
                                                          5/&$/0            &RQWULEXWLRQ   &RXQW
                                                         72&

'XUKDP                                         

)UHHSRUW                                        

3RZQDO                                            

$GGLWLRQDO WHUPV DQG GHILQLWLRQV

('  0DLQH 'HSDUWPHQW RI (GXFDWLRQ IRUP WKDW VKRZV WKH VFKRRO IXQGLQJ QHHGHG WR VXSSRUW (VVHQWLDO 3URJUDPV DQG 6HUYLFHV WKH SURJUDPV DQG UHVRXUFHV WKDW DUH HVVHQWLDO IRU VWXGHQWV WR KDYH DQ HTXLWDEOH RSSRUWXQLW\ WR DFKLHYH 0DLQH V /HDUQLQJ 5HVXOWV 

0LQLPXP 6SHFLDO (GXFDWLRQ DGMXVWPHQW &XUUHQWO\ DSSOLFDEOH WR )UHHSRUW RQO\ )RU PLQLPXP UHFHLYHUV WKH VWDWH VWLOO SURYLGHV IXQGV WR VXSSRUW VSHFLDO HGXFDWLRQ 7KH DGGLWLRQDO DPRXQW DERYH VWDWH VXEVLG\ QHFHVVDU\ WR PHHW WKH JXDUDQWHHG PLQLPXP VWDWH VKDUH IRU VSHFLDO HGXFDWLRQ

6WDWH 6XEVLG\ LV WKH DPRXQW RI VWDWH IXQGLQJ WKDW ZLOO EH SURYLGHG WR WKH 568 LI WKH 5/& LV DSSURYHG ORFDOO\ LQ RUGHU WR PHHW WKH (VVHQWLDO 3URJUDPV DQG 6HUYLFHV ,I D

PXQLFLSDOLW\ LV DEOH WR UDLVH WKH IXOO DPRXQW IRU (36 EDVHG RQ LWV YDOXDWLRQ LW UHFHLYHV QR VWDWH VXEVLG\

7RWDO 2XWVLGH &RQWULEXWLRQ WR WKH 568 LQFOXGHV DOO UHYHQXHV UHFHLYHG E\ WKH 568 IURP VRXUFHV RWKHU WKDQ PXQLFLSDO WD[ UHYHQXHV IRU D JLYHQ \HDU PLQXV DQ DPRXQW HTXDO WR SULQFLSDO DQG LQWHUHVW SD\PHQWV RQ VWDWHSDUWLFLSDWLQJ GHEW 

2WKHU DGMXVWPHQWV IURP ('  VXFK DV 5HJLRQDOL]DWLRQ DQG (IILFLHQF\ $VVLVWDQFH

 5/& DQG $/0 QXPEHUV IURP 568 %RDUG )< %XGJHW ,PSDFW 6XPPDU\  7RWDO &RQWULEXWLRQ GLYLGHG E\ 2SHUDWLQJ %XGJHW OHVV 6KDUHG 5HYHQXH$LG 568 %RDUG )< %XGJHW ,PSDFW 6XPPDU\   3HUFHQWDJHV EDVHG RQ SXSLO FRXQW SHU 568 GDWD DV RI  'XUKDP  )UHHSRUW  3RZQDO  IRU 7RWDO RI   ('  6HFWLRQ $  ('  6HFWLRQ %

6

7

8

9

10

1/4/24

RSU #05 COST SHARING

Prepared by Suzan Beaudoin Consulting LLC sbeaudoinllc@gmail.com 2/8/2023

1

• School funding in Maine is based on Essential Programs and Services (EPS), which are defined as the programs and resources that are essential for students to have an equitable opportunity to achieve Maine's Learning Results.

• The EPS formula determines both the State and local share of funding needed for each School Administrative Unit (SAU) to have Essential Programs and Services. The funding formula is designed to respond to student needs and is based on State School Funding years of research and information gleaned from high EPS Formula performing, cost-effective school units.

• Each year, every district in the State receives a document known as the “ED 279”. This is the annual State Calculation for Funding Education (PreK-12) Report which shows the various components that go into the funding formula.

2

11 1

1/4/24

Key Operating Cost Components to Determine EPS:

• Student Demographics (School Administrative Unit (SAU) Pupil Counts for PreK-K, 1-5, 6-8, 9-12 and Specialized Student Populations)

• EPS Per Pupil Rate for Each SAU (Per Pupil Amounts Tailored for Each Unit Which Reflect Costs for Personnel, Administration, & Instructional Support)

• Weighted Amounts (Additional Per Pupil Amounts for English Learners and Economically Disadvantaged Pupils)

• Targeted Amounts (Additional Per Pupil Amounts for 4YO/PreK Determining EPS Pupils, 4YO/ K-2 Pupils, Student Assessment, and Technology Resources)

• Other Adjustments (Isolated Small Schools, Adult Education, and Equivalent Instruction) Other Cost Components to Determine EPS:

• Other Subsidizable Costs (Gifted & Talented, Special Education, Transportation and Buses)

• Teacher Retirement Costs (Normalized Costs)

• Debt Service (State Board approved bond payments and approved lease payments)

3

• State and Local Share: EPS calculates the share of the costs between State and Local: EPS Costs – Local Share* = State Share. *Many local units raise above and beyond what the State requires for local share.

Determining State and • Key Factors in Determining Required Local Share: Local Shares Percentage of students by town within a combined district, used to determine distribution of Total Allocation by Town Valuation by town as provided by the Maine Revenue Service each year, which determines ability to pay Mil Expectation set by calculated recommended funding level each year

4

12 2

1/4/24

• The Required Local contribution is established by the EPS school funding formula.

• There are two calculations the State makes to determine the State and local shares for the Required Local

1. They determine shares based on pupil count

2. They determine based on valuation, the ability of the towns to afford the required cost REQUIRED LOC AL

• If a town’s ability to pay exceeds the required shares based on pupil count, then those towns do not get State subsidy; they are considered Minimum Receivers. Freeport falls into this category.

• The Required Local share is then based on Pupil Count.

5

RSU #05’s the Freeport member town is also eligible for the Minimum Special Education Adjustment (20-A MRSA Section 15689, sub-section 1-B) This adjustment guarantees that Freeport’s State share must equal at least 50% of Freeport’s share (based on Freeport’s percentage of pupils) of the Special Education Cost as calculated by Essential Programs & Services For 2022-2023 Freeport’s EPS Special Education Minimum Special Allocation (ED 279 Section 3 A, lines 2 plus 3) equals Education Adjustment $3,278,567.62 times 57.26% (Freeport’s percentage of pupils) equals $1,877,308 time 50% equals $938,654 for the minimum special education adjustment. This adjustment increases the amount of State subsidy and lowers the Required Local Contribution for Freeport and the school administrative unit as a whole.

6

13 3

1/4/24

School units often have additional costs beyond EPS.

• Durham has DEBT service from New PreK-8 Elementary School and this non-shared debt is solely the responsibility of Durham.

• RSU #05 also has an ADDITIONAL LOCAL amount to raise since the cost of education is greater than the EPS formula. (Over 80% of school Additional Local Share administrative units raise additional local funds.)

• RSU #05 shares the additional local amount based on the percentages established in their approved 2008 RSU reorganization plan.

• Durham 21.42%

• Freeport 65.68%

• Pownal 12.60%

7

RSU #05 Historical Review of Additional Local Raised

Town            2010-2011 to      2015-2016 to 2019-2020 to 2021-2022 to
                 2013-2014         2018-2019    2022-2023    2022-2023
                  Average           Average      Average     Percentage
                 Percentage        Percentage   Percentage    Increase
                  Increase          Increase     Increase
Durham              2.37%             10.93%                8.45%            16.20%
Freeport            2.37%             10.93%                8.45%            16.20%
Pownal              2.37%             10.93%                8.45%            16.20%
RSU Total           2.37%             10.93%              8.45%              16.20%

Note: Due to the set percentages of cost sharing in RSU #05, the percentage Increase for the individual municipalities will be the same as the RSU Total.

8

14 4

1/4/24

Factors that can impact the additional local raised amounts:

• Increase or decrease in the unit’s total budget.

• Increase or decrease in the amount of State subsidy. Revisions in the State school funding law can significantly impact the amount of subsidy a school Factors that can unit may receive. impact Additional • Increase or decrease of the required local Local Share contribution. This can shift funds from the required local contribution category into the additional local raise category.

• Increase or decrease of debt service obligations.

• Increase or decrease in other revenues that support the annual budget – such as tuition revenue and balance forward.

9

Factors that can impact additional local raised

Town                            2010-2011 to   2015-2016 to     2019-2020 to       2021-2022 to
                                 2013-2014      2018-2019        2022-2023          2022-2023
                                  Average        Average          Average           Percentage
                                 Percentage     Percentage       Percentage          Increase
                                  Increase       Increase         Increase
Total Budget                       3.32%          4.85%             3.02%               4.24%
Adjusted State Subsidy             2.52%          4.85%             2.21%               -2.79%
Required Local Contribution        5.32%          3.35%             0.83%               -3.70%
Additional Local Contribution      2.37%          10.93%            8.45%              16.20%
Total Local Contribution           3.14%          5.21%             3.27%               2.90%

10

15 5

1/4/24

Common Cost Sharing Components

• The 55% of RSUs based their cost sharing on percentage of valuations (fiscal capacity).

• However, 48 of the 75 RSUs were formerly School Administrative Districts (SADs) that reformulated into RSUs and kept their existing cost share formulas. Many of these SADs established their cost sharing at a time that the law required it to be based solely on valuation.

• Of the 27 remaining RSUs: Common Cost Sharing • Ten RSUs are based on some combination of percentage of Components valuation (fiscal capacity) and percentage of resident students.

• Five RSUs are based on percentage of valuation (fiscal capacity).

• 10 RSUs are based on some other formula that may include percentage of valuation (fiscal capacity) and percentage of resident students, per-pupil costs or are the same percentage as the EPS formula

• The remaining two RSUs’ cost sharing formulas were unavailable.

11

RSU #05 Percentage of Pupils*

Town            Current         2010-2011 2015-2016               2019-2020          2022-2023
              Cost Sharing       to 2013-   to 2018-               to 2022-          Percentage
              Percentages          2014       2019                   2023             of Pupils
                                 Average    Average                Average
                                Percentage Percentage             Percentage
                                 of Pupils  of Pupils              of Pupils
Durham            21.42%           30.02%          31.12%            31.42%             32.06%
Freeport          65.98%           59.94%          58.60%            57.94%             57.26%
Pownal            12.60%           10.04%          10.28%            10.63%             10.68%

*ED279 Average Subsidizable Pupils from Section 4

12

16 6

1/4/24

RSU #05 Percentage of Valuation*

Town                     Current          2010-2011 2015-2016             2019-2020    2022-2023
                       Cost Sharing        to 2013-   to 2018-             to 2022-    Percentage
                       Percentages           2014       2019                 2023       of Fiscal
                                           Average    Average              Average      Capacity
                                          Percentage Percentage           Percentage
                                           of Fiscal  of Fiscal            of Fiscal
                                           Capacity   Capacity             Capacity
Durham                     21.42%            17.12%          18.05%          17.39%      17.12%
Freeport                   65.98%            73.71%          71.49%          71.84%      72.41%
Pownal                     12.60%             9.17%          10.46%          10.78%      10.47%

*ED279 Fiscal Capacity from Section 4 – valuations as defined by law

13

RSU #05 Comparison of Percentage of Valuation and Percentage of Pupils to Current Formula – utilizing 2022-2023 data

Town                     Current          2022-2023 Percentage            2022-2023    Percentage
                       Cost Sharing       Percentage Difference           Percentage   Difference
                       Percentages         of Pupils    from               of Fiscal      from
                                                      Current              Capacity     Current
Durham                     21.42%            32.06%          10.64%          17.12%      -4.30%
Freeport                   65.98%            57.26%          -8.72%          72.41%      6.43%
Pownal                     12.60%            10.68%          -1.92%          10.47%      -2.13%

14

17 7

1/4/24

RSU #05 Comparison of Percentage of Valuation and Percentage of Pupils to Current Formula – updated to preliminary 2023-2024 data

Town                 Current      2023-2024 Percentage                   2023-2024                 Percentage
                   Cost Sharing   Percentage Difference                  Percentage                Difference
                   Percentages     of Pupils    from                      of Fiscal                   from
                                              Current                     Capacity                  Current
Durham                21.42%        31.63%           10.21%                  17.18%                     -4.24%
Freeport              65.98%        57.60%           -8.38%                  72.31%                     6.33%
Pownal                12.60%        10.77%           -1.83%                  10.51%                      -2.09

15

Recommendations:

• The RSU should consider establishing a cost sharing formula that adjusts for changes in fiscal capacity and pupils for each municipality from year to year.

• Utilizing a combination of percentage of resident pupils and percentage of fiscal capacity (valuations) would provide an equitable method of sharing the additional local costs.

• Resident pupil data, it is best to utilize the pupils indicated on the ED279 Section 4 for consistency. Recommendations • Fiscal capacity data, the RSU should use that same calculation that is used under current EPS School Funding law (below) presented on the ED279 Section 4. This method buffers any large increases from year to year and recognizes the loss of taxable valuation resulting from recent declines.

• Property fiscal capacity. "Property fiscal capacity" means the average of the certified state valuations for the 3 most recent years prior to the most recently certified state valuation or the certified state valuation for the most recent prior year, whichever is lower.

• Should the RSU choose to move forward in changing the cost sharing formula, it would be prudent to phase this change over a three-to-five-year period.

16

18 8

1/4/24

RSU #05 Possible Formulas for Cost Sharing – utilizing 2022-2023 data

Town                  Current            25%            30%            35%       Percentage
                    Cost Sharing        Pupils         Pupils         Pupils      Based on
                    Percentages       75% Fiscal     70% Fiscal     65% Fiscal   EPS 2022-
                                       Capacity       Capacity       Capacity      2023*
Durham                 21.42%           20.86%         21.60%           22.35%     18.72%
Freeport               65.98%           69.62%         67.86%           67.11%     69.82%
Pownal                 12.60%           10.52%         10.53%           10.54%     11.46%

*ED279 Adjusted Local Contribution from Section F

17

RSU #05 Possible Formulas for Cost Sharing Formula – updated to preliminary 2023-2024 data

Town                  Current            25%            30%            35%       Percentage
                    Cost Sharing        Pupils         Pupils         Pupils      Based on
                    Percentages       75% Fiscal     70% Fiscal     65% Fiscal   EPS 2023-
                                       Capacity       Capacity       Capacity      2024*
Durham                 21.42%           20.79%         21.52%           22.24%     18.49%
Freeport               65.98%           68.63%         67.89%           67.16%     70.21%
Pownal                 12.60%           10.58%         10.59%           10.60%     11.30%

*ED279 Adjusted Local Contribution from Section F

18

19 9

1/4/24

R SU #0 5 H is torical Comp aris on of Pe rce n tage of Valu ation an d Pe rc e n tage of P up ils to Cu rre nt Formul a – 20 09 - 20 10 an d p re limin ar y 2 02 3- 20 24 d ata

Town                                               Current                   2009-2010 Percentage                                     2009-2010                              Percentage
                                                 Cost Sharing                Percentage Difference                                    Percentage                             Difference
                                                 Percentages                  of Pupils    from                                        of Fiscal                                from
                                                                                         Current                                       Capacity                               Current
Durham                                              21.42%                           29.37%                      7.95%                     16.31%                                       -5.11%
Freeport                                            65.98%                           59.82%                     -6.16%                     74.39%                                       8.41%
Pownal                                              12.60%                           10.81%                     -1.79%                       9.30%                                      -3.30%

Town                                               Current                   2023-2024 Percentage                                     2023-2024                              Percentage
                                                 Cost Sharing                Percentage Difference                                    Percentage                             Difference
                                                 Percentages                  of Pupils    from                                        of Fiscal                                from
                                                                                         Current                                       Capacity                               Current
Durham                                              21.42%                           31.63%                     10.21%                     17.18%                                       -4.24%
Freeport                                            65.98%                           57.60%                     -8.38%                     72.31%                                       6.33%
Pownal                                              12.60%                           10.77%                     -1.83%                     10.51%                                       -2.09

19

R SU #0 5 H is torical Comp aris on of Valu ation / Fis cal Cap acity an d P u p i ls f rom 2 0 1 8- 20 19 and p re limin ar y 2 0 23- 20 24 d ata

                                                                                                                                           2018-2019          2018-2019
                                                                                                                                              to                 to
ED279 Pupil Counts                           2018-2019       2019-2020        2020-2021       2021-2022       2022-2023       2023-2024    2023-2024          2023-2024
Durham                                           594.0           599.5            619.0           622.0           626.0           640.0                46.0           7.7%
Freeport                                        1,118.0         1,140.0          1,164.0         1,126.5         1,118.0         1,165.5               47.5           4.2%
Pownal                                           203.0           211.5            209.0           205.5           208.5           218.0                15.0           7.4%
Total                                           1,915.0         1,951.0          1,992.0         1,954.0         1,952.5         2,023.5           108.5              5.7%

Increase/(Decrease) over Prior Year
Durham                                                           0.93%            3.25%           0.48%           0.64%           2.24%
Freeport                                                         1.97%            2.11%          -3.22%          -0.75%           4.25%
Pownal                                                           4.19%           -1.18%          -1.67%           1.46%           4.56%
Total                                                            1.88%            2.10%          -1.91%          -0.08%           3.64%

                                                                                                                                           2018-2019          2018-2019
                                                                                                                                              to                 to
ED279 Valuations (Fiscal Capacity)           2018-2019       2019-2020        2020-2021       2021-2022       2022-2023       2023-2024    2023-2024          2023-2024
Durham                                     365,000,000     376,000,000      393,900,000     419,483,333     442,083,333     469,766,667      104,766,667           28.7%
Freeport                                  1,491,750,000   1,526,466,667    1,618,700,000   1,733,083,333   1,869,816,667   1,976,683,333     484,933,333           32.5%
Pownal                                     231,575,000     236,100,000      246,500,000     257,383,333     270,400,000     287,316,667       55,741,667           24.1%
Total                                     2,088,325,000   2,138,566,667    2,259,100,000   2,409,949,999   2,582,300,000   2,733,766,667     645,441,667           30.9%

Increase/(Decrease) over Prior Year
Durham                                                           3.01%            4.76%           6.49%           5.39%           6.26%
Freeport                                                         2.33%            6.04%           7.07%           7.89%           5.72%
Pownal                                                           1.95%            4.40%           4.42%           5.06%           6.26%
Total                                                            2.41%            5.64%           6.68%           7.15%           5.87%

20

20 10

ÂÃ

21

ÂÄ

22

                                                                                               STATE OF MAINE DEPARTMENT OF EDUCATION
ED 279                                                                                                  AUGUSTA 04333                                                                                                          3/28/2023
                                                                                  STATE CALCULATION FOR FUNDING PUBLIC EDUCATION (PreK-12) REPORT
                                            ORG ID : 1449                                                                RSU 05                                                              2023 - 2024

Section 4 : Calculation of Required Local Contribution - Mil Expectation                                                                                                                   Section : 4
      A) Subsidizable Pupils (Excludes Superintendent Transfers for SADs, RSUs & CSDs) by Member Municipality
                                                                                   Average Subsidizable Pupils                                     Oper., Othr Sub, &                          Municipal Debt            Total Municipal
                                                                                                                       Percantage of               Tchr. Ret. Allocation                      Allocation            Alllocation Distribution
                                     Member Municipality                                                                Total Pupils                   Distribution                           Distribution          as a Percentage of Pupils
                 Durham                                                                                640.0                         31.63%               7,770,060.43      +                    1,017,018.18 =                                  8,787,078.61
                 Freeport                                                                             1165.5                        57.60%               14,149,714.86      +                             0.00 =                                14,149,714.86
                 Pownal                                                                                218.0                        10.77%                2,645,701.89      +                             0.00 =                                 2,645,701.89
                                                                           Total                       2,023.5                      100.00%                24,565,477.18                          1,017,018.18                                  25,582,495.36

B)    State Valuation by Member Municipality
                                                                                                                                                                                                                 Total Municipal Allocation Distribution
                                                                                3-Yr Average or Previous                Mil                                                                                                  per Valuation
                             Member Municipality                               Yr State Valuation                   Expectation                                                                                            x Mil Expectation
             Durham                                                                          469,766,667               6.97                                                                                                                  3,274,273.67
             Freeport                                                                       1,976,683,333              6.97                                                                                                                 13,777,482.83
             Pownal                                                                          287,316,667               6.97                                                                                                                  2,002,597.17
                                                                      Total                 2,733,766,667                                                                                                                                   19,054,353.67
C)    Required Local Contribution = the lesser of the previous two calculations :
                                                                                                                                                  Required Local
                                                                                                                 Total Allocation by              Contribution by                                 Calculated    State Contribution by Municipality (Prior
                                 Member Municipality                                                                Municipality                   Municipality                                     Mil Rate    to adjustments)
             Durham                                                                                                        8,787,078.61   -             3,274,273.67                                   6.97                                  5,512,804.94
             Freeport                                                                                                     14,149,714.86   -            13,777,482.83                                   6.97                                   372,232.03
             Pownal                                                                                                        2,645,701.89   -             2,002,597.17                                   6.97                                   643,104.72
                                                                       Total                                              25,582,495.36   -             19,054,353.67                                                                        6,528,141.69
                                                             Preliminary FY 2023-2024 Governor͛s Recommended Funding Level Budget ʹAdjustments may be made to these printouts throughout FY 24

23

                                                                                          STATE OF MAINE DEPARTMENT OF EDUCATION
        ED 279                                                                                     AUGUSTA 04333                                                                                                          3/28/2023
                                                                               STATE CALCULATION FOR FUNDING PUBLIC EDUCATION (PreK-12) REPORT
                                                     ORG ID : 1449                                              RSU 05                                                       2023 - 2024
Section 5: Totals and Adjustments                                                                                                                                      Section : 5
                                                                                                                                      Total Allocation                     Local Contribution                             State Contribution
    A) Total Allocation, Local Contribution, and State Contribution Prior to Adjustment                                                 25,582,495.36                            19,054,353.67                                    6,528,141.69
           4)   Minimum Special Education Adj. for Towns in a RSU                                                                                                                       -772,722.00                                 772,722.00

            Totals after adjustment to Local and State Contributions                                                                25,582,495.36                            18,281,631.67                                    7,300,863.69
B) Other Adjustments to State Contribution Only
      1)    Plus Audit Adjustments                                                                                                                                                                                                    0.00
      2)    Less Audit Adjustments                                                                                                                                                                                                    0.00
      3)    Less Adjustment for Unappropriated Local Contribution                                                                                                                                                                     0.00
      4)    Less Adjustment for Unallocated Balance in Excess of 3%                                                                                                                                                                   0.00
      5)    Special Education Budgetary Hardship Adjustment                                                                                                                                                                           0.00
      6)    Career & Technical Education Center Allocation                                                                                                                                                                            0.00
      7)    Plus Long-Term Drug Treatment Centers Adjustment                                                                                                                                                                          0.00
      8)    Education Service Center Member Allocation                                                                                                                                                                           58,458.60
      9)    Minimum Teacher's Salary Adjustment                                                                                                                                                                                       0.00
      10)   Less MaineCare Seed - Private                                                                                                                                                                                             0.00
      11)   Less MaineCare Seed - Public                                                                                                                                                                                              0.00

C)     Adjusted State Contribution                                                                                                                                                                                             7,359,322.29

Local and State Percentages Prior to Adjustments :                                                                            Local Share % =    74.48 %                       State Share % = 25.52 %

Local and State Percentages After Adjustments :                                                                               Local Share % =    71.46 %                       State Share % = 28.54 %

FYI : 100% EPS Allocation                                                                                                  25,582,495.36

Section F: Adjusted Local Contribution by Town                                                                                                            ***** WARRANT ARTICLE *****
                                                                                   Min. Spec. Ed. RSU                                                                                        Adjusted Local           Adjusted        Adjusted
 Member Municipality                                                              Towns Adj.Sec.5 Line                                                               Total Allocation         Contribution           Percentage        Mil Rate
                                                                                           A4
                   Durham                                                                         0.00                                                                  8,787,078.61                  3,274,273.67        17.91%          6.97
                   Freeport                                                                 772,722.00                                                                 14,149,714.86              13,004,760.83           71.14%          6.58
                    Pownal                                                                        0.00                                                                  2,645,701.89                  2,002,597.17        10.95%          6.97
          Totals                                                                           772,722.00                                                                25,582,495.36              18,281,631.67           100.00%

Preliminary FY 2023-2024 Governor͛s Recommended Funding Level Budget ʹAdjustments may be made to these printouts throughout FY 24

24

FY 2023 / 2024 Scenarios 1 RLC, ALM and non-shared debt numbers from RSU5 Board FY23 Board Budget Impact Summary 2 Revenues received from Maine DOE per ED279 4C and 5A(4) 3 Total Contribution totals the Operating Budget less Shared Revenue/Aid found on RSU5 Board Budget Impact Summary

                                              Non-shared                   Total Contribution 3     % Total                       ALM          Cost
                    RLC 1          ALM 1        debt 1         TOC 2        (RLC+ALM+ TOC)        Contribution       % Pupil Count   Sharing %'s
Current Plan                                                                                                                           Current Plan
Durham            $3,274,277     $2,422,517     $122,377    $5,512,805             $11,331,976          29.99%             31.63%           21.42%
Freeport         $13,777,483     $7,462,077           $0    $1,144,954             $22,384,514          59.24%             57.60%           65.98%
Pownal            $2,002,597     $1,425,010           $0      $643,105              $4,070,712          10.77%             10.77%           12.60%
                 $19,054,357    $11,309,605     $122,377    $7,300,864             $37,787,202

100% Valuation / 0% Pupil Count                                                                                                          100% / 0% Difference $ Difference % of RLC+ALM
Durham            $3,274,277    $1,943,427      $122,377    $5,512,805             $10,852,885          28.72%             31.63%          17.18%      ($479,091)   -9.18%
Freeport         $13,777,483    $8,177,548            $0    $1,144,954             $23,099,985          61.13%             57.60%          72.31%       $715,470     3.26%
Pownal            $2,002,597    $1,188,630            $0      $643,105              $3,834,332          10.15%             10.77%          10.51%      ($236,380)   -7.41%
                 $19,054,357 $11,309,605        $122,377    $7,300,864             $37,787,202

75% Valuation / 25% Pupil Count                                                                                                          75% / 25% Difference      Difference % of RLC+ALM
Durham            $3,274,277    $2,351,831      $122,377    $5,512,805             $11,261,290          29.80%             31.63%          20.79%        ($70,686)     -1.26%
Freeport         $13,777,483    $7,761,694            $0    $1,144,954             $22,684,131          60.03%             57.60%          68.63%       $299,616        1.39%
Pownal            $2,002,597    $1,196,080            $0      $643,105              $3,841,782          10.17%             10.77%          10.58%      ($228,930)      -7.16%
                 $19,054,357 $11,309,605        $122,377    $7,300,864             $37,787,202

70% Valuation / 30% Pupil Count                                                                                                          70% / 30% Difference     Difference % of RLC+ALM
Durham            $3,274,277    $2,433,512      $122,377    $5,512,805             $11,342,970          30.02%             31.63%          21.52%        $10,994       0.19%
Freeport         $13,777,483    $7,678,523            $0    $1,144,954             $22,600,960          59.81%             57.60%          67.89%       $216,445       1.01%
Pownal            $2,002,597    $1,197,570            $0      $643,105              $3,843,272          10.17%             10.77%          10.59%      ($227,440)     -7.11%
                 $19,054,357 $11,309,605        $122,377    $7,300,864             $37,787,202

65% Valuation / 35% Pupil Count                                                                                                          65% / 35% Difference     Difference % of RLC+ALM
Durham            $3,274,277    $2,515,193      $122,377    $5,512,805             $11,424,651          30.23%             31.63%          22.24%        $92,675       1.60%
Freeport         $13,777,483    $7,595,352            $0    $1,144,954             $22,517,789          59.59%             57.60%          67.16%       $133,275       0.62%
Pownal            $2,002,597    $1,199,060            $0      $643,105              $3,844,762          10.17%             10.77%          10.60%      ($225,950)     -7.06%
                 $19,054,357 $11,309,605        $122,377    $7,300,864             $37,787,202

25

60% Valuation / 40% Pupil Count                                                                      60% / 40% Difference     Difference % of RLC+ALM
Durham            $3,274,277    $2,596,873   $122,377   $5,512,805   $11,506,332   30.45%   31.63%     22.96%       $174,356       2.97%
Freeport         $13,777,483    $7,512,181         $0   $1,144,954   $22,434,618   59.37%   57.60%     66.42%        $50,104       0.24%
Pownal            $2,002,597    $1,200,550         $0     $643,105    $3,846,252   10.18%   10.77%     10.62%      ($224,460)     -7.01%
                 $19,054,357 $11,309,605     $122,377   $7,300,864   $37,787,202

50% Valuation / 50% Pupil Count                                                                      50% / 50% Difference     Difference % of RLC+ALM
Durham            $3,274,277    $2,760,235   $122,377   $5,512,805   $11,669,694   30.88%   31.63%     24.41%       $337,718       5.60%
Freeport         $13,777,483    $7,345,840         $0   $1,144,954   $22,268,276   58.93%   57.60%     64.95%      ($116,238)     -0.55%
Pownal            $2,002,597    $1,203,530         $0     $643,105    $3,849,232   10.19%   10.77%     10.64%      ($221,480)     -6.91%
                 $19,054,357 $11,309,605     $122,377   $7,300,864   $37,787,202

0% Valuation / 100% Pupil Count                                                                      0% / 100% Difference     Difference % of RLC+ALM
Durham            $3,274,277    $3,577,043   $122,377   $5,512,805   $12,486,502   33.04%   31.63%     31.63%     $1,154,526      16.85%
Freeport         $13,777,483    $6,514,131         $0   $1,144,954   $21,436,568   56.73%   57.60%     57.60%      ($947,946)     -4.67%
Pownal            $2,002,597    $1,218,430         $0     $643,105    $3,864,132   10.23%   10.77%     10.77%      ($206,580)     -6.41%
                 $19,054,357 $11,309,605     $122,377   $7,300,864   $37,787,202

26

FY 2022 / 2023 Scenarios 1 RLC, ALM and non-shared debt numbers from RSU5 Board FY23 Budget Impact Summary 2 Revenues received from Maine DOE per ED279 4C and 5A(4) 3 Total Contribution totals the Operating Budget less Shared Revenue/Aid found on RSU5 Board Budget Impact Summary

                                              Non-shared                   Total Contribution 3     % Total                       ALM          Cost
                    RLC 1          ALM 1        debt 1         TOC 2        (RLC+ALM+ TOC)        Contribution       % Pupil Count   Sharing %'s
Current Plan                                                                                                                           Current Plan
Durham            $3,138,792     $2,349,657     $125,094    $4,997,167             $10,610,710          29.64%             32.06%           21.42%
Freeport         $13,275,698     $7,237,646           $0      $938,654             $21,451,998          59.92%             57.26%           65.98%
Pownal            $1,919,840     $1,382,151           $0      $438,504              $3,740,495          10.45%             10.68%           12.60%
                 $18,334,330    $10,969,455     $125,094    $6,374,325             $35,803,204

100% Valuation / 0% Pupil Count                                                                                                          100% / 0% Difference $ Difference % of RLC+ALM
Durham            $3,138,792    $1,877,943      $125,094    $4,997,167             $10,138,996          28.32%             32.06%          17.12%      ($471,714)   -9.40%
Freeport         $13,275,698    $7,942,869            $0      $938,654             $22,157,221          61.89%             57.26%          72.41%       $705,222     3.32%
Pownal            $1,919,840    $1,148,643            $0      $438,504              $3,506,987           9.80%             10.68%          10.47%      ($233,508)   -7.61%
                 $18,334,330 $10,969,455        $125,094    $6,374,325             $35,803,204

75% Valuation / 25% Pupil Count                                                                                                          75% / 25% Difference      Difference % of RLC+ALM
Durham            $3,138,792    $2,287,699      $125,094    $4,997,167             $10,548,752          29.46%             32.06%          20.86%        ($61,958)     -1.14%
Freeport         $13,275,698    $7,527,427            $0      $938,654             $21,741,779          60.73%             57.26%          68.62%       $289,780        1.39%
Pownal            $1,919,840    $1,154,329            $0      $438,504              $3,512,673           9.81%             10.68%          10.52%      ($227,823)      -7.41%
                 $18,334,330 $10,969,455        $125,094    $6,374,325             $35,803,204

70% Valuation / 30% Pupil Count                                                                                                          70% / 30% Difference     Difference % of RLC+ALM
Durham            $3,138,792    $2,369,651      $125,094    $4,997,167             $10,630,704          29.69%             32.06%          21.60%        $19,993       0.36%
Freeport         $13,275,698    $7,444,339            $0      $938,654             $21,658,691          60.49%             57.26%          67.86%       $206,692       1.00%
Pownal            $1,919,840    $1,155,466            $0      $438,504              $3,513,810           9.81%             10.68%          10.53%      ($226,685)     -7.37%
                 $18,334,330 $10,969,455        $125,094    $6,374,325             $35,803,204

65% Valuation / 35% Pupil Count                                                                                                          65% / 35% Difference     Difference % of RLC+ALM
Durham            $3,138,792    $2,451,602      $125,094    $4,997,167             $10,712,655          29.92%             32.06%          22.35%       $101,945       1.82%
Freeport         $13,275,698    $7,361,250            $0      $938,654             $21,575,602          60.26%             57.26%          67.11%       $123,604       0.60%
Pownal            $1,919,840    $1,156,603            $0      $438,504              $3,514,947           9.82%             10.68%          10.54%      ($225,548)     -7.33%
                 $18,334,330 $10,969,455        $125,094    $6,374,325             $35,803,204

27

60% Valuation / 40% Pupil Count                                                                      60% / 40% Difference     Difference % of RLC+ALM
Durham            $3,138,792    $2,533,553   $125,094   $4,997,167   $10,794,606   30.15%   32.06%     23.10%       $183,896       3.24%
Freeport         $13,275,698    $7,278,162         $0     $938,654   $21,492,514   60.03%   57.26%     66.35%        $40,515       0.20%
Pownal            $1,919,840    $1,157,740         $0     $438,504    $3,516,084    9.82%   10.68%     10.55%      ($224,411)     -7.29%
                 $18,334,330 $10,969,455     $125,094   $6,374,325   $35,803,204

50% Valuation / 50% Pupil Count                                                                      50% / 50% Difference     Difference % of RLC+ALM
Durham            $3,138,792    $2,697,455   $125,094   $4,997,167   $10,958,508   30.61%   32.06%     24.59%       $347,798       5.96%
Freeport         $13,275,698    $7,111,985         $0     $938,654   $21,326,337   59.57%   57.26%     64.83%      ($125,661)     -0.62%
Pownal            $1,919,840    $1,160,015         $0     $438,504    $3,518,359    9.83%   10.68%     10.57%      ($222,137)     -7.21%
                 $18,334,330 $10,969,455     $125,094   $6,374,325   $35,803,204

0% Valuation / 100% Pupil Count                                                                      0% / 100% Difference     Difference % of RLC+ALM
Durham            $3,138,792    $3,516,967   $125,094   $4,997,167   $11,778,020   32.90%   32.06%     32.06%     $1,167,310      17.54%
Freeport         $13,275,698    $6,281,102         $0     $938,654   $20,495,454   57.24%   57.26%     57.26%      ($956,545)     -4.89%
Pownal            $1,919,840    $1,171,386         $0     $438,504    $3,529,730    9.86%   10.68%     10.68%      ($210,765)     -6.82%
                 $18,334,330 $10,969,455     $125,094   $6,374,325   $35,803,204

28

Source: , linked from www.rsu5.org/board-of-directors-and-policies/board-committees/standing-committees/finance-committee. Text copied out by software (pdftotext); no wording corrected.