Required information The governmentwide financial statements for the City of Arborland for a three-year period are presented. CITY OF mom Statements of Net Position As of December 31 (in thousands) 2023 2022 2021 Business Business Business Governmental -type Governmental -tvpe Governmental -type Activities Activities Total Activities Activities Total Activities Activities Total Assets Current assets: Cash S 8,898 5 1,820 S 10,718 S 5,031 S 3,319 $ 8,350 5 6,413 S 3,049 S 9,462 Investments 735 293 1,028 798 183 981 793 181 974 Receivables (net) 2,847 1,811 4,658 3,347 1,510 4,957 1,955 1,474 3,439 Prepaid expenses 255 10 265 451 8 459 173 7 180 Inventories 28 60 88 251 50 301 169 51 220 Total current assets 12,763 3,994 16,757 9,878 5,170 15,048 9,513 4,762 14,275 Capital assets: Land 2,200 2,301 4,501 2,270 1,806 4,076 1,973 1,606 3,579 Depreciable assets 37,700 14,518 52,218 38,326 17,785 56,111 38,347 15,001 53,348 Accumulated depreciation (16,039) (4,081) (20,120) (17,432) (10,276) (27,708) (20,080) (8,002) (28,082) Total Capital assets (net) 23,861 12,738 36,599 23,164 9,315 32,479 20,240 8,605 28,845 Total assets 36,624 16,732 53,356 33,042 14,485 47,527 29,753 13,367 43,120 Liabilities Accounts payable 1,680 567 2,247 569 378 947 1,693 305 1,998 Deferred revenue 34 34 170 170 68 68 other, current 1,756 220 1,976 1,503 192 1,695 1,609 180 1,789 Total current liabilities 3,470 787 4,257 2,242 570 2,812 3,370 485 3,855 Bonds payable 16,100 6,900 23,000 17,600 7,520 25,120 16,900 6,700 23,600 Total liabilities 19,570 7,687 27,257 19,842 8,090 27,932 20,270 7,185 27,455 Net Position Net investment in capital assets 11,360 3,792 15,152 9,033 3,917 12,950 5,628 2,469 8,097 Restricted for: Capital projects 160 160 153 153 132 132 Debt service 935 935 1,035 1,035 820 820 Unrestricted (deficit) 4,599 5,253 9,852 2,979 2,478 5,457 2,903 3,713 6,616 Total net position S 17,054 $ 9,045 S 26,099 $ 13,200 S 6,395 5 19,595 5 9,483 $ 6,182 $ 15,665 i CITY OF ARBORLAN'D Funct ions I Programs Governmental Activities: General government Judicial Public safety Health and sanitation Culture and recreation Road maintenance Interest on longterm debt Total governmental activities Businesstype activities Total government CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2023 (in thousands) Program Revenues Net (Expense) Revenue and Changes in Net Position Charges Operating Capital Business for Grants and Grants and Governmental type Expenses Services Contributions Contributions Activities Activities Total $ 5,720 $ 551 $ (5,169) $ (5,169) 1,928 816 $ 101 (1,011) (1,011) 7,960 1,630 268 (6,062) (6,062) 2,814 544 (2,270) (2,270) 2,266 556 $ 595 (1,115) (1,115) 2,465 25 1,719 (721) (721) 950 (950) (950) 24,103 4,122 2,088 595 (17,298) (17,298) 2,995 5,618 27 $2,650 2,650 $27,098 $9,740 $ 2,088 5 622 $(17,298) $2,650 $(14,648) General Revenues: Property taxes 17,596 17,596 Grants and contributions not restricted to specific programs 2,440 2,440 Investment earnings 916 916 Special itemgain on sale of land 200 200 Total general revenues and special items 21,152 21,152 Change in net position 3,854 2,650 6,504 Net positionJanuary 1 13,200 6,395 19,595 Net positionDecember 31 5 17,054 $9,045 $ 26,099 \\ Functions/Programs Governmental Activities: General government Judicial Public safety Health and sanitation Culture and recreation Road maintenance Interest on longterm debt Total governmental activities Businesstype activities Total government C ITY OF ARBORLAND Statement of Activities For the Year Ended December 31, (in thousands) Program Revenues 2022 Net (Expense) Revenue and changes in Net Position Charges Operating Capital Business for Grants and Grants and Governmental type Expenses Services Contributions Contributions Activities Activities Total $ 4,143 $ 150 $ (3,993) $ (3,993) 1,739 211 S 77 (1,451) (1,451) 5,241 1,945 70 (3,226) (3,226) 2,169 149 (2,020) (2,020) 3,962 326 352 (3,284) (3,284) 1,155 551 (604) (604) 954 (954) (954) 19,363 2,781 599 352 (15,532) (15,532) 4,289 4,490 12 $ 213 213 $23,652 $7,271 S 695 364 $(15,532) $ 213 $(15,319) General Revenues: Property taxes 14,019 14,019 Grants and contributions not restricted to specific programs 3,614 3,814 Investment earnings 1,016 1,016 Special itemgain on sale of land 400 400 Total general revenues and special items 19,249 19,249 Change in net position 3,717 213 3,930 Net positionJanuary 1 9,483 6,182 15,665 Net positionDecember 31 5 13,200 $6,395 $ 19,595 r Functions/Programs Governmental Activities: General government Judicial Public safety Health and sanitation Culture and recreation Road maintenance Interest on longterm debt Total governmental activities Businesstype activities Total government Additional information follows: Population: Year 2023: 30,440, Year 2022: 28,311, Year 2021: 26,394. Debt limit remained at $20,100,000 for each of the CITY OF ARBORLAN'D Statement of Activities For the Year Ended December 31, 202]. (in thousands) Program Revenues Net (lxpense) Revenue and changes in Net Position three years. Net cash from operations is generally 80 percent of total revenues each year. Required b. Calculate those ratios identified in part a for FY 2023. Show your computations. (Round your answers to the nearest whole dollar amount. Enter your answer in thousands except for Bonded debt per Capita. Available Legal Debt Limit. and Property Taxes per Capita whose values should be entered in dollars and not in thousands. Use ending values if the averages are not available. Use Property tax revenues instead of Property tax levy in your computation.) Charges Operating Capital Business- for Grants and Grants and Governmental type Expenses Services Contributions Contributions Activities Activities Total $ 3,972 5 111 $ (3,861) $ (3,861) 1,761 202 s 59 (1,500) (1,500) 4,213 1,725 12 (2,476) (2,476) 2,346 316 (2,030) (2,030) 3,574 434 $ 440 (2,700) (2,700) 1,506 464 (1,044) (1,044) 1,048 (1,048) (1,048) 18,422 2,788 535 440 (14,659) (14,659) 2,737 3,758 22 $1,043 1,043 $21,159 $6,546 $ 535 $ 462 $(14,659) $1,043 $(13,616) General Revenues: Property taxes 13,300 13,300 Grants and contributions not restricted to specific programs 3,010 3,010 Investment earnings 711 711 Special itemgain on sale of land 300 300 Total general revenues and special items 17,321 17,321 Change in net position 2,662 1,043 3,705 Net positionJanuary 1 6,821 5,139 11,960 Net positionDecember 31 $ 9,433 $51132 $ 151655 '_ Legal Debt Limit + General Bonded Debt Debt to Assets Current Assets Current Liabilities Current Ratio Change in Net Position Ratio Choose Numerator Choose Denominator Change in Net Position V + Total Beginning Net Position V Change in Net Position Ratio 2023 6,504 EA 19,595 E 33 % 2022 $ 3,930 + $ 15,665 E 25 2021 $ 3,705 $ 11,960 = 31 % Interperiod Equity Choose Numerator Choose Denominator Net Revenues Total Expenses Interperiod Equity 2023 $ (17,298) X + $ 24, 103 = (0.72) times 2022 (15,532) X 19,363 = (0.80) times 2021 $ (14,659) X + $ 18,422 (0.80) times BTA Self-Sufficiency Choose Numerator Choose Denominator BTA Service Charge Revenues BTA Total Expenses V E BTA self-sufficiency 2023 5,618 $ 2,995 = 1.88 times 2022 $ 4,490 + $ 4,289 E 1.05 times 2021 $ 3,758 + $ 2,737 = 1.37 times Capital Asset Condition Choose Numerator Choose Denominator Accumulated Depreciation V Average Cost of Depreciable Capital Assets V E Capital Asset Condition Governmental Activities 2023 = NaN 2022 = NaN % 2021 NaN %2023 NEW % 2022 NaN % 2021 NEW % General Bonded Debt Population Bonded Debt per Capita 2023 15,100,000 9 + 30,440 0 523.91 2022 17,600,000 9 + 28.3110 521.57 15,900,000 0 = 540.30 General Bonded Debt 0 = Legal Debt Limit 0 Available Legal Debt Limit 2023 15,100,000 0 : 20,100,000 0 30.1 % 2022 17,600,000 0 : 20,100,000 9 87.6 % 2021 15,900,000 9 : 20,100,000 9 34.1 % Property Tax Levy 0 + Population 9 Property Taxes per Capita 2023 $ 17,595,000 0 + 30,440 0 $ 573.05 2022 $ 14,019,000 0 + 23,3110 $ 495.13 2021 $ 13,300,000 9 + 25,394 9 $ 503.90