{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Retirement","Pension Note","Pension Expense","OPEB Note","OPEB Expense","x"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Summary","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[14,3,14,5]]}
["Farmdale Water District"]
["Payroll Summary"]
["December 31, 2024"]
[]
["SOI: Quarterly/monthly Form 941s, W-2s, W-3, K-5, K-3s, UI-3s, FC-Form Q2s"]
[]
["Period","Salaries & Wages","FICA Taxable Gross","Social Security","Medicare","SUTA"]
["January - March",56493.919999999998,58290.37,{"$f":"C8*0.062","v":3614.0029400000003},{"$f":"C8*0.0145","v":845.21036500000002},1134.93]
["April - June ",59185.16,60944.160000000003,{"$f":"C9*0.062","v":3778.5379200000002},{"$f":"C9*0.0145","v":883.69032000000004},397.24]
["July - September (amended)",62149.26,63974.35,3966.4096999999997,927.62807500000008,121.31]
["October - December ",72335.98,74422.559999999998,4614.1987199999994,1079.1271200000001,210.55]
["Totals per 941s",{"$f":"SUM(B8:B11)","v":250164.32},{"$f":"SUM(C8:C11)","v":257631.44},{"$f":"SUM(D8:D11)","v":15973.149280000001},{"$f":"SUM(E8:E11)","v":3735.6558800000003},{"$f":"SUM(F8:F11)","v":1864.03}]
["   Employee Retirement",{"$f":"2758.98+177.9+2686.32+1843.92","v":7467.1200000000008}]
["Total Gross Salaries & Wages",{"$f":"SUM(B12:B13)","v":257631.44},null,null,{"$f":"SUM(D12:F12)","v":21572.835160000002}]
[null,null,null,"Employer Payroll Taxes"]
[]
[]
["Accrued Payroll Taxes"]
["Form 941",-17.43]
["Kentucky Unemployment",210.55]
["Amended KUI (Q3)",-81.650000000000006]
["Kentucky Withholding",908.25]
["Franklin County",744.29]
["Total Accrued Payroll Taxes",{"$f":"SUM(B19:B23)","v":1764.01}]
[]
[]
[]
[]
["Employee Salaries & Wages:"]
["Mike Hieatt ",828]
["Chris Ralph",49705.51]
["Chris Obrien",49188.75]
["Jan Sanders",58177.599999999999]
["Deavon Johnston",33024]
["Yvonne Poole",4147.33]
["Matthew Perry",35772.25]
["Holly Mayer",6208]
["Harmon Clark",5292]
["Zachary Pelfrey",688]
["Total Employee Salaries & Wages",null,{"$f":"SUM(B30:B39)","v":243031.44}]
[]
["Officers Salaries:"]
["Scott Wooldridge",4800]
["Eddie Harrod",5000]
["Jonathan Dailey",4800]
["Total Officers",null,{"$f":"SUM(B43:B45)","v":14600}]
[]
["Total Salaries & Wages",null,{"$f":"SUM(C40:C46)","v":257631.44}]

{"sheet":"Retirement","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[42,8,42,9]]}
["Farmdale Water District"]
["Retirement "]
["December 31, 2024"]
[]
["Amount paid per month per Jan's payroll ledger (Gross less FICA)","J. Sanders1","D. Johnston2","C.Ralph2","C.Obrien3","Gross Salary","Employee Portion (5% Sanders, Johnston, Ralph//Obrien after December)","Additional Employee Portion (+1% Johnston, Ralph, Obrien)","Employer Portion4","Total Due","Actual Paid","Difference"]
["January",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(987+819+913.5+1013.25)*0.9235","v":3447.1946250000001},0,{"$f":"SUM(B6:D6)","v":9944.2018250000001},{"$f":"(B6+C6+D6+E6)*0.05","v":497.21009125},{"$f":"(C6+D6+E6)*0.01","v":58.113546249999999},{"$f":"F6*0.2334","v":2320.9767059549999},{"$f":"G6+I6+H6","v":2876.3003434550001},3327.07,{"$f":"K6-J6","v":450.76965654500009}]
["February",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"2560*0.9235","v":2364.16},{"$f":"(1233.75+1060.5+808.5+819)*0.9235","v":3621.7361249999999},0,10118.743324999999,505.93716625000002,{"$f":"(C7+D7+E7)*0.01","v":59.858961249999993},{"$f":"F7*0.2334","v":2361.7146920549999},{"$f":"G7+I7+H7","v":2927.5108195550001},3028.55,{"$f":"K7-J7","v":101.03918044500006}]
["March",{"$f":"(1118.8*5)*0.9235","v":5166.0590000000002},{"$f":"(640*5)*0.9235","v":2955.2},{"$f":"(903+840+903+840+840)*0.9235","v":3995.0610000000001},0,12116.32,605.81600000000003,69.502610000000004,2827.9490879999998,3503.2676980000001,2942.62,-560.64769800000022]
["April",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(882+819+840+840)*0.9235","v":3122.3535000000002},0,9619.3607000000011,480.9680350000001,54.865135000000002,2245.1587873800004,2780.9919573800007,3081.51,300.51804261999951]
["May",{"$f":"(1118.8*5)*0.9235","v":5166.0590000000002},{"$f":"(640+640+640+512+640)*0.9235","v":2836.9920000000002},{"$f":"(840+880+880+880+825)*0.9235","v":3975.6675},0,11978.718500000001,598.93592500000011,68.126594999999995,2795.8328979000003,3462.8954179000007,3226.88,-236.01541790000056]
["June",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(880+880+913+946)*0.9235","v":3342.1464999999998},0,9839.1536999999989,491.95768499999997,57.063064999999995,2296.4584735799999,2845.4792235799996,2845.46,-1.922357999956148E-2]
["July",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(880+1012+1078+880)*0.9235","v":3555.4749999999999},0,10052.4822,502.62411000000003,59.196350000000002,{"$f":"F12*0.1971","v":1981.34424162},2543.1647016200004,2943.48,400.3152983799996]
["August",{"$f":"(1118.8*5)*0.9235","v":5166.0590000000002},{"$f":"(640*5)*0.9235","v":2955.2},{"$f":"(836+1012+880+880+979)*0.9235","v":4236.0945000000002},0,12357.353500000001,617.86767500000008,71.912945000000008,{"$f":"F13*0.1971","v":2435.6343748500003},3125.4149948500003,2787.53,-337.88499485000011]
["September",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(980+980+1035.13+980)*0.9235","v":3671.0325550000002},0,10168.039755,508.40198774999999,60.351925549999997,2004.1206357105,2572.8745490104998,2711.46,138.58545098950026]
["October",{"$f":"(1118.8*4)*0.9235","v":4132.8472000000002},{"$f":"(640*4)*0.9235","v":2364.16},{"$f":"(1696.63+1127+980+1127)*0.9235","v":4553.4368050000003},0,11050.444005000001,552.52220025000008,69.175968050000009,2178.0425133855001,2799.7406816855,3354.09,554.34931831450012]
["November",{"$f":"5594*0.9235","v":5166.0590000000002},{"$f":"(640+640+640+512+640)*0.9235","v":2836.9920000000002},{"$f":"(918.75+980+1225+1004.5+980)*0.9235","v":4717.4688749999996},0,12720.519875,636.02599375,75.544608749999995,2507.2144673624998,3218.7850698624998,2731.99,-486.79506986249999]
["December",{"$f":"4475.2*0.9235","v":4132.8472000000002},{"$f":"2560*0.9235","v":2364.16},{"$f":"3969*0.9235","v":3665.3714999999997},{"$f":"3998.5*0.9235","v":3692.6147499999997},10162.378699999999,{"$f":"(B17+C17+D17+E17)*0.05","v":692.74967249999997},97.221462499999987,2003.0048417699998,2792.9759767699998,3671.83,878.85402323000017]
[]
["Totals",{"$f":"SUM(B6:B18)","v":53727.013600000006},30497.664000000001,45903.03848499999,3692.6147499999997,{"$f":"SUM(F6:F18)","v":130127.71608499999},6691.0165417500011,800.93317235000006,{"$f":"SUM(I6:I17)","v":27957.451719568497},{"$f":"SUM(J6:J18)","v":35449.401433668507},{"$f":"SUM(K6:K18)","v":36652.47},{"$f":"SUM(L6:L18)","v":1203.0685663314994}]
["To reconcile the above to W-2s:",null,null,null,null,null,null,null,"GL #514",null,null,"(Immaterial)"]
["Add back FICA, 7.65%",{"$f":"3607.01+843.58","v":4450.59},{"$f":"2047.49+478.85","v":2526.34},{"$f":"3081.74+720.73","v":3802.47},305.89,null,null,null,"(before pension adj)"]
["+ wages before eligibility",0,0,0,45708.01]
["Gross Wages",{"$f":"B19+B21+B22","v":58177.603600000002},{"$f":"C19+C21+C22","v":33024.004000000001},49705.508484999991,{"$f":"E19+E21+E22","v":49706.514750000002}]
["Per W-2",58177.599999999999,33024,49705.51,49706.51]
["Difference",{"$f":"B23-B24","v":3.6000000036437996E-3},{"$f":"C23-C24","v":4.0000000008149073E-3},{"$f":"D23-D24","v":-1.5150000108405948E-3},4.7500000000582077E-3]
[]
[]
["Retirement Payable"]
["Total Due @ 12/31/24",{"$f":"K17","v":3671.83}]
["+/- additional amount due/(overpaid)",{"$f":"-L19","v":-1203.0685663314994}]
[null,{"$f":"SUM(B29:B30)","v":2468.7614336685006}]
[null,"GL #210"]
[]
[]
[]
[]
["Notes:"]
["1 - Jan Sanders joined before 9/1/2008, making her contribution percentage 5%."]
["2 - Deavon Johnston and Chris Ralph joined the pension plan after 9/1/2008, which requires them to contribute an additional 1% for health insurance costs."]
["3 - Chris Obrien became eligible in December 2024 (must pay additional 1% for health insurance)"]
["4 - 23.34% January - June, 19.71% July - December."]

{"sheet":"Pension Note","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[9,0,9,3]]}
["Farmdale Water District"]
["Pension Note Information"]
["December 31, 2024"]
[null,null,null,"Pension Portion",null,"Insurance Portion",null,"Total"]
["January - June",{"$f":"SUM(Retirement!I6:I11)","v":14848.090644869999},null,{"$f":"B5*(23.34/23.34)","v":14848.090644869999},null,{"$f":"B5*(0/23.34)","v":0},null,{"$f":"SUM(D5:F5)","v":14848.090644869999}]
["July - December",{"$f":"SUM(Retirement!I12:I17)","v":13109.361074698501},null,{"$f":"B6*(19.71/19.71)","v":13109.361074698501},null,{"$f":"B6*(0/19.71)","v":0},null,{"$f":"SUM(D6:F6)","v":13109.361074698501}]
["Total Pension Expense per worksheet",{"$f":"SUM(B5:B6)","v":27957.4517195685},null,{"$f":"D5+D6","v":27957.4517195685},null,{"$f":"F5+F6","v":0},null,{"$f":"D7+F7","v":27957.4517195685}]
[]
[]
["The following information comes from the 2024 GASB 68 Proportionate Share Audit Report with Schedules from KPPA's website (page numbers provided below):"]
[]
["Net Pension Liability ",216790,null,"GL #224"]
["   Appendix A, Page 33 - Net Pension Liability, Discount Rate 6.50% (Code V637)"]
[]
[]
["Calculation of Deferred Inflows and Outflows:"]
[null,"Outflows",null,"Inflows"]
["Difference between expected and actual results",10493,1,0,1]
["Change in assumptions",0,2,9795,2]
["Net difference between projected and actual earnings on plan investments",0,3,13938]
["Changes in proportion and difference between employer contributions and proportionate share of contributions",0,4,33035,4]
["Contributions subsequent to the measurement date",{"$f":"D6","v":13109.361074698501},5,0]
["Total ",{"$f":"SUM(B18:B22)","v":23602.3610746985},null,{"$f":"SUM(D18:D22)","v":56768}]
[null,"GL #191",null,"GL #231"]
[]
["Appendix A, Page 50:"]
["1 - \"Liability Experience\" "]
["2 - \"Assumption Changes\""]
["3 - Inflows \"Investment Experience\" less Outflows \"Investment Experience\" (if positive, Inflow - if negative, Outflow column)"]
["4 - \"Changes in Proportion ….\""]
["5 - See \"Pension Portion\" from above - July - December"]

{"sheet":"Pension Expense","index":3,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[12,1,12,6],[4,0,4,6]]}
["Farmdale Water District"]
["Pension Expense Calculation with Change in Net Pension Liability"]
["12.31.24"]
[]
["To assist with the calculation, KRS has provided an example of using the spreadsheet to calculate pension expense as follows:"]
["Step 1","   Net Pension Liability - End of Year = Schedule B, \"Net Pension Liability\" (Column E)  "]
["Step 2","- Net Pension Liability  Beginning of Year =  Schedule B, \"FYE2020 Net Pension Liability\" (Column C)"]
["Step 3","- Deferred Outflows = Schedule B, \"Total Deferred Outflows of Resources\" (Column K)"]
["Step 4","+ Year 1 Amortization of Deferred Outflows = 0"]
["Step 5","+ Amortization of Prior Year Deferred Outflows = 0"]
["Step 6","+ Deferred Inflows Occurring this Year = Schedule B, \"Total Deferred Inflows of Resources\" (Column Q)"]
["Step 7","- Amortization of Prior Year Deferred Inflows = 0"]
["Step 8","+ Reductions to Ending Net Pension Liability due to Contributions Paid = Schedule A, \"Actual Employer Contributions\" (Column D)"]
["Total","Pension Expense"]
[]
["Step 1",null,"Net pension liability -- end of year ",null,null,216790]
["Step 2",null,"Net pension liability -- beginning of year ",null,null,-261922]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":-45132}]
["Step 3",null,"Deferred outflows occurring this year",null,null,-23602]
["Step 4",null,"+ Year 1 Amortizaton of Deferred Outflows",null,null,0]
["Step 5",null,"Prior Year Deferred Outflows",null,null,31688]
["Step 6",null,"Deferred inflows occurring this year",null,null,56768]
["Step 7",null,"Prior Year Deferred Inflows",null,null,-62307]
["Step 8",null,"Contributions paid",null,null,27957]
["Equals",null,"Total pension expense/(benefit) for the year",null,null,{"$f":"SUM(F18:F24)","v":-14628},"GL #514"]
[null,null,"Actuarial Calculated Pension Expense",null,null,12074]
[null,null,"Variance",null,null,{"$f":"F26-F25","v":26702}]

{"sheet":"OPEB Note","index":4,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,0,8,3]]}
["Farmdale Water District"]
["OPEB Note Information"]
["December 31, 2024"]
[null,null,null,"Pension Portion",null,"Insurance Portion",null,"Total"]
["January - June",{"$f":"SUM(Retirement!I6:I11)","v":14848.090644869999},null,{"$f":"B5*(23.34/23.34)","v":14848.090644869999},null,{"$f":"B5*(0/23.34)","v":0},null,{"$f":"SUM(D5:F5)","v":14848.090644869999}]
["July - December",{"$f":"SUM(Retirement!I12:I17)","v":13109.361074698501},null,{"$f":"B6*(19.71/19.71)","v":13109.361074698501},null,{"$f":"B6*(0/19.71)","v":0},null,{"$f":"SUM(D6:F6)","v":13109.361074698501}]
["Total Pension Expense per worksheet",{"$f":"SUM(B5:B6)","v":27957.4517195685},null,{"$f":"D5+D6","v":27957.4517195685},null,{"$f":"F5+F6","v":0},null,{"$f":"D7+F7","v":27957.4517195685}]
[]
["The following information comes from the 2024 GASB 75 Proportionate Share Audit Report with Schedules from KPPA's website (page numbers provided below):"]
[]
["Net OPEB Liability/(Asset)",-6277,null,"GL #225"]
["   Appendix A, Page 38 - Net OPEB Liability, Discount Rate 5.99%"]
[]
[]
["Calculation of Deferred Inflows and Outflows:"]
[null,"Outflows",null,"Inflows"]
["Difference between expected and actual results",3483,1,49391,1]
["Change in assumptions",5688,2,4429,2]
["Net difference between projected and actual earnings on plan investments",0,3,5729]
["Changes in proportion and difference between employer contributions and proportionate share of contributions",2512,4,18111,4]
["Contributions subsequent to the measurement date",1702,5,0]
["Total ",{"$f":"SUM(B17:B21)","v":13385},null,{"$f":"SUM(D17:D21)","v":77660}]
[null,"GL #192",null,"GL #232"]
[]
["Appendix A, Page 72:"]
["1 - \"Liability Experience\" "]
["2 - \"Assumption Changes\""]
["3 - Inflows \"Investment Experience\" less Outflows \"Investment Experience\" (if positive, Inflow - if negative, Outflow column)"]
["4 - \"Changes in Proportion ….\""]
["5 - See \"Insurance Portion\" from above - July - December, plus \"implicity subsidy\" from Appendix A, Page 55"]

{"sheet":"OPEB Expense","index":5,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[12,1,12,6],[4,0,4,6]]}
["Farmdale Water District"]
["OPEB Expense Calculation with Change in Net OPEB Liability"]
["12.31.24"]
[]
["To assist with the calculation, KRS has provided an example of using this spreadsheet to calculate OPEB expense as follows:"]
["Step 1","   Net Pension Liability - End of Year = Schedule B, \"Net OPEB Liability\" (Column E)  "]
["Step 2","- Net Pension Liability  Beginning of Year =  Schedule B, \"FYE2020 Net OPEB Liability\" (Column C)"]
["Step 3","- Deferred Outflows = Schedule B, \"Total Deferred Outflows of Resources\" (Column K)"]
["Step 4","+ Year 1 Amortization of Deferred Outflows = 0"]
["Step 5","+ Amortization of Prior Year Deferred Outflows = 0"]
["Step 6","+ Deferred Inflows Occurring this Year = Schedule B, \"Total Deferred Inflows of Resources\" (Column Q)"]
["Step 7","- Amortization of Prior Year Deferred Inflows = 0"]
["Step 8","+ Reductions to Ending Net OPEB Liability due to Contributions Paid = Schedule A, \"2021 Actual Employer Contributions\" (Column D)"]
["Total","OPEB Expense"]
[]
["Step 1",null,"Net OPEB liability/(asset) -- end of year ",null,null,-6277]
["Step 2",null,"Net OPEB liability/(asset) -- beginning of year ",null,null,5636]
[null,null,null,null,null,{"$f":"SUM(F16:F17)","v":-641}]
["Step 3",null,"Deferred outflows occurring this year",null,null,-13385]
["Step 4",null,"+ Year 1 Amortizaton of Deferred Outflows",null,null,0]
["Step 5",null,"Prior Year Deferred Outflows",null,null,25567]
["Step 6",null,"Deferred inflows occurring this year",null,null,77660]
["Step 7",null,"Prior Year Deferred Inflows",null,null,-112630]
["Step 8",null,"Health Insurance paid during the year",null,null,32819]
["Equals",null,"Total opeb expense/(benefit) for the year",null,null,{"$f":"SUM(F18:F24)","v":9390},"GL #503"]
[null,null,"Actuarial Calculated OPEB Expense",null,null,-14638]
[null,null,"Variance",null,null,{"$f":"F25-F26","v":24028}]

{"sheet":"x","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}