Loading...
HomeMy WebLinkAboutAgenda - 01-23-2014-13 (4) INFORMATION ITEM ORANGE'' COUNTY NX)RTH INA FINANCE AND ADMINISTRATIVE SERVICES 200 South Cameron Street Clarence G.Grier,CPA,CITP,CGMA Phone(919)245-2553 Post Office Box 8181 Assistant County Manager—CFO Fax(919)644-3324 Hillsborough, North Carolina 27278 MEMORANDUM To: Board of County Commissioners From: Clarence Grier, Assistant County Manager—Chief Finance Officer Date: January 23, 2014 Re: Major Fund Financial Statement for the Six Months Ended December 31, 2013 As part of meeting the periodic financial reporting requirements and providing timelier source information in regards to the financial status of the County, we have developed an interim financial statement that will provide information on the major fund financial status for the six months ended December 31, 2013. The following County funds are considered major funds under the Governmental Accounting Standards Board: The Major funds of the County are as follows: • General Fund • Capital Funds—County Capital and School Capital Funds • Solid Waste Fund • Sportsplex Fund The Major Fund of the County accounted for approximately 86 percent of the total annual revenues of the County. An overview of financial status for each of the major funds is included in the financial statement and as follows: General Fund • Total revenues for the General Fund are $127 million for an increase of$2.1 million or 2% over the same period in fiscal year 2012-13. This revenue increase is mainly due to the timing of billing Ad Valorem Taxes. Total revenues collected are 79% of the amended budget for the current fiscal year. • Total expenditures for the General Fund are $86.1 million for an increase of$3.1 million or 4% over the same period in the previous year. Total expenditures are 31.6% of the budget for the fiscal year. • Revenues and net transfers are more than expenditures by $40.8 million representing a net decrease of$950,645 million or 2% over the same period in the previous fiscal year. Capital Funds • The County Capital Funds revenues and other financing sources total $8.9 million compared to expenditures of approximately $5.0 million. The main revenue and financing source are the funds received for the installment financing proceeds received in July of this fiscal year. The majority of the current fiscal year expenditures related to construction cost incurred for the Buckhorn Mebane Economic Development District and communication system improvements for Emergency Services as part of the strategic plan. • The School Capital Funds expenditures total $4.2 million. The majority of the current fiscal year expenditures related to construction cost incurred for Northside Elementary (Elementary #11) and-window replacements for the Chapel Hill—Carrboro City Schools District. Solid Waste Fund • Total revenues and transfers for the Solid Waste Fund decreased 21% over the same period in the previous fiscal year to $5.3 million. Revenues and other financing sources and uses lower due to the closure of the landfill as of June 30, 2013. Total revenues collected are 40% of the amended budget for the fiscal year. • Total expenses for the Solid Waste Fund decreased 17% over the same period in the previous fiscal year to$3.3 million. Total expenditures are 25% of the budget for the fiscal year. • Revenues and transfers are greater than expenses by $1.9 million compared to greater than expenditures by$2.3 million over the same period in the previous fiscal year due to the closure of the Landfill. Sportsplex Fund • Total revenues for the Sportsplex Fund increased 8.8% over the same period in the previous year to $201,338. This is mainly due to increased memberships and increased fees. Total revenues are 36% of the amended budget for the fiscal year. • Total expenditures for the Sportsplex Fund increased 7% over the same period in the previous fiscal year to$1.4 million. Total expenditures are 32% of the budget for the fiscal year. • Revenues and net transfers are greater than expenditures by$154,000, which is nominally the same as the previous fiscal year. ORANGE COUNTY NORTH CAROLINA Major Fund Financial Statement (Unaudited) For the Six Months Ended December 31, 2013 EMMT11 "51 ' HitiVI!PA zr, eirp- -cltd :mg; Arth ORANGE COUNTY, NORTH CAROLINA MAJOR FUND FINANCIAL STATEMENT FOR THE SIX MONTHS ENDED DECEMBER 31,2013 TABLE OF CONTENTS Exhibit Balance Sheet- Major Governmental Funds 1 Statement of Revenues,Expenditures,and Changes in Fund Balances-Major Governmental Funds 2 Statement of Revenues,Expenditures, and Changes in Fund Balances-Budget and Actual-General Fund 3 Statement of Net Position-Proprietary Funds 4 Statement of Revenues,Expenses,and Changes in Fund Net Position-Proprietary Funds 5 County Capital Improvements Fund- Schedule of Revenues,Expenditures,and Changes in Fund Balance-Budget and Actual 6 School Capital Improvements Fund- Schedule of Revenues,Expenditures,and Changes in Fund Balance-Budget and Actual 7 ORANGEI$COUNTY NOItTEE eZAROT NA FINANCE AND ADMINISTRATIVE SERVICES 200 South Cameron Street Clarence G.Grier,CPA,CITP,CGMA Phone(919)245-2553 Post Office Box 8181 Assistant County Manager—CFO Fax(919)644-3324 Hillsborough,North Carolina 27278 Summary Information for Major Funds as of December 3L 2013: General Fund: • Total revenues for the General Fund are$127 million for an increase of$2.1 million or 2%over the same period in fiscal year 2012-13. This revenue increase is mainly due to the timing of billing Ad Valorem Taxes. Total revenues collected are 79% of the amended budget for the current fiscal year. • Total expenditures for the General Fund are$86.1 million for an increase of$3.1 million or 4% over the same period in the previous year. Total expenditures are 31.6% of the budget for the fiscal year. • Revenues and net transfers are more than expenditures by $40.8 million representing a net decrease of$950,645 million or 2%over the same period in the previous fiscal year. Capital Funds: • The County Capital Funds revenues and other financing sources total $8.9 million compared to expenditures of approximately $5.0 million. The main revenue and financing source are the funds received for the installment financing proceeds received in July of this fiscal year. The majority of the current fiscal year expenditures related to construction cost incurred for the Buckhorn Mebane Economic Development District and communication system improvements for Emergency Services as part of the strategic plan. • The School Capital Funds expenditures total $4.2 million. The majority of the current fiscal year expenditures related to construction cost incurred for Northside Elementary (Elementary #11)and window replacements for the Chapel Hill—Carrboro City Schools District., Solid Waste Fund: • Total revenues and transfers for the Solid Waste Fund decreased 21% over the same period in the previous fiscal year to $5.3 million. Revenues and other financing sources and uses lower due to the closure of the landfill as of June 30, 2013. Total revenues collected are 40% of the amended budget for the fiscal year. • Total expenses for the Solid Waste Fund decreased 17% over the same period in the previous fiscal year to$3.3 million.Total expenditures are 25%of the budget for the fiscal year. • Revenues and transfers are greater than expenses by $1.9 million compared to greater than expenditures by$2.3 million over the same period in the previous fiscal year due to the closure of the Landfill. Sportsplex Fund: • Total revenues for the Sportsplex Fund increased 8.8% over the same period in the previous year to $201,338. This is mainly due to increased memberships and increased fees. Total revenues are 36%of the amended budget for the fiscal year. • Total expenditures for the Sportsplex Fund increased 7% over the same period in the previous fiscal year to$1.4 million.Total expenditures are 32%of the budget for the fiscal year. • Revenues and net transfers are greater than expenditures by $154,000, which is nominally the same as the previous fiscal year. An Equal Opportunity/Affirmative Action Employer www.orangecountync.gov Exhibit 1 ORANGE COUNTY,NORTH CAROLINA BALANCE SHEET-MAJOR GOVERNMENTAL FUNDS(UNAUDITED) December 31,2013 Major Funds Total County School Major Capital Capital Governmental General Improvements Improvements Funds Assets: Cash and investments $ 97,515,860 $ - $ - $ 97,515,860 Accounts receivable, property taxes,net 29,583,907 - - 29,583,907 Inventories 23,008 - - 23,008 Due from other funds 557,991 66,983 - 624,974 Prepaids 16,946 - - 16,946 Restricted cash and investments - 10,963,999 3,328,036 14,292,035 Total assets $ 127,697,712 $ 11,030,982 $ 3,328,036 $ 142,056,730 Liabilities,Deferred Inflows of Resources,and Fund Balance: Liabilities: Accounts payable $ 487,336 $ 60,220 $ 88,563 $ 636,119 Accrued payroll and withholdings 71,396 - - 71,396 Accrued liabilities 902,752 - - 902,752 Due to other funds 682,282 - - 682,282 Arbitrage payable - - 24,739 24,739 Total liabilities 2,143,766 60,220 113,302 2,317,288 Deferred Inflows of Resources: Unavailable grant revenue 379,624 - - 379,624 Property taxes receivable 29,583,907 - - 29,583,907 Prepaid taxes 69,005 - 69,005 Total Deferred inflows of resources 30,032,536 - 30,032,536 Fund Balances: Non-spendable: Prepaid items 16,946 - - 16,946 Inventories 23,008 - - 23,008 Restricted for: Stabilization for State statute 9,736,215 2,053,626 - 11,789,841 Restricted,all other - 8,917,135 3,214,734 12,131,869 Committed 3,105,267 - - 3,105,267 Assigned 9,442,980 - - 9,442,980 Unassigned 73,196,994 - - 73,196,994 Total fund balances 95,521,410 10,970,761 3,214,734 109,706,905 Total liabilities,deferred inflows of resources,and fund balances $ 127,697,712 $ 11,030,982 $ 3,328,036 $ 142,056,730 Exhibit 2 ORANGE COUNTY,NORTH CAROLINA STATEMENT OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCES-MAJOR GOVERNMENTAL FUNDS(UNAUDITED) FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Major Funds Total County School Major Capital Capital Governmental General Improvements Improvements Funds Revenues: Property taxes $ 110,956,568 $ - $ - $ 110,956,568 Sales tax 3,768,382 - - 3,768,382 Intergovernmental revenues 6,966,783 15,000 - 6,981,783 Charges for services 4,543,191 37,954 - 4,581,145 Investment earnings 12,858 5,197 2,360 20,415 Licenses and permits 78,442 - - 78,442 Miscellaneous 763,991 - - 19 764,010 Total revenues 127,090,215 58,151 2,379 127,150,745 Expenditures: Current: Governing and management 7,437,J94 - - 7,437,794 General services 3,993,739 - - 3,993,739 Community and environment 3,088,891 - - 3,088,891 Human services 15,668,975 - - 15,668,975 Education 34,512,169 - - 34,512,169 Public safety 9,121,040 - - 9,121,040 Culture and recreation 1,291,312 - - 1,291,312 Capital outlay - 4,991,984 4,152,985 9,144,969 Debt service: - Principal 6,848,134 - - 6,848,134 Interest and fees 4,182,041 - - 4,182,041 Total expenditures 86,144,095 4,991,984 4,152,985 95,289,064 Revenues over(under)expenditures 40,946,120 (4,933,833) (4,150,606) 31,861,681 Other Financing Sources(Uses): Bond premium - - - - Refunding bonds - - - - Installment loan issuances - 8,859,497 - 8,859,497 Payment to escrow agent - - - - Transfers in - - - - Transfers out - - - - Total other financing sources(uses) - 8,859,497 - 8,859,497 Net change in fund balances 40,946,120 3,925,664 (4,150,606) 40,721,178 Fund Balances: Beginning of year-July 1 54,575,290 7,045,097 7,365,340 78,792,212 Six Months Ended-December 31 $ 95,521,410 $ 10,970,761 $ 3,214,734 $ 119,513,390 • Exhibit 3. ORANGE COUNTY,NORTH CAROLINA GENERAL FUND STATEMENT OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL(UNAUDITED) FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Variance With Budgeted Amounts Final Budget Original Amended Actual Encumbrances Over/(Under) FY2012-13 Revenues: Property taxes $ 139,733,522 $ 139,733,522 $ 110,956,568 $ - $ (28,776,954) $ 109,020,423 Sales tax 17,190,148 17,190,148 3,768,382 - (13,421,766) 3,751,968 Intergovernmental revenues 13,703,850 18,572,594 6,966,783 - (11,605,811) 7,453,566 Charges for services 9,654,843 9,700,071 4,543,191 - (5,156,880) 4,105,640 Investment earnings 105,000 105,000 12,858 - (92,142) 12,305 Licenses and permits 313,000 313,000 78,442 - (234,558) 77,669 Miscellaneous 796,718 839,601 763,991 - (75,610) 451,427 Total revenues 181,497,081 186,453,936 127,090,215 - (59,363,721) 124,872,998 Expenditures: Governing and management 15,981,211 16,245,627 7,437,794 359,355 (8,807,833) 6,459,406 General services 8,669,540 8,741,011 3,993,739 149,310 (4,747,272) 3,825,682 Community and environment 7,103,245 7,218,123 3,088,891 128,424 (4,129,232) 2,979,461 Human services 31,459,113 36,050,480 15,668,975 593,077 (20,381,505) 15,256,652 Education 69,657,252 69,657,252 34,512,169 - (35,145,083) 32,979,675 Public safety 21,445,378 21,697,733 9,121,040 303,653 (12,576,693) 8,744,479 Cultural and recreational 2,495,908 2,507,410 1,291,312 58,419 (1,216,098) 1,066,312 Debt service: - - Principal 17,579,399 17,579,399 6,848,134 — (10,731,265) 4,893,330 Interest and fees 8,030,387 8,030,387 4,182,041 - (3,848,346) 6,875,553 Total expenditures 182,421,433 187,727,422 86,144,095 1,592,238 (101,583,327) 83,080,550 Revenues over(under)expenditures (924,352) (1,273,486) 40,946,120 (1,592,238) 42,219,606 41,792,448 Other Financing Sources(Uses): Capital lease issuance - - - - - - Transfers in 1,046,300 1,058,800 - - (1,058,800) - Transfers out (5,312,066) (9,228,294) - - 9,228,294 (3,000,000) Appropriated fund balance 5,190,118 9,442,980 - - (9,442,980) - Total other financing sources(uses) 924,352 1,273,486 - - (1,273,486) (3,000,000) Net change in fund balance $ - $ - 40,946,120 $ (1,592,238) $ 40,946,120 $ 38,792,448 Fund Balance: Beginning of year-July 1 54,575,290 Six months Ended-December 31, $ 95,521,410 Exhibit 4 ORANGE COUNTY,NORTH CAROLINA MAJOR PROPRIETARY FUNDS STATEMENT OF NET POSITION-UNAUDITED December 31,2013 Total Major Major Solid Waste SportsPlex Proprietary Fund Fund Funds Assets: Current assets: Cash and cash equivalents $ 19,542,150 $ 762,928 $ 20,305,078 Accounts receivable,other 164,104 125,471 289,575 Prepaid expenses - 5,735 5,735 Total current assets 19,706,254 894,134 20,600,388 Non-current assets: Non-depreciable assets 1,442,890 794,466 2,237,356 Capital assets,net of depreciation 6,594,548 6,118,242 12,712,790 Total non-current assets 8,037,438 6,912,708 14,950,146 Total assets 27,743,692 7,806,842 35,550,534 Liabilities and Net Position: Liabilities: Current liabilities: Accounts payable 341,695 56,549 398,244 Payroll withholdings - 20,599 20,599 Accrued interest 51,968 34,455 86,423 Prepaid fees - 163,891 163,891 Current portion of long-term debt 320,067 372,682 692,749 Compensated absences,current portion 183,764 - 183,764 Total current liabilities 897,494 648,176 1,545,670 Non-current liabilities: Compensated absences 122,510 - 122,510 Post-closing liability 12,959,312 - 12,959,312 OPEB liability 1,485,201 - 1,485,201 Long-term debt 4,294,777 4,528,499 8,823,276 Total non-current liabilities 18,861,800 4,528,499 23,390,299 Total liabilities 19,759,294 5,176,675 24,935,969 Net Position: Net investment in capital assets 3,422,594 1,608,738 5,031,332 Unrestricted 4,561,804 1,021,429 5,583,233 Total net position $ 7,984,398 $ 2,630,167 $ 10,614,565 Exhibit 5 ORANGE COUNTY,NORTH CAROLINA STATEMENT OF REVENUES,EXPENSES,AND CHANGES IN FUND NET POSITION-MAJOR PROPRIETARY FUNDS(UNAUDITED) FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Total Major Major Solid Waste SportsPlex Proprietary Fund Fund Funds Operating Revenues: Landfill fees $ 4,198,580 $ - $ 4,198,580 Service fees - 1,577,027 1,577,027 Other 58,916 - 58,916 Total operating revenues 4,257,496 1,577,027 5,834,523 Operating Expenses: Landfill 423,917 - 423,917 General and administrative 524,674 - 524,674 Recycling 1,521,762 - 1,521,762 Sanitation 849,609 - 849,609 Post-closing cost - - - Sportsplex - 1,407,472 1,407,472 Total operating expenses 3,319,962 1,407,472 4,727,434 Operating income(loss) 937,534 169,555 1,107,089 Non-Operating Revenues(Expenses): Investment earnings 4,525 - 4,525 Interest and fees (7,382) - (7,382) Contribution to other agency - - - Grant-State 113,824 - 113,824 Total non-operating revenues(expenses) 110,967 - 110,967 Income(loss)before contributions and transfers 1,048,501 169,555 1,218,056 Transfers in 934,748 - 934,748 Change in net position 1,983,249 169,555 2,152,804 Net Position: Beginning of year-July 1 6,001,149 2,460,612 8,461,761 Six Months Ended-December 31, $ 7,984,398 $ 2,630,167 $ 10,614,565 Attachment 6 Page 7 of 10 ORANGE COUNTY,NORTH CAROLINA COUNTY CAPITAL IMPROVEMENTS FUND SCHEDULE OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL(UNAUDITED) FROM INCEPTION AND FOR THE SIX MONTHS ENDED DECEMBER 31,2013 . Actual Budget Reported in Current Total to Date Prior Years Year to Date Revenues: Federal grants $ 5,888,842 $ 4,990,660 $ - $ 4,990,660 State grants 6,161,633 5,235,521 15,000 5,250,521 Investment earnings 2,624,400 3,338,388 5,197 3,343,585 Other 1,547,665 3,406,775 37,954 3,444,729 Total revenues 16,222,540 16,971,344 58,151 17,029,495 Expenditures: New Hope Creek Preserve 40,000 18,750 6,250 25,000 Jail 1,375,000 256,567 - 256,567 Justice facility and new courthouse -12,229,073 12,326,996 - 12,326,996 New courthouse - 218,797 - 218,797 Northern Human Services Center 714,545 363,931 29,569 393,500 Senior Center-Central Orange 6,460,533 6,147,769 - 6,147,769 Robert and Pearl Seymour Center 70,000 - - - Southern Human Services Center 280,000 - - - Whiffed Human Services Center 1,792,200 2,800 126,229 129,029 Animal services facility 9,168,864 9,157,734 480 9,158,214 EMS relocation and meadowlands annex 3,569,214 3,552,307 10,242 3,562,549 County campus,office building,and library 26,899,000 26,890,736 - 26,890,736 County other - 1,449,460 - 1,449,460 Blackwood Farm 2,437,435 2,279,170 - 2,279,170 Cedar Grove Park 1,848,000 1,847,999 - 1,847,999 Twin Creeks Park 2,579,457 844,937 - 844,937 Fairview Park 1,615,023 1,606,218 - 1,606,218 Conservation easement 1,733,208 1,705,824 170,028 1,875,852 Homestead Aquatics - 83,346 - 83,346 Lands Legacy 1,630,909 111,290 1,495 112,785 Parkland and recreation facilities 103,530 175,011 - 175,011 Seven Mile Creek Preserve 151,000 145,689 - 145,689 Southern Park - 38,196 - 38,196 SportsPlex Maintenance Reserve 100,000 - - - West Ten soccer complex 4,054,128 4,054,616 - 4,054,616 Central recreation repairs 416,980 412,323 2,118 414,441 Millhouse Road Park 264,802 258,712 - 258,712 Blackwood Farm Park 50,000 - - - Joint Artificial Turf Soccer 623,000 - 623,000 623,000 Roofmg projects 1,498,100 1,142,904 89,295 1,232,199 Affordable housing 2,808,804 2,036,344 - 2,036,344 Information technology 4,817,757 3,855,925 167,383 4,023,308 Register of Deeds'automation enhancement 500,450 246,701 13,164 259,865 Medicaid maximization 3,899,142 1,908,365 31,432 1,939,797 Loan Pool Reserve 275,000 200,000 - 200,000 Efland Sewer extension 1,798,240 111,251 - 111,251 HVAC projects 2,261,423 774,854 670,181 1,445,035 ADA compliance 16,058 16,058 - 16,058 Utilities demand reduction systems 130,000 106,055 - 106,055 Upfit of County Space-Link Center 1,752,662 1,302,023 14,790 1,316,813 Telephone system replacement 575,000 562,748 - 562,748 • Attachment 6 • Page 8 of 10 ORANGE COUNTY,NORTH CAROLINA COUNTY CAPITAL IMPROVEMENTS FUND SCHEDULE OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL(UNAUDITED) FROM INCEPTION AND FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Actual Budget Reported in Current Total to Date Prior Years Year to Date Hillsborough Commons 3,790,000 3,780,709 - 3,780,709 Board of Elections office 97,000 34,750 - 34,750 Piedmont Food and Agriculture Processing 1,494,825 1,425,285 - 1,425,285 Eno EDD 200,000 - 41,737 41,737 800 MHz Radios 700,000 473,436 - 473,436 Dental equipment 100,000 74,190 - 74,190 Buckhom EDD Phase 2 4,452,046 619,861 2,060,977 2,680,838 Payroll Software System 329,861 311,100 - 311,100 129 East King Street 145,000 109,991 - 109,991 Central Efland Buckhorn Sewer 4,848,400 3,569,274 5,295 3,574,569 McGowan Creek Outfall 755,450 7,740 33,086 40,826 Energy Bank 50,000 - 41,220- 41,220 Viper Radio System 543,750 - - - Communication System Improvements 1,101,978 744,261 593,236 1,337,497 Lake Orange Capital Maintenance 346,300 189,647 - 189,647 Observation Well Network 11,330 11,297 - 11,297 Jail New Campus - 3,419 - 3,419 Historic Rogers Road Community Center 650,000 - - - Future EMS Stations 50,000 - - - Southern Orange Campus(Future) 300,000 103,009 121,370 224,379 Southwest Branch Library 700,000 56,576 - 56,576 Interest and fees 1,566,376 948,611 139,407 1,088,018 Total expenditures 122,770,853 98,675,562 4,991,984 103,667,546 Revenues over(under)expenditures (106,548,313) (81,704,218) (4,933,833) (86,638,051) Other Financing Sources(Uses): Bond issuance costs 9,015,794 2,502,871 - 2,502,871 Refunding bonds 20,000,000 132,448,500 - 132,448,500 Bond premium 2,000,000 17,638,520 - 17,638,520 Installment loan issuance 75,211,065 59,567,506 8,859,497 68,427,003 Capital lease issuance - 2,540,999 - 2,540,999 Payment to escrow agent (20,603,624) (141,736,447) - (141,736,447) Transfers in 23,308,141 19,211,630 - 19,211,630 Transfers out (3,730,000) (3,424,264) - (3,424,264) Appropriated fund balance 1,346,937 - - - Total other financing sources(uses) 106,548,313 88,749,315 8,859,497 97,608,812 Net change in fund balance $ - $ 7,045,097 3,925,664 $ 10,970,761 Fund Balance: Beginning of year-July 1 7,045,097 Six Months Ended-December 31, $ 10,970,761 MIIIIIIIIIIIIIMMMIIIIIIIII.M.IIIIi' Attachment 7 ORANGE COUNTY,NORTH CAROLINA Page 9 of 10 SCHOOL CAPITAL IMPROVEMENTS FUND SCHEDULE OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL(UNAUDITED) FROM INCEPTION AND FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Actual Budget Reported in Current Total to Date Prior Years Year to Date Revenues: Investment earnings $ 60,000 $ 628,042 $ 2,360 $ 630,402 Sales tax 180,000 87,597 - 87,597 Lottery proceeds 2,892,139 2,959,057 - 2,959,057 Other - 33,759 19 33,778 Total revenues 3,132,139 3,708,455 2,379 3,710,834 Expenditures: Orange County Schools: A.L.Stanback Middle School 12,000 - - - Cameron Park Elementary 525,634 524,922 - 524,922 Efland Cheeks Elementary 423,449 389,814 - 389,814 Grady Brown Elementary 54,040 54,023 - 54,023 Hillsborough Elementary 362,899 241,878 - 241,878 New Hope Elementary renovations 325,000 242,740 - 242,740 Stanford Middle School 688,065 424,227 - 424,227 Orange-High School 558,767 554381 - 554,381 Orange High Track repairs 495,634 495,634 - 495,634 Alternative School 361,720 302,111 - 302,111 Indoor air quality 15,000 - - - Central elementary air 174,900 138,601 - 138,601 Classroom improvements 3,394,886 2,931,227 - 2,931,227 Electrical systems 290,000 170,685 - 170,685 Window replacements 573,567 228,131 - 228,131 Kitchen renovations project 27,785 - - - Mechanical systems 15,000 14,196 - 14,196 Paving/parking lot improvements 80,281 - - - Electrical service upgrades 33,000 - - - Planning for future projects 300,000 - - - Roofing projects 1,600,000 1,600,001 - 1,600,001 Technology plan 2,222,668 1,677,721 - 1,677,721 HVAC upgrade/improvements 1,493,961 741,652 - 741,652 District-wide improvements 247,745 231,154 - 231,154 Bathroom renovations 180,532 83,682 - 83,682 Fire/safety upgrades 333,569 263,224 - 263,224 Total Orange County Schools 14,790,102 11,310,004 - 11,310,004 ' Attachment 7 Page 10 of 10 ORANGE COUNTY,NORTH CAROLINA SCHOOL CAPITAL IMPROVEMENTS FUND SCHEDULE OF REVENUES,EXPENDITURES,AND CHANGES IN FUND BALANCE-BUDGET AND ACTUAL(UNAUDITED) FROM INCEPTION AND FOR THE SIX MONTHS ENDED DECEMBER 31,2013 Actual Budget Reported in Current Total to Date Prior Years Year to Date Chapel Hill Carrboro Schools: Elementary#11 23,137,196 20,359,848 2,192,912 22,552,760 Morris Grove Elementary 40,000 38,911 - 38,911 Transportation Center 309,500 289,540 - 289,540 Carrboro High School 75,000 75,000 - 75,000 Carrboro Arts Wing 4,048,028 4,048,027 - 4,048,027 Abatement projects 435,576 292,000 28,812 320,812 ADA requirements 200,505 141,371 13,132 154,503 ATH facilities/playgrounds 590,000 590,000 84,699 674,699 Emergency efficiency renovations 300,000 - 54,528 54,528 Classroom/academic improvements 785,682 744,553 227,476 972,029 Doors,hardware,canopies 158,000 87,610 6,817 94,427 Electrical systems 489,740 427,192 105,639 532,831 Fire,safety,and security 480,000 396,066 36,299 432,365 Indoor air quality 501,340 454,087 19,045 473,132 Mechanical systems 1,749,570 1,637,451 235,824 1,873,275 Mobile classrooms 497,696 458,702 68,046 526,748 Parking lot improvements 320,000 267,913 14,190 282,103 Planning for future projects 450,000 444,575 5,122 449,697 Roofing projects 5,360,009 5,301,880 18,365 5,320,245 Bathroom renovations 193,406 193,406 - 193,406 Technology 5,586,433 5,586,045 948,093 6,534,138 Window replacements 353,658 327,484 - 327,484 Culbreth Science Wing 600,000 - 93,986 93,986 Total Chapel Hill Carrboro Schools 46,661,339 42,161,661 4,152,985 46,314,646 Other expenditures 60,000 43,215 - 43,215 Total expenditures 61,511,441 53,514,880 4,152,985 57,667,865 Revenues over(under)expenditures (58,379,302) (49,806,425) 4,155,364 61,378,699 Other Financing Sources(Uses): Bonds issuance 14,170,874 14,170,873 - 14,170,873 Installment loan insurance 33,100,000 32,426,288 - 32,426,288 Transfers in 11,060,683 10,574,604 - 10,574,604 Appropriated fund balance 47,745 - - - Total other financing sources(uses) 58,379,302 57,171,765 - 57,171,765 Net change in fund balance $ - $ 7,365,340 (4,150,606) $ 3,214,734 Fund Balance: Beginning of year-July 1 7,365,340 Six Months Ended-December 31, $ 3,214,734