Variance with
Final Budget
Actual Positive
Original Final Amounts (Negative)
REVENUES
Taxes:
Property Taxes 17,828,290$ 17,799,790$ 18,371,082$ 571,292$ Business License Taxes 985,000 1,080,000 1,119,427 39,427 Sales and Use Tax 12,836,240 14,675,080 16,876,712 2,201,632 Franchise Tax 1,230,000 1,252,000 1,284,525 32,525 Other 701,800 763,800 908,203 144,403 Licenses and Permits 1,743,700 1,915,700 2,481,187 565,487 Charges for Services 2,398,100 1,680,140 2,384,400 704,260 Fines and Penalties 588,600 435,600 542,604 107,004 Investment Income 125,000 60,000 798,468 738,468 Rental Income 705,220 759,220 802,678 43,458 Intergovernmental 69,000 66,500 107,264 40,764 Other Revenue 104,360 577,747 616,024 38,277 Total Revenues 39,315,310 41,065,577 46,292,574 5,226,997
EXPENDITURES
Current:
General Government 1,860,590 757,925 1,899,974 (1,142,049) Public Safety 27,603,960 25,805,984 24,708,858 1,097,126 Engineering and Public Works 6,487,490 6,424,828 6,402,725 22,103 Development Services 1,967,330 1,943,503 1,773,917 169,586 Community Services 3,067,770 3,050,575 2,917,641 132,934 Debt Service:
Principal 182,490 182,490 182,482 8 Interest and Fiscal Charges 259,040 259,040 259,030 10 Total Expenditures 41,428,670 38,424,345 38,144,627 279,718 Excess (Deficiency) of Revenues
over Expenditures (2,113,360) 2,641,232 8,147,947 5,506,715
OTHER FINANCING SOURCES (USES)
Transfers In - - - - Transfers Out - (1,664,508) (1,664,509) (1) Sale of Capital Assets - 31,218 31,218 Total Other Financing Sources (Uses)- (1,664,508) (1,633,291) 31,217 Net Change in Fund Balances (2,113,360) 976,724 6,514,656 5,537,932 Fund Balances, Beginning 24,276,097 24,276,097 24,276,097 - Fund Balances, Ending 22,162,737$ 25,252,821$ 30,790,753$ 5,537,932$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balances Budget and Actual - General Fund
Year Ended June 30, 2021
Budgeted Amounts
61 Page 78 of 173
Variance with
Final Budget
Actual Positive
Original Final Amounts (Negative)
REVENUES
Investment Income 23,000$ 23,000$ (344)$ (23,344)$ Rental Income 4,200,000 4,200,000 4,383,012 183,012 Other Revenue 209,470 209,470 76,874 (132,596) Total Revenues 4,432,470 4,432,470 4,459,542 27,072
EXPENDITURES
Current:
Development Services 3,124,470 3,123,674 2,890,417 233,257 Debt Service:
Principal 559,000 559,000 557,096 1,904 Interest & Fiscal Charges 522,920 522,920 524,816 (1,896) Total Expenditures 4,206,390 4,205,594 3,972,329 233,265 Excess (Deficiency) of Revenues
over Expenditures 226,080 226,876 487,213 260,337
OTHER FINANCING SOURCES (USES)
Transfers In - - - - Transfers Out - - (50,865) (50,865) Total Other Financing Sources (Uses)- - (50,865) (50,865) Net Change in Fund Balance 226,080 226,876 436,348 209,472 Fund Balance, Beginning 9,878,762 9,878,762 9,878,762 - Fund Balance, Ending 10,104,842$ 10,105,638$ 10,315,110$ 209,472$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Housing Special Revenue Fund
Year Ended June 30, 2021
Budgeted Amounts
62 Page 79 of 173
City of Upland
Notes to Required Supplementary Information
Year Ended June 30, 2021
BUDGETS AND BUDGETARY ACCOUNTING
The following procedures are used in establishing the budgetary data reflected in the financial statements:
The City Council approves each year’s budget submitted by the City Manager prior to the beginning of the fiscal year.
Public hearings are conducted prior to the adoption by City Council. Appropriations for each fund may only be increased or decreased by the City Council. During the year, there were budgetary appropriation decreases amounting to $3,247,275. The City Manager has authority to adjust the amounts appropriated between the departments and activities of a fund, provided, however, that the total appropriations for each fund may not exceed the amounts provided in the budget resolution. The level on which expenditures may not legally exceed appropriations is the fund level. The City Manager is also authorized to approve continuing appropriations at year-end for capital improvement projects and other expenditures previously approved by the City Council. City Council approval is required for an increase in total appropriations greater than $20,000.
Budgets for the various funds are adopted on a basis consistent with generally accepted accounting principles (GAAP).
Annual appropriated budgets are legally adopted for the general, special revenue, capital projects, and debt service fund types, except for the American Rescue Plan Act (ARPA) Special Revenue Fund and the Public Financing Authority Debt Service funds for which no budget is legally adopted and therefore no budget comparison schedule will be presented.
63 Page 80 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
Schedule of Changes in the Net Pension
Liability and Related Ratios - Last 10 Years*
Agent Multiple-employer Plan - Miscellaneous
Total Pension Liability 2020 2019 2018
Service cost 1,461,755$ 1,581,166$ 1,568,587$ Interest on total pension liability 9,399,565 9,162,859 8,880,290 Changes in assumptions - - (600,917) Differences between expected and actual experience 532,528 1,054,267 (675,727) Benefit payments, including refunds (8,056,083) (7,756,492) (7,358,347) Net change in total pension liability 3,337,765 4,041,800 1,813,886 Total pension liability - beginning 134,227,077 130,185,277 128,371,391 Total pension liability - ending (a) 137,564,842$ 134,227,077$ 130,185,277$ Plan Fiduciary Net Position
Contributions - employer 4,697,971$ 3,311,285$ 2,999,453$ Contributions - employee 670,433 754,481 655,077 Net investment income 4,621,628 5,949,555 7,384,991 Benefit payments (8,056,083) (7,756,492) (7,358,347) Net Plan to Plan Resource Movement - 1,301 - Administrative/Other Expense (132,141) (65,111) (398,906) Net change in plan fiduciary net position 1,801,808 2,195,019 3,282,268 Plan fiduciary net position - beginning 93,733,090 91,538,071 88,255,803 Plan fiduciary net position - ending (b) 95,534,898$ 93,733,090$ 91,538,071$ Net pension liability - ending (a) - (b) 42,029,944$ 40,493,987$ 38,647,206$ Plan fiduciary net position as a percentage
of the total pension liability 69.45% 69.83% 70.31%
Covered payroll 8,343,351$ 8,524,725$ 8,430,545$ Net pension liability as percentage of
covered payroll 503.75% 475.02% 458.42%
Notes to Schedule of Changes in Net Pension Liability and Related Ratios:
Changes in Assumptions: In 2017, the accounting discount rate reduced from 7.65 percent to 7.15 percent.
In 2016, there were no changes. In 2015, amounts reported reflected an adjustment of the discount rate from
7.5 percent (net of administrative expense) to 7.65 percent (without a reduction for pension plan administrative expense.) In 2014, amounts reported were based on the 7.5 percent discount rate.
Measurement Period
Benefit Changes: The figures above do not include any liability impact that may have resulted from plan changes which occurred after the June 30, 2018 valuation date. This applies to voluntary benefit changes as well as any offers of Two Years Additional Service Credit (a.k.a. Golden Handshakes). * Pension schedules are intended to show information for ten years, additional years’ information will be displayed as it becomes available.
64 Page 81 of 173
2017 2016 2015 2014
1,728,641$ 1,603,986$ 1,778,643$ 2,058,203$ 8,747,118 8,670,714 8,475,794 8,374,645 7,056,199 - (2,015,694) - (1,671,546) (1,502,457) (3,437,406) - (7,154,726) (6,299,318) (5,934,069) (5,480,303) 8,705,686 2,472,925 (1,132,732) 4,952,545 119,665,705 117,192,780 118,325,512 113,372,967 128,371,391$ 119,665,705$ 117,192,780$ 118,325,512$ 2,352,967$ 2,239,207$ 1,977,651$ 1,880,762$ 670,114 703,361 703,031 846,655 9,227,177 429,550 1,971,870 13,175,373 (7,154,726) (6,299,318) (5,934,069) (5,480,303) - (301) - - (122,962) (52,573) (97,096) - 4,972,570 (2,980,074) (1,378,613) 10,422,487 83,283,233 86,263,307 87,641,920 77,219,433 88,255,803$ 83,283,233$ 86,263,307$ 87,641,920$ 40,115,588$ 36,382,472$ 30,929,473$ 30,683,592$
68.75%69.60%73.61%74.07%
9,034,865$ 9,183,479$ 10,003,615$ 11,030,619$ 444.01% 396.17% 309.18% 278.17%
Measurement Period
65 Page 82 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
Schedule of Changes in the Net Pension Liability
And Related Ratios – Last 10 Years*
Agent Multiple-employer Plan – Safety Plan
Notes to Schedule of Changes in Net Pension Liability and Related Ratios:
Benefit Changes: The figures above do not include any liability impact that may have resulted from plan changes which occurred after the June 30, 2018 valuation date. This applies to voluntary benefit changes as well as any offers of Two Years Additional Service Credit (a.k.a. Golden Handshakes).
Changes in Assumptions: In 2017, the accounting discount rate reduced from 7.65 percent to 7.15 percent. In 2016, there were no changes. In 2015, amounts reported reflected an adjustment of the discount rate from 7.5 percent (net of administrative expense) to 7.65 percent (without a reduction for pension plan administrative expense.) In 2014, amounts reported were based on the 7.5 percent discount rate.
* Pension schedules are intended to show information for ten years, additional years’ information will be displayed as it becomes available. In addition, this plan was converted to a cost-sharing multiple employer plan for the financial reporting period ended June 30, 2020.
`2018 2017 2016 2015 2014
Total Pension Liability
Service cost 3,120,107$ 3,353,845$ 2,840,973$ 2,955,272$ 3,190,547$ Interest on total pension liability 14,424,159 13,994,358 13,738,636 13,154,006 12,955,418 Changes in benefits - - - - - Changes in assumptions (482,151) 11,831,388 - (3,292,952) - Differences between expected and actual experience 146,880 (2,387,269) 987,863 (4,793,043) - Benefit payments, including refunds (11,174,227) (10,595,503) (9,694,252) (9,101,311) (8,365,575) Net change in total pension liability 6,034,768 16,196,819 7,873,220 (1,078,028) 7,780,390 Total pension liability - beginning 206,098,820 189,902,001 182,028,781 183,106,809 175,326,419 Total pension liability - ending (a)212,133,588$ 206,098,820$ 189,902,001$ 182,028,781$ 183,106,809$ Plan Fiduciary Net Position
Contributions - employer 4,816,496$ 4,870,870$ 4,265,372$ 3,611,390$ 3,380,630$ Contributions - employee 668,922 1,085,857 1,166,670 1,183,942 1,342,231 Net investment income 11,191,173 13,839,363 673,474 2,937,028 19,584,973 Benefit payments (11,174,227) (10,595,503) (9,694,252) (9,101,311) (8,365,575) Net Plan to Plan Resource Movement - - 301 - - Administrative/Other Expense (606,455) (184,789) (78,513) (144,969) - Net change in plan fiduciary net position 4,895,909 9,015,798 (3,666,948) (1,513,920) 15,942,259 Plan fiduciary net position - beginning 134,174,733 125,158,935 128,825,883 130,339,803 114,397,544 Plan fiduciary net position - ending (b)139,070,642$ 134,174,733$ 125,158,935$ 128,825,883$ 130,339,803$ Net pension liability - ending (a) - (b)73,062,946$ 71,924,087$ 64,743,066$ 53,202,898$ 52,767,006$ Plan fiduciary net position as a percentage
of the total pension liability 65.56% 65.10% 65.91% 70.77% 71.18% Covered payroll 7,851,917$ 11,286,708$ 10,755,149$ 11,241,479$ 11,699,414$ Net pension liability as percentage of
covered payroll 930.51% 637.25% 601.97% 473.27% 451.02% Measurement Period
66 Page 83 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
* Pension schedules are intended to show information for ten years, additional years’ information will be displayed as it becomes available; in addition, for the 2019 measurement period, CalPERS moved the City’s Safety plan from an agent-multiple employer plan to a cost-sharing plan. Therefore, not all 10 years of information is presented.
Notes to the Schedule of the City’s Proportionate Share of the Net Pension Liability
Benefit Changes: None
Changes in Assumptions: In 2017, the accounting discount rate changed from 7.65% to 7.15%.
Proportionate Plan Fiduciary
Proportion of Proportionate Share of the Net Net Position as the Net Pension Share of Net Covered Pension Liability a % of the Total Measurement Date Liability Pension Liability Payroll as a % of Payr oll Pension Liability 2020 0.72025% 78,366,541$ 7,473,800$ 1048.55%64.98% 2019 0.71858% 73,633,282 6,845,982 1075.57%66.40% Schedule of the Cit y's Proportionate Share of the Net Pension Liability Last 10 Years*
67 Page 84 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
Schedule of Contributions – Last 10 Years*
Agent Multiple-employer Plan – Miscellaneous Plan
Schedule of Contributions – Last 10 Years*
Cost-Sharing Plan – Safety Plan
Contributions in
Relation to the Contributions
Contractually Actuarially Contribution as a % of
Required Determined Deficiency/ Covered Covered
Fiscal Year Contributions Contributions (Excess) Payroll Payroll 2021 4,088,720$ (4,088,720)$ -$ 10,008,388$ 40.85% 2020 3,734,440 (4,734,440) (1,000,000) 8,343,351 44.76% 2019 3,335,368 (3,335,368) - 8,524,725 39.13% 2018 2,999,453 (2,999,453) - 8,430,545 35.58% 2017 2,352,967 (2,352,967) - 9,034,865 26.04% 2016 2,239,207 (2,239,207) - 9,183,479 24.38% 2015 1,977,651 (1,977,651) - 10,003,615 19.77% 2014 1,880,762 (1,880,762) - 11,030,619 17.05% Contributions in
Relation to the Contributions
Contractually Actuarially Contribution as a % of
Required Determined Deficiency/ Covered Covered
Fiscal Year Contributions Contributions (Excess) Payroll Payroll 2021 7,041,790$ (7,041,790)$ -$ 7,767,343$ 90.66% 2020 6,210,535 (6,210,535) - 7,473,800 83.10% 2019 5,322,942 (5,322,942) - 6,845,982 77.75% 2018 4,816,496 (4,816,496) - 7,851,917 61.34% 2017 4,870,870 (4,870,870) - 11,286,708 43.16% 2016 4,265,372 (4,265,372) - 10,755,149 39.66% 2015 3,611,390 (3,611,390) - 11,241,479 32.13% 2014 3,380,630 (3,380,630) - 11,699,414 28.90% 68 Page 85 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
Notes to Schedule of Plan Contributions:
Valuation Date: June 30, 2019
Actuarial cost method: Entry age normal
Amortization method: Level percentage of payroll, closed Assets valuation method: Direct rate smoothing
Inflation: 2.50%
Salary Increases: Varies by entry age and service
Payroll Growth: 2.85%
Investment rate of return: 7.15% net of pension investment and administrative expenses, including inflation Retirement Age: All other actuarial assumptions used in the June 30, 2019 valuation were based on the results of an actuarial experience study for the period from 1997 to 2015. Including updates to salary increase, mortality and retirement rates. The Experience Study report may be accessed on the CalPERS website at www.calpers.ca.gov .
Mortality: The mortality table used was developed using CalPERS’ specific data. The table includes 15 years of mortality improvements using 90 percent of Society of Actuaries’ Scale 2016. 69 Page 86 of 173
City of Upland
Required Supplementary Information
Year Ended June 30, 2021
Schedule of Changes in the Net OPEB Liability and Related Ratios for the Measurement Periods Ended June 30
Last 10 Years*
Notes to Schedule of Changes:
The discount rate from the 2017 Actuarial Valuation to the 2019 Actuarial Valuation changed from 6.25% to 5.91%.
* OPEB schedules are intended to show information for ten years, additional years’ information will be displayed as it becomes available.
2020 2019 2018 2017
Total OPEB Liability
Service cost 166,888$ 390,159$ 557,634$ 538,257$ Interest on total OPEB liability 448,931 573,095 562,756 547,618 Changes in assumptions 2,001,839 784,435 (1,049,491) - Changes in benefits - - (1,080,543) - Differences between expected and actual experience - (1,821,317) - - Benefit payments, including refunds (853,875) (591,246) (699,692) (669,865) Net change in total OPEB liability 1,763,783 (664,874) (1,709,336) 416,010 Total OPEB liability - beginning 13,050,100 13,714,974 15,424,310 15,008,300 Total OPEB liability - ending (a)14,813,883$ 13,050,100$ 13,714,974$ 15,424,310$ Plan Fiduciary Net Position
Contributions - employer 853,875$ 591,246$ 699,692$ 1,669,865$ Net Investment Income 51,511 69,490 54,034 966 Benefit payments (853,875) (591,246) (699,692) (669,865) Administrative Expense (5,696) (2,660) (2,595) - Net change in plan fiduciary net position 45,815 66,830 51,439 1,000,966 Plan fiduciary net position - beginning 1,119,235 1,052,405 1,000,966 - Plan fiduciary net position - ending (b)1,165,050$ 1,119,235$ 1,052,405$ 1,000,966$ Net OPEB liability - ending (a) - (b)13,648,833$ 11,930,865$ 12,662,569$ 14,423,344$ Plan fiduciary net position as a percentage
of the total OPEB liability 7.9%8.6%7.7%6.5%
Measurement Period
70 Page 87 of 173
SUPPLEMENTARY INFORMATION
NON-MAJOR GOVERNMENTAL FUNDS
City of Upland
Non-Major Governmental Funds
Year Ended June 30, 2021
SPECIAL REVENUE FUNDS
Special Revenue Funds are used to account for specific revenues that are legally restricted to expenditure for particular purposes.
Gas Tax Fund
To account for State gasoline taxes received by the City. These funds may be used for street maintenance, right-of-way acquisition, and street construction. Gas Tax funds are used for capital projects established within the Gas Tax Fund.
HOME Program Fund
This fund accounts for housing rehab loans/grants from the California Department of Housing and Community Development. These loans/grants are provided for single-family rehabilitation, neighborhood restoration, first- time homebuyers, tenant based assistance and rental rehabilitation programs.
CalHOME Program Fund
This fund accounts for housing rehab loans/grants from the CalHome program. These loans/grants are provided for single-family rehabilitation, neighborhood restoration, first-time homebuyers, tenant based assistance and rental rehabilitation programs.
Community Development Block Grant Fund
To account for receipt and disbursement of the Upland Community Development Block Grant Program of the United States Department of Housing and Urban Development.
Measure I Fund
To account for revenues which were approved by the San Bernardino County voters in a General Election authorizing a one-half percent (1/2%) sales tax on all retail transactions within the incorporated and unincorporated territory of the County of San Bernardino through 2040, proceeds of which are to be solely for county-wide transportation improvements and traffic management programs.
Air Quality Management District Fund
To account for the receipt and disbursement of funds generated by Assembly Bill 2766 which sets forth requirements for reduction of air pollution from mobile sources as promulgated by the South Coast Air Quality Management District.
Parking Business Improvement Area Fund
To account for revenues received from an additional levy of the general business license tax imposed on businesses in the downtown area to be used for the acquisition, construction and maintenance of parking facilities and improvements for the benefit of the downtown area.
SB509 Public Safety Augmentation Fund
To account for revenue and expenditures related to the half-cent sales tax enacted by Proposition 172 and SB509. Funds are used to cover operational expenditures of the Police Department.
Asset Forfeiture Fund
To account for revenue received for the City’s various deposits for asset forfeiture restricted for public safety.
Public Safety Grants Fund
To account for revenue and expenditures related to grants restricted to be used for public safety.
Other Grants Fund
To account for revenue and expenditures related to grants restricted for specific purposes.
71 Page 90 of 173
City of Upland
Non-Major Governmental Funds
Year Ended June 30, 2021
SPECIAL REVENUE FUNDS - Continued
CARES Act Fund
To account for revenue and expenditures related to The Coronavirus Aid, Relief, and Economic Security Act.
CAPITAL PROJECT FUNDS
Capital Projects Funds are used to account for the purchase or construction of major capital facilities which are not financed by Proprietary Funds or Trust Funds. Capital Projects Funds are ordinarily not used to account for the acquisition of furniture, fixtures, machinery, equipment and other relatively minor or short-lived capital assets.
Park Acquisition and Development Fund
To account for revenue from the Dwelling Unit Construction Tax which must be used for the acquisition and development of park facilities within the City.
General Capital Development Fund
To account revenues received for fees from various building permits to be used for certain general government, fire, and police facilities.
Storm Drain Development Fund
To account for the revenues received from the fees on various building permits to be used for the creation of a storm drain system in cooperation with other governmental entities in the area.
Street and Traffic Safety Development Fund
To account for the revenues received from fees on various building permits to be used for improved street and traffic facilities.
General Capital Fund
To account for projects of a general nature which are supported by available General Funds and Special Revenue Funds.
Street and Alley Repair Fund
To account for the revenues received from fees on various permits to be used for improved street and alley repairs.
Energy Efficiency Improvements
To account for the proceeds from leases and bonds issued that are restricted for the acquisition, construction, and installation of energy efficient improvements.
72 Page 91 of 173
Community
Gas HOME CalHOME Development
Tax Program Program Block Grant
ASSETS
Cash and Investments 8,238,576$ 1,635,088$ 543,801$ -$ Cash with Fiscal Agent - - - - Receivables:
Accounts - - - - Notes, net - 3,004,957 1,661,341 - Accrued Interest on Notes - 920,979 350,052 - Due from Other Governments 266,254 - - 505,674 Total Assets 8,504,830$ 5,561,024$ 2,555,194$ 505,674$
LIABILITIES
Accounts Payable 105,501$ 17,551$ -$ 156,163$ Accrued Salaries and Benefits 6,015 - - 5,674 Due to Other Funds - - - 286,324 Deposits Payable - - - - Retentions Payable - - - - Unearned Revenue - - 4,469 - Total Liabilities 111,516 17,551 4,469 448,161
DEFERRED INFLOWS OF RESOURCES
Unavailable Revenue - 920,979 350,052 505,674 Total Deferred Inflows of Resources - 920,979 350,052 505,674
FUND BALANCE (DEFICITS)
Restricted 8,393,314 4,622,494 2,200,673 - Assigned - - - - Unassigned - - - (448,161) Total Fund Balances (Deficits)8,393,314 4,622,494 2,200,673 (448,161) Total Liabilities, Deferred Inflows
8,504,830$ 5,561,024$ 2,555,194$ 505,674$ and Fund Balances (Deficits) June 30, 2021
Special Revenue
City of Upland
Combining Balance Sheet
Non-major Governmental Funds
73 Page 92 of 173
Air Quality Parking and SB 509 Public
Management Business Public Safety Asset Safety Other
Measure I District Improvement Augmentation Forfeiture Grants Grants 6,112,513$ 159,633$ 183,244$ -$ 778,449$ 981,736$ -$ - - - - - - - - - 9,900 - - - - - - - - - - - - - - - - - - 512,015 26,168 - 100,292 - 223,721 54,303 6,624,528$ 185,801$ 193,144$ 100,292$ 778,449$ 1,205,457$ 54,303$ 50,830$ 34$ -$ -$ -$ 7,416$ 15,150$ 3,503 526 - 34,732 - 3,210 3,099 - - - 65,278 - - 23,509 - - - - 31,020 - - - - - - - - - - - - - - - 4,295 54,333 560 - 100,010 31,020 10,626 46,053 - - - - - 36,275 54,303 - - - - - 36,275 54,303 6,570,195 185,241 193,144 282 747,429 1,158,556 - - - - - - - - - - - - - - (46,053) 6,570,195 185,241 193,144 282 747,429 1,158,556 (46,053) 6,624,528$ 185,801$ 193,144$ 100,292$ 778,449$ 1,205,457$ 54,303$ Continued
Special Revenue
74 Page 93 of 173
Special
Revenue
Park General Storm
CARES Acquistion & Capital Drain
ACT Development Development Development
ASSETS
Cash and Investments -$ 10,025,052$ 2,170,698$ 4,886,148$ Cash with Fiscal Agent - - - - Receivables:
Accounts - - - 317 Notes, net - - - - Accrued Interest on Notes - - - - Due from Other Governments 324,474 - - - Total Assets 324,474$ 10,025,052$ 2,170,698$ 4,886,465$
LIABILITIES
Accounts Payable 14$ 53,820$ -$ 4,313$ Accrued Salaries and Benefits - - 1,841 450 Due to Other Funds 295,589 - - - Deposits Payable - - - - Retentions Payable - - - - Unearned Revenue - - - - Total Liabilities 295,603 53,820 1,841 4,763
DEFERRED INFLOWS OF RESOURCES
Unavailable Revenue 1,436 - - - Total Deferred Inflows of Resources 1,436 - - -
FUND BALANCE (DEFICITS)
Restricted 27,435 9,971,232 2,168,857 4,881,702 Assigned - - - - Unassigned - - - - Total Fund Balances (Deficits)27,435 9,971,232 2,168,857 4,881,702 Total Liabilities, Deferred Inflows
and Fund Balances (Deficits)324,474$ 10,025,052$ 2,170,698$ 4,886,465$ June 30, 2021
Capital Projects
City of Upland
Combining Balance Sheet
Non-major Governmental Funds - Continued
75 Page 94 of 173
Street and General Street & Energy
Traffic Safety Capital Alley Efficiency
Development Projects Repair Improvements Total
2,046,636$ 1,508,841$ 705,797$ 7,570$ 39,983,782$ - - - - - - - 19,611 - 29,828 - - - - 4,666,298 - - - - 1,271,031 - - - - 2,012,901 2,046,636$ 1,508,841$ 725,408$ 7,570$ 47,963,840$ 464,439$ 21,586$ -$ -$ 896,817$ 138 354 2,156 - 61,698 - - - - 670,700 - - - - 31,020 - - 22,542 197,622 220,164 - - - - 8,764 464,577 21,940 24,698 197,622 1,889,163 - - - - 1,868,719 - - - - 1,868,719 1,582,059 1,486,901 700,710 - 44,890,224 - - - - - - - - (190,052) (684,266) 1,582,059 1,486,901 700,710 (190,052) 44,205,958 2,046,636$ 1,508,841$ 725,408$ 7,570$ 47,963,840$ Capital Projects
76 Page 95 of 173
Community
Gas HOME CalHOME Development
Tax Program Program Block Grant
REVENUES
Taxes -$ -$ -$ -$ Licenses and Permits - - - - Fines and Forfeitures - - - - Investment Income 1,513 12,148 3,707 - Rental Income - - - - Intergovernmental 3,189,822 - - 359,114 Other Revenue 2,326 17,620 1,737 - Total Revenues 3,193,661 29,768 5,444 359,114
EXPENDITURES
Current:
General Government - - - - Public Safety - - - - Engineering and Public Works 3,042,782 - - - Development Services - - - 864,787 Community Services - - - - Debt Service:
Principal - - - - Interest and Fiscal Charges - - - - Total Expenditures 3,042,782 - - 864,787 Excess (Deficiency) of Revenues
Over Expenditures 150,879 29,768 5,444 (505,673)
OTHER FINANCING SOURCES (USES)
Transfers In - - - - Transfers Out - - - - Issuance of Debt - - - - Total Other Financing Sources (Uses)- - - - Net Change in Fund Balances 150,879 29,768 5,444 (505,673) Fund Balances - Beginning 8,242,435 4,592,726 2,195,229 57,512 Fund Balances - Ending 8,393,314$ 4,622,494$ 2,200,673$ (448,161)$ City of Upland
Combining Statement of Revenues, Expenditures and Changes in Fund Balances Non-major Governmental Funds
Year Ended June 30, 2021
Special Revenue
77 Page 96 of 173
Air Quality Parking and SB 509 Public
Management Business Public Safety Asset Safety Other
Measure I District Improvement Augmentation Forfeiture Grants Grants -$ -$ 58,797$ 1,056,742$ -$ -$ -$ - - - - - - - - - - - - - - (5,526) 1,131 1,661 1,221 5,486 9,223 - - - - - - - - 1,782,332 102,914 - - 15,487 518,025 25,194 - 855 - - - - 146 1,776,806 104,900 60,458 1,057,963 20,973 527,248 25,340 - - - - - - - - - - 1,057,962 1,500 530,689 - 1,641,413 141,188 108,054 - - - - - - - - - - 34,574 - - - - - - 45,032 - - - - - - - - - - - - - - 1,641,413 141,188 108,054 1,057,962 1,500 530,689 79,606 135,393 (36,288) (47,596) 1 19,473 (3,441) (54,266) - - - - - - - - - - - - - - - - - - - - - - - - - - - - 135,393 (36,288) (47,596) 1 19,473 (3,441) (54,266) 6,434,802 221,529 240,740 281 727,956 1,161,997 8,213 6,570,195$ 185,241$ 193,144$ 282$ 747,429$ 1,158,556$ (46,053)$ Continued
Special Revenue
78 Page 97 of 173
Special
Revenue
Park General Storm
CARES Acquistion & Capital Drain
ACT Development Development Development
REVENUES
Taxes -$ -$ -$ -$ Licenses and Permits - 1,660,906 345,749 786,516 Fines and Forfeitures - - - - Investment Income 2,063 (820) (291) (676) Rental Income - - - 73,865 Intergovernmental 2,141,164 - - - Other Revenue - (87,822) - - Total Revenues 2,143,227 1,572,264 345,458 859,705
EXPENDITURES
Current:
General Government 355,772 - - - Public Safety 1,082,737 - - - Engineering and Public Works 80,214 151,671 265,634 116,760 Development Services 119,911 - - - Community Services 230,482 - - - Debt Service:
Principal - - - - Interest and Fiscal Charges - - - - Total Expenditures 1,869,116 151,671 265,634 116,760 Excess (Deficiency) of Revenues
Over Expenditures 274,111 1,420,593 79,824 742,945
OTHER FINANCING SOURCES (USES)
Transfers In - - - - Transfers Out - - - - Issuance of Debt - - - - Total Other Financing Sources (Uses)- - - - Net Change in Fund Balances 274,111 1,420,593 79,824 742,945 Fund Balances - Beginning (246,676) 8,550,639 2,089,033 4,138,757 Fund Balances - Ending 27,435$ 9,971,232$ 2,168,857$ 4,881,702$ City of Upland
Combining Statement of Revenues, Expenditures and Changes in Fund Balances Non-Major Governmental Funds - Continued
Year Ended June 30, 2021
Capital Projects
79 Page 98 of 173
Street and General Street & Energy
Traffic Safety Capital Alley Efficiency
Development Projects Repair Improvements Total
-$ -$ -$ -$ 1,115,539$ 464,484 - 216,348 - 3,474,003 - - - - - (3,818) - (623) 42 26,441 - - - - 73,865 - - - - 8,134,052 - - - - (65,138) 460,666 - 215,725 42 12,758,762 - - - - 355,772 - - - - 2,672,888 1,541,251 515,207 511,498 226,259 8,341,931 - - - - 1,019,272 - - - - 275,514 - - - - - - - - - - 1,541,251 515,207 511,498 226,259 12,665,377 (1,080,585) (515,207) (295,773) (226,217) 93,385 - 593,000 - - 593,000 - - - - - - - - - - - 593,000 - - 593,000 (1,080,585) 77,793 (295,773) (226,217) 686,385 2,662,644 1,409,108 996,483 36,165 43,519,573 1,582,059$ 1,486,901$ 700,710$ (190,052)$ 44,205,958$ Capital Projects
80 Page 99 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 45,000 1,513 (43,487)
Intergovernmental 3,100,140 3,189,822 89,682
Other Revenue - - - Total Revenues 3,145,140 3,191,335 46,195
EXPENDITURES
Current:
Engineering and Public Works 10,226,281 3,042,782 7,183,499 Total Expenditures 10,226,281 3,042,782 7,183,499
Excess (Deficiency) of Revenues
over Expenditures (7,081,141) 148,553 7,229,694
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (7,081,141) 148,553 7,229,694 Fund Balance, Beginning 8,242,435 8,242,435 -
Fund Balance, Ending 1,161,294$ 8,390,988$ 7,229,694$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Gas Tax Special Revenue Fund
Year Ended June 30, 2021
81 Page 100 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 1,210 12,148 10,938
Intergovernmental - - - Other Revenue 190,000 17,620 (172,380)
Total Revenues 191,210 29,768 (161,442)
EXPENDITURES
Current:
Development Services 420,000 - 420,000 Total Expenditures 420,000 - 420,000
Excess (Deficiency) of Revenues
over Expenditures (228,790) 29,768 258,558
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (228,790) 29,768 258,558
Fund Balance, Beginning 4,592,726 4,592,726 -
Fund Balance, Ending 4,363,936$ 4,622,494$ 258,558$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - HOME Program Special Revenue Fund
Year Ended June 30, 2021
82 Page 101 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 200 3,707 3,507
Intergovernmental - - - Other Revenue 7,000 1,737 (5,263) Total Revenues 7,200 5,444 (1,756)
EXPENDITURES
Current:
Development Services 210,000 - 210,000 Total Expenditures 210,000 - 210,000
Excess (Deficiency) of Revenues
over Expenditures (202,800) 5,444 208,244
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (202,800) 5,444 208,244
Fund Balance, Beginning 2,195,229 2,195,229 -
Fund Balance, Ending 1,992,429$ 2,200,673$ 208,244$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - CalHOME Program Special Revenue Fund Year Ended June 30, 2021
83 Page 102 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Intergovernmental 1,220,059$ 359,114$ (860,945)$ Other Revenue - - - Total Revenues 1,220,059 359,114 (860,945)
EXPENDITURES
Current:
Development Services 2,178,433 864,787 1,313,646 Total Expenditures 2,178,433 864,787 1,313,646
Excess (Deficiency) of Revenues
over Expenditures (958,374) (505,673) 452,701
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (958,374) (505,673) 452,701 Fund Balance, Beginning 57,512 57,512 -
Fund Balance, Ending (900,862)$ (448,161)$ 452,701$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - CDBG Special Revenue Fund
Year Ended June 30, 2021
84 Page 103 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 15,000 (5,526) (20,526) Intergovernmental 1,364,270 1,782,332 418,062
Other Revenue - - - Total Revenues 1,379,270 1,776,806 397,536
EXPENDITURES
Current:
Engineering and Public Works 6,367,621 1,641,413 4,726,208 Total Expenditures 6,367,621 1,641,413 4,726,208
Excess (Deficiency) of Revenues
over Expenditures (4,988,351) 135,393 5,123,744
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (4,988,351) 135,393 5,123,744 Fund Balance, Beginning 6,434,802 6,434,802 -
Fund Balance, Ending 1,446,451$ 6,570,195$ 5,123,744$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Measure I Special Revenue Fund
Year Ended June 30, 2021
85 Page 104 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 1,131 1,131 Intergovernmental 100,000 102,914 2,914
Other Revenue - 855 855 Total Revenues 100,000 104,900 4,900
EXPENDITURES
Current:
Engineering and Public Works 201,030 141,188 59,842 Total Expenditures 201,030 141,188 59,842
Excess (Deficiency) of Revenues
over Expenditures (101,030) (36,288) 64,742
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (101,030) (36,288) 64,742 Fund Balance, Beginning 221,529 221,529 -
Fund Balance, Ending 120,499$ 185,241$ 64,742$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Air Quality Management District Special Revenue Fund Year Ended June 30, 2021
86 Page 105 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes 58,500$ 58,797$ 297$
Investment Income 2,500 1,661 (839) Total Revenues 61,000 60,458 (542)
EXPENDITURES
Current:
Engineering and Public Works 312,720 108,054 204,666 Total Expenditures 312,720 108,054 204,666
Excess (Deficiency) of Revenues
over Expenditures (251,720) (47,596) 204,124
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (251,720) (47,596) 204,124 Fund Balance, Beginning 240,740 240,740 -
Fund Balance, Ending (10,980)$ 193,144$ 204,124$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Parking & Business Improvement Special Revenue Fund Year Ended June 30, 2021
87 Page 106 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes 900,000$ 1,056,742$ 156,742$
Investment Income 1,221 1,221 Intergovernmental - - - Other Revenue - - - Total Revenues 900,000 1,057,963 157,963
EXPENDITURES
Current:
Public Safety 900,000 1,057,962 (157,962)
Total Expenditures 900,000 1,057,962 (157,962)
Excess (Deficiency) of Revenues
over Expenditures - 1 1
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances - 1 1 Fund Balance, Beginning 281 281 - Fund Balance, Ending 281$ 282$ 1$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - SB 509 Public Safety Augmentation Special Revenue Fund Year Ended June 30, 2021
88 Page 107 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Investment Income -$ 5,486$ 5,486$ Fines and Forfeitures - - - Intergovernmental - 15,487 15,487 Total Revenues - 20,973 20,973
EXPENDITURES
Current:
Public Safety 1,500 (1,500) Total Expenditures - 1,500 (1,500) Excess (Deficiency) of Revenues
over Expenditures - 19,473 19,473
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances - 19,473 19,473 Fund Balance, Beginning 727,956 727,956 - Fund Balance, Ending 727,956$ 747,429$ 19,473$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Asset Forfeiture Special Revenue Fund Year Ended June 30, 2021
89 Page 108 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income 9,223 9,223 Intergovernmental 921,782 518,025 (403,757) Other Revenue - - - Total Revenues 921,782 527,248 (394,534)
EXPENDITURES
Current:
Public Safety 1,873,052 530,689 1,342,363
Total Expenditures 1,873,052 530,689 1,342,363
Excess (Deficiency) of Revenues
over Expenditures (951,270) (3,441) 947,829
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (951,270) (3,441) 947,829 Fund Balance, Beginning 1,161,997 1,161,997 -
Fund Balance, Ending 210,727$ 1,158,556$ 947,829$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Public Safety Grants Special Revenue Fund Year Ended June 30, 2021
90 Page 109 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Taxes -$ -$ -$
Investment Income - - - Intergovernmental 390,870 25,194 (365,676) Other Revenue - 146 146 Total Revenues 390,870 25,340 (365,530)
EXPENDITURES
Current:
Development Services 310,000 34,574 275,426 Community Services 92,400 45,032 47,368 Total Expenditures 402,400 79,606 322,794
Excess (Deficiency) of Revenues
over Expenditures (11,530) (54,266) (42,736)
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (11,530) (54,266) (42,736) Fund Balance, Beginning 8,213 8,213 - Fund Balance, Ending (3,317)$ (46,053)$ (42,736)$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Other Grants Special Revenue Fund
Year Ended June 30, 2021
91 Page 110 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Investment Income -$ 2,063$ 2,063$ Intergovernmental 2,525,599 2,141,164 (384,435) Total Revenues 2,525,599 2,143,227 (382,372)
EXPENDITURES
Current:
General Government 2,054,447 355,772 1,698,675 Public Safety 1,169,979 1,082,737 87,242
Engineering and Public Works 61,807 80,214 (18,407) Development Services - 119,911 (119,911) Community Services 285,239 230,482 54,757 Total Expenditures 3,571,472 1,869,116 1,702,356
Excess (Deficiency) of Revenues
over Expenditures (1,045,873) 274,111 1,319,984
OTHER FINANCING SOURCES (USES)
Transfers In - - - Transfers Out - - - Total Other Financing
Sources (Uses)- - - Net Change in Fund Balances (1,045,873) 274,111 1,319,984 Fund Balance, Beginning (246,676) (246,676)
Fund Balance, Ending (1,292,549)$ 27,435$ 1,319,984$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - CARES Act Special Revenue Fund
Year Ended June 30, 2021
92 Page 111 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits 2,200,000$ 1,660,906$ (539,094)$ Investment Income 85,000 (820) (85,820) Intergovernmental - - - Other Revenue - (87,822) (87,822) Total Revenues 2,285,000 1,572,264 (712,736)
EXPENDITURES
Current:
Engineering and Public Works 504,427 151,671 352,756 Community Services - - - Total Expenditures 504,427 151,671 352,756
Excess (Deficiency) of Revenues
over Expenditures 1,780,573 1,420,593 (359,980)
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances 1,780,573 1,420,593 (359,980) Fund Balance, Beginning 8,550,639 8,550,639 -
Fund Balance, Ending 10,331,212$ 9,971,232$ (359,980)$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Park Acquisition & Development Capital Projects Fund Year Ended June 30, 2021
93 Page 112 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits 595,000$ 345,749$ (249,251)$ Investment Income 14,000 (291) (14,291) Intergovernmental - - - Other Revenue - - - Total Revenues 609,000 345,458 (263,542)
EXPENDITURES
Current:
Engineering and Public Works 546,050 265,634 280,416 Community Services - - - Total Expenditures 546,050 265,634 280,416
Excess (Deficiency) of Revenues
over Expenditures 62,950 79,824 16,874
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances 62,950 79,824 16,874 Fund Balance, Beginning 2,089,033 2,089,033 -
Fund Balance, Ending 2,151,983$ 2,168,857$ 16,874$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - General Capital Development Capital Projects Fund Year Ended June 30, 2021
94 Page 113 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits 1,150,000$ 786,516$ (363,484)$ Investment Income 35,000 (676) (35,676) Rental Income 73,550 73,865 315
Total Revenues 1,258,550 859,705 (398,845)
EXPENDITURES
Current:
Engineering and Public Works 1,217,647 116,760 1,100,887 Community Services - - - Total Expenditures 1,217,647 116,760 1,100,887
Excess (Deficiency) of Revenues
over Expenditures 40,903 742,945 702,042
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances 40,903 742,945 702,042 Fund Balance, Beginning 4,138,757 4,138,757 -
Fund Balance, Ending 4,179,660$ 4,881,702$ 702,042$
City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Storm Drain Development Capital Projects Fund Year Ended June 30, 2021
95 Page 114 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits 570,000$ 464,484$ (105,516)$ Investment Income 25,000 (3,818) (28,818) Intergovernmental - - - Other Revenue - - - Total Revenues 595,000 460,666 (134,334)
EXPENDITURES
Current:
Engineering and Public Works 3,034,800 1,541,251 1,493,549 Community Services - - - Total Expenditures 3,034,800 1,541,251 1,493,549
Excess (Deficiency) of Revenues
over Expenditures (2,439,800) (1,080,585) 1,359,215
OTHER FINANCING SOURCES (USES)
Transfers In - - - Transfers Out - - - Issuance of Debt - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (2,439,800) (1,080,585) 1,359,215 Fund Balance, Beginning 2,662,644 2,662,644 - Fund Balance, Ending 222,844$ 1,582,059$ 1,359,215$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Street & Traffic Safety Development Capital Projects Fund Year Ended June 30, 2021
96 Page 115 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits -$ -$ -$ Investment Income - - - Intergovernmental - - - Other Revenue - - - Total Revenues - - -
EXPENDITURES
Current:
Engineering and Public Works 1,842,759 515,207 1,327,552 Community Services - - - Total Expenditures 1,842,759 515,207 1,327,552
Excess (Deficiency) of Revenues
over Expenditures (1,842,759) (515,207) 1,327,552
OTHER FINANCING SOURCES (USES)
Transfers In 593,000 593,000 -
Transfers Out - - - Issuance of Debt - - - Total Other Financing
Sources (Uses) 593,000 593,000 -
Net Change in Fund Balances (1,249,759) 77,793 1,327,552 Fund Balance, Beginning 1,409,108 1,409,108 - Fund Balance, Ending 159,349$ 1,486,901$ 1,327,552$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - General Capital Projects Fund
Year Ended June 30, 2021
97 Page 116 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits 216,330$ 216,348$ 18$
Investment Income - (623) (623) Intergovernmental - - - Other Revenue - - - Total Revenues 216,330 215,725 (605)
EXPENDITURES
Current:
Engineering and Public Works 940,124 511,498 428,626 Community Services - - - Total Expenditures 940,124 511,498 428,626
Excess (Deficiency) of Revenues
over Expenditures (723,794) (295,773) 428,021
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Issuance of Debt - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (723,794) (295,773) 428,021 Fund Balance, Beginning 996,483 996,483 - Fund Balance, Ending 272,689$ 700,710$ 428,021$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Street & Alley Repair Capital Projects Fund Year Ended June 30, 2021
98 Page 117 of 173
Variance -
Final Actual Positive
Budget Amounts (Negative)
REVENUES
Licenses and Permits -$ -$ -$ Investment Income - 42 42 Intergovernmental - - - Other Revenue - - - Total Revenues - 42 42
EXPENDITURES
Current:
Engineering and Public Works 22,938 226,259 (203,321) Community Services - - - Total Expenditures 22,938 226,259 (203,321)
Excess (Deficiency) of Revenues
over Expenditures (22,938) (226,217) (203,279)
OTHER FINANCING SOURCES (USES)
Transfers In - - -
Transfers Out - - - Issuance of Debt - - - Total Other Financing
Sources (Uses) - - - Net Change in Fund Balances (22,938) (226,217) (203,279) Fund Balance, Beginning 36,165 36,165 - Fund Balance, Ending 13,227$ (190,052)$ (203,279)$ City of Upland
Schedule of Revenues, Expenditures, and Changes in Fund Balance Budget and Actual - Energy Efficiency Improvements Capital Projects Fund Year Ended June 30, 2021
99 Page 118 of 173
INTERNAL SERVICE FUNDS
City of Upland
Internal Service Funds
Year Ended June 30, 2021
INTERNAL SERVICE FUNDS
The internal service funds are used to account for goods and services provided by one City department to other City departments on a cost reimbursement basis.
Self-funded Insurance Fund
To account for the accumulation and allocation of costs associated with the City’s Workers’ Compensation and General Liability Self-Insurance Program.
Vehicle Replacement Fund
To account for the accumulation and allocation of costs associated with the acquisition, repair, and maintenance of City vehicles.
Information Systems Fund
To account for the operations of the City’s information systems division, including maintenance of copiers, voice systems, and the City’s computer network and hardware infrastructure.
Building Maintenance Fund
To provide for the operation of the City’s building maintenance and operations division which maintains the City’s facilities.
100 Page 120 of 173
City of Upland
Combining Statement of Net Position
Internal Service Funds
June 30, 2021
Self-funded Vehicle Information Building
Insurance Replacement Systems Maintenance Totals
ASSETS
Current Assets:
Cash and Investments 2,052,585$ 473,441$ 2,271,541$ 1,356,681$ 6,154,248$ Accounts Receivable - Net - - 35,829 - 35,829 Inventory and Prepaid Items 173,676 78,990 11,518 - 264,184 Total Current Assets 2,226,261 552,431 2,318,888 1,356,681 6,454,261 Noncurrent Assets:
Capital Assets, Not Being Depreciated
Construction In Progress - - 52,388 - 52,388 Capital Assets, Depreciable, Net - 578,380 563,044 - 1,141,424 Total Noncurrent Assets - 578,380 615,432 - 1,193,812 Total Assets 2,226,261 1,130,811 2,934,320 1,356,681 7,648,073
DEFERRED OUTFLOWS OF RESOURCES
OPEB Related Items 14,171 36,529 39,049 58,888 148,637
Pension Related Items 82,412 85,908 118,373 104,388 391,081 Total Deferred Outflows of Resources 96,583 122,437 157,422 163,276 539,718
LIABILITIES
Current Liabilities:
Accounts Payable 35,679 41,236 62,277 126,118 265,310 Accrued Salaries and Wages 14,485 9,231 20,234 22,503 66,453 Current Portion of Long-Term Liabilities:
Claims and Judgments Payable 2,949,359 - - - 2,949,359 Compensated Absences 10,773 7,475 20,644 20,984 59,876 Total Current Liabilities 3,010,296 57,942 103,155 169,605 3,340,998 Noncurrent Liabilities:
Claims and Judgments Payable 6,798,090 - - - 6,798,090 Net OPEB Liability 61,420 158,326 169,246 255,233 644,225 Net Pension Liability 693,494 722,915 996,110 878,426 3,290,945 Compensated Absences 1,818 4,658 18,880 21,772 47,128 Total Noncurrent Liabilities 7,554,822 885,899 1,184,236 1,155,431 10,780,388 Total Liabilities 10,565,118 943,841 1,287,391 1,325,036 14,121,386
DEFERRED INFLOWS OF RESOURCES
OPEB Related Items 5,210 13,431 14,357 21,651 54,649 Pension Related Items - - - - - Total Deferred Inflows of Resources 5,210 13,431 14,357 21,651 54,649
NET POSITION
Net Investment in Capital Assets - 578,380 615,432 - 1,193,812 Unrestricted (8,247,484) (282,404) 1,174,562 173,270 (7,182,056) Total Net Position (8,247,484)$ 295,976$ 1,789,994$ 173,270$ (5,988,244)$ 101 Page 121 of 173
City of Upland
Combining Statement of Revenues, Expenses, and Changes in Net Position Internal Service Funds
Year Ended June 30, 2021
Self-funded Vehicle Information Building
Insurance Replacement Systems Maintenance Totals
OPERATING REVENUES
Charges for Services 4,683,130$ 655,990$ 1,835,380$ 929,710$ 8,104,210$ Other Operating Revenues 3,269 - 145,482 300 149,051 Total Operating Revenues 4,686,399 655,990 1,980,862 930,010 8,253,261
OPERATING EXPENSES
Maintenance and Operations 495,296 724,095 1,899,255 893,398 4,012,044 Contractual Services 283,919 - - - 283,919 Claims Expense 2,572,231 - - - 2,572,231 Depreciation - 44,656 205,570 - 250,226 Total Operating Expenses 3,351,446 768,751 2,104,825 893,398 7,118,420 Operating Income (Loss)1,334,953 (112,761) (123,963) 36,612 1,134,841
NONOPERATING REVENUES (EXPENSES)
Interest Income 7,032 5,573 15,522 9,920 38,047 Gain/(Loss) on Disposal of Capital Assets - 66,650 - - 66,650 Total Nonoperating Revenues (Expenses)7,032 72,223 15,522 9,920 104,697 Income (Loss) Before Operating Transfers 1,341,985 (40,538) (108,441) 46,532 1,239,538 Capital Contributions - - - - - Transfers In 700,000 349,274 266,100 - 1,315,374 Transfers Out - - - (193,000) (193,000) Change in Net Position 2,041,985 308,736 157,659 (146,468) 2,361,912 Net Position - Beginning of Year (10,289,469) (12,760) 1,632,335 319,738 (8,350,156) Net Position - End of Year (8,247,484)$ 295,976$ 1,789,994$ 173,270$ (5,988,244)$ 102 Page 122 of 173
City of Upland
Combining Statement of Cash Flows
Internal Service Funds
Year Ended June 30, 2021
Self-funded Vehicle Information Building
Insurance Replacement Systems Maintenance Totals
CASH FLOWS FROM OPERATING ACTIVITIES
Cash Received from User Departments 4,686,459$ 655,990$ 1,981,439$ 930,010$ 8,253,898$ Cash Paid to Suppliers for Goods and Services (3,866,193) (435,117) (1,456,896) (343,285) (6,101,491) Cash Paid to Employees for Services (123,103) (330,333) (368,131) (563,845) (1,385,412) Net Cash from Operating Activities 697,163 (109,460) 156,412 22,880 766,995
CASH FLOWS FROM NONCAPITAL AND
RELATED FINANCING ACTIVITIES
Cash Paid (to) from Other Funds 700,000 349,274 266,100 (193,000) 1,122,374 Advances Paid (to) from Other Funds - - - - - Net Cash from Noncapital and
Related Financing Activities 700,000 349,274 266,100 (193,000) 1,122,374
CASH FLOWS FROM CAPITAL AND
RELATED FINANCING ACTIVITIES
Cash Received from Sale of Capital Assets - 66,650 - - 66,650 Acquisition and Construction of Capital Assets - (444,410) (116,253) - (560,663) Net Cash from Capital and
Related Financing Activities - (377,760) (116,253) - (494,013)
CASH FLOWS FROM INVESTING ACTIVITIES
Interest Received 7,032 5,573 15,522 9,920 38,047 Net Cash from Investing Activities 7,032 5,573 15,522 9,920 38,047 Net Increase (Decrease) in Cash and Cash Equivalents 1,404,195 (132,373) 321,781 (160,200) 1,433,403 Cash and Cash Equivalents, Beginning of the Year 648,390 605,814 1,949,760 1,516,881 4,720,845 Cash and Cash Equivalents, End of the Year 2,052,585$ 473,441$ 2,271,541$ 1,356,681$ 6,154,248$ Reconciliation of Operating Income (Loss) to
Net Cash from Operating Activities:
Operating Income (Loss)1,334,953$ (112,761)$ (123,963)$ 36,612$ 1,134,841$ Adjustments to Reconcile Operating Income (Loss) to
Net Cash Provided (Used) by Operating Activities:
Depreciation - 44,656 205,570 - 250,226 Changes in Operating Assets and Liabilities:
(Increase) Decrease in Accounts Receivable 60 - 577 - 637 (Increase) Decrease in Due from Other Governments - - - - - (Increase) Decrease in Inventory and Prepaid Items (54,418) (3,044) (11,518) - (68,980) (Increase) Decrease in Deferred Outflows - Pensions (22,430) 10,905 6,326 17,680 12,481 (Increase) Decrease in Deferred Outflows - OPEB (1,535) (16,221) (19,945) (30,457) (68,158) Increase (Decrease) in Accounts Payable 11,070 12,258 43,621 46,843 113,792 Increase (Decrease) in Accrued Salaries and Benefits 1,200 (1,955) 5,629 (1,312) 3,562 Increase (Decrease) in Compensated Absences 6,123 (1,433) 13,778 4,261 22,729 Increase (Decrease) in Net Pension Liability 231,863 (22,174) 36,403 (61,034) 185,058 Increase (Decrease) in Net OPEB Liability (38,799) (2,741) 17,724 29,740 5,924 Increase (Decrease) in Deferred Inflows - Pensions (6,364) (10,272) (13,230) (12,951) (42,817) Increase (Decrease) in Deferred Inflows - OPEB (7,302) (6,678) (4,560) (6,502) (25,042) Increase (Decrease) in Claims Payable (757,258) - - - (757,258) Net Cash from Operating Activities 697,163$ (109,460)$ 156,412$ 22,880$ 766,995$ 103 Page 123 of 173
CUSTODIAL FUNDS
City of Upland
Custodial Funds
Year Ended June 30, 2021
CUSTODIAL FUNDS
Custodial Funds are used to account for assets held by a government in a trustee capacity or as an agent for individuals, private organizations, other governments, and/or other funds.
Community Facilities District 2003-2 Area 1 Fund
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvements in the Colonies development.
Community Facilities District 2003-2 Area 2 Fund
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvements in the Colonies development.
Community Facilities District 2015-1 Fund
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvements in the Sycamore Hills development.
Community Facilities District 2016-1 Fund
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvements in the Harvest at Upland development.
Community Facilities District 2016-2 Maintenance Fund
To account for revenues received from property holders for the payment of maintenance services including median landscaping, channel landscaping, storm drain clean outs, and asphalt slurry every 5 years within the Harvest at Upland development.
Community Facilities District 2017-1 Maintenance Fund
To account for revenues received from property holders for the payment of maintenance services including median landscaping, channel landscaping, storm drain clean outs, and asphalt slurry every 5 years within the Sycamore Hills development.
Community Facilities District 2016-1 Area 2Fund
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvements in the Harvest at Upland development.
Assessment District 84-1 Fund
To account for the district formed to provide street sweeping, landscape irrigation, and street light services.
Sanitary Sewer Facility Development Fund
To account for revenue collected to expand both the City’s and the region’s sanitary sewage facilities to accommodate current and future growth.
Welfare Committee Fund
To account for employee contributions to provide future financial assistance to employees in the event of a personal financial emergency.
West End Consolidated Water Company (Water Company)
To account for the Water Company’s financial transactions and balances. 104 Page 125 of 173
City of Upland
Custodial Funds
Year Ended June 30, 2021
CUSTODIAL FUNDS - Continued
Community Facilities District 2003-1
To account for revenues received from property holders for the payment of debt issued to finance the acquisition of certain public rights of way and construction of certain public improvement in the Upland 54 development.
105 Page 126 of 173
City of Upland
Combining Statement of Fiduciary Net Position
Custodial Funds
June 30, 2021
Community Community Community Community Community Community Facilities District Facilities District Facilities Facilities Facilities Facilities 2003-2 Area 1 2003-2 Area 2 District 2015-1 District 2016-1 District 2016-2 District 2017-1 ASSETS
Cash and Investments 13,467$ 14,013$ 8,348$ 4,403$ 114,830$ 37,480$ Cash with Fiscal Agent 3,437,323 2,633,191 4,865,552 886,482 - - Accounts Receivable 10,812 - 2,248 6,335 1,639 15 Total Assets 3,461,602 2,647,204 4,876,148 897,220 116,469 37,495
LIABILITIES
Deposits Payable - - 46,329 150,500 15,784 - Accounts Payable - 209 - - 1,702 2,750 Total Liabilities - 209 46,329 150,500 17,486 2,750
NET POSITION
Restricted for:
Organizations and Individuals 3,461,602 2,646,995 4,829,819 746,720 98,983 34,745 Other Governments - - - - - - Total Net Position 3,461,602$ 2,646,995$ 4,829,819$ 746,720$ 98,983$ 34,745$ 106 Page 127 of 173
Community Sanitary Sewer West End Community
Facilities District Assessment Facility Welfare Consolidated Facilities 2016-1 Area 2 District 84-1 Development Committee Water Co. District 2003-1 Total 6,093$ -$ 5,748,458$ 35,077$ 496,941$ 4,362$ 6,483,472$ 8,647,197 - - - - 279,817 20,749,562 215 13 - - - 1,263 22,540 8,653,505 13 5,748,458 35,077 496,941 285,442 27,255,574 164,308 - - - - - 376,921 - 832 1,068,078 - - - 1,073,571 164,308 832 1,068,078 - - - 1,450,492 8,489,197 (819) - 35,077 496,941 285,442 21,124,702 - - 4,680,380 - - - 4,680,380 8,489,197$ (819)$ 4,680,380$ 35,077$ 496,941$ 285,442$ 25,805,082$ 107 Page 128 of 173
City of Upland
Combining Statement of Fiduciary Net Position
Custodial Funds
June 30, 2021
Community Community Community Community Community Community Facilities District Facilities District Facilities Facilities Facilities Facilities 2003-2 Area 1 2003-2 Area 2 District 2015-1 District 2016-1 District 2016-2 District 2017-1
ADDITIONS
Contributions:
Taxes and assessments collected for others 1,497,162$ 1,279,338$ 521,781$ 531,844$ 74,227$ 17,042$ Contributions from Bondholders - - - - - - Investment Earnings:
Interest Income - - - - - - Total Additions 1,497,162 1,279,338 521,781 531,844 74,227 17,042
DEDUCTIONS
General and Administrative 17,279 18,413 898,643 32,932 10,061 10,937 Recipient Payments - - - - - - Distribution to Shareholders 1,517,900 1,312,068 379,869 508,116 - - Total Deductions 1,535,179 1,330,481 1,278,512 541,048 10,061 10,937 Net Increase (decrease) in fiduciary net position (38,017) (51,143) (756,731) (9,204) 64,166 6,105 Net Position, beginning of the year (restated)3,499,619 2,698,138 5,586,550 755,924 34,817 28,640 Net Position, end of the year 3,461,602$ 2,646,995$ 4,829,819$ 746,720$ 98,983$ 34,745$ 108 Page 129 of 173
Community Sanitary Sewer West End Community
Facilities District Assessment Facility Welfare Consolidated Facilities 2016-1 Area 2 District 84-1 Development Committee Water Co. District 2003-1 Total 9,019$ 3,645$ 1,532,066$ 1,106$ -$ 121,626$ 5,588,856$ 8,499,405 - - - - - 8,499,405 - - - - 3,695 - 3,695 8,508,424 3,645 1,532,066 1,106 3,695 121,626 14,091,956 19,227 3,789 1,068,078 - - 8,466 2,087,825 - - 2,505,240 - - - 2,505,240 - - - - - 122,900 3,840,853 19,227 3,789 3,573,318 - - 131,366 8,433,918 8,489,197 (144) (2,041,252) 1,106 3,695 (9,740) 5,658,038 - (675) 6,721,632 33,971 493,246 295,182 20,147,044 8,489,197$ (819)$ 4,680,380$ 35,077$ 496,941$ 285,442$ 25,805,082$ 109 Page 130 of 173
STATISTICAL SECTION
City of Upland
Description of Statistical Section Contents
June 30, 2021
This part of the City of Upland's Annual Comprehensive financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures, and required supplementary information say about the government's overall financial health.
Contents: Pages
Financial Trends theses schedules contain trend information to help the reader understand how the City's financial performance and well-being have changed over time
111
Revenue Capacity these schedules contain information to help the reader assess the City's most significant local revenue source, the property tax
121
Debt Capacity these schedules present information to help the reader assess the affordability of the City's current levels of outstanding debt and the City's ability to issue additional debt in the future
129
Demographic and Economic Information these schedules offer demographic and economic indicators to help the reader understand the environment within which the City's financial activities take place
136
Operating Information these schedules contain service and infrastructure data to help the reader understand how the information in the City's financial report relates to the services the City provides and the activities it performs
138
110 Page 132 of 173
CITY OF UPLAND
2012 2013 2014 2015 2016
Governmental activities
Invested in capital assets, net of related debt 279,503,381$ 281,184,806$ 272,320,453$ 274,795,930$ 269,132,382$ Restricted 15,971,514 22,177,079 18,336,004 14,482,775 25,659,378 Unrestricted (12,516,353) (19,386,237) (253,534) (62,716,819) (64,259,153) Total governmental activities net position 282,958,542$ 283,975,648$ 290,402,923$ 226,561,886$ 230,532,607$ Business-type activities
Invested in capital assets, net of related debt 75,066,229$ 76,050,669$ 75,114,852$ 68,450,050$ 67,891,850$ Restricted - - - - - Unrestricted 38,813,010 37,241,528 36,705,400 27,528,096 34,916,716 Total business-type activities net position 113,879,239$ 113,292,197$ 111,820,252$ 95,978,146$ 102,808,566$ Primary government
Invested in capital assets, net of related debt 354,569,610$ 357,235,475$ 347,435,305$ 343,245,980$ 337,024,232$ Restricted 15,971,514 22,177,079 18,336,004 14,482,775 25,659,378 Unrestricted 26,296,657 17,855,291 36,451,866 (35,188,723) (29,342,437) Total primary government net position 396,837,781$ 397,267,845$ 402,223,175$ 322,540,032$ 333,341,173$ Source: Finance Division, City of Upland
NET POSITION BY COMPONENT
LAST TEN FISCAL YEARS ( ACCRUAL BASIS OF ACCOUNTING)
Fiscal Year Ended June 30,
111 Page 133 of 173
2017 2018 2019 2020 2021
267,791,299$ 262,318,491$ 262,465,719$ 266,996,077$ 267,040,558$ 40,844,504 42,616,153 44,877,724 52,227,409 43,407,782 (74,170,029) (83,164,838) (80,859,640) (74,070,557) (59,600,057) 234,465,774$ 221,769,806$ 226,483,803$ 245,152,929$ 250,848,283$ 68,761,226$ 69,511,985$ 70,481,398$ 80,694,523$ 11,916,179$ - - - - - 39,989,572 48,033,153 54,825,737 62,335,721 141,256,446 108,750,798$ 117,545,138$ 125,307,135$ 143,030,244$ 153,172,625$ 336,552,525$ 331,830,476$ 332,947,117$ 347,690,600$ 278,956,737$ 40,844,504 42,616,153 44,877,724 52,227,409 43,407,782 (34,180,457) (35,131,685) (26,033,903) (11,734,836) 81,656,389 343,216,572$ 339,314,944$ 351,790,938$ 388,183,173$ 404,020,908$ Fiscal Year Ended June 30,
112 Page 134 of 173
LAST TEN FISCAL YEARS ( ACCRUAL BASIS OF ACCOUNTING)
2012 2013 2014 2015 2016
Expenses
Governmental activities:
General government 5,137,446$ 4,113,605$ 4,709,996$ 3,050,233$ 5,626,905$ Public safety 30,710,194 29,009,795 24,047,934 27,468,131 27,178,673 Engineering and public works 12,074,768 7,868,067 9,879,986 9,281,467 11,049,238 Development services 5,218,453 4,967,335 3,174,496 5,447,239 5,214,410 Community services 4,584,937 6,100,981 4,057,338 5,073,673 4,308,397 Interest expense 1,326,383 310,478 286,492 284,269 281,359 Total governmental activities expenses 59,052,181 52,370,261 46,156,242 50,605,012 53,658,982 Business-type activities:
Water utility 17,893,977 17,019,949 19,565,979 20,124,035 16,121,912 Solid waste utility 9,360,397 9,246,343 9,322,648 9,872,451 9,602,172 Sewer utility 5,882,096 5,813,597 6,278,008 7,457,367 7,063,779 Animal services 1,163,149 1,082,162 1,020,821 - - Total business-type activities expenses 34,299,619 33,162,051 36,187,456 37,453,853 32,787,863 Total primary government expenses 93,351,800$ 85,532,312$ 82,343,698$ 88,058,865$ 86,446,845$ Program Revenues
Governmental activities:
Charges for services:
General government 1,428,531$ 1,416,615$ 1,508,984$ 1,658,124$ 1,124,713$ Public safety 2,509,528 2,526,925 2,930,767 3,593,175 3,789,627 Engineering and public works 271,742 411,595 579,582 660,583 246,341 Development services 2,094,944 3,881,798 4,541,765 4,612,643 4,933,961 Community services 624,243 611,995 1,058,570 1,097,518 1,072,754 Operating grants and contributions 6,515,231 6,554,132 6,234,320 7,014,790 5,120,131 Capital grants and contributions 1,827,726 2,614,837 1,636,573 2,712,801 3,926,465 Total governmental activities
program revenues 15,271,945 18,017,897 18,490,561 21,349,634 20,213,992 Business-type activities
Charges for services:
Water utility 17,769,773 17,324,491 18,184,343 22,713,562 18,601,289 Solid waste utility 9,421,363 9,535,127 9,592,364 10,355,699 10,544,776 Sewer utility 6,193,947 6,294,532 6,432,824 7,233,341 8,068,428 Animal services 438,750 567,329 384,674 - - Operating grants and contributions - - 23,220 21,672 15,519 Capital grants and contributions - - - - - Total business-type activities
program revenues 33,823,833 33,721,479 34,617,425 40,324,274 37,230,012 Total primary government
program revenues 49,095,778$ 51,739,376$ 53,107,986$ 61,673,908$ 57,444,004$ Net (expenses)/revenue
Governmental activities (43,780,236)$ (34,352,364)$ (27,665,681)$ (29,255,378)$ (33,444,990)$ Business-type activities (475,786) 559,428 (1,570,031) 2,870,421 4,442,149 Total net revenues (expense) (44,256,022)$ (33,792,936)$ (29,235,712)$ (26,384,957)$ (29,002,841)$
CITY OF UPLAND
CHANGES IN NET POSITION
Fiscal Year Ended June 30,
113 Page 135 of 173
2017 2018 2019 2020 2021
3,080,619$ 4,539,492$ 4,033,829$ 3,740,648$ 2,148,712$ 32,174,086 27,927,892 27,265,506 23,786,129 31,674,977 9,819,952 11,468,377 12,092,590 3,524,461 14,653,574 5,407,099 6,624,913 6,059,857 5,931,597 5,682,894 3,691,035 3,370,656 4,255,538 3,910,878 3,642,911 358,679 715,062 840,116 817,235 783,846 54,531,470 54,646,392 54,547,436 41,710,948 58,586,914 18,483,205 19,989,900 21,525,637 20,513,809 22,480,852 10,051,229 11,042,468 12,316,577 13,787,098 14,487,585 7,818,112 9,285,699 9,387,370 9,946,531 10,663,464 - - - - - 36,352,546 40,318,067 43,229,584 44,247,438 47,631,901 90,884,016$ 94,964,459$ 97,777,020$ 85,958,386$ 106,218,815$ 305,373$ 382,010$ 1,187,018$ 583,514$ 795,356$ 3,541,745 1,827,271 1,866,761 1,644,528 1,223,941 776,173 4,207,550 2,991,516 5,038,970 4,002,120 5,461,323 5,245,335 5,876,464 6,038,238 6,066,211 495,702 546,702 581,989 395,733 934,551 5,933,967 2,066,407 2,340,876 2,518,963 4,433,802 4,337,377 6,604,091 7,305,417 8,229,671 7,219,514 20,851,660 20,879,366 22,150,041 24,449,617 24,675,495 21,299,753 28,076,336 26,203,575 27,703,940 29,333,341 11,103,446 11,687,415 12,677,799 13,772,383 14,643,704 9,705,668 10,144,832 10,573,571 10,606,800 10,818,913 - - - - - 63,207 70,598 57,708 - 23,630 - - 1,544,529 9,882,981 2,903,615 42,172,074 49,979,181 51,057,182 61,966,104 57,723,203 63,023,734$ 70,858,547$ 73,207,223$ 86,415,721$ 82,398,698$ (33,679,810)$ (33,767,026)$ (32,397,395)$ (17,261,331)$ (33,911,419)$ 5,819,528 9,661,114 7,827,598 17,718,666 10,091,302 (27,860,282)$ (24,105,912)$ (24,569,797)$ 457,335$ (23,820,117)$ Fiscal Year Ended June 30,
114 Page 136 of 173
LAST TEN FISCAL YEARS ( ACCRUAL BASIS OF ACCOUNTING)
2012 2013 2014 2015 2016
General Revenues and Other
Changes in Net Position
Governmental activities:
Taxes
Property taxes 16,279,713$ 17,207,416$ 17,656,767$ 18,376,071$ 19,309,037$ Tax increment 4,813,601 - - - - Sales taxes 9,992,768 10,167,479 11,282,830 12,477,307 13,909,909 Other taxes 1,676,719 1,603,147 1,744,459 1,890,562 1,778,356 Investment income 100,072 26,819 61,284 93,147 216,843 Motor vehicle in lieu 179,479 190,258 217,444 852,384 429,308 Gain on sale of assets 9,682 - 51,530 14,151 32,589 Miscellaneous revenue 908,588 583,147 3,494,568 4,238,903 394,567 Extraordinary gain (note 21)23,491,941 - - - - Special Item (note 16)- - - - - Transfers 1,195,158 5,922,919 (69,537) 122,245 (3,000) Total governmental activities 58,647,721 35,701,185 34,439,345 38,064,770 36,067,609 Business-type activities:
Investment income 186,316 53,563 28,549 99,832 148,205 Share of joint venture net income - - - - - Gain on sale of assets 20,350 - - - - Miscellaneous revenue - - - - - Transfers (1,195,158) (1,058,593) 69,537 (122,245) 3,000 Total business-type activities (988,492) (1,005,030) 98,086 (22,413) 151,205 Total primary government 57,659,229$ 34,696,155$ 34,537,431$ 38,042,357$ 36,218,814$ Changes in Net Position
Governmental activities 14,867,485$ 1,348,821$ 6,773,664$ 8,809,392$ 2,622,619$ Business-type activities (1,464,278) (445,602) (1,471,945) 2,848,008 4,593,354 Total primary government 13,403,207$ 903,219$ 5,301,719$ 11,657,400$ 7,215,973$ Source: Finance Division, City of Upland
CITY OF UPLAND
CHANGES IN NET POSITION
Fiscal Year Ended June 30,
115 Page 137 of 173
2017 2018 2019 2020 2021
20,482,854$ 16,343,119$ 16,831,839$ 18,055,721$ 18,818,701$ - - - - - 13,293,304 13,673,539 14,507,927 13,579,780 16,876,712 2,740,447 2,696,807 2,692,051 2,819,493 2,895,754 326,531 (90,335) 1,012,981 1,232,765 927,392 223,315 40,421 36,969 62,114 57,805 4,180 - 132,623 - - 355,677 321,564 271,298 180,584 30,374 - - - - - - (5,562,967) - - - 67,000 - 814,669 - - 37,493,308 27,422,148 36,300,357 35,930,457 39,606,738 189,704 415,529 761,947 1,187,036 51,079 - - - - - - - (12,879) - - - - - - - (67,000) - (814,669) - - 122,704 415,529 (65,601) 1,187,036 51,079 37,616,012$ 27,837,677$ 36,234,756$ 37,117,493$ 39,657,817$ 3,813,498$ (6,344,878)$ 3,902,962$ 18,669,126$ 5,695,319$ 5,942,232 10,076,643 7,761,997 18,905,702 10,142,381 9,755,730$ 3,731,765$ 11,664,959$ 37,574,828$ 15,837,700$ Fiscal Year Ended June 30,
116 Page 138 of 173
Fiscal Year Ended June 30,
2012 2013 2014 2015 2016
General Fund
Nonspendable 125,762$ 139,164$ 158,323$ 110,709$ 63,831$ Restricted - - - - - Committed - - - - - Assigned - - - - - Unassigned 805,739 721,275 3,841,677 10,284,958 14,478,664 Total General Fund 931,501$ 860,439$ 4,000,000$ 10,395,667$ 14,542,495$ Other governmental funds
Nonspendable -$ -$ -$ -$ -$ Restricted 10,208,668 15,078,398 18,683,199 34,769,384 38,524,248 Committed - - - - - Assigned - - - - - Unassigned (83,676) (1,525,535) (112,511) (20,372) (254,428) Total Other Governmental Funds 10,124,992$ 13,552,863$ 18,570,688$ 34,749,012$ 38,269,820$ Source: Finance Division, City of Upland
CITY OF UPLAND
FUND BALANCES OF GOVERNMENTAL FUNDS
LAST TEN FISCAL YEARS (MODIFIED ACCRUAL BASIS OF ACCOUNTING) 117 Page 139 of 173
2017 2018 2019 2020 2021
75,325$ 64,869$ 73,803$ 68,061$ 178,650$ - 18,473 18,473 53,073 10,733,983 - 4,670,418 4,670,418 7,750,840 15,137,875 - - - - 4,491,000 15,254,150 9,479,082 18,538,881 16,404,123 249,245 15,329,475$ 14,232,842$ 23,301,575$ 24,276,097$ 30,790,753$ -$ -$ -$ -$ -$ 39,563,384 42,616,153 44,979,990 53,645,011 55,210,075 - - - - - - 7,531 - - - (4,088) (296) - (246,676) (684,266) 39,559,296$ 42,623,388$ 44,979,990$ 53,398,335$ 54,525,809$ Fiscal Year Ended June 30,
118 Page 140 of 173
LAST TEN FISCAL YEARS (MODIFIED ACCRUAL BASIS OF ACCOUNTING) 2012 2013 2014 2015 2016
Revenues
Taxes 35,295,459$ 30,756,478$ 32,593,211$ 35,655,141$ 37,799,228$ Licenses and permits 1,070,611 987,862 1,041,388 1,794,686 1,875,032 Charges for services 4,203,719 4,362,451 5,230,294 5,606,821 5,392,160 Fines and penalties 517,741 500,389 533,282 604,509 594,417 Investment income 100,072 27,704 57,147 92,100 187,819 Rental income 1,727,205 3,318,077 3,787,894 3,860,094 4,013,904 Intergovernmental 7,268,610 7,221,745 6,806,235 7,655,572 5,435,521 y Other 1,182,183 1,254,136 4,659,040 5,317,007 1,273,394 Total revenues 51,365,600 48,428,842 54,708,491 60,585,930 56,571,475 Expenditures
General government 5,991,749 4,805,137 5,138,890 3,420,069 3,658,673 Public safety 27,603,446 26,530,316 25,998,626 26,462,312 28,178,150 Engineering and public works 7,940,843 10,362,812 4,870,786 5,698,034 7,874,070 Development services 4,959,672 4,857,256 4,612,547 5,274,072 5,262,923 Community services 3,894,008 4,145,232 3,908,447 4,506,490 4,216,350 Debt service:
Principal 1,925,000 210,000 220,000 235,000 258,368 Interest 1,242,428 317,068 293,657 282,901 296,236 Pass-through payments 801,386 - - - - Fiscal charges 3,319 3,300 3,300 6,659 2,258 Total expenditures 54,361,851 51,231,121 45,046,253 45,885,537 49,747,028 Excess (deficiency) of revenues
over (under) expenditures (2,996,251) (2,802,279) 9,662,238 14,700,393 6,824,447 Other financing sources (uses)
Transfers in 2,073,948 6,808,907 2,761,375 273,409 1,208,553 Transfers out (1,129,300) (870,049) (3,919,838) (2,478,470) (1,525,154) Extraordinary gain (loss) (note 21) (14,129,606) - - - - Proceeds from sale of capital assets 9,682 - - - 1,600 Issuance of capital leases - - - 200,524 Payments to bond escrow - - - - - Issuance of bonds/debt - - - - - Total other financing sources(uses) (13,175,276) 5,938,858 (1,158,463) (2,205,061) (114,477) Net change in fund balances (16,171,527)$ 3,136,579$ 8,503,775$ 12,495,332$ 6,709,970$ Debt service as a percentage of
noncapital expenditures*7.5%6.0%1.2%1.2%1.1%
* This percentage is computed as: Debt Service divided by Non-Capital Expenditures
CITY OF UPLAND
CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS
Fiscal Year Ended June 30,
119 Page 141 of 173
2017 2018 2019 2020 2021
38,830,352$ 32,719,390$ 36,119,214$ 35,505,234$ 39,675,488$ 3,009,862 5,164,222 4,354,120 6,164,957 5,955,190 5,857,984 2,785,383 3,055,102 2,843,447 2,384,400 619,646 646,874 989,437 893,964 542,604 86,173 38,881 1,813,945 1,679,486 829,306 4,191,730 4,738,192 5,003,949 5,156,573 5,259,555 5,798,858 5,579,860 5,518,173 6,812,160 8,241,316 1,742,663 934,735 1,727,759 550,605 627,760 60,137,268 52,607,537 58,581,699 59,606,426 63,515,619 4,950,630 2,154,855 1,918,770 1,956,329 2,255,746 31,733,042 23,950,547 23,653,097 25,977,681 27,381,746 9,380,001 15,361,147 12,907,584 9,842,367 14,744,656 5,446,549 6,366,818 5,343,038 5,735,938 5,683,606 3,518,510 3,170,399 3,279,498 3,240,983 3,193,155 288,319 18,677,299 674,583 695,406 739,578 360,854 715,062 840,116 817,235 783,846 - - - - - 3,575 - - - - 55,681,480 70,396,127 48,616,686 48,265,939 54,782,333 4,455,788 (17,788,590) 9,965,013 11,340,487 8,733,286 517,960 224,081 1,035,556 1,725,996 593,000 (2,164,720) (3,693,295) (518,892) (3,673,616) (1,715,374) - - - - - - - 132,623 - 31,218 - - - - - - - - - - - 22,210,487 - - - (1,646,760) 18,741,273 649,287 (1,947,620) (1,091,156) 2,809,028$ 952,683$ 10,614,300$ 9,392,867$ 7,642,130$
1.1%1.3%3.9%3.6%4.1%
Fiscal Year Ended June 30,
120 Page 142 of 173
CITY OF UPLAND
ASSESSED VALUE AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY (IN THOUSANDS OF DOLLARS)
LAST TEN FISCAL YEARS
2011/12 2012/13 2013/14 2014/15 2015/16
Residential 5,382,875 5,498,151 5,680,385 6,068,414 6,401,935 Commercial 820,057 823,190 849,188 873,943 875,269 Industrial 309,414 306,113 314,762 318,293 342,277 Dry Farm 4,021 4,029 4,184 4,186 470 Govt. Owned 941 960 979 983 1,003 Institutional 12,430 12,982 14,288 10,334 9,826 Irrigated 1,890 1,928 1,967 1,976 2,015 Miscellaneous 74,576 76,292 78,275 78,792 80,400 Recreational 17,828 18,041 14,322 14,353 14,804 Vacant 71,460 68,364 74,268 65,657 84,782 SBE Nonunitary 69 69 69 70 70 Unsecured 262,654 265,091 262,039 259,893 268,858 TOTALS 6,958,214 7,075,211 7,294,725 7,696,894 8,081,709 Total Direct Rate 0.29248% 0.29337% 0.17491% 0.17491% 0.17492% Source: San Bernardino County Assessor 2011/12 - 2020/21 Combined Tax Rolls; HdL Coren & Cone
Note: The State Constitution requires property to be assessed at one hundred percent of the most recent purchase price, plus an increment of no more than two percent annually, plus any local overrides. These values are considered to be full market values.
Fiscal Year
121 Page 143 of 173
2016/17 2017/18 2018/19 2019/20 2020/21
6,697,951 7,059,507 7,440,680 7,822,956 8,303,185 908,646 991,548 1,059,249 1,092,437 1,146,927 350,443 377,242 401,508 405,874 436,283 477 487 497 507 621 1,018 1,039 1,060 1,554 1,585 13,908 11,982 12,730 8,269 8,177 1,640 1,673 1,707 1,741 1,775 103,978 76,233 78,464 84,498 95,151 14,162 13,758 13,812 14,875 14,940 91,043 132,223 127,536 150,349 132,343 70 70 69 180 180 249,241 230,214 246,034 251,133 239,443 8,432,577 8,895,976 9,383,346 9,834,373 10,380,611
0.17492% 0.17492% 0.08257% 0.09330% 0.09079%
Fiscal Year
122 Page 144 of 173
Fiscal Gallons % of Gallons % of Gallons % of Gallons % of Year Consumed Total Consumed Total Consumed Total Consumed Total 2012 4,648,953,144 74.3% 694,179,156 11.1% 238,037,536 3.8% 677,373,092 10.8% 2013 4,825,517,048 73.7% 733,835,124 11.2% 241,184,372 3.7% 750,007,632 11.4% 2014 4,930,872,848 72.8% 729,473,536 10.8% 218,617,212 3.2% 895,623,036 13.2% 2015 4,456,746,316 71.4% 718,672,416 11.5% 210,080,288 3.4% 860,493,216 13.8% 2016 3,566,689,896 70.7% 650,598,432 12.9% 176,596,816 3.5% 649,350,020 12.9% 2017 3,848,856,440 71.0% 680,205,768 12.5% 177,463,748 3.3% 717,650,648 13.2% 2018 4,243,225,976 70.1% 717,147,992 11.8% 186,568,404 3.1% 909,118,452 15.0% 2019 3,804,467,128 69.4% 659,586,400 12.0% 165,040,216 3.0% 852,306,356 15.5% 2020 3,940,665,212 71.5% 592,244,708 10.7% 167,931,236 3.0% 813,682,628 14.8% 2021 4,359,818,232 71.5% 593,676,380 9.7% 212,988,512 3.5% 934,994,764 15.3% Source: Finance Division, City of Upland
CITY OF UPLAND
WATER SALES BY USER TYPE
LAST TEN FISCAL YEARS
Residential Commercial Public Agency Irrigation
123 Page 145 of 173
CITY OF UPLAND
DIRECT AND OVERLAPPING PROPERTY TAX RATES
(RATE PER $100 OF TAXABLE VALUE)
LAST TEN FISCAL YEARS
Agency 2011/12 2012/13 2013/14 2014/15 2015/16
Basic Levy1 1.00000 1.00000 1.00000 1.00000 1.00000
Alta Loma Elementary Bond 0.04530 0.04580 0.04500 0.04370 0.04170 Central Elementary Bond 0.06880 0.07270 0.07110 0.06600 0.06500 Chaffey Community College Bond 0.01530 0.01110 0.01570 0.01090 0.01130 Chaffey High School Bond 0.01940 0.01010 0.03710 0.02940 0.04090 Metropolitan Water Agency 0.00370 0.00350 0.00350 0.00350 0.00350 Ontario-Montclair Elementary Bond 0.02890 0.02740 0.02940 0.02600 0.02680 Upland Unified School Bond 0.04740 0.05240 0.04840 0.04620 0.05250 Total Direct & Overlapping2 Tax Rates 1.22880 1.22300 1.25020 1.22570 1.24170 City Share of 1% levy per Prop 133 0.17482 0.17482 0.17482 0.17482 0.17482 Redevelopment Rate4 1.00370 n/a n/a n/a n/a
Total Direct Rate5 0.29248 0.29337 0.17491 0.17491 0.17492 Notes:
Source: San Bernardino County Assessor 2011/12 - 2020/21 Tax Rate Table; HdL Coren & Cone 5 Total Direct Rate is the weighted average of all individual direct rates applied by the City/Agency preparing the statistical section information and excludes revenues derived from aircraft. Beginning in 2013/14 the Total Direct Rate no longer includes revenue generated from the former redevelopment tax rate areas. Challenges to recognized enforceable obligations are assumed to have been resolved during 2012/13. For the purposes of this report, residual revenue is assumed to be distributed to the City/Agency in the same proportions as general fund revenue.
1 In 1978, California voters passed Proposition 13 which set the property tax rate at a 1.00% fixed amount. This
1.00% is shared by all taxing agencies for which the subject property resides within. In addition to the 1.00% fixed amount, property owners are charged taxes as a percentage of assessed property values for the payment of any voter approved bonds.
2 Overlapping rates are those of local and county governments that apply to property owners within the City. Not all overlappping rates apply to all city property owners. 3 City's Share of 1% Levy is based on the City's share of the general fund tax rate area with the largest net taxable value within the City. The ERAF portion of the City's Levy has been subtracted where known. 4 Redevelopment Rate is based on the largest RDA tax rate area and only includes rate(s) from indebtedness adopted prior to 1989 per California State statute. RDA direct and overlapping rates are applied only to the incremental property values. The approval of ABX1 26 eliminated Redevelopment from the State of California for the fiscal year 2012/13 and years thereafter.
Fiscal Year
124 Page 146 of 173
2016/17 2017/18 2018/19 2019/20 2020/21
1.00000 1.00000 1.00000 1.00000 1.00000
0.04080 0.05640 0.06800 0.06530 0.04570
0.06880 0.06700 0.04650 0.05020 0.04890
0.01160 0.00880 0.01530 0.02410 0.01110
0.03190 0.02790 0.04020 0.03750 0.03520
0.00350 0.00350 0.00350 0.00350 0.00350
0.02640 0.05570 0.05550 0.04280 0.04580
0.06070 0.05510 0.05870 0.05600 0.05150
1.24370 1.27440 1.28770 1.27940 1.24170
0.17482 0.17482 0.08042 0.09353 0.09353
n/a n/a n/a n/a n/a
0.17492 0.17492 0.08257 0.09330 0.09079
Fiscal Year
125 Page 147 of 173
CITY OF UPLAND
PRINCIPAL PROPERTY TAXPAYERS
CURRENT YEAR AND TEN YEARS AGO
Taxpayer
Taxable
Assessed
Value Rank
Percentage of
Total Taxable
Assessed Value
Taxable
Assessed
Value Rank
Percentage of
Total Taxable
Assessed Value
Colonies-Pacific LLC 165,016,627$ 1 1.59% 39,994,984$ 3 0.57% College Park Apartment Homes LP 53,908,710 2 0.52% 46,784,287 1 0.67% AMFP IV Alvista LLC 49,878,000 3 0.48%
Foothill Evergreen SPE LLC 49,215,000 4 0.47% MG Stoneridge Village Grove LLC 47,077,637 5 0.45% Rancho Monte Vista Apartment Homes 45,598,985 6 0.44% 39,274,544 4 0.56% CT Retail Properties Finance II LLC 43,884,445 7 0.42% 37,460,857 6 0.54% WNG Mountain Springs GP 40,146,767 8 0.39% 34,270,284 7 0.49% Dee Matreyek-Kurth Non Exempt Trust 37,152,576 9 0.36% NU-168 Apartments LLC 35,838,074 10 0.35% 30,592,271 9 0.44% Granite Sr Woodlane LLC 42,956,901 2 0.62% Koll Per College Business Park, LLC 38,782,851 5 0.56% Bill and Mary Matreyek Trust 30,938,763 8 0.44% GE 2005-C4 Mountain Grv OP Reo 26,330,623 10 0.38% Totals 567,716,821$ 5.47% 367,386,365$ 5.28% Source: San Bernardino County Assessor 2020/21 Combined Tax Roll and the SBE Non Unitary Tax Roll 2021 2012
126 Page 148 of 173
Percentage of Percentage of
Gallons Total Gallons Gallons Total Gallons
Water Purchaser Consumed Rank Consumed Consumed Rank Consumed City of Upland 294,854,120 1 4.8% 215,697,020 1 3.4% Upland Development LLC 146,222,032 2 2.4%
Upland Unified School District 126,229,488 3 2.1% 108,175,012 2 1.2% Mountain View Land Co 79,652,276 4 1.3% 71,132,556 4 1.1% San Antonio Community Hospital 50,209,500 5 0.8% 55,812,768 5 0.9% Upland Hills Estates HOA 46,764,960 6 0.8% 47,444,144 6 0.8% Upland Hills CC COA 39,942,452 7 0.7% 36,770,184 7 0.6% ST of California Dept of Trans 31,903,696 8 0.5% Upland Medows Management Co LP 27,607,184 9 0.5% 33,202,224 9 0.5% College Park Apartment Homes 26,215,156 10 0.4%
State of California 76,279,544 3 1.7%
Orchard Lane Condos 36,681,920 8 0.6%
County of San Bernardino 28,728,436 10 0.5%
Totals 869,600,864 14.3% 709,923,808 11.3%
Source: Finance Division, City of Upland
CITY OF UPLAND
PRINCIPAL WATER PURCHASERS
CURRENT YEAR AND TEN YEARS AGO
2021 2012
127 Page 149 of 173
Fiscal Taxes Levied Collections in
Year Ended for the Percent Subsequent Percent
June 30, Fiscal Year Amount of Levy Years (1) Amount of Levy 2012 9,732,257 9,265,615 95.21% N/A 9,265,615 95.21% 2013 9,881,310 9,452,806 95.66% N/A 9,452,806 95.66% 2014 10,195,064 9,902,877 97.13% N/A 9,902,877 97.13% 2015 10,792,671 10,512,265 97.40% N/A 10,512,265 97.40% 2016 11,319,306 11,049,460 97.62% N/A 11,049,460 97.62% 2017 11,883,283 11,615,501 97.75% N/A 11,615,501 97.75% 2018 12,310,682 12,120,710 98.46% N/A 12,120,710 98.46% 2019 1 6,032,861 5,900,839 97.81% N/A 5,900,839 97.81% 2020 7,326,803 7,162,370 97.76% N/A 7,162,370 97.76% 2021 7,730,056 7,623,675 98.62% N/A 7,623,675 98.62% Notes:
1 Change from prior years due to City's Annexation with San Bernadino County for Fire Services.
CITY OF UPLAND
PROPERTY TAX LEVIES AND COLLECTIONS
LAST TEN FISCAL YEARS
Collected within the
Fiscal Year of Levy Total Collections to Date
Source: Data provided by the San Bernardino County Assessor's Office for collection of prior years taxes does not segregate the information by fiscal year. Therefore, the City is not able to provide this information in the above shcedule.
128 Page 150 of 173
CITY OF UPLAND
RATIOS OF OUTSTANDING DEBT BY TYPE
LAST TEN FISCAL YEARS
Fiscal Lease Total
Year Ended Revenue Tax Allocation Housing Capital Clean Renewable Governmental June 30, Bonds Notes (b)Bonds Leases Energy Bonds Activities 2012 1,160,000 - 18,000,000 - - 19,160,000 2013 950,000 - 18,000,000 - - 18,950,000 2014 730,000 - 18,000,000 - - 18,730,000 2015 495,000 - 18,000,000 - - 18,495,000 2016 250,000 - 18,000,000 187,156 - 18,437,156 2017 - - 18,000,000 148,837 - 18,148,837 2018 - - 14,420,150 2,736,044 4,525,832 21,682,026 2019 - - 13,905,615 2,607,411 4,494,189 21,007,215 2020 - - 13,372,270 2,467,202 4,472,265 20,311,737 2021 - - 12,815,345 2,315,651 4,441,631 19,572,628 Note: Details regarding the City's outstanding debt can be found in the notes to the financial statements. (a) This ratio is calculated using personal income and population for the prior calendar year.
Source: Notes to the Financial Statements, Long Term Debt Section (b) As a result of the dissolution of the Redevelopment Agency on January 31, 2012 indebtedness was tranferred to the Successor Agency.
Governmental
Activities
129 Page 151 of 173
Water Total Percentage Debt Fiscal
Lease Revenue Primary of Personal Per Year Ended
Bonds Government Income (a)Capita (a)June 30,
12,746,534 31,906,534 1.45% 427.89 2012 11,958,964 30,908,964 1.41% 412.63 2013 11,282,566 30,012,566 1.38% 399.38 2014 10,483,221 28,978,221 1.36% 386.00 2015 9,658,875 28,096,031 1.29% 370.79 2016 8,809,529 26,958,366 1.21% 351.07 2017 8,435,184 30,117,210 1.32% 391.05 2018 8,045,838 29,053,053 1.20% 370.19 2019 7,646,493 27,958,230 1.12% 354.74 2020 7,232,147 26,804,775 0.99% 341.41 2021 Business-type
Activities
130 Page 152 of 173
2020-21 Assessed Valuation:$10,368,713,237
Total Debt City’s Share of
OVERLAPPING TAX AND ASSESSMENT DEBT:6/30/2020 % Applicable (1)Debt 6/30/20 Metropolitan Water District $26,830,000 31.80% $85,319
Chaffey Community College District 315,490,000 8.135 25,665,112 Upland Unified School District 90,918,463 92.714 84,294,144 Chaffey Union High School District 530,528,431 0.798 4,233,617 Alta Loma School District 54,982,209 0.529 290,856
Central School District 71,496,410 1.958 1,399,900
Ontario-Montclair School District 109,165,015 2.693 2,939,814 Upland Unified School District Community Facilities District No. 99-1 1,168,000 100 1,168,000 Upland Unified School District Community Facilities District No. 01-1 1,585,000 100 1,585,000 City of Upland Community Facilities District No. 2003-1 1,185,000 100 1,185,000 City of Upland Community Facilities District No. 2003-2, I.A. Nos. 1 & 2 32,030,000 100 32,030,000 City of Upland Community Facilities District No. 2015-1, I.A. No. 1 9,160,000 100 9,160,000 City of Upland Community Facilities District No. 2016-1, I.A. No. 1 8,185,000 100 8,185,000 City of Upland Community Facilities District No. 2016-1, I.A. No. 2 8,495,000 100 8,495,000 TOTAL OVERLAPPING TAX AND ASSESSMENT DEBT $180,716,762
DIRECT AND OVERLAPPING GENERAL FUND DEBT:
San Bernardino County General Fund Obligations $214,095,000 4.14% $8,867,815 San Bernardino County Pension Obligation Bonds 180,825,585 4.143 7,489,796 San Bernardino County Flood Control District General Fund Obligations 51,360,000 4.143 2,127,331 Chaffey Community College District General Fund Obligations 28,935,000 8.144 2,353,862 City of Upland Equipment Lease Obligations 6,757,282 100 6,757,282 City of Upland Housing Revenue Bonds 12,815,172 100 12,815,172 TOTAL GROSS DIRECT AND OVERLAPPING GENERAL FUND DEBT $40,411,258 Less: City of Upland Housing Revenue Bonds (100% supported from housing related revenues)12,815,172 TOTAL NET DIRECT AND OVERLAPPING GENERAL FUND DEBT $27,596,086 OVERLAPPING TAX INCREMENT DEBT (Successor Agency):$18,475,000 100.00% $18,475,000 TOTAL GROSS DIRECT DEBT $19,572,454
TOTAL NET DIRECT DEBT $6,757,282
TOTAL OVERLAPPING DEBT $213,273,284
GROSS COMBINED TOTAL DEBT $239,603,020 (2)
NET COMBINED TOTAL DEBT $226,787,848
Ratios to 2020-21 Assessed Valuation:
Total Overlapping Tax and Assessment Debt 1.74%
Total Gross Direct Debt ($20,311,914)0.19%
Total Net Direct Debt ($6,939,762)0.07%
Gross Combined Total Debt 2.31%
Net Combined Total Debt 2.19%
Ratios to Redevelopment Successor Agency Incremental Valuation ($1,855,756,042):
Total Overlapping Tax Increment Debt 1.00%
Source: California Municipal Statistics, Inc., Avenu Insights & Analytics (2) Excludes tax and revenue anticipation notes, enterprise JUNE 30, 2021
CITY OF UPLAND
DIRECT AND OVERLAPPING BOND DEBT
(1) The percentage of overlapping debt applicable to the city is estimated using taxable assessed property value. Applicable percentages were estimated by determining the portion of the overlapping district's assessed value that is within the boundaries of the city divided by the district's total taxable assessed value. 131 Page 153 of 173
2011 2012 2013 2014 2015
Debt Limit 895,958,208$ 1,058,579,687$ 1,091,662,967$ 1,152,315,001$ 1,210,072,895$ Total Net Debt Applicable to Limit - - - - - Legal Debt Margin 895,958,208$ 1,058,579,687$ 1,091,662,967$ 1,152,315,001$ 1,210,072,895$ Total Net Debt Applicable to The Limit
As a Percentage of Debt Limit 0.00%0.00%0.00%0.00%0.00% Legal Debt Margin Calculation for Fiscal Year 2019:
Assessed Valuation
Debt Limit (15% of Assessed Value)
Debt Applicable to Limit:
General Obligation Bonds
Legal Debt Margin
Note: The Government Code of the State of California provides for a legal debt limit of 15% of gross assessed valuation.
1 As a result of the dissolution of the Redevelopment Agency on January 31, 2012, total assessed value for the City is no longer reduced by the incremental value of the redevelopment project areas.
CITY OF UPLAND
LEGAL DEBT MARGIN INFORMATION
LAST TEN FISCAL YEARS
Fiscal Year Ended June 30,
132 Page 154 of 173
2016 2017 2018 2019 2021
1,263,218,981$ 1,332,692,325$ 1,405,592,832$ 1,473,057,903$ 1,555,306,986$ 1 - - - - - 1,263,218,981$ 1,332,692,325$ 1,405,592,832$ 1,473,057,903$ 1,555,306,986$
0.00% 0.00% 0.00% 0.00% 0.00%
10,368,713,237$
1,555,306,986
-
1,555,306,986$
Fiscal Year Ended June 30,
133 Page 155 of 173
Water Bonds
Fiscal Water Less: Net
Year Ended Charges Operating Available Debt Service
June 30, and Other Expenses Revenue Principal Interest Coverage 2012 16,873,954 17,468,067 (594,112) 655,000 1,023,096 (0.35) 2013 17,122,606 15,146,422 1,976,184 760,000 407,969 1.69 2014 18,184,342 16,532,719 1,651,623 750,000 463,325 1.36 2015 22,713,561 17,673,638 5,039,923 765,000 442,475 4.17 2016 18,601,416 13,367,187 5,234,229 760,000 419,150 4.44 2017 21,436,735 17,418,778 4,017,957 815,000 361,406 3.42 2018 28,076,336 18,979,818 9,096,518 340,000 340,868 13.36 2019 26,203,575 19,636,043 6,567,532 355,000 327,673 9.62 2020 35,276,713 19,764,310 15,512,403 365,000 313,174 22.87 2021 31,669,481 22,037,035 9,632,446 380,000 336,250 13.45 Note: Water Charges and Other includes total revenues (including investment earnings).
Operating Expenses are exclusive of depreciation.
Source: Finance Division, City of Upland
CITY OF UPLAND
PLEDGED REVENUE COVERAGE
LAST TEN FISCAL YEARS
134 Page 156 of 173
Special Assessment Bonds
Special
Assessment Debt Service
Collections Principal Interest Coverage
3,358,321 440,000 2,525,223 1.13
3,022,803 520,000 2,356,637 1.05
2,935,287 700,000 2,107,620 1.05
2,973,637 820,000 2,080,248 1.03
2,731,961 1,305,000 1,441,090 0.99
2,863,814 1,160,000 1,635,846 1.02
2,822,587 1,250,000 1,598,954 0.99
3,384,728 1,330,000 1,666,350 1.13
3,946,683 1,631,434 1,996,055 1.09
4,093,614 1,640,000 2,200,853 1.07
135 Page 157 of 173
Personal Per
Income Capita
Calendar (in thousands Personal School Unemployment
Year Population of dollars)Income Enrollment Rate
2011 74,568 2,193,940$ 29,422$ 11,927 9.1%
2012 74,907 2,192,004$ 29,263$ 11,908 6.5%
2013 75,147 2,182,720$ 29,046$ 11,665 5.6%
2014 75,074 2,130,600$ 28,380$ 11,380 5.9%
2015 75,774 2,182,404$ 28,801$ 11,138 4.8%
2016 76,790 2,226,460$ 28,994$ 11,028 4.2%
2017 77,017 2,274,591$ 29,533$ 10,913 2.5%
2018 78,481 2,417,412$ 30,802$ 10,702 3.3%
2019 78,814 2,503,598$ 31,765$ 10,580 3.1%
2020 78,513 2,702,987$ 34,427$ 10,228 8.7%
CITY OF UPLAND
DEMOGRAPHIC AND ECONOMIC STATISTICS
LAST TEN CALENDAR YEARS
Sources: HdL, Coren & Cone and the California Department of Education 136 Page 158 of 173
CITY OF UPLAND
PRINCIPAL EMPLOYERS
CURRENT YEAR AND TEN YEARS AGO
2021 2012 *
Percentage of Percentage of
Total City Total City
Employer Employees Rank Employment Employees Rank Employment San Antonio Regional Hospital 2,178 1 5.8% 2,001 1 7.9% Upland Unified School District 1,037 2 2.8% 1,435 2 5.7% Home Depot 350 3 0.9%351 6 1.4% WalMart 315 4 0.8%400 5 1.6%
Lewis Group 313 5 0.8%300 9 1.2% Upland Rehabilitation & Care Center 291 6 0.8% Target 265 7 0.7%250 10 1.0%
City of Upland 258 8 0.7%
Holliday Rock Co. Inc 250 9 0.7%325 8 1.3% VCI Construction 227 10 0.6%
Kohl's Department Store 501 3 2.0%
Insurance Agency Network 500 4 2.0%
Universal Services of America 335 7 1.3%
Totals 5,484 14.6% 6,398 25.2%
*Source: Upland Chamber of Commerce, Finance Division & Development Services 137 Page 159 of 173
Function 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 General government 75.00 75.50 78.25 78.00 64.00 58.00 58.00 57.00 67.00 68.00 Public safety
Police
Officers 76.00 70.00 70.00 70.00 74.00 75.00 75.00 75.00 75.00 75.00 Civilians 28.00 22.50 22.50 22.50 26.00 30.00 31.00 37.00 30.00 31.00 Fire
Firefighters and officers 41.00 41.00 40.00 40.00 40.00 40.00 - - - - 1 Civilians 9.00 9.00 9.00 9.00 9.00 9.00 - - - - 1 Highways and streets
Engineering 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 3.00 Operations 23.00 23.00 23.00 22.00 23.50 23.50 23.50 23.50 23.50 24.50 Recreation 7.50 7.50 7.50 7.50 6.00 6.00 5.00 5.00 5.00 5.00 Water 22.00 24.00 24.00 24.00 24.00 24.00 24.00 27.00 31.00 31.00 Solid Waste Utility - - - - - - - - 1.00 1.00 Environmental Quality 5.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 4.00 Total 289.50 279.50 281.25 280.00 273.50 272.50 223.50 231.50 238.50 242.50 Source: Finance Division, City of Upland
CITY OF UPLAND
FULL-TIME EQUIVALENT CITY GOVERNMENT EMPLOYEES BY FUNCTION
LAST TEN FISCAL YEARS
1 Decrease due to annexation of the Fire Department to San Bernardino County as of July 22, 2017. 138 Page 160 of 173
2012 2013 2014 2015 2016
Function
Fire
Stations 55555
Police
Patrol Units 23 23 23 22 22
Motorcycles 65455
Library
Facilities 11111
Recreation
Buildings 34444
Parks 13 13 13 13 13
Soccer fields (lighted)66666
Baseball fields (lighted)88888
Softball fields (lighted)33333
Public Works
Miles of City Streets 208.90 208.90 208.90 208.90 209.20 Miles of State Highways 6.70 6.70 6.70 6.70 6.70
Miles of City Alleys 37.50 37.50 37.50 37.50 37.50
Water
Miles of Water Mains 240.26 240.26 240.26 240.88 243.70 Sewer
Miles of Sewer Lines 228.00 228.00 228.00 228.00 228.00 Source: Various Departments, City of Upland
CITY OF UPLAND
CAPITAL ASSET STATISTICS BY FUNCTION
LAST TEN FISCAL YEARS
1 Decrease due to annexation of the Fire Department to San Bernardino County as of July 22, 2017. 2 Amount differs from prior year due to a typo (224.08 vs 224.008).
Fiscal Year Ended June 30,
139 Page 161 of 173
2017 2018 2019 2020 2021
511111
22 24 24 25 24
44544
11111
44444
13 13 13 13 13
66666
88888
33333
209.25 209.85
2 210.01 210.01 210.01
6.20 6.20 6.20 6.20 6.20
37.50 37.50 37.50 37.50 37.50
255.60 245.71 247.08 247.08 247.09
222.00 222.00 224.01 224.06 224.06
Fiscal Year Ended June 30,
140 Page 162 of 173
LAST TEN FISCAL YEARS
2012 2013 2014 2015 2016
Function
General government
Building permits issued 1,042 1,120 1,408 2,007 1,176
Police
Physical arrests 3,809 3,104 4,272 3,532 3,013
Traffic collisions 666 634 667 690 814
Fire
Emergency responses 7,300 7,865 9,482 8,855 9,607
Public Works
Miles of street sweeping 14,172 14,484 14,484 13,009 14,600 Potholes repaired 918 831 910 2,400 318
Number of trees pruned 9,235 5,405 5,671 5,015 2,378
Parks and recreation
Community center admissions 8,454 9,093 9,406 9,450 8,868 Library
Volumes in collection 159,746 157,769 117,295 113,146 111,548 Current Periodical & Serial Subscriptions 81 73 340 83 97 Audio-visual items 8,454 7,464 5,911 5,947 5,695
Water
New meter installations 292 550 1,056 981 894
Average daily consumption 21,838 21,087 20,690 17,848 14,209 (thousands of gallons)
Number of linear feet of new water pipelines 17,240 3,859 - 1,531 3,668 Refuse collection
Refuse collected (tons per day)129 130 144 140 158
Recyclables collected (tons per day)72 65 72 64 68
Environmental Quality
Number of sewer inspections conducted 199 207 210 201 208 Number of permitted dischargers/active permits 196 192 194 197 193 Source: Various Departments, City of Upland
1Last date of service for the City of Upland Fire Department was 07/22/2017. 2We transitioned from physical magazines to electronic due to COVID and will continue to keep our holdings el 3Physical DVDs and audiobooks on CD, does not include downloadable films and audiobooks.
CITY OF UPLAND
OPERATING INDICATORS BY FUNCTION
Fiscal Year Ended June 30,
141 Page 163 of 173
2017 2018 2019 2020 2021
1,095 2,040 2,327 1,365 3,126
4,377 3,477 3,670 2,198 2,283
867 724 607 535 350
9,647 404 0 0 0
15,000 10,800 11,600
11,000 14,600
720 550 650
700 3,250
2,273 4,288 5,850
5,200 6,280
6,864 6,703 7,208 4,372 541
107,760 82,577 103,466 73,092 116,755
42 466 40 760 7,002
5,154 4,302 2,916 5,340 5,006
1,233 1,500 153 210 158
15,572 17,276 15,650 15,732 16,027
1,627 18,091 6,581 - 78 151 165 158 162 161
65 76 68 77 82
211 148 145 5 173
195 191 193 193 195
lectronically and not paper copies
Fiscal Year Ended June 30,
142 Page 164 of 173
January 31, 2022
City Council
City of Upland
Upland, CA
We have audited the financial statements of the governmental activities, business-type activities, the aggregate discretely presented component units, each major fund, and the aggregate remaining fund information of the City of Upland for the year ended June 30, 2021. Professional standards require that we provide you with information about our responsibilities under generally accepted auditing standards, Government Auditing Standards, and the Uniform Guidance, as well as certain information related to the planned scope and timing of our audit. We have communicated such information in our letter to you dated June 14, 2021. Professional standards also require that we communicate to you the following information related to our audit.
Significant Audit Findings
Qualitative Aspects of Accounting Practices
Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by the City are described in Note 1 to the financial statements.
No new accounting policies were adopted and the application of existing policies was not changed during the fiscal year. We noted no transactions entered into by the City during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period.
Accounting estimates are an integral part of the financial statements prepared by management and are based on management’s knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected. The most sensitive estimates affecting the financial statements were:
Management’s estimate of the fair value of investments is based on information provided by financial institutions. We evaluated the key factors and assumptions used to develop the fair value of investments in determining that it is reasonable in relation to the financial statements as a whole.
1 Page 165 of 173
Management’s estimate of capital assets depreciation is based on historical estimates of each capitalized item’s useful life. We evaluated key factors and assumptions used to develop the estimated useful lives in determining that they are reasonable in relation to the financial statements as a whole.
Management’s estimate of the net pension and net OPEB liabilities are based on actuarial information provided by the California Public Employee Retirement System’s (CalPERS) actuarial office, and other sources. We evaluated the key factors and assumptions used to develop these liabilities in determining that the estimated liabilities are reasonable in relation to the financial statements as a whole.
Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. The most sensitive disclosure affecting the financial statements were:
The disclosure of the fair value of investments in Note 2 to the financial statements represents amounts susceptible to market fluctuation.
The disclosure of accumulated depreciation in Note 4 to the financial statements is based on estimated useful lives which could differ from actual useful lives of each capitalized item.
The disclosures for the net OPEB and net pension liabilities in Notes 6 and 10 to the financial statements are based on assumptions for discount rates, etc., which could differ from actual experience. The notes disclose the differences in these liabilities if different assumptions are used in estimating these liabilities.
Difficulties Encountered in Performing the Audit
We encountered no significant difficulties in dealing with management in performing and completing our audit.
Corrected and Uncorrected Misstatements
Professional standards require us to accumulate all known and likely misstatements identified during the audit, other than those that are trivial, and communicate them to the appropriate level of management. The following material misstatements detected as a result of audit procedures were corrected by management:
Adjustments were made to accounts payable at year-end.
2 Page 166 of 173
Disagreements with Management
For purposes of this letter, a disagreement with management is a financial accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be significant to the financial statements or the auditor’s report. We are pleased to report that no such disagreements arose during the course of our audit.
Management Representations
We have requested certain representations from management that are included in the management representation letter dated January 31, 2022.
Management Consultations with Other Independent Accountants
In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a “second opinion” on certain situations. If a consultation involves application of an accounting principle to the City’s financial statements or a determination of the type of auditor’s opinion that may be expressed on those statements, our professional standards require the consulting accountant to check with us to determine that the consultant has all the relevant facts. To our knowledge, there were no such consultations with other accountants.
Other Audit Findings or Issues
We generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to retention as the City’s auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our retention.
Other Matters
With respect to the supplementary information accompanying the financial statements, we made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to our audit of the financial statements. We compared and reconciled the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves.
New Accounting Pronouncements
Note 16 to the financial statements describes various accounting pronouncements, which the City will be required to implement in future fiscal years.
3 Page 167 of 173
Restrictions on Use
This information is intended solely for the use of the City Council and management of the City and is not intended to be, and should not be, used by anyone other than these specified parties.
Very truly yours,
4 Page 168 of 173
Independent Auditor’s Report on Internal Control over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance with Government Auditing Standards
City Council
City of Upland
Upland, California
We have audited, in accordance with the auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards issued by the Comptroller General of the United States, the financial statements of the governmental activities, business-type activities, the aggregate discretely presented component units, each major fund and the aggregate remaining fund information of the City of Upland (the “City”), as of and for the year ended June 30, 2021, and the related notes to the financial statements, which collectively comprise the City’s basic financial statements, and have issued our report thereon dated January 31, 2022.
Internal Control Over Financial Reporting
In planning and performing our audit of the financial statements, we considered the City’s internal control over financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the purpose of expressing our opinion on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City’s internal control. Accordingly, we do not express an opinion on the effectiveness of the City’s internal control.
A deficiency in internal control exists when the design or operation of a control does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control, such that there is a reasonable possibility that a material misstatement of the entity’s financial statements will not be prevented, or detected and corrected on a timely basis. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance.
Our consideration of internal control was for the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control that might be material weaknesses or, significant deficiencies. Given these limitations, during our audit we did not identify any deficiencies in internal control that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified.
1 Page 169 of 173
Compliance and Other Matters
As part of obtaining reasonable assurance about whether the City’s financial statements are free from material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards.
Purpose of this Report
The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the City’s internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the City’s internal control and compliance. Accordingly, this communication is not suitable for any other purpose.
January 31, 2022
2 Page 170 of 173
INDEPENDENT ACCOUNTANT’S REPORT ON AGREED-UPON PROCEDURES
APPLIED TO APPROPRIATIONS LIMIT WORKSHEETS
City Council
City of Upland
Upland, California
We have performed procedures enumerated below to be the accompanying Appropriations Limit worksheet of the City of Upland, for the year ended June 30, 2021. These procedures, which were agreed to by the City of Upland and the League of California Cities (as presented in the publication entitled Agreed-upon Procedures Applied to the Appropriations Limitation Prescribed by Article XIIIB of the California Constitution), were performed solely to assist the City in meeting the requirements of Section 1.5 of Article XIIIB of the California Constitution. The City’s management is responsible for the Appropriations Limit worksheet. This agreed-upon procedures engagement was conducted in accordance with attestation standards established by the American Institute of Certified Public Accountants. The sufficiency of the procedures is solely the responsibility of those parties specified in this report. Consequently, we make no representation regarding the sufficiency of the procedures described below either for the purpose for which this report has been requested or for any other purpose.
The procedures performed and our findings were as follows:
1. We obtained the completed worksheets and compared the limit and annual adjustment factors included in those worksheets to the limit and annual adjustment factors that were adopted by resolution of the City Council. We also compared the population and inflation options included in the aforementioned documents to those that were selected by a recorded vote of the City Council.
Finding: No exceptions were noted as a result of our procedures.
2. For the accompanying Appropriations Limit worksheet, we added last year’s limit to total adjustments and agreed the resulting amount to this year’s limit.
Finding: No exceptions were noted as a result of our procedures.
3. We agreed the current year information presented in the accompanying Appropriations Limit worksheet to the other documents referenced in #1 above.
Finding: No exceptions were noted as a result of our procedures.
2 4. We agreed the prior year appropriations limit presented in the accompanying Appropriations Limit worksheet to the prior year appropriations limit adopted by the City Council during the prior year.
Finding: No exceptions were noted as a result of our procedures.
We were not engaged to, and did not, perform an examination, the objective of which would be the expression of an opinion on the accompanying Appropriations Limit worksheet. Accordingly, we do not express such an opinion. Had we performed additional procedures, other matters might have come to our attention that would have been reported to you. No procedures have been performed with respect to the determination of the appropriations limit for the base year, as defined by the League publication entitled Article XIIIB of the California Constitution.
This report is intended solely for the use of the City Council and management of the City of Upland and is not intended to be and should not be used by anyone other than these specified parties. However, this report is a matter of public record and its distribution is not limited.
January 31, 2022
3 CITY OF UPLAND
APPROPRIATIONS LIMIT COMPUTATION
2020 – 2021
2020-21
Change in Per Capita Personal Income 3.73%
Population Change
County Population Growth 0.51%
A. Change in Per Capita Personal Income Converted to a Ratio 1.0373 B. Population Growth Converted to a Ratio 1.0051
Calculation of Growth Factor (A x B) 1.0426
2019 - 2020 Appropriations Limit 109,691,345$
2020 - 2021 Appropriations Limit
($109,691,345 x 1.0426) 114,364,196$