Citation in context

#q1d79
audit · claytonschools

finance 2020 2021 Audited Financial Report

2020-07-01 Portal: claytonschools Section: 2. District's Other Risk #q1d79

SCHOOL DISTRICT OF CLAYTON SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL - CASH BASIS - SPECIAL REVENUE FUND - UNAUDITED Year ended June 30, 2021 Budgeted amounts Variances - positive (negative) Original Final Actual (budgetary basis) Original to final Final to actual Revenues Local $34,511,200 $32,692,450 $32,418,245 $(1,818,750)$ (274,205) County 267,070 258,180 258,167 (8,890) (13) State 1,499,550 1,512,240 1,457,571 12,690 (54,669) Federal 51,620 488,170 90,744 436,550 (397,426) Other 95,550 95,550 89,787 - (5,763) Total revenues 36,424,990 35,046,590 34,314,514 (1,378,400) (732,076) Expenditures Instruction 28,388,620 28,399,360 27,671,036 (10,740) 728,324 Attendance and guidance 1,362,030 1,364,130 1,385,574 (2,100) (21,444) Health services 128,060 128,060 211,849 - (83,789) Improvement of instruction and professional development 1,162,780 1,249,780 1,114,649 (87,000) 135,131 Media services 603,400 603,400 604,720 - (1,320) Executive administration 1,062,100 1,062,100 1,190,156 - (128,056) Building level administration 1,611,290 1,611,290 1,594,375 - 16,915 Business services 90,000 90,000 - - 90,000 Adult/community programs 3,480 3,480 3,166 - 314 Total expenditures 34,411,760 34,511,600 33,775,525 (99,840) 736,075 Revenues over expenditures $ 2,013,230 $ 534,990 $ 538,989 $(1,478,240)$ 3,999 The accompanying notes are an integral part of this statement. - 67 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING The District follows these procedures in establishing the budgetary data reflected in the financial statements:  In accordance with Chapter 67, RSMo, the District adopts a budget for each fund.  Prior to July, the Superintendent, who serves as the budget officer, submits to the Board a proposed budget for the fiscal year beginning on the following July 1. The proposed budget includes estimated revenues and proposed expenditures for all District funds. Budgeted expenditures cannot exceed beginning available monies plus estimated revenues for the year.  A public hearing is conducted to obtain taxpayer comments. Prior to its approval by the Board, the budget document is available for public inspection.  Prior to July 1, the budget is legally enacted by a vote of the Board.  Subsequent to its formal approval of the budget, the Board has the authority to make necessary adjustments to the budget by formal vote of the Board. For each fund, total fund expenditures may not legally exceed final amended budgeted expenditures. Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 2, 2020, or as amended by the Board at various times during the year.  Budgets are adopted on the cash basis of accounting for all governmental funds. The cash basis is used to enable the District to more accurately budget revenue and expenses as the resources are expended or received. - 68 -

Expenditure appropriations lapse at the end of the fiscal year.  Budgeted amounts are as originally adopted on June 2, 2020, or as amended by the Board at various times during the year.  Budgets are adopted on the cash basis of accounting for all governmental funds. The cash basis is used to enable the District to more accurately budget revenue and expenses as the resources are expended or received. - 68 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING - CONTINUED The following schedule reconciles the revenue and expenditures on the budgetary basis of accounting (cash basis) with the amounts presented under the modified accrual basis of accounting: General Fund Special Revenue Fund Revenues Revenues - cash basis $ 20,794,490 $ 34,314,514 Current year revenue accruals (124,968) (547,891) Prior year revenue accruals (252,903) (200,283) Revenues - modified accrual basis $ 20,416,619 $ 33,566,340 Expenditures Expenditures - cash basis $ 17,521,743 $ 33,775,525 Current year expenditure accruals 70,956 104,255 Prior year expenditure accruals 22,163 (23,650) Expenditures - modified accrual basis $ 17,614,862 $ 33,856,130 - 69 -

SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2021 NOTE A – BUDGETS AND BUDGETARY ACCOUNTING - CONTINUED The following schedule reconciles the revenue and expenditures on the budgetary basis of accounting (cash basis) with the amounts presented under the modified accrual basis of accounting: General Fund Special Revenue Fund Revenues Revenues - cash basis $ 20,794,490 $ 34,314,514 Current year revenue accruals (124,968) (547,891) Prior year revenue accruals (252,903) (200,283) Revenues - modified accrual basis $ 20,416,619 $ 33,566,340 Expenditures Expenditures - cash basis $ 17,521,743 $ 33,775,525 Current year expenditure accruals 70,956 104,255 Prior year expenditure accruals 22,163 (23,650) Expenditures - modified accrual basis $ 17,614,862 $ 33,856,130 - 69 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2021 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PSRS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5208 $ 21,366,213 $ 23,616,628 % 90.47 % 89.34 6/30/2015 % 0.5256 30,342,153 24,305,850 % 124.83 % 85.78 6/30/2016 % 0.5421 40,335,757 25,587,013 % 157.64 % 82.18 6/30/2017 % 0.5510 39,790,604 26,583,036 % 149.68 % 83.77 6/30/2018 % 0.5512 41,022,820 27,049,379 % 151.00 % 84.06 6/30/2019 % 0.5515 40,701,088 27,606,008 % 147.44 % 84.62 6/30/2020 % 0.5488 49,011,771 27,895,612 % 175.70 % 82.01 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PEERS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5233 $ 1,910,913 $ 7,630,413 % 25.04 % 91.33 6/30/2015 % 0.5044 2,667,803 7,563,393 % 35.27 % 88.28 6/30/2016 % 0.5122 4,109,561 7,908,987 % 51.96 % 83.32 6/30/2017 % 0.5064 3,863,583 8,137,380 % 47.48 % 85.35 6/30/2018 % 0.4976 3,844,992 8,279,018 % 46.44 % 86.06 6/30/2019 % 0.4942 3,908,930 8,571,837 % 45.60 % 86.38 6/30/2020 % 0.4788 4,647,029 8,615,269 % 53.94 % 84.06 - 70 -

SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2021 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PSRS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5208 $ 21,366,213 $ 23,616,628 % 90.47 % 89.34 6/30/2015 % 0.5256 30,342,153 24,305,850 % 124.83 % 85.78 6/30/2016 % 0.5421 40,335,757 25,587,013 % 157.64 % 82.18 6/30/2017 % 0.5510 39,790,604 26,583,036 % 149.68 % 83.77 6/30/2018 % 0.5512 41,022,820 27,049,379 % 151.00 % 84.06 6/30/2019 % 0.5515 40,701,088 27,606,008 % 147.44 % 84.62 6/30/2020 % 0.5488 49,011,771 27,895,612 % 175.70 % 82.01 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios – PEERS Year ended* Proportion of the Net Pension Liability (Asset) Proportionate share of the Net Pension Liability (Asset) Actual member payroll Net Pension Liability (Asset) as a percentage of covered payroll Fiduciary Net Position as a percentage of total pension liability 6/30/2014 % 0.5233 $ 1,910,913 $ 7,630,413 % 25.04 % 91.33 6/30/2015 % 0.5044 2,667,803 7,563,393 % 35.27 % 88.28 6/30/2016 % 0.5122 4,109,561 7,908,987 % 51.96 % 83.32 6/30/2017 % 0.5064 3,863,583 8,137,380 % 47.48 % 85.35 6/30/2018 % 0.4976 3,844,992 8,279,018 % 46.44 % 86.06 6/30/2019 % 0.4942 3,908,930 8,571,837 % 45.60 % 86.38 6/30/2020 % 0.4788 4,647,029 8,615,269 % 53.94 % 84.06 - 70 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2021 Schedule of Employer Contributions - PSRS Year ended Contractually required contribution Actual employer contributions Contributions excess / (deficiency) Covered payroll Contributions as a percentage of covered payroll 6/30/2013 $ 3,360,070 $ 3,360,070 $ - $ 23,695,943 % 14.18 6/30/2014 3,353,834 3,353,834 - 23,616,628 % 14.20 6/30/2015 3,450,675 3,450,675 - 24,305,850 % 14.20 6/30/2016 3,631,138 3,631,138 - 25,587,013 % 14.19 6/30/2017 3,768,984 3,768,984 - 26,583,036 % 14.18 6/30/2018 3,843,008 3,843,008 - 27,049,379 % 14.21 6/30/2019 3,925,649 3,925,649 - 27,606,008 % 14.22 6/30/2020 3,972,917 3,972,917 - 27,895,612 % 14.24 6/30/2021 4,119,081 4,119,081 - 29,007,613 % 14.20 Schedule of Employer Contributions - PEERS Year ended Contractually required contribution Actual employer contributions Contributions excess / (deficiency) Covered payroll Contributions as a percentage of covered payroll 6/30/2013 $ 535,396 $ 535,396 $ - $ 7,805,015 % 6.86 6/30/2014 523,447 523,447 - 7,630,413 % 6.86 6/30/2015 518,849 518,849 - 7,563,393 % 6.86 6/30/2016 542,557 542,557 - 7,908,987 % 6.86 6/30/2017 558,224 558,224 - 8,137,380 % 6.86 6/30/2018 567,941 567,941 - 8,279,018 % 6.86 6/30/2019 588,545 588,545 - 8,571,837 % 6.87 6/30/2020 591,055 591,055 - 8,615,269 % 6.86 6/30/2021 587,375 587,375 - 8,562,318 % 6.86 Note: These schedules are intended to show information for ten years. Additional years will be displayed as they become available. *The data provided in the schedules is based as of the measurement date of the System's net pension liability, which is as of the beginning of the District's fiscal year. - 71 -

SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year ended June 30, 2021 Schedule of Employer Contributions - PSRS Year ended Contractually required contribution Actual employer contributions Contributions excess / (deficiency) Covered payroll Contributions as a percentage of covered payroll 6/30/2013 $ 3,360,070 $ 3,360,070 $ - $ 23,695,943 % 14.18 6/30/2014 3,353,834 3,353,834 - 23,616,628 % 14.20 6/30/2015 3,450,675 3,450,675 - 24,305,850 % 14.20 6/30/2016 3,631,138 3,631,138 - 25,587,013 % 14.19 6/30/2017 3,768,984 3,768,984 - 26,583,036 % 14.18 6/30/2018 3,843,008 3,843,008 - 27,049,379 % 14.21 6/30/2019 3,925,649 3,925,649 - 27,606,008 % 14.22 6/30/2020 3,972,917 3,972,917 - 27,895,612 % 14.24 6/30/2021 4,119,081 4,119,081 - 29,007,613 % 14.20 Schedule of Employer Contributions - PEERS Year ended Contractually required contribution Actual employer contributions Contributions excess / (deficiency) Covered payroll Contributions as a percentage of covered payroll 6/30/2013 $ 535,396 $ 535,396 $ - $ 7,805,015 % 6.86 6/30/2014 523,447 523,447 - 7,630,413 % 6.86 6/30/2015 518,849 518,849 - 7,563,393 % 6.86 6/30/2016 542,557 542,557 - 7,908,987 % 6.86 6/30/2017 558,224 558,224 - 8,137,380 % 6.86 6/30/2018 567,941 567,941 - 8,279,018 % 6.86 6/30/2019 588,545 588,545 - 8,571,837 % 6.87 6/30/2020 591,055 591,055 - 8,615,269 % 6.86 6/30/2021 587,375 587,375 - 8,562,318 % 6.86 Note: These schedules are intended to show information for ten years. Additional years will be displayed as they become available. *The data provided in the schedules is based as of the measurement date of the System's net pension liability, which is as of the beginning of the District's fiscal year. - 71 - SCHOOL DISTRICT OF CLAYTON SCHEDULE OF CHANGES IN TOTAL OPEB LIABILITY AND RELATED RATIOS - UNAUDITED Year ended June 30, 2021 2021 2020 2019 2018 Total OPEB liability Service Cost $ 289,758 $ 216,081 $ 264,514 $ 270,318 Interest on total OPEB liability 116,915 205,795 213,641 199,304 Effect of liability gains or losses - (1,530,458) - - Changes in assumptions 29,005 657,732 211,954 (160,959) Benefit payments (219,114) (205,185) (357,661) (341,928) Net change in total OPEB liability 216,564 (656,035) 332,448 (33,265) Total OPEB liability at beginning of year 5,109,453 5,765,488 5,433,040 5,466,305 Total OPEB liability at end of year $ 5,326,017 $ 5,109,453 $ 5,765,488 $ 5,433,040 - Covered Payroll $ 33,349,789 $ 32,481,736 $ 32,341,024 $ 31,688,037 Total OPEB liability as a percentage of covered payroll % 15.97 % 15.73 % 17.83 % 17.15 Note: This schedule is to present information for 10 years. Additional years will be presented as they become available. Plan Assets No assets are accumulated in a trust that meets all of the following criteria of GASB Statement No. 75, paragraph 4, to pay benefits:  Contributions from the employer and any nonemployer contributing entities, and earnings thereon, must be irrevocable.  Plan assets must be dedicated to providing OPEB to plan members in accordance with the benefit terms.  Plan assets must be legally protected from the creditors of the employer, nonemployer contributing entities, the plan administrator, and plan members. - 72 -

Open full document View original source Report an error →