Full Text
1 / 2 Ogden City Council Work Session: February 28, 2017 FY2017 QUARTERLY FINANCIAL REPORT - Second Quarter Ending 12-31-16 Purpose of Work Session: To Review and Discuss the FY17 Second Quarter Budget Report Executive Summary The Council will review and discuss the Second Quarter FY2017 Financial Report. Background Utah Code Ann. § 10-6-147 requires that the city finance manager “prepare and present to the governing body appropriate quarterly financial reports, prepared in the manner prescribed in the Uniform Accounting Manual for Utah Cities.” The report is required only for the first, second and third quarters. The annual Comprehensive Financial Audit Report (CAFR) serves as the fourth quarter report. The Council adopts Financial Principles each year. These Financial Principles are jointly reviewed by the Administration and Council and can be amended as agreed. The adopted Financial Principles state the following regarding quarterly budget reports: 7. Not later than 45 days after the end of each quarter, the Administration shall provide quarterly financial reports to the City Council that include the following: a. Actuals to budgeted revenues and expenditures b. Balance sheet for governmental funds c. Fund balance analysis for governmental funds d. Cash balance analysis for proprietary funds These reports are not required to contain notes to the financial statements. Estimates can be included where appropriate. ---PAGE BREAK--- 2 / 2 Ogden City Council Work Session: February 28, 2017 February 15, 2017 The Council Office received an Administrative Transmittal and the Quarterly Financial Report for the second quarter of FY2017. Proposal/Review With the exception of some General Fund revenues, the budget is tracking with the FY2017 budget. General Fund Revenues The Second quarter report suggests that sales tax, telecommunications and parking violations revenue may have been over estimated for the FY2017 budget. However, the corrections to the B&C Road Funds calculations that occurred during an interim legislative session in 2016 adds an additional $770,000 in revenues. As a result, the Administration is currently projecting a $524,398 excess in General Fund revenues. Other Funds The other City funds are tracking with the FY2017 Budget. Questions 1. Please discuss the issues with sales tax, telecommunications, parking violations, and B&C road funds revenues. 2. Please highlight any other important items in the quarterly financial report. Council Staff Contact: Janene Eller-Smith, (801)629-8165 ---PAGE BREAK--- OGDEN CITY COUNCIL TRANSMITTAL Date: February 13, 2017 To: Ogden City Council From: Lisa Stout, Comptroller RE: Financial Quarterly Report Staff Contact: Lisa Stout, Comptroller, extension 8713 Recommendation: Accept for review Document(s): Ogden City Financial Quarterly Report Executive Summary The attached Financial Quarterly Report for the quarter ended December 31st, includes the following: Fund Revenue & Expenditure Summary General Fund Revenue Summary General Fund Departmental Expenditure Summary Special Assessment Funds Revenue & Expenditure Summary Capital Improvement Fund Revenue & Expenditure Summary Enterprise Funds Revenue & Expenditure Summary with Statement of Revenues, Expenses, & Cash Statement Internal Service Funds Revenue & Expenditure Summary Trust Funds Financial Information Grant Funds Financial Information RDA Fund Financial Information MBA Fund Financial Information Background Please note the following: The data used to create this report is unaudited Proposal Accept for review and discussion at a work session as needed. Fiscal Impact No fiscal impact. ---PAGE BREAK--- Ogden City Financial Quarterly Report Period Ending 12/31/2016 Unaudited ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE GENERAL FUND REVENUE 56,416,840 29,425,178 52% 26,991,662 EXPENDITURES 56,416,840 24,374,065 43% 32,042,775 ‐ 5,051,113 SPECIAL ASSESSMENT FUNDS REVENUE 276,750 219,791 79% 56,959 EXPENDITURES 276,750 63,886 23% 212,864 ‐ 155,905 CAPITAL IMPROVEMENTS FUND REVENUE 4,365,250 2,225,051 51% 2,140,199 EXPENDITURES 4,365,250 7,193,002 165% (2,827,752) ‐ (4,967,951) WATER UTILITY FUND REVENUE 37,958,500 11,583,209 31% 26,375,291 EXPENDITURES 37,958,500 11,390,643 30% 26,567,857 ‐ 192,566 SANITARY SEWER UTILITY FUND REVENUE 13,770,925 5,617,918 41% 8,153,007 EXPENDITURES 13,770,925 6,636,746 48% 7,134,179 ‐ (1,018,828) REFUSE UTILITY FUND REVENUE 5,525,400 2,789,864 50% 2,735,536 EXPENDITURES 5,525,400 2,376,076 43% 3,149,324 ‐ 413,787 HINCKLEY AIRPORT FUND REVENUE 3,435,675 313,996 9% 3,121,679 EXPENDITURES 3,435,675 1,368,957 40% 2,066,718 ‐ (1,054,962) GOLF FUND REVENUE 1,652,775 718,635 43% 934,140 EXPENDITURES 1,652,775 693,519 42% 959,256 ‐ 25,116 RECREATION ENTERPRISE FUND REVENUE 273,350 92,515 34% 180,835 EXPENDITURES 273,350 169,870 62% 103,480 ‐ (77,355) PROPERTY MANAGEMENT FUND ‐ BDO REVENUE 18,577,950 1,465,947 8% 17,112,003 EXPENDITURES 18,577,950 10,032,680 54% 8,545,270 ‐ (8,566,733) OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of December 31, 2016 1 of 2 ---PAGE BREAK--- BUDGET ACTUAL PERCENT BALANCE OGDEN CITY FUND REVENUE & EXPENDITURE SUMMARY As of December 31, 2016 STORM SEWER FUND REVENUE 6,746,125 2,330,169 35% 4,415,956 EXPENDITURES 6,746,125 2,066,995 31% 4,679,130 ‐ 263,174 MEDICAL FUND REVENUE 7,799,425 3,550,881 46% 4,248,544 EXPENDITURES 7,799,425 3,057,103 39% 4,742,322 ‐ 493,779 FACILITIES/FLEET/STORES FUND REVENUE 10,818,900 5,066,978 47% 5,751,922 EXPENDITURES 10,818,900 5,078,610 47% 5,740,290 ‐ (11,632) MANAGEMENT INFORMATION SYSTEMS FUND REVENUE 5,698,850 2,804,431 49% 2,894,419 EXPENDITURES 5,698,850 2,437,712 43% 3,261,138 ‐ 366,719 RISK MANAGEMENT FUND REVENUE 1,604,500 837,978 52% 766,522 EXPENDITURES 1,604,500 1,289,134 80% 315,366 ‐ (451,156) NICHOLAS & CEMETERY TRUST FUNDS REVENUE 22,750 9,610 42% 13,140 EXPENDITURES 22,750 2,395 11% 20,355 ‐ 7,215 MISCELLANEOUS GRANTS & DONATIONS FUND REVENUE 24,125 (153,392) ‐636% 177,517 EXPENDITURES 24,125 142,310 590% (118,185) ‐ (295,702) MAJOR GRANTS FUND REVENUE 9,748,100 3,900,361 40% 5,847,739 EXPENDITURES 9,748,100 4,430,793 45% 5,317,307 ‐ (530,432) REDEVELOPMENT AGENCY REVENUE 27,168,935 15,162,309 56% 12,006,626 EXPENDITURES 27,168,935 6,964,527 26% 20,204,408 ‐ 8,197,782 MUNICIPAL BUILDING AUTHORITY REVENUE 550,475 273,203 50% 277,272 EXPENDITURES 550,475 508,429 92% 42,046 ‐ (235,226) TOTAL ALL FUNDS AND AGENCIES REVENUE $205,689,475 $85,904,464 42% $119,785,011 EXPENDITURES $205,689,475 $88,210,457 43% $117,479,018 $0 ($2,305,993) 2 of 2 ---PAGE BREAK--- TAXES 1 BUDGET RECEIVED PERCENT BALANCE $41,504,400 $21,959,620 53% $19,544,780 $19,389,180 ($155,600) LICENSES AND PERMITS 2 BUDGET RECEIVED PERCENT BALANCE $2,529,775 $1,307,911 52% $1,221,864 $1,221,864 INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $4,754,215 $2,303,491 48% $2,450,724 $3,220,724 $770,000 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,853,100 $1,885,403 49% $1,967,697 $1,967,697 FINES AND FORFEITURES 5 BUDGET RECEIVED PERCENT BALANCE $2,299,875 $1,072,154 47% $1,227,721 $1,137,721 ($90,000) OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE 1,475,475 896,601 61% $578,874 $578,874 FUND TOTALS $56,416,840 $29,425,178 52% $26,991,662 $27,516,060 ANTICIPATED NET GENERAL FUND REVENUES OVER (SHORT) of BUDGET $524,398 PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS Sales tax has come in under budget, year today the City is $55,600 under budget. Telecommunication taxes are expected to come in under budget by approximately $100,000. Most grants require reports of actual expenditures before reimbursement. B&C road fund and active transportation funds are included in this category and make up the majority of this revenue class. Class B&C Road Funds are received quarterly, active transportation tax is received and beer tax is received in November. The receipt of this revenue lags behind and is anticipated to exceed projects in B&C road funds. The City lowered the B&C road funds projection due to some uncertainty at the State. This has been resolved and City adminsitration will propose an increase in the B&C road funds budget. EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) OGDEN CITY GENERAL FUND REVENUE SUMMARY As of December 31, 2016 PROJECTED RECEIPTS EXCESS (SHORTAGE) GENERAL FUND ‐ 1000 EXCESS (SHORTAGE) PROJECTED RECEIPTS The majority of business license revenue is received during November through February. It is anticipated the revenue accounted for as licenses and permits will meet budgeted expectations. At this time, it is anticipated that Parking Violations could be $90,000 short. Revenue projections are expected to be met. PROJECTED RECEIPTS EXCESS (SHORTAGE) ---PAGE BREAK--- GENERAL FUND MAYOR BUDGET EXPENDED PERCENT BALANCE 100 PERSONNEL SERVICES 570,525 259,040 45% 311,485 SUPPLIES 16,975 5,229 31% 11,746 CHARGES FOR SERVICES 41,750 14,344 34% 27,406 OTHER OPER EXPENSES 16,575 3,155 19% 13,420 TOTAL 645,825 $ 281,768 $ 44% 364,057 $ COUNCIL BUDGET EXPENDED PERCENT BALANCE 150 PERSONNEL SERVICES 904,500 425,131 47% 479,369 SUPPLIES 5,550 1,031 19% 4,519 CHARGES FOR SERVICES 146,500 48,829 33% 97,671 OTHER OPER EXPENSES 53,300 19,141 36% 34,159 TOTAL 1,109,850 $ 494,132 $ 45% 615,718 $ MANAGEMENT SERVICES BUDGET EXPENDED PERCENT BALANCE 200 PERSONNEL SERVICES 3,607,100 1,586,232 44% 2,020,868 SUPPLIES 93,825 35,978 38% 57,847 CHARGES FOR SERVICES 732,925 257,178 35% 475,747 OTHER OPER EXPENSES 114,100 34,531 30% 79,569 CAPITAL OUTLAY 3,015 7,835 260% (4,820) TOTAL 4,550,965 $ 1,921,754 $ 42% 2,629,211 $ CITY ATTORNEY BUDGET EXPENDED PERCENT BALANCE 250 PERSONNEL SERVICES 1,150,250 534,100 46% 616,150 SUPPLIES 14,325 6,328 44% 7,997 CHARGES FOR SERVICES 63,375 24,326 38% 39,049 OTHER OPER EXPENSES 11,525 4,734 41% 6,791 TOTAL 1,239,475 $ 569,488 $ 46% 669,987 $ NON DEPARTMENTAL BUDGET EXPENDED PERCENT BALANCE 300 PERSONNEL SERVICES 200,000 ‐ 0% 200,000 CHARGES FOR SERVICES 1,459,575 635,173 44% 824,402 OTHER OPER EXPENSES 1,420,300 601,781 42% 818,519 DATA PROCESSING 1,741,775 870,875 50% 870,900 DEBT SERVICE 147,325 75,386 51% 71,939 CAPITAL OUTLAY 70,000 118,574 169% (48,574) INTERFUND TRANSFERS 1,740,350 818,900 47% 921,450 TOTAL 6,779,325 $ 3,120,688 $ 46% 3,658,637 $ OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of December 31, 2016 As a reminder, the $200,000 in Personnel in Non‐Departmental is the Contingency for vacation buy‐back. Debt service is not paid evenly throughout the fiscal year. Capital outlay is overbudget due to a property purchased that was budgeted in FY16, the carryforward of this budget has not yet been posted for $91,800. 1 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of December 31, 2016 POLICE BUDGET EXPENDED PERCENT BALANCE 350 PERSONNEL SERVICES 17,598,650 7,575,444 43% 10,023,206 SUPPLIES 371,600 156,357 42% 215,243 CHARGES FOR SERVICES 1,147,175 190,222 17% 956,953 OTHER OPER EXPENSES 924,925 408,357 44% 516,568 TOTAL 20,042,350 $ 8,330,379 $ 42% 11,711,971 $ FIRE BUDGET EXPENDED PERCENT BALANCE 400 PERSONNEL SERVICES 7,371,350 3,422,329 46% 3,949,021 SUPPLIES 158,019 49,222 31% 108,797 CHARGES FOR SERVICES 79,900 27,419 34% 52,481 OTHER OPER EXPENSES 313,656 172,101 55% 141,555 CAPITAL OUTLAY 9,000 1,419 16% 7,581 TOTAL 7,931,925 $ 3,672,490 $ 46% 4,259,435 $ PUBLIC SERVICES PUBLIC SERVICES ADMIN BUDGET EXPENDED PERCENT BALANCE 850100 PERSONNEL SERVICES 464,200 151,324 33% 312,876 SUPPLIES 34,050 (59,693) ‐175% 93,743 CHARGES FOR SERVICES 13,525 4,048 30% 9,477 OTHER OPER EXPENSES 47,125 22,992 49% 24,133 TOTAL 558,900 $ 118,671 $ 21% 440,229 $ PARKS/CEMETERY BUDGET EXPENDED PERCENT BALANCE 850200 PERSONNEL SERVICES 1,922,450 871,740 45% 1,050,710 SUPPLIES 236,300 78,853 33% 157,447 CHARGES FOR SERVICES 606,250 482,474 80% 123,776 OTHER OPER EXPENSES 435,950 183,941 42% 252,009 TOTAL 3,200,950 $ 1,617,009 $ 51% 1,583,941 $ RECREATION BUDGET EXPENDED PERCENT BALANCE 850400 PERSONNEL SERVICES 910,000 451,663 50% 458,337 SUPPLIES 105,475 43,243 41% 62,232 CHARGES FOR SERVICES 394,850 109,803 28% 285,047 OTHER OPER EXPENSES 57,400 28,668 50% 28,732 DATA PROCESSING 11,050 4,089 37% 6,961 TOTAL 1,478,775 $ 637,466 $ 43% 841,309 $ CHRISTMAS VILLAGE & AMPHITHEATRE BUDGET EXPENDED PERCENT BALANCE 850800 PERSONNEL SERVICES 140,475 114,565 82% 25,910 SUPPLIES 34,500 34,839 101% (339) CHARGES FOR SERVICES 10,000 8,429 84% 1,571 OTHER OPER EXPENSES 64,500 18,183 28% 46,317 TOTAL 249,475 $ 176,017 $ 71% 73,458 $ Christmas Village is a seasonal activity, it is epected that the expenditures are primarily during the 2nd quarter of the year. 2 of 3 ---PAGE BREAK--- GENERAL FUND OGDEN CITY GENERAL FUND DEPARTMENTAL EXPENDITURE SUMMARY As of December 31, 2016 STREETS BUDGET EXPENDED PERCENT BALANCE 855200 PERSONNEL SERVICES 1,234,550 544,571 44% 689,979 SUPPLIES 173,850 34,498 20% 139,352 CHARGES FOR SERVICES 541,775 183,562 34% 358,213 OTHER OPER EXPENSES 1,213,100 396,683 33% 816,417 TOTAL 3,163,275 $ 1,159,313 $ 37% 2,003,962 $ ENGINEERING BUDGET EXPENDED PERCENT BALANCE 855300 PERSONNEL SERVICES 961,075 469,624 49% 491,451 SUPPLIES 13,700 3,846 28% 9,855 CHARGES FOR SERVICES (153,675) (294,436) 192% 140,761 OTHER OPER EXPENSES 44,400 12,642 28% 31,758 TOTAL 865,500 $ 191,675 $ 22% 673,825 $ COMMUNITY & ECONOMIC DEVELOPMENT BUDGET EXPENDED PERCENT BALANCE 550 PERSONNEL SERVICES 3,734,875 1,670,448 45% 2,064,427 SUPPLIES 77,650 34,774 45% 42,876 CHARGES FOR SERVICES 341,000 173,331 51% 167,669 OTHER OPER EXPENSES 446,725 121,208 27% 325,517 DATA PROCESSING ‐ 100 (100) CAPITAL OUTLAY ‐ 83,353 (83,353) TOTAL 4,600,250 $ 2,083,215 $ 45% 2,517,035 $ GENERAL FUND TOTALS 56,416,840 24,374,065 43% 32,042,775 Charges for services budget and expenses are negative due to a reclassification of expenses to the Utility Funds. 3 of 3 ---PAGE BREAK--- SPECIAL ASSESSMENTS FUNDS ‐ 2100 & 3100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $275,000 $218,629 80% $56,371 $56,371 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $1,750 $1,162 66% $588 $588 FUND TOTALS $276,750 $219,791 79% $56,959 $56,959 ANTICIPATED NET SPEC REVENUE FDS REV OVER (SHORT) of BUDGET $0 EXPENDITURES SPECIAL ASSESSMENTS BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $149,250 $63,886 43% $85,364 OTHER OPER EXPENSES $70,000 $0 0% $70,000 OTHER FINANCING USES $57,500 $0 0% $57,500 TOTAL $276,750 $63,886 23% $212,864 OGDEN CITY SPECIAL ASSESSMMENT FUNDS REVENUE & EXPENSE SUMMARY As of December 31, 2016 Interest income is the revenue source accounted for as other revenue in these funds. PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) Includes transient room taxes and the downtown special assessment levy. The special assessment levy is being billed by the County and the revenue estimated was received in December, when property taxes are collected. ---PAGE BREAK--- CAPITAL IMPROVEMENT FUND ‐ 4100 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $83,000 $0 0% $83,000 $83,000 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $0 $37,500 ($37,500) $37,500 $0 Payment from Dino Park to be used for Trails. A budget opening to recognize this revenue is need for FY17 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $4,282,250 $2,187,551 51% $2,094,699 $2,094,699 FUND TOTALS $4,365,250 $2,225,051 51% $2,140,199 $2,215,199 ANTICIPATED NET CIP FUND REVENUES OVER (SHORT) of BUDGET EXPENDITURES CAPITAL IMPROVEMENTS BUDGET EXPENDED PERCENT BALANCE MANAGEMENT SERVICES $100,000 $67,935 68% $32,065 NON DEPARTMENTAL $743,825 $219,261 29% $524,564 FIRE $0 $4,510 ($4,510) PUBLIC SERVICES $3,521,425 $6,901,296 196% ($3,379,871) TOTAL $4,365,250 $7,193,002 165% ($2,827,752) Detail expenditures by project are provided in the CIP quarterly report RAMP funds are included in this category. PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY CAPITAL IMPROVEMENT FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 Revenue accounted for as other revenue includes a road funds and active transportation funds transfer from the general fund, a transfer from the BDO fund, a transfer from the Gomer Nicholas Andowment Fund for parks and interest income. The CIP projects carryovers from FY 2016 has not been posted to the general ledger as of December 31st. ---PAGE BREAK--- WATER UTILITY FUND ‐ 5100 REVENUE TAXES 1 BUDGET RECEIVED PERCENT BALANCE $864,600 $0 0% $864,600 $864,600 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $19,140,975 $11,560,417 60% $7,580,558 $7,580,558 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $17,952,925 $22,792 0% $17,930,133 $17,930,133 $0 FUND TOTALS $37,958,500 $11,583,209 31% $26,375,291 $26,375,291 ANTICIPATED NET WATER FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES WATER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $4,034,100 $1,808,617 45% $2,225,483 SUPPLIES $1,086,850 $651,097 60% $435,753 CHARGES FOR SERVICES $1,996,675 $541,579 27% $1,455,096 OTHER OPER EXPENSES $5,008,125 $2,050,085 41% $2,958,040 DATA PROCESSING $526,125 $211,625 40% $314,500 NON OPERATING EXPENSE $7,406,200 $4,841,856 65% $2,564,344 CAPITAL OUTLAY $17,860,425 $1,245,783 7% $16,614,642 OTHER FINANCING USES $40,000 $40,000 100% $0 TOTAL $37,958,500 $11,390,643 30% $26,567,857 Other Financing Uses is a transfer for percent for arts Profit/(Loss) to date (encumbrances not included) $192,566 Cash in Bank September 30, 2016 $11,228,975 Cash in Bank December 31, 2016 $10,986,168 OGDEN CITY WATER FUND REVENUE & EXPENSE SUMMARY EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) Includes bond proceeds of $17,000,000 and use of retained earnings for capital outlay. PROJECTED RECEIPTS PROJECTED RECEIPTS PROJECTED RECEIPTS This is a budget to for a end of year adjustments. It is to recognize Weber Basin Water District tax revenue collect directly by Weber Basin to provide for Ogden City costs. At this time, it is expected revenue will meet projections As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH WATER FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 18,284,575 $ 6,953,815 $ 4,178,399 $ 11,132,214 60.9% Special district taxes 864,600 - - - 0.0% Accounting charges 856,400 214,025 214,178 428,203 50.0% Miscellaneous income 7,500 11 20 31 0.4% Total revenue 20,013,075 7,167,851 4,392,597 11,560,448 57.8% OPERATING EXPENSES: Personal services: Salaries and wages 2,614,550 590,481 582,708 1,173,189 44.9% Benefits 1,422,700 318,819 317,766 636,585 44.7% Supplies: Office supplies 241,600 35,203 54,587 89,790 37.2% Operating supplies 592,450 177,738 213,145 390,883 66.0% Repair and maintenance supplies 274,150 130,246 88,604 218,850 79.8% Charges for services: Public utility services 648,600 119,524 148,676 268,200 41.4% Travel and education 71,000 12,300 11,756 24,056 33.9% Contracted agreements 1,408,925 150,836 138,669 289,505 20.5% Other operating expenses: Rental charges 114,550 28,600 28,650 57,250 50.0% Fiscal charges 3,104,300 776,225 776,025 1,552,250 50.0% Depreciation 2,000,000 - 1,405,947 1,405,947 70.3% Data processing and computer equipment 526,125 106,375 105,250 211,625 40.2% Maintenance and repair 755,925 85,121 81,489 166,610 22.0% Vehicle operating expenses 479,575 106,494 101,042 207,536 43.3% Water purchase 1,013,125 - - - 0.0% Miscellaneous 488,600 47,008 75,970 122,978 25.2% Total operating expenses 15,756,175 2,684,970 4,130,284 6,815,254 43.3% Operating income (loss) 4,256,900 4,482,881 262,313 4,745,194 111.5% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 50,000 1,359 - 1,359 2.7% Gain on sale of assets 35,000 9,021 12,381 21,402 61.1% Bond proceeds 17,000,000 - - - 0.0% Expenses: Capital improvements (17,860,425) (403,331) (842,452) (1,245,783) 7.0% Debt service - principal (1,913,800) (712,263) (760,247) (1,472,510) 76.9% Interest expense (2,388,100) (655,462) (1,161,634) (1,817,096) 76.1% Total non-operating revenues (expenses) (5,077,325) (1,760,676) (2,751,952) (4,512,628) 88.9% Income before operating transfers (820,425) 2,722,205 (2,489,639) 232,566 -28.3% Transfers in (use of fund balance) 860,425 - - - 0.0% Transfers out (40,000) (40,000) - (40,000) 100.0% Change in net assets $ - $ 2,682,205 $ (2,489,639) $ 192,566 Cash Summary: Cash, Beginning of quarter $ 9,189,593 $ 11,228,975 Cash, End of quarter $ 11,228,975 $ 10,986,168 ---PAGE BREAK--- SANITARY SEWER UTILITY FUND ‐ 5110 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $10,946,775 $5,616,403 51% $5,330,372 $5,330,372 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $2,824,150 $1,515 0% $2,822,635 $2,822,635 FUND TOTALS $13,770,925 $5,617,918 41% $8,153,007 $8,153,007 ANTICIPATED NET SEWER FUND REVENUES OVER (SHORT) of BUDGET EXPENDITURES SANITARY SEWER UTILITY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $903,025 $332,166 37% $570,859 SUPPLIES $77,675 $29,824 38% $47,851 CHARGES FOR SERVICES $870,525 $443,608 51% $426,917 OTHER OPER EXPENSES $6,084,950 $3,035,060 50% $3,049,890 DATA PROCESSING $83,125 $41,425 50% $41,700 NON OPERATING EXPENSE $2,454,475 $1,361,084 55% $1,093,392 CAPITAL OUTLAY $1,929,300 $466,580 24% $1,462,720 OTHER FINANCING USES $1,367,850 $927,000 68% $440,850 TOTAL $13,770,925 $6,636,746 48% $7,134,179 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) ‐$1,018,828 Cash in Bank September 30, 2016 $14,834,937 Cash in Bank December 31, 2016 $14,186,942 PROJECTED RECEIPTS Includes use of retained earnings for capital outlay. EXCESS (SHORTAGE) SANITARY SEWER FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 PROJECTED RECEIPTS OGDEN CITY At this time, it is expected revenue will meet projections EXCESS (SHORTAGE) ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH SANITARY SEWER FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 10,946,775 $ 2,882,028 $ 2,734,376 $ 5,616,404 51.3% Miscellaneous income 12,150 230 300 530 4.4% Total revenue 10,958,925 2,882,258 2,734,676 5,616,934 51.3% OPERATING EXPENSES: Personal services: Salaries and wages 594,300 113,498 114,059 227,557 38.3% Benefits 309,025 52,851 51,858 104,709 33.9% Supplies: Office supplies 725 107 - 107 14.8% Operating supplies 66,950 7,853 15,384 23,237 34.7% Repair and maintenance supplies 4,175 225 150 375 9.0% Charges for services: Sewer district charges 4,991,150 1,259,020 1,247,788 2,506,808 50.2% Public utility services 3,075 828 753 1,581 51.4% Travel and education 4,000 - 144 144 3.6% Contracted agreements 728,475 146,925 160,182 307,107 42.2% Other operating expenses: Rental charges 47,475 11,925 11,850 23,775 50.1% Fiscal charges 1,884,950 471,050 471,300 942,350 50.0% Depreciation 450,000 - 290,437 290,437 64.5% Data processing and computer equipment 83,125 20,575 20,850 41,425 49.8% Maintenance and repair 539,975 198,103 65,884 263,987 48.9% Vehicle operating expenses 155,600 60,108 30,377 90,485 58.2% Miscellaneous 41,250 - 348 348 0.8% Total operating expenses 9,904,250 2,343,068 2,481,364 4,824,432 48.7% Operating income (loss) 1,054,675 539,190 253,312 792,502 75.1% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 143,000 984 - 984 0.7% Gain on sale of assets 550,000 - - - 0.0% Expenses: Other (return to fund balance) (440,850) - - - 0.0% Capital improvements (1,929,300) - (466,580) (466,580) 24.2% Debt service - Principal (260,200) (99,988) (106,808) (206,796) 79.5% Interest expense (309,325) (77,988) (133,950) (211,938) 68.5% Total non-operating revenues (expenses) (2,246,675) (176,992) (707,338) (884,330) 39.4% Income before operating transfers (1,192,000) 362,198 (454,026) (91,828) 7.7% Transfers in (use of fund balance) 2,119,000 - - - 0.0% Transfers out (927,000) (15,000) (912,000) (927,000) 100.0% Change in net assets $ - $ 377,198 $ (1,366,026) $ (1,018,828) Cash Summary: Cash, Beginning of quarter $ 14,709,182 $ 14,834,937 Cash, End of quarter $ 14,834,937 $ 14,186,942 ---PAGE BREAK--- REFUSE FUND ‐ 5120 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,521,400 $2,764,850 50% $2,756,550 $2,756,550 OTHER REVENUE CATEGORIES PROJECTED 6,7,&8 BUDGET RECEIVED PERCENT BALANCE RECEIPTS $4,000 $25,014 625% ($21,014) $0 $21,014 FUND TOTALS $5,525,400 $2,789,864 50% $2,735,536 $2,756,550 ANTICIPATED NET REFUSE FUND REVENUES OVER (SHORT) of BUDGET $21,014 EXPENDITURES REFUSE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,118,050 $521,472 47% $596,578 SUPPLIES $196,075 $45,041 23% $151,034 CHARGES FOR SERVICES $1,360,200 $522,794 38% $837,406 OTHER OPER EXPENSES $1,159,625 $738,746 64% $420,879 DATA PROCESSING $61,075 $30,475 50% $30,600 NON OPERATING EXPENSE $978,650 $489,350 50% $489,300 CAPITAL OUTLAY $75,000 $28,197 38% $46,803 OTHER FINANCING USES $576,725 $0 0% $576,725 TOTAL $5,525,400 $2,376,076 43% $3,149,324 Other Financing Uses is budgeted profit from operations Profit/(Loss) to date (encumbrances not included) $413,787 Cash in Bank September 30, 2016 $2,783,660 Cash in Bank December 31, 2016 $2,848,214 PROJECTED RECEIPTS OGDEN CITY REFUSE FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 EXCESS (SHORTAGE) EXCESS (SHORTAGE) At this time, it is expected revenue will meet projections ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH REFUSE FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,521,400 $ 1,380,730 $ 1,384,120 $ 2,764,850 50.1% Miscellaneous income 3,000 - - - 0.0% Total revenue 5,524,400 1,380,730 1,384,120 2,764,850 50.0% OPERATING EXPENSES: Personal services: Salaries and wages 761,225 174,279 184,021 358,300 47.1% Benefits 357,450 81,786 81,867 163,653 45.8% Supplies: Office supplies 1,700 309 212 521 30.6% Operating supplies 18,275 4,817 10,113 14,930 81.7% Repair and maintenance supplies 2,900 500 450 950 32.8% Charges for services: Disposal charges 1,075,300 118,620 308,708 427,328 39.7% Public utility services 2,475 675 600 1,275 51.5% Travel and education 6,725 66 - 66 1.0% Contracted agreements 149,950 12,837 13,033 25,870 17.3% Other operating expenses: Rental charges 64,275 16,125 16,050 32,175 50.1% Fiscal charges 1,144,300 286,150 286,050 572,200 50.0% Depreciation 45,000 - 21,059 21,059 46.8% Data processing and computer equipment 61,075 15,175 15,300 30,475 49.9% Maintenance and repair 122,500 19,201 31,990 51,191 41.8% Vehicle operating expenses 880,400 295,873 350,298 646,171 73.4% Miscellaneous 255,125 14,334 15,578 29,912 11.7% Total operating expenses 4,948,675 1,040,747 1,335,329 2,376,076 48.0% Operating income (loss) 575,725 339,983 48,791 388,774 67.5% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 25,014 - 25,014 2501.4% Total non-operating revenues (expenses) 1,000 25,014 - 25,014 2501.4% Income before operating transfers 576,725 364,997 48,791 413,788 71.7% Transfers out (576,725) - - - 0.0% Change in net assets $ - $ 364,997 $ 48,791 $ 413,788 Cash Summary: Cash, Beginning of quarter $ 1,884,529 $ 2,783,660 Cash, End of quarter $ 2,783,660 $ 2,848,214 ---PAGE BREAK--- HINCKLEY AIRPORT FUND ‐ 5130 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $1,000,000 ‐$246,031 ‐25% $1,246,031 $1,246,031 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $371,500 $118,402 32% $253,098 $253,098 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $2,064,175 $441,624 21% $1,622,551 $1,622,551 $0 FUND TOTALS $3,435,675 $313,996 9% $3,121,679 $3,121,679 ANTICIPATED NET AIRPORT FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES AIRPORT BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $483,475 $223,513 46% $259,962 SUPPLIES $40,600 $15,290 38% $25,310 CHARGES FOR SERVICES $124,825 $53,133 43% $71,692 OTHER OPER EXPENSES $1,307,800 $726,033 56% $581,767 DATA PROCESSING $17,300 $8,810 51% $8,490 DEBT SERVICE $115,425 $57,675 50% $57,750 CAPITAL OUTLAY $1,346,250 $284,504 21% $1,061,746 TOTAL $3,435,675 $1,368,957 40% $2,066,718 Capital outlay expense is related to FAA grants. Profit/(Loss) to date (encumbrances not included) ($1,054,962) Cash in Bank September 30, 2016 ($340,430) Cash in Bank December 31, 2016 ($567,155) PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY AIRPORT FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 Intergovernmental revenue generally requires the Airport fund to incure the expenses before reimbursements are drawn down. Generally federal funding is related to taxiway maintenance. Intergovernmental revenue had a negative balance due to grant revenue receivable accrued to FY16. The City had not received the payment as of December 31st. It is expected the City will receive this payment during November, which corrects the negative revenue reported here. Includes use of retained earnings, the majority of which represents depreciation the airport fund will have during FY17 and contribution from the General Fund. PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) The major item in this category is land rental which is received in January. ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH AIRPORT FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 376,500 $ 45,365 $ 73,211 $ 118,576 31.5% Grants and donations 1,000,000 (243,936) (2,095) (246,031) -24.6% Miscellaneous income 21,000 5,410 15,340 20,750 98.8% Total revenue 1,397,500 (193,161) 86,456 (106,705) -7.6% OPERATING EXPENSES: Personal services: Salaries and wages 352,625 79,644 79,242 158,886 45.1% Benefits 130,850 32,286 32,341 64,627 49.4% Supplies: Office supplies 3,850 623 700 1,323 34.4% Operating supplies 30,175 1,599 8,549 10,148 33.6% Repair and maintenance supplies 11,825 4,527 1,842 6,369 53.9% Charges for services: Public utility services 70,775 6,792 16,508 23,300 32.9% Travel and education 19,000 557 8,209 8,766 46.1% Contracted agreements 70,050 17,146 11,420 28,566 40.8% Other operating expenses: Rental charges 2,550 525 675 1,200 47.1% Depreciation 1,100,000 - 673,327 673,327 61.2% Data processing and computer equipment 17,300 4,390 4,420 8,810 50.9% Maintenance and repair 127,900 6,928 18,708 25,636 20.0% Vehicle operating expenses 95,700 688 13,651 14,339 15.0% Miscellaneous 16,400 826 655 1,481 9.0% Total operating expenses 2,049,000 156,531 870,247 1,026,778 50.1% Operating income (loss) (651,500) (349,692) (783,791) (1,133,483) -174.0% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 500 - - - 0.0% Expenses: Capital Improvements (1,271,250) (68,500) (216,004) (284,504) 22.4% Debt Service - Principal (115,425) (28,800) (28,875) (57,675) 50.0% Total non-operating revenues (expenses) (1,386,175) (97,300) (244,879) (342,179) 24.7% Income before operating transfers (2,037,675) (446,992) (1,028,670) (1,475,662) 72.4% Transfers in (or use of retained earnings) 2,037,675 278,500 142,200 420,700 20.6% Change in net assets $ - $ (168,492) $ (886,470) $ (1,054,962) Cash Summary: Cash, Beginning of quarter $ (385,490) $ (340,430) Cash, End of quarter $ (340,430) $ (567,155) ---PAGE BREAK--- GOLF FUND ‐ 5150 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $1,096,000 $489,026 45% $606,974 $606,974 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $556,775 $229,609 41% $327,166 $327,166 $0 FUND TOTALS $1,652,775 $718,635 43% $934,140 $934,140 ANTICIPATED NET GOLF FUND REVENUES OVER (SHORT) of BUDGET $0 EXPENDITURES GOLF COURSES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $629,450 $317,441 50% $312,009 SUPPLIES $80,625 $17,893 22% $62,732 CHARGES FOR SERVICES $138,300 $45,283 33% $93,017 OTHER OPER EXPENSES $423,800 $216,433 51% $207,367 DATA PROCESSING $11,200 $5,500 49% $5,700 NON OPERATING EXPENSE $133,650 $66,750 50% $66,900 CAPITAL OUTLAY $235,750 $24,220 10% $211,530 TOTAL $1,652,775 $693,519 42% $959,256 Profit/(Loss) to date (encumbrances not included) $25,116 Cash in Bank September 30, 2016 $184,218 Cash in Bank December 31, 2016 $21,298 PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) Includes a transfer for the sprinkler system CIP and use of retained earnings. OGDEN CITY GOLF FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH GOLF FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 1,096,000 $ 374,872 $ 114,154 $ 489,026 44.6% Miscellaneous income 6,000 1,354 1,005 2,359 39.3% Total revenue 1,102,000 376,226 115,159 491,385 44.6% OPERATING EXPENSES: Cost of materials and parts 143,400 23,127 10,947 34,074 23.8% Personal services: Salaries and wages 490,900 151,257 95,587 246,844 50.3% Benefits 138,550 37,903 32,694 70,597 51.0% Supplies: Office supplies 2,900 437 462 899 31.0% Operating supplies 47,150 4,008 3,993 8,001 17.0% Repair and maintenance supplies 11,000 93 - 93 0.8% Charges for services: Public utility services 89,225 27,617 17,614 45,231 50.7% Travel and education 3,325 - - - 0.0% Contracted agreements 45,575 60 - 60 0.1% Other operating expenses: Depreciation 55,000 - 73,604 73,604 133.8% Data processing and computer equipment 11,200 2,650 2,850 5,500 49.1% Maintenance and repair 16,050 5,645 5,782 11,427 71.2% Vehicle operating expenses 197,350 38,142 42,430 80,572 40.8% Miscellaneous 34,250 2,297 23,350 25,647 74.9% Total operating expenses 1,285,875 293,236 309,313 602,549 46.9% Operating income (loss) (183,875) 82,990 (194,154) (111,164) 60.5% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - - 0.0% Expenses: Capital improvements (233,250) (13,935) (10,285) (24,220) 10.4% Debt service - principal (133,650) (33,300) (33,450) (66,750) 49.9% Total non-operating revenues (expenses) (365,900) (47,235) (43,735) (90,970) 24.9% Income before operating transfers (549,775) 35,755 (237,889) (202,134) 36.8% Transfers in 549,775 227,250 - 227,250 41.3% Change in net assets $ - $ 263,005 $ (237,889) $ 25,116 Cash Summary: Cash, Beginning of Quarter $ (28,535) $ 184,218 Cash, Ending of Quarter $ 184,218 $ 21,298 ---PAGE BREAK--- RECREATION ENTERPRISE FUND ‐ 5160 REVENUE CHAREGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $230,525 $92,515 40% $138,010 $138,010 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $42,825 $0 0% $42,825 $42,825 $0 FUND TOTALS $273,350 $92,515 34% $180,835 $180,835 ANTICIPATED NET RECREATION FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES RECREATION ENTERPRISE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $65,100 $15,906 24% $49,194 SUPPLIES $50,325 $61,784 123% ($11,459) CHARGES FOR SERVICES $99,850 $63,371 63% $36,479 OTHER OPER EXPENSES $46,550 $22,984 49% $23,566 NON OPERATING EXPENSE $11,525 $5,825 51% $5,700 TOTAL $273,350 $169,870 62% $103,480 Profit/(Loss) to date (encumbrances not included) ($77,355) Cash in Bank September 30, 2016 $46,992 Cash in Bank December 31, 2016 ‐$2,687 PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS Includes interest revenue and use of retained earnings. OGDEN CITY RECREATION FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH RECREATION FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 230,525 $ 56,277 $ 36,238 $ 92,515 40.1% Total revenue 230,525 56,277 36,238 92,515 40.1% OPERATING EXPENSES: Cost of materials and parts 21,000 2,474 1,603 4,077 0.0% Personal services: Salaries and wages 55,525 8,549 5,945 14,494 26.1% Benefits 9,575 859 554 1,413 14.8% Supplies: Office supplies 2,550 - - - 0.0% Operating supplies 47,775 10,579 51,205 61,784 129.3% Repair and maintenance supplies 650 200 150 350 0.0% Charges for services: Public utility services 9,500 377 5,532 5,909 62.2% Travel and education - - - - 0.0% Contracted agreements 90,350 32,212 25,249 57,461 63.6% Other operating expenses: Rental charges 11,000 - - - 0.0% Fiscal charges 11,525 2,975 2,850 5,825 50.5% Depreciation 1,000 - 16,672 16,672 1667.2% Maintenance and repair 2,825 - - - 0.0% Miscellaneous 10,075 419 1,466 1,885 18.7% Total operating expenses 273,350 58,644 111,226 169,870 62.1% Operating income (loss) (42,825) (2,367) (74,988) (77,355) 180.6% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 1,000 - - - 0.0% Total non-operating revenues (expenses) 1,000 - - - 0.0% Income before operating transfers (41,825) (2,367) (74,988) (77,355) 184.9% Transfers in 41,825 - - - 0.0% Change in net assets $ - $ (2,367) $ (74,988) $ (77,355) Cash Summary: Cash, Beginning of quarter $ 88,193 $ 46,992 Cash, End of quarter $ 46,992 $ (2,687) ---PAGE BREAK--- PROPERTY MANAGEMENT FUND ‐ BDO ‐ 5180 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,150,000 $1,465,947 28% $3,684,053 $3,684,053 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $13,427,950 $0 0% $13,427,950 $13,427,950 $0 FUND TOTALS $18,577,950 $1,465,947 8% $17,112,003 $17,112,003 ANTICIPATED NET PROP MGT FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES PROPERTY MANAGEMENT ‐ BDO REUSE BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $63,000 $29,404 47% $33,596 CHARGES FOR SERVICES $400,000 $132,105 33% $267,895 OTHER OPER EXPENSES $4,077,000 $2,027,828 50% $2,049,172 CAPITAL OUTLAY $2,500,000 $2,880,793 115% ($380,793) OTHER FINANCING USES $11,537,950 $4,962,550 43% $6,575,400 TOTAL $18,577,950 $10,032,680 54% $8,545,270 Profit/(Loss) to date (encumbrances not included) ($8,566,733) Cash in Bank September 30, 2016 $12,576,495 Cash in Bank December 31, 2016 $11,368,407 Revenue generated from leases at BDO, which is collected quarterly. EXCESS (SHORTAGE) The main revenue item here is the transfer of tax increment from the BDO Tax Increment District, which is transferred as part of the year end closing, and carry over from the previous year for used in projects as approved in the budget. PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS OGDEN CITY PROPERTY MANAGEMENT FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH BUSINESS DEPOT OGDEN (BDO) FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 11,662,950 $ - $ 1,465,947 $ 1,465,947 12.6% Grants and donations - - - - 0.0% Miscellaneous income - - - - 0.0% Total revenue 11,662,950 - 1,465,947 1,465,947 12.6% OPERATING EXPENSES: Personal services: Salaries and wages 41,675 9,668 9,517 19,185 0.0% Benefits 21,325 5,192 5,095 10,287 0.0% Charges for services: Contracted agreements 400,000 - 132,037 132,037 33.0% Other operating expenses: Depreciation 4,050,000 - 2,027,828 2,027,828 50.1% Miscellaneous 27,000 - - - 0.0% Total operating expenses 4,540,000 14,860 2,174,477 2,189,337 48.2% Operating income (loss) 7,122,950 (14,860) (708,530) (723,390) -10.2% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 45,000 - - - 0.0% Expenses: Capital improvements (2,500,000) (1,308,607) (1,572,186) (2,880,793) 115.2% Total non-operating revenues (expenses) (2,455,000) (1,308,607) (1,572,186) (2,880,793) 117.3% Income before operating transfers 4,667,950 (1,323,467) (2,280,716) (3,604,183) -77.2% Transfers in (use of fund balance) 6,870,000 - - - 0.0% Transfers out (11,537,950) (4,187,350) (775,200) (4,962,550) 43.0% Change in net assets $ - $ (5,510,817) $ (3,055,916) $ (8,566,733) Cash Summary: Cash, Beginning of quarter $ 16,215,844 $ 12,576,495 Cash, End of quarter $ 12,576,495 $ 11,368,407 ---PAGE BREAK--- STORM SEWER FUND ‐ 5190 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $4,780,575 $2,330,169 49% $2,450,406 $2,450,406 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $1,965,550 $0 0% $1,965,550 $1,965,550 $0 FUND TOTALS $6,746,125 $2,330,169 35% $4,415,956 $4,415,956 ANTICIPATED NET PROP MGT FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES STORM SEWER FUND ‐ 5190 BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $833,725 $312,383 37% $521,342 SUPPLIES $66,700 $23,120 35% $43,580 CHARGES FOR SERVICES $826,350 $236,556 29% $589,794 OTHER OPER EXPENSES $779,500 $410,920 53% $368,580 DATA PROCESSING $42,850 $21,400 50% $21,450 NON OPERATING EXPENSE $1,399,900 $599,213 43% $800,687 CAPITAL OUTLAY $1,987,850 $453,402 23% $1,534,448 OTHER FINANCING USES $809,250 $10,000 1% $799,250 TOTAL $6,746,125 $2,066,995 31% $4,679,130 Profit/(Loss) to date (encumbrances not included) $263,174 Cash in Bank September 30, 2016 $5,388,873 Cash in Bank December 31, 2016 $5,600,852 PROJECTED RECEIPTS EXCESS (SHORTAGE) OGDEN CITY PROJECTED RECEIPTS EXCESS (SHORTAGE) Includes use of retained earnings for capital outlay. STORM SEWER FUND REVENUE & EXPENSE SUMMARY As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH STORM SEWER FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 4,780,575 $ 1,167,833 $ 1,162,336 $ 2,330,169 48.7% Miscellaneous income 1,000 - - - 0.0% Total revenue 4,781,575 1,167,833 1,162,336 2,330,169 48.7% OPERATING EXPENSES: Personal services: Salaries and wages 551,675 113,354 104,478 217,832 39.5% Benefits 282,200 48,242 46,446 94,688 33.6% Supplies: Office supplies 450 - 406 406 90.2% Operating supplies 30,150 3,723 3,796 7,519 24.9% Repair and maintenance supplies 10,275 - - - 0.0% Charges for services: Public utility services 1,675 325 450 775 46.3% Travel and education 5,700 107 2,399 2,506 44.0% Contracted agreements 762,325 103,349 101,289 204,638 26.8% Other operating expenses: Rental charges 15,025 3,775 3,750 7,525 50.1% Fiscal charges 828,700 207,250 207,150 414,400 50.0% Depreciation 180,000 - 235,487 235,487 130.8% Data processing and computer equipment 42,850 10,675 10,725 21,400 49.9% Maintenance and repair 313,100 32,925 32,850 65,775 21.0% Vehicle operating expenses 353,700 87,490 58,339 145,829 41.2% Total operating expenses 3,377,825 611,215 807,565 1,418,780 42.0% Operating income (loss) 1,403,750 556,618 354,771 911,389 64.9% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 10,000 - - - 0.0% Expenses: Other (return to fund balance) (799,250) - - - 0.0% Capital improvements (1,987,850) (244,413) (208,989) (453,402) 22.8% Debt service - Principal (349,000) - - - 0.0% Interest expense (222,200) - (184,813) (184,813) 83.2% Total non-operating revenues (expenses) (3,348,300) (244,413) (393,802) (638,215) 19.1% Income before operating transfers (1,944,550) 312,205 (39,031) 273,174 -14.0% Transfers in (use of fund balance) 1,954,550 - - - 0.0% Transfers out (10,000) (10,000) - (10,000) 100.0% Change in net assets $ - $ 302,205 $ (39,031) $ 263,174 Cash Summary: Cash, Beginning of quarter $ 5,326,310 $ 5,388,873 Cash, End of quarter $ 5,388,873 $ 5,600,852 ---PAGE BREAK--- MEDICAL SERVICES FUND ‐ 5200 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $1,349,675 $665,087 49% $684,588 $684,588 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $5,889,750 $2,846,941 48% $3,042,809 $3,042,809 $0 OTHER REVENUE CATEGORIES 6,7&8 BUDGET RECEIVED PERCENT BALANCE $560,000 $38,853 7% $521,147 $521,147 $0 FUND TOTALS $7,799,425 $3,550,881 46% $4,248,544 $4,248,544 ANTICIPATED NET MEDICAL FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES MEDICAL SERVICES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $3,571,425 $1,675,688 47% $1,895,737 SUPPLIES $296,425 $90,875 31% $205,550 CHARGES FOR SERVICES $863,725 $282,558 33% $581,167 OTHER OPER EXPENSES $545,075 $187,357 34% $357,718 DATA PROCESSING $78,875 $39,425 50% $39,450 NON OPERATING EXPENSE $560,000 $279,950 50% $280,050 CAPITAL OUTLAY $61,500 $1,249 2% $60,251 OTHER FINANCING USES $1,822,400 $500,000 27% $1,322,400 TOTAL $7,799,425 $3,057,103 39% $4,742,322 Other financing uses includes a return to retained earnings from operations Profit/(Loss) to date (encumbrances not included) $493,779 Cash in Bank September 30, 2016 $1,616,557 Cash in Bank December 31, 2016 $1,548,720 PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) OGDEN CITY MEDICAL SERVICES FUND REVENUE & EXPENSE SUMMARY PROJECTED RECEIPTS PROJECTED RECEIPTS As of December 31, 2016 ---PAGE BREAK--- OGDEN CITY CORPORATION STATEMENT OF REVENUES, EXPENSES AND CASH MEDICAL FUND Quarter Ended December 31, 2016 YTD % of Budget Annual 1st Quarter 2nd Quarter YTD Received / Budget Actual Actual Actual Expended OPERATING REVENUES: Charges for services $ 5,889,750 $ 1,659,847 $ 1,187,094 $ 2,846,941 48.3% Grants and donations 1,349,675 221,696 443,391 665,087 49.3% Miscellaneous income 10,000 - - - 0.0% Total revenue 7,249,425 1,881,543 1,630,485 3,512,028 48.4% OPERATING EXPENSES: Personal services: Salaries and wages 2,480,050 599,175 560,709 1,159,884 46.8% Benefits 1,095,375 259,578 257,725 517,303 47.2% Supplies: Office supplies 5,050 645 1,044 1,689 33.4% Operating supplies 279,375 43,449 45,125 88,574 31.7% Repair and maintenance supplies 12,000 455 157 612 5.1% Charges for services: Public utility services 94,875 12,428 22,028 34,456 36.3% Travel and education 109,300 6,717 2,193 8,910 8.2% Contracted agreements 497,550 92,459 95,454 187,913 37.8% Other operating expenses: Rental charges 5,575 1,300 1,425 2,725 48.9% Fiscal charges 560,000 139,925 140,025 279,950 50.0% Depreciation 65,000 - 32,952 32,952 50.7% Data processing and computer equipment 78,875 19,700 19,725 39,425 50.0% Maintenance and repair 124,550 11,724 12,481 24,205 19.4% Vehicle operating expenses 270,150 58,853 65,490 124,343 46.0% Miscellaneous 299,300 4,053 50,109 54,162 18.1% Total operating expenses 5,977,025 1,250,461 1,306,642 2,557,103 42.8% Operating income (loss) 1,272,400 631,082 323,843 954,925 75.0% NON-OPERATING REVENUES (EXPENSES): Revenues: Interest income 50,000 17,324 21,529 38,853 77.7% Total non-operating revenues (expenses) 50,000 17,324 21,529 38,853 77.7% Income before operating transfers 1,322,400 648,406 345,372 993,778 75.1% Transfers in (or use of fund balance) 500,000 - - - 0.0% Transfers out (1,822,400) - (500,000) (500,000) 27.4% Change in net assets - 648,406 (154,628) 493,778 Cash Summary: Cash, Beginning of quarter $ 1,255,725 $ 1,616,557 Cash, End of quarter $ 1,616,557 $ 1,548,720 ---PAGE BREAK--- FACILITIES/FLEET/STORES ‐ 6100 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $7,965,450 $4,364,023 55% $3,601,427 $3,601,427 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $2,853,450 $702,955 25% $2,150,495 $2,150,495 FUND TOTALS $10,818,900 $5,066,978 47% $5,751,922 $5,751,922 ANTICIPATED NET FLEET FUND REVENUE OVER (SHORT) of BUDGET EXPENDITURES FLEET/FACILITIES/STORES BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,436,125 $587,164 41% $848,961 SUPPLIES $175,850 $183,725 104% ($7,875) CHARGES FOR SERVICES $1,824,850 $841,458 46% $983,392 OTHER OPER EXPENSES $5,247,225 $2,326,322 44% $2,920,903 DATA PROCESSING $114,850 $57,400 50% $57,450 DEBT SERVICE $956,050 $485,864 51% $470,186 CAPITAL OUTLAY $1,063,950 $596,676 56% $467,274 TOTAL $10,818,900 $5,078,610 47% $5,740,290 Profit/(Loss) to date (encumbrances not included) $5,066,978 Cash in Bank September 30, 2016 ($897) Cash in Bank December 31, 2016 $779,719 Includes use of retained earnings for vehicle replacements, etc. EXCESS (SHORTAGE) As of December 31, 2016 PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) FACILITIES/FLEET/STORES REVENUE & EXPENSE SUMMARY OGDEN CITY ---PAGE BREAK--- INFORMATION TECHNOLOGY ‐ 6120 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,504,200 $1,945,260 56% $1,558,940 $1,558,940 $0 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $2,194,650 $859,171 39% $1,335,479 $1,335,479 $0 FUND TOTALS $5,698,850 $2,804,431 49% $2,894,419 $2,894,419 ANTICIPATED NET MIS FUND REVENUE OVER (SHORT) of BUDGET $0 EXPENDITURES INFORMATION TECHNOLOGY BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $1,992,150 $780,291 39% $1,211,859 SUPPLIES $21,750 $4,985 23% $16,765 CHARGES FOR SERVICES $1,421,125 $556,285 39% $864,840 OTHER OPER EXPENSES $223,400 $65,135 29% $158,265 DEBT SERVICE $241,575 $98,593 41% $142,982 CAPITAL OUTLAY $1,654,000 $932,422 56% $721,578 OTHER FUNDING USES $144,850 $0 0% $144,850 TOTAL $5,698,850 $2,437,712 43% $3,261,138 Profit/(Loss) to date (encumbrances not included) $366,719 Cash in Bank September 30, 2016 $1,871,588 Cash in Bank December 31, 2016 $1,657,926 Capital outlay includes expenditures for equipment purchases above what had been planned for, examples include grant funded purchases of laptops for police and fire. Divisions are then charged to reimburse IT for the expenditure. This category includes transfers from other funds and a use of retained earnings. EXCESS (SHORTAGE) EXCESS (SHORTAGE) Charges for services revenue includes charges to divisions for equipment purchases above what had been planned for, examples include grant funded purchases of laptops for police and fire. PROJECTED RECEIPTS PROJECTED RECEIPTS OGDEN CITY INFORMATION TECHNOLOGY REVENUE & EXPENSE SUMMARY As of December 31, 2016 ---PAGE BREAK--- RISK MANAGEMENT FUND ‐ 6130 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $1,601,500 $837,978 52% $763,522 $763,522 OTHER REVENUE CATEGORIES 6,7,&8 BUDGET RECEIVED PERCENT BALANCE $3,000 $0 0% $3,000 $3,000 $0 FUND TOTALS $1,604,500 $837,978 52% $766,522 $766,522 ANTICIPATED NET RISK MGT FUND REVENUE OVER (SHORT) of BUDGET EXPENDITURES RISK MANAGEMENT BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $64,550 $30,051 47% $34,499 SUPPLIES $12,000 $2,251 19% $9,749 CHARGES FOR SERVICES $369,025 $446,205 121% ($77,180) OTHER OPER EXPENSES $1,007,875 $798,327 79% $209,548 DATA PROCESSING $24,750 $12,300 50% $12,450 OTHER FUNDING USES $126,300 $0 0% $126,300 TOTAL $1,604,500 $1,289,134 80% $315,366 Profit/(Loss) to date (encumbrances not included) ($451,156) Cash in Bank September 30, 2016 $1,398,231 Cash in Bank December 31, 2016 $1,643,331 Charges to other City funds for Workman's Comp and Unemployment coverage. PROJECTED RECEIPTS PROJECTED RECEIPTS Charges for Services is higher than would be expected due to the payment of insurance premiums due at the beginning of the fiscal year. Other funding uses, is a planned return to fund balance. As of December 31, 2016 RISK MANAGEMENT REVENUE & EXPENSE SUMMARY This includes interest income and miscellaneous income. OGDEN CITY EXCESS (SHORTAGE) EXCESS (SHORTAGE) ---PAGE BREAK--- TRUST FUNDS ‐ 7100 & 7110 REVENUE GOMER NICHOLAS TRUST FUND ‐ 7100 OTHER REVENUE CATEGORIES 6 BUDGET RECEIVED PERCENT BALANCE $1,500 $1,870 125% ($370) $0 $370 REVENUE CEMETERY PERPETUAL CARE FUND ‐ 7110 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $9,250 $7,740 84% $1,510 $1,510 $0 OTHER REVENUE CATEGORIES 6,8 BUDGET RECEIVED PERCENT BALANCE $12,000 $0 0% $12,000 $12,000 $0 FUND TOTALS $22,750 $9,610 42% $13,140 $13,510 ANTICIPATED NET TRUST FUNDS REVENUE OVER (SHORT) of BUDGET $370 EXPENDITURES G. NICHOLAS TRUST BUDGET EXPENDED PERCENT BALANCE INTERFUND TRANSFERS $1,500 $2,751 183% ($1,251) TOTAL $1,500 $2,751 183% ($1,251) CEMETERY PERP. CARE BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $21,250 ($356) $21,606 CAPITAL OUTLAY $0 $0 $0 TOTAL $21,250 ($356) $21,606 TOTAL TRUST FUNDS $22,750 $2,395 11% $20,355 TRUST FUND FINANCIAL INFORMATION As of December 31, 2016 Other Operating Expenses is due to reimbursement from outside entities for higher cost associated with different types of headstones. PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS PROJECTED RECEIPTS This is interest earnings. A portion of each lot sale is credited to perpetual care. This is interest earned from the investment. OGDEN CITY ---PAGE BREAK--- MISCELLANEOUS GRANTS & DONATIONS FUND ‐ 7120 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $14,125 ($173,197) ‐1226% $187,322 $187,322 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $3,000 $16,929 564% ($13,929) $0 $13,929 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $7,000 $2,875 41% $4,125 $4,125 $0 FUND TOTALS $24,125 ($153,392) ‐636% $177,517 $191,447 ANTICIPATED NET MISC GRANTS FD REV OVER (SHORT) of BUDGET $13,930 EXPENDITURES MISC GRANTS & DONATIONS BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $10,000 $131,349 1313% ($121,349) TOTAL $24,125 $142,310 590% ($118,185) Intergovernmental revenue had a negative balance due to grant revenue receivable accrued to FY16,. The City had not received the payment as of December 30th. It is expected the City will receive this payment during the next quarter, which corrects the negative revenue reported here. EXCESS (SHORTAGE) PROJECTED RECEIPTS OGDEN CITY MISC. GRANTS/DONATIONS FUND FINANCIAL INFORMATION As of December 31, 2016 Donations and miscellaneous grants are activities in this category. EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS PROJECTED RECEIPTS ---PAGE BREAK--- MAJOR GRANTS FUND ‐ 7130 REVENUE INTERGOVERNMENTAL 3 BUDGET RECEIVED PERCENT BALANCE $2,781,175 $98,538 4% $2,682,637 $2,682,637 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $4,535,375 $2,601,823 57% $1,933,552 $1,933,552 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $2,431,550.00 $1,200,000.00 49% $1,231,550 $1,231,550 $0 FUND TOTALS $9,748,100 $3,900,361 40% $5,847,739 $5,847,739 ANTICIPATED NET MAJOR GRANTS FD REV OVER (SHORT) of BUDGET $0 EXPENDITURES MAJOR GRANTS BUDGET EXPENDED PERCENT BALANCE PERSONNEL SERVICES $620,250 $302,600 49% $317,650 SUPPLIES $8,000 $2,776 35% $5,224 CHARGES FOR SERVICES $73,125 $15,366 21% $57,759 OTHER OPER EXPENSES $7,998,900 $3,087,727 39% $4,911,173 DATA PROCESSING $47,825 $22,325 47% $25,500 TOTAL $8,748,100 $3,430,793 39% $5,317,307 These are major grants that if not received are available when needed and will carry over if not drawn. In most cases, they are reimbursable grants. These funds are program income generated by repayment of prior use of federal grant funds. They are used prior to drawing down additional funds from federal grants. Additionally the charges for services revenue includes the asset control area program. Other revenue is primarily transfers from other funds and program income, generated by repayment of prior use of federal grant funds and recognized for use in the current year. Other operating expenses include the use of federal grant funds As of December 31, 2016 PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) PROJECTED RECEIPTS EXCESS (SHORTAGE) PROJECTED RECEIPTS OGDEN CITY MAJOR GRANTS FUND FINANCIAL INFORMATION ---PAGE BREAK--- REDEVELOPMENT AGENCY ‐ GENERAL REVENUE GENERAL ACTIVITY ‐ 3120 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $3,879,900 $2,136,000 55% $1,743,900 $1,743,900 $0 FUND TOTALS $3,879,900 $2,136,000 55% $1,743,900 $1,743,900 ANTICIPATED NET RDA FD DISTRICTS REV OVER (SHORT) of BUDGET $0 EXPENDITURES REDEVELOPMENT AGENCY‐‐GENERAL RDA GENERAL BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $744,900 $369,450 50% $375,450 CAPITAL OUTLAY $3,135,000 $2,175,675 69% $959,325 TOTAL $3,879,900 $2,545,125 66% $1,334,775 REDEVELOPMENT AGENCY ‐ HOUSING REVENUE GENERAL ACTIVITY ‐ 3900 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $6,142,875 $1,000,000 16% $5,142,875 $5,142,875 $0 FUND TOTALS $6,142,875 $1,000,000 16% $5,142,875 $5,142,875 ANTICIPATED NET RDA HOUSING DISTRICTS REV OVER (SHORT) of BUDGET $0 EXPENDITURES REDEVELOPMENT AGENCY‐‐HOUSING RDA HOUSING BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $246,304 $246,304 100% CAPITAL OUTLAY $5,004,571 $1,756,243 35% $3,248,328 TOTAL $5,592,875 $2,002,547 36% $3,590,328 This category is mostly transfers from the districts to cover general expenses. The actual amounts are determined at the end of the year. This category is transfers from the districts for housing. The actual amounts are determined at the end of the year. OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of December 31, 2016 OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of December 31, 2016 EXCESS (SHORTAGE) PROJECTED RECEIPTS PROJECTED RECEIPTS EXCESS (SHORTAGE) ---PAGE BREAK--- REDEVELOPMENT AGENCY ‐ ENTITY 2 REVENUE TAX INCREMENT DISTRICTS TAXES 1 BUDGET RECEIVED PERCENT BALANCE $11,969,225 $10,457,891 87% $1,511,334 $1,511,334 $0 CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $764,800 $303,556 40% $461,244 $461,244 $0 OTHER REVENUE CATEGORIES 6,7,8 BUDGET RECEIVED PERCENT BALANCE $4,412,135 $1,264,862 29% $3,147,273 $3,147,273 $0 FUND TOTALS $17,146,160 $12,026,309 70% $5,119,851 $5,119,851 ANTICIPATED NET RDA FD DISTRICTS REV OVER (SHORT) of BUDGET $0 RDA TOTALS $27,168,935 $15,162,309 56% $12,006,626 $12,006,626 EXPENDITURES REDEVELOPMENT AGENCY‐‐Tax Increment Districts RDA DISTRICTS BUDGET EXPENDED PERCENT BALANCE CHARGES FOR SERVICES $560,250 $306,490 55% $253,760 OTHER OPER EXPENSES $2,497,475 $354,307 14% $2,143,168 NON OPERATING EXPENSE $5,665,625 $595,576 11% $5,070,049 CAPITAL OUTLAY $0 $22,482 ($22,482) INTERFUND TRANSFERS $2,234,810 $0 0% $2,234,810 OTHER FUNDING USES $6,188,000 $1,138,000 18% $5,050,000 TOTAL $17,146,160 $2,416,855 14% $14,729,305 Total RDA $26,618,935 $6,964,527 26% $19,654,408 This category is sale of property and miscellaneous interest income. However the major items in this category are interfund transfers, bond proceeds and use of prior year's fund balance, most of which are not posted until end of year. OGDEN CITY REDEVELOPMENT AGENCY FUND FINANCIAL INFORMATION As of December 31, 2016 PROJECTED RECEIPTS EXCESS (SHORTAGE) EXCESS (SHORTAGE) EXCESS (SHORTAGE) The majority of property tax is received after property taxes are collected. This is mostly Rec Center lease revenue. PROJECTED RECEIPTS PROJECTED RECEIPTS ---PAGE BREAK--- MUNICIPAL BUILDING AUTHORITY ‐ ENTITY 3 REVENUE CHARGES FOR SERVICES 4 BUDGET RECEIVED PERCENT BALANCE $545,475 $272,775 50% $272,700 $272,700 $0 OTHER REVENUE CATEGORIES 6,7&8 BUDGET RECEIVED PERCENT BALANCE $5,000 $428 9% $4,572 $4,572 $0 FUND TOTALS $550,475 $273,203 50% $277,272 $277,272 ANTICIPATED NET MBA FUND REV OVER (SHORT) of BUDGET $0 EXPENDITURES MBA BUDGET EXPENDED PERCENT BALANCE OTHER OPER EXPENSES $1,200 $0 0% $1,200 NON OPERATING EXPENSE $549,275 $508,429 93% $40,846 TOTAL $550,475 $508,429 92% $42,046 Non operating expenses are debt service related. This is the lease revenue from the City's General Fund. There are estimated transfers that are reconciled as part of the year‐end process. Interest and miscellaneous income. OGDEN CITY MUNICIPAL BUILDING AUTHORITY FUND FINANCIAL INFORMATION EXCESS (SHORTAGE) EXCESS (SHORTAGE) As of December 31, 2016 PROJECTED RECEIPTS PROJECTED RECEIPTS