Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
06 - June 2026 Monthly Financial Report
VILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS JUNE 2026 Estimated YTD YTD Net Fund Ending YTD YTD Increase Fund Balance Governmental Funds Revenues Expenditures (Decrease)(Deficit) General Fund (Major Fund)20,325,855$ 15,493,086$ 4,832,769$ 47,979,091$ Main operating fund of the Village. Hotel Fund (Major Fund)1,003,436$ 465,205$ 538,231$ 6,714,291$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 227,561$ 58,856$ 168,706$ 2,950,966$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)5,719,995$ 1,329,043$ 4,390,952$ 32,272,349$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Enterprise Funds Water Fund (Major Fund)5,332,103$ 7,827,545$ (2,495,442)$ 21,819,364$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,335,506$ 2,641,714$ 693,792$ 4,526,873$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Internal Service Funds Insurance Fund 1,618,914$ 1,646,213$ (27,298)$ 324,326$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 339,925$ 414,076$ (74,151)$ 503,750$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 745,655$ 784,309$ (38,655)$ 3,812,646$ Accounts for the replacement of the Village's vehicle fleet and the related departmental contributions. Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through June 30, 2026 6/30/26 6/30/26 6/30/25 6/30/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 10,196,665$ 11,874,452 9,250,000$ 128.4%18,500,000$ 1,677,788$ State Income Tax 836,431 858,279 774,903 110.8%1,549,806 21,847 Replacement Tax 202,269 216,321 250,000 86.5%500,000 14,052 Road & Bridge Tax 19,003 17,768 16,850 105.4%33,700 (1,235) Local Use Tax 87,879 35,697 145,000 24.6%290,000 (52,182) Cannabis Use Tax 6,549 6,730 6,923 97.2%13,846 181 Grants 7,804 - 10,560 0.0%21,120 (7,804) Utility/Telecom. Tax 1,628,798 1,755,461 1,450,000 121.1%2,900,000 126,663 Licenses and Permits 1,158,475 1,219,098 1,214,205 100.4%2,428,410 60,623 Charges for Services 1,054,371 1,912,797 1,022,025 187.2%2,044,050 858,425 Investment Interest 618,247 743,049 700,000 106.1%1,400,000 124,802 Miscellaneous Income 291,621 294,491 357,130 82.5%714,260 2,870 Total Operating Revenues 16,108,111$ 18,934,143$ 15,197,596$ 124.6%30,395,192$ 2,826,032$ OPERATING EXPENDITURES Personnel 11,476,543$ 11,830,099$ 12,448,927$ 95.0%24,897,854$ 353,556$ Materials and Supplies 249,159 243,859 359,214 67.9%718,429 (5,300)$ Operation and Contract 3,169,394 3,312,091 3,470,730 95.4%6,941,461 142,696$ Other Expenditures 3,961 9,712 4,950 196.2%9,900 5,751$ Capital Outlay 826,855 97,327 277,345 35.1%554,690 (729,528)$ Total Operating Expenditures 15,725,912$ 15,493,086$ 16,561,167$ 93.6%33,122,333$ (232,826)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 382,199$ 3,441,057$ (1,363,571)$ -252.4%(2,727,141)$ 3,058,858$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out N/A - Reimbursements From Other Funds 1,005,528 1,391,712 1,391,717 100.0%2,783,433 386,184 Reimbursements To Other Funds - - - N/A - - Sports Core Loan N/A - - Total Interfund Transactions 1,005,528$ 1,391,712$ 1,391,717$ 100.0%2,783,433$ 386,184$ NET FUND INCREASE (DECREASE)1,387,727$ 4,832,769$ 28,146$ 56,292$ 3,445,042$ *Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax. Village of Oak Brook General Fund Financial Update For the Period Ending June 30, 2026 6/30/26 6/30/26 6/30/25 6/30/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 736,704$ 751,714$ 800,000$ 94.0%1,600,000$ 15,010$ Investment Interest 87,578 103,872 30,000 346.2%60,000 16,294 Loan Interest - - - N/A - - Miscellaneous 108,264 147,850 249,250 498,500 39,586 Total Operating Revenues 932,546$ 1,003,436$ 1,079,250$ 93.0%2,158,500$ 70,890$ EXPENDITURES Personnel 67,912$ 70,575$ 77,378$ 91.2%154,755$ 2,663$ Operation and Contract 192,213 249,431 555,370 44.9%1,110,740 57,218 Other Expenditures - 143,879 0.0%287,758 - Capital Outlay 58,436 1,325 425,025 0.3%850,050 (57,110.15) Total Expenditures 318,561$ 321,331$ 1,124,274$ 28.6%2,403,303$ 108$ SURPLUS (DEFICIT) OF REVENUES OVER - EXPENDITURES 613,986$ 682,105$ (122,401)$ -557.3%(244,803)$ 70,782$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A -$ -$ Reimbursements to Other Funds (102,894) (143,874) 143,879 -100.0%287,758 (40,980) Total Interfund Transactions (102,894)$ (143,874)$ 143,879$ -100.0%287,758$ (40,980)$ NET FUND INCREASE (DECREASE)511,092$ 538,231$ 21,478$ 42,955$ 29,802$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending June 30, 2026 6/30/26 6/30/26 6/30/25 6/30/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 4,395,389$ 5,226,563$ 4,297,500$ 121.6%8,595,000$ 831,173$ Charges for Services - - N/A -$ Investment Interest 349,277 493,432 250,000 197.4%500,000 144,156 Grants - - N/A - Miscellaneous - - N/A - Total Operating Revenues 4,744,666$ 5,719,995$ 4,547,500$ 125.8%9,095,000$ 975,329$ OPERATING EXPENDITURES Personnel 14,231$ 16,343$ -$ N/A -$ 2,112$ Materials and Supplies 25,083 13,516 29,402 46.0%58,804 (11,567) Operation and Contract 566,341 872,916 1,900,849 45.9%3,801,698 306,574 Other Expenditures - - 552,415 0.0%1,104,830 - Capital Outlay 635,735 (26,145) 4,604,251 -0.6%9,208,503 (661,880) Total Operating Expenditures 1,241,391$ 876,631$ 7,086,917$ 12.4%14,173,835$ (364,760)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,503,275$ 4,843,364$ (2,539,417)$ -190.7%(5,078,835)$ 1,340,089$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Reimbursements From Other Funds - - 1,000,000 0.0%2,000,000 - Reimbursements To Other Funds (350,952) (452,412) (552,415) 81.9%(1,104,830) (101,460) Total Interfund Transactions (350,952)$ (452,412)$ 447,585$ -101.1%895,170$ (101,460)$ NET FUND INCREASE (DECREASE)3,152,323$ 4,390,952$ (2,091,832)$ (4,183,665)$ 1,238,629$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending June 30, 2026 6/30/26 6/30/26 6/30/25 6/30/26 YTD % of YTD 2026 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,050$ 75$ 375$ 20.0%750$ (975)$ Building/Inspection Fees - - - N/A - - Water Sales 3,869,741 4,369,232 6,204,500 70.4%12,409,000 499,491 Unmetered Sales 27,805 26,622 20,000 133.1%40,000 (1,183) Water Connection Fees 56,350 25,300 30,000 84.3%60,000 (31,050) Fire Service Charge - - - N/A - Meter Charges 20,100 9,351 8,250 113.3%16,500 (10,749) Special Services 15,926 16,629 7,500 221.7%15,000 703 Investment Interest 542,795 555,194 425,000 130.6%850,000 12,399 Proceeds from Property Sale - - - N/A - Miscellaneous 64,494 329,700 37,500 879.2%75,000 265,206 Total Operating Revenues 4,598,261$ 5,332,103$ 6,733,125$ 79.2%13,466,250$ 733,842$ OPERATING EXPENDITURES Personnel 294,516$ 310,848$ 351,577$ 88.4%703,153$ 16,332$ Materials and Supplies 76,318 54,857 76,266 71.9%152,532 (21,460) Operation and Contract 2,572,189 2,725,926 4,006,790 68.0%8,013,581 153,737 Other Expenditures - - 342,379 0.0%684,758 - Capital Outlay 415,340 4,393,530 3,008,615 146.0%6,017,230 3,978,190 Total Expenditures 3,358,362$ 7,485,161$ 7,785,627$ 96.1%15,571,254$ 4,126,799$ Surplus (Deficit) of Revenues Over Expenditures 1,239,899$ (2,153,058)$ (1,052,502)$ 204.6%(2,105,004)$ (3,392,957)$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (294,606)$ (342,384)$ (342,379)$ 100.0%(684,758)$ (47,778)$ Total Interfund Transactions (294,606)$ (342,384)$ (342,379)$ 100.0%(684,758)$ (47,778)$ Fund Increase/(Decrease) - Budgetary Basis 945,293$ (2,495,442)$ (1,394,881)$ (2,789,762)$ (3,440,735)$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Water Fund Financial Update For the Period Ending June 30, 2026 Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending June 30, 2026 6/30/26 6/30/26 6/30/26 YTD % of YTD 2026 6/30/25 Difference B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior Operations Operations Operations Club Total Budget Budget Budget Total Year OPERATING REVENUES Memberships 639,310$ -$ -$ 385,905$ 1,025,215$ 521,445$ 196.6%1,042,890 945,129$ 80,086$ Greens Fees - - - 750,359 750,359 871,000 86.1%1,742,000 715,221 35,139 Pro Shop Sales - - - 80,455 80,455 90,000 89.4%181,000 79,230 1,225 Golf Lessons - - - 81,125 81,125 50,000 162.3%100,000 80,735 390 Driving Range Fees - - - 511,636 511,636 389,500 131.4%779,000 384,292 127,344 Golf Surcharge - - - 97,690 97,690 125,000 78.2%250,000 90,829 6,861 Rentals 96,386 70,500 87,158 287,963 542,007 564,235 96.1%1,226,070 421,900 120,108 Programs/User Fees 114,317 - - - 114,317 77,910 146.7%155,820 99,926 14,391 Food Sales 19,573 - - 26,801 46,373 57,875 80.1%115,750 54,457 (8,084) Beverage Sales 25,201 - - - 25,201 2,000 1260.0%4,000 22,071 3,130 Grants - - - - - - N/A - - - Other Revenue 26,640 - - 14,484 41,124 38,280 107.4%76,560 39,144 1,980 Total Operating Revenues 921,426$ 70,500$ 87,158$ 2,236,418$ 3,315,502$ 2,787,245$ 119.0%5,673,090$ 2,932,934$ 382,568$ OPERATING EXPENDITURES Personnel 137,543$ -$ -$ 628,590$ 766,133$ 908,761$ 84.3%1,817,521$ 706,621$ 59,512$ Materials & Supplies 12,361 - 2,666 213,376 228,403 228,944 99.8%457,887 205,677 22,726 Operational & Contractual 502,621 39,852 40,504 191,944 774,921 566,756 136.7%1,133,511 534,922 239,999 Other - - - - - - N/A - - - Capital 87,831 - - 311,381 399,212 444,471 89.8%888,942 411,515 (12,303) Total Operating Expenditures 740,356$ 39,852$ 43,170$ 1,345,291$ 2,168,668$ 2,148,931$ 100.9%4,297,861$ 1,858,735$ 309,933$ B&T Administration Overhead Allocation*477,077$ (40,545)$ (85,416)$ (351,116)$ -$ -$ N/A -$ 0$ 0$ Operating Revenues Over (Under) Expenditures 658,147$ (9,897)$ (41,428)$ 540,012$ 1,146,834$ 638,315$ 179.7%1,375,229$ 1,074,199$ 72,636$ INTERFUND TRANSACTIONS Reimbursement From Other Funds 20,004$ -$ -$ -$ 20,004$ 20,000$ 100.0%40,000$ 20,004$ -$ Reimbursement To General Fund (473,046) - - - (473,046) (473,044) 100.0%(946,087) (277,080) (195,966) Total Interfund Transactions (453,042)$ -$ -$ -$ (453,042)$ (453,044)$ 100.0%(906,087)$ (257,076)$ (195,966)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 205,105$ (9,897)$ (41,428)$ 540,012$ 693,792$ 185,271$ 469,142$ 817,123$ (123,330)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a % basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending June 30, 2026 6/30/26 6/30/26 822 6/30/26 YTD % of YTD 2026 6/30/25 Difference 811 812 813 Poolside YTD Adopted Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 614,380$ 24,930$ -$ 639,310$ 319,858$ 199.9%639,715$ 586,529$ 52,781$ Programs/User Fees - 89,410 24,907 - 114,317 77,910 146.7%155,820 99,926 14,391 Pro Shop Sales - - - - - 500 0.0%1,000 260 (260) Rentals 94,886 - - 1,500 96,386 48,800 197.5%97,600 93,533 2,853 Food Sales - - - 19,573 19,573 3,000 652.4%6,000 31,856 (12,283) Beverage Sales - - - 25,201 25,201 2,000 1260.0%4,000 21,188 4,013 Grants - - - - - - N/A - - - Other Revenue 26,640 - - - 26,640 23,280 114.4%46,560 3,890 22,750 Total Operating Revenues 121,526$ 703,790$ 49,837$ 46,274$ 921,426$ 475,348$ 193.8%950,695$ 837,181$ 84,245$ OPERATING EXPENDITURES Personnel 107,275$ 30,268$ -$ -$ 137,543$ 166,229$ 82.7%332,458$ 113,687$ 23,855$ Materials & Supplies 61 12,300 - - 12,361 14,300 86.4%28,600 21,983 (9,622) Operational & Contractual 237,484 190,204 45,575 29,359 502,621 293,825 171.1%587,649 354,941 147,680 Other - - - - - N/A - - - Capital 87,831 - - - 87,831 2,700 3253.0%5,400 12,112 75,719 Total Operating Expenditures 432,650$ 232,772$ 45,575$ 29,359$ 740,356$ 477,054$ 155.2%954,107$ 502,724$ 237,632$ B&T Administration Overhead Allocation*605,045$ (100,736)$ (19,959)$ (7,272)$ 477,077$ 477,077 100.0%954,154$ 328,018$ 149,059$ Operating Revenues Over (Under) Expenditures 293,921$ 370,282$ (15,698)$ 9,643$ 658,147$ 475,371$ 138.4%950,742$ 662,475$ (4,328)$ INTERFUND TRANSACTIONS Reimbursement From Other Fund 20,004$ -$ -$ -$ 20,004$ 20,000$ 100.0%40,000$ 20,004$ -$ Reimbursement To General Fund (473,046) - - - (473,046) (473,044) 100.0%(946,087) (277,080) (195,966) Total Interfund Transactions (453,042)$ -$ -$ -$ (453,042)$ (453,044)$ 100.0%(906,087)$ (257,076)$ (195,966)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (159,121)$ 370,282$ (15,698)$ 9,643$ 205,105$ 22,328$ 44,655$ 405,399$ (200,294)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Open Fields Operations For the Period Ending June 30, 2026 6/30/26 6/30/26 6/30/26 YTD % of YTD 2026 6/30/25 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 70,500$ 70,500$ 102,000$ 69.1%204,000$ 72,667$ (2,167)$ Range Rentals - - - - N/A - - - Other Revenue - - - N/A - - - Total Operating Revenues -$ 70,500$ 70,500$ 102,000$ 69.1%204,000$ 72,667$ (2,167)$ OPERATING EXPENDITURES Personnel -$ -$ -$ -$ N/A -$ -$ -$ Materials & Supplies - - -$ 4,745 0.0%9,490 - - Operational & Contractual - 39,852 39,852$ 38,661 103.1%77,322 20,537 19,315 Capital - - -$ 100,000 0.0%200,000 - - Total Operating Expenditures -$ 39,852$ 39,852$ 143,406$ 27.8%286,812$ 20,537$ 19,315$ B&T Administration Overhead Allocation*-$ (40,545)$ (40,545)$ (40,545) 100.0%(81,090)$ (27,877)$ (12,668)$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (9,897)$ (9,897)$ (81,951)$ 12.1%(163,902)$ 24,253$ (34,150)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Bath & Tennis Clubhouse Operations For the Period Ending June 30, 2026 6/30/26 6/30/26 821 YTD % of YTD 2026 6/30/25 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 87,158$ 120,000$ 72.6%240,000$ 89,551$ (2,392)$ Other Revenue - - 0.0%- - - Total Operating Revenues 87,158$ 120,000$ 72.6%240,000$ 89,551$ (2,392)$ OPERATING EXPENDITURES Personnel -$ -$ N/A -$ -$ -$ Materials & Supplies 2,666 2,500 106.6%5,000 2,759 (93) Operational & Contractual 40,504 31,725 127.7%63,450 22,494 18,010 Capital - - N/A - - - Total Operating Expenditures 43,170$ 34,225$ 126.1%68,450$ 25,252$ 17,917$ B&T Administration Overhead Allocation*(85,416)$ (85,416) 100.0%(170,832)$ (60,447)$ (24,969)$ Operating Revenues Over (Under) Expenditures (41,428)$ 359$ -11539.7%718$ 3,851$ (45,278)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (41,428)$ 359$ 718$ 3,851$ (45,278)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis. **Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year. Village of Oak Brook Monthly Operating Statement Golf Club Programs For the Period Ending June 30, 2026 6/30/26 6/30/26 823 831 832 833 834 844 6/30/26 YTD % of YTD 2026 6/30/25 Difference Golf Golf General Golf Learning Golf Cart Golf Course Golf YTD Amended Amended Adopted YTD Prior Café Operation & Practice Operations Maintenance Surcharge Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 385,905$ -$ -$ -$ -$ 385,905$ 201,588$ 191.4%403,175$ 358,600$ 27,305$ Greens Fees - 750,359 - - - - 750,359 871,000 86.1%1,742,000 715,221 35,139 Pro Shop Sales - 80,455 - - - - 80,455 90,000 89.4%180,000 79,230 1,225 Golf Lessons - - 81,125 - - - 81,125 50,000 162.3%100,000 80,735 390 Driving Range Fees - - 511,636 - - - 511,636 389,500 131.4%779,000 384,292 127,344 Rentals 18,360 4,490 18,750 246,363 - - 287,963 342,235 84.1%684,470 259,682 28,281 Food Sales 26,801 - - - - - 26,801 54,875 48.8%109,750 22,601 4,199 Beverage Sales - - - - - - - - N/A 884 (884) Golf Surcharge - - - - - 97,690 97,690 125,000 78.2%250,000 90,829 6,861 Other Revenue - 14,484 - - - - 14,484 15,000 96.6%30,000 35,254 (20,770) Total Operating Revenues 45,161$ 1,235,693$ 611,511$ 246,363$ -$ 97,690$ 2,236,418$ 2,139,198$ 104.5%4,278,395$ 2,027,328$ 209,090$ OPERATING EXPENDITURES Personnel -$ 196,800$ 62,238$ 12,061$ 357,492$ -$ 628,590$ 742,532$ 84.7%1,485,063$ 592,934$ 35,656$ Materials & Supplies - 56,558 17,218 - 139,599 213,376 207,399 102.9%414,797 180,935 32,440 Operational & Contractual - 143,089 15,314 4,351 29,190 191,944 202,545 94.8%405,090 136,950 54,994 Other - - - - - - - N/A - - Capital - 87,879 8,500 - 49,252 165,750 311,381 341,771 91.1%683,542 399,403 (88,022) Total Operating Expenditures -$ 484,326$ 103,270$ 16,412$ 575,533$ 165,750$ 1,345,291$ 1,494,246$ 90.0%2,988,492$ 1,310,222$ 35,068$ Operating Revenues Over (Under) Expenditures 45,161$ 751,367$ 508,241$ 229,952$ (575,533)$ (68,060)$ 891,128$ 644,952$ 138.2%1,289,903$ 717,106$ 174,022$ B&T Administration Overhead Allocation*-$ (351,116)$ -$ -$ -$ -$ (351,116)$ (351,116) 100.0%(702,232)$ (239,693)$ (111,422)$ INTERFUND TRANSACTIONS Reimbursement To General Fund -$ -$ -$ -$ -$ -$ N/A -$ 0.0%-$ -$ Total Interfund Transactions -$ -$ -$ -$ -$ -$ N/A -$ -$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis 45,161$ 400,252$ 508,241$ 229,952$ (575,533)$ (68,060)$ 540,012$ 293,836$ 587,671$ 477,413$ 62,599$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.