Citation in context

#q1e45
audit · claytonschools

finance 2018 2019 Audited Financial Report

2018-07-01 Portal: claytonschools Section: 18. Use of Estimates #q1e45

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, 2019 Variances - Actual eositive (negative) Budgeted amounts (budgetary Original Final Original Final basis) to final to actual Revenues Local $ 28,710,680 $ 25,082,450 $ 26,908,287 $ (3,628,230) $ 1,825,837 County 249,000 242,700 242,944 (6,300) 244 State 1,359,570 1,401 ,740 1,488,243 42,170 86,503 Federal 224,460 142,090 183,242 (82,370) 41,152 Other 388,570 320,000 349,325 (68,570) 29,325 Total revenues 30,932,280 27,188,980 29,172,041 (3,743,300) 1,983,061 Expenditures Instruction 27,600,060 27,668,090 26,895,998 (68,030) 772,092 Attendance and guidance 1,303,860 1,303,860 1,310,617 (6,757) Health Services 112,680 112,680 126,345 (13,665) Improvement of instruction and professional development 584,820 587,730 588,321 (2,910) (591) Media services 606,730 606,730 606,639 91 Executive administration 1,124,880 1,124,880 1,123,656 1,224 Building level administration 1,575,690 1,575,690 1,536,469 39,221 Businss Services 90,000 90,000 90,000 Central office support services 6,960 6,960 6,960 Adult/community programs 14,920 14,920 3,511 11,409 Total expenditures 33,020,600 33,091,540 32,191,556 (70,940) 899,984 Revenues over (under) expenditures $ {2,088,320} $ {5,902,560) $ (3,019,515) $ (3,814,240) $2,883,045 The accompanying notes are an integral part of this schedule. - 64 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2019 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 of Education 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 of Education, the budget document is available for public inspection. • Prior to July 1, the budget is legally enacted by a vote of the Board of Education. • Subsequent to its formal approval of the budget, the Board of Education 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 6, 2018, or as amended by the Board of Education 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. - 65 -

Expenditure appropriations lapse at the end of the fiscal year. • Budgeted amounts are as originally adopted on June 6, 2018, or as amended by the Board of Education 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. - 65 - SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2019 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: Special General Revenue Fund Fund Revenues Revenues - cash basis $ 17,849,518 $ 29,172,041 Current year revenue accruals 384,104 174,792 Prior year revenue accruals (259,928) (158,757) Revenues - modified accrual basis $ 17,973,694 $ 29,188,076 Expenditures Expenditures - cash basis $ 18,615,448 $ 32,191,556 Current year expenditure accruals 187,305 109,063 Prior year expenditure accruals (115,410) (123,548) Expenditures - modified accrual basis $ 18,687,343 $ 32,177,071 - 66 -

SCHOOL DISTRICT OF CLAYTON NOTES TO REQUIRED SUPPLEMENTARY INFORMATION June 30, 2019 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: Special General Revenue Fund Fund Revenues Revenues - cash basis $ 17,849,518 $ 29,172,041 Current year revenue accruals 384,104 174,792 Prior year revenue accruals (259,928) (158,757) Revenues - modified accrual basis $ 17,973,694 $ 29,188,076 Expenditures Expenditures - cash basis $ 18,615,448 $ 32,191,556 Current year expenditure accruals 187,305 109,063 Prior year expenditure accruals (115,410) (123,548) Expenditures - modified accrual basis $ 18,687,343 $ 32,177,071 - 66 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year Ended June 30, 2019 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios-PSRS Net Pension Fiduciary Net Proportion of the Proportionate share Actual Liability (Asset) Position as a Year Net Pension of the Net Pension member as a percentage percentage of total ended* Liability (Asset) Liability (Asset) payroll of covered payroll 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.66% 84.06% Schedule of Proportionate Share of the Net Pension Liability and Related Ratios - PEERS Net Pension Fiduciary Net Proportion of the Proportionate share Actual Liability (Asset) Position as a Year Net Pension of the Net Pension member as a percentage percentage of total ended* Liability (Asset) Liability (Asset) payroll of covered payroll 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% Schedule of Employer Contributions - PSRS Contributions as Contractually Actual Contributions a percentage of Year required employer excess/ Covered of covered ended contribution contributions ( deficiency) payroll 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,453,947 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,918,329 3,918,329 27,613,312 14.19% - 67 -

SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year Ended June 30, 2019 Schedule of Proportionate Share of the Net Pension Liability and Related Ratios-PSRS Net Pension Fiduciary Net Proportion of the Proportionate share Actual Liability (Asset) Position as a Year Net Pension of the Net Pension member as a percentage percentage of total ended* Liability (Asset) Liability (Asset) payroll of covered payroll 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.66% 84.06% Schedule of Proportionate Share of the Net Pension Liability and Related Ratios - PEERS Net Pension Fiduciary Net Proportion of the Proportionate share Actual Liability (Asset) Position as a Year Net Pension of the Net Pension member as a percentage percentage of total ended* Liability (Asset) Liability (Asset) payroll of covered payroll 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% Schedule of Employer Contributions - PSRS Contributions as Contractually Actual Contributions a percentage of Year required employer excess/ Covered of covered ended contribution contributions ( deficiency) payroll 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,453,947 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,918,329 3,918,329 27,613,312 14.19% - 67 - SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year Ended June 30, 2019 Schedule of Employer Contributions - PEERS Contractually Actual Year required employer ended contribution contributions 6/30/2013 $ 535,396 $ 535,396 6/30/2014 523,447 523,447 6/30/2015 518,849 518,849 6/30/2016 542,557 542,557 6/30/2017 558,224 558,224 6/30/2018 567,941 567,941 6/30/2019 588,264 588,264 Contnbutions as Contnbutions a percentage of excess / Covered of covered ( deficiency) payroll payroll $ $ 7,805,015 6.86% 7,630,413 6.86% 7,563,393 6.86% 7,908,987 6.86% 8,137,380 6.86% 8,279,018 6.86% 8,575,277 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 Systems' net pension liability, which is as of the beginning of the District's fiscal year. - 68 -

SCHOOL DISTRICT OF CLAYTON NET PENSION LIABILITY - UNAUDITED Year Ended June 30, 2019 Schedule of Employer Contributions - PEERS Contractually Actual Year required employer ended contribution contributions 6/30/2013 $ 535,396 $ 535,396 6/30/2014 523,447 523,447 6/30/2015 518,849 518,849 6/30/2016 542,557 542,557 6/30/2017 558,224 558,224 6/30/2018 567,941 567,941 6/30/2019 588,264 588,264 Contnbutions as Contnbutions a percentage of excess / Covered of covered ( deficiency) payroll payroll $ $ 7,805,015 6.86% 7,630,413 6.86% 7,563,393 6.86% 7,908,987 6.86% 8,137,380 6.86% 8,279,018 6.86% 8,575,277 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 Systems' net pension liability, which is as of the beginning of the District's fiscal year. - 68 - SCHOOL DISTRICT OF CLAYTON SCHEDULE OF CHANGES IN TOT AL OPEB LIABILITY AND RELATED RATIOS - UNAUDITED Year Ended June 30, 2019 Schedule of Changes in Total OPEB Liability Total OPEB liability Service cost Interest on total O PEB liability Changes in assumptions Benefit payments Net change in total OPEB liability Total OPEB liability at beginning of year Total OPEB liability at end of year Covered Payroll Total OPEB liability as a percentage of covered payroll 2019 $ 264,514 213,641 211,954 (357,661) 332,448 5,433,040 $ 5,765,488 $32,341,024 17.83% 2018 $ 270,318 199,304 (160,959) (341,928) (33,265) 5,466,305 $ 5,433,040 $31,688,037 17.15% Note: This schedule is to present information for 10 years. become available. Additional years will be presented as they 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. - 69 -

Open full document View original source Report an error →