Required information The government-wide financial statements for the City of Arborland for a three-year period are presented. CITY OF ARBORLAND Statements of Net Position As of December 31 (in thousands) 2023 Business Governmental -type Activities Activities 2022 Total Business Governmental -type Activities Activities Total Governmental Activities Activitie 2021 Busines -type Land Assets Current assets: Cash Investments Receivables (net) Prepaid expenses Inventories Total current assets Capital assets: Depreciable assets $ 17,149 $1,870 $ 19,019 $ 6,281 $ 7,459 $13,740 $13,818 740 298 1,038 1,198 188 1,386 853 $ 6,954 186 3,097 1,816 4,913 4,347 1,615 5,962 2,215 260 33 15 275 951 13 964 178 1,470 12 65 98 626 55 681 174 56 21,279 4,064 25,343 13,403 9,306 22,733 17,238 8,667 2,250 2,801 5,051 2,770 1,011 4,581 1,978 1,611 37,950 19,928 57,878 41,291 17,810 Accumulated depreciation (18,539) (5,081) (23,620) (17,932) 59,101 (11,526) (29,458) 35,847 15,501 (21,000) (19,502 Total capital assets (net) 21,661 17,648 39,309 26,129 8,095 34,224 16,745 7,610 Total assets. 42,9401 21,712 Liabilities 64,652 39,532 17,425 56,957 33.983 16,297 Accounts payable 1,780 817 2,597 1,069) 383 1,452 Deferred revenue 1,843 338 39 39 420 420 133 Other, current 1,761 270 2,031 1,753 197 1,950 1,909 205 Total current liabilities 3,580) 1,087 4,667 3,242 580 3,822 3,885 535 Bonds payable 16,600 7,908 24,500 20,600 7,570 28,170 19,400 7,200 Total Liabilities 20,180 8,987 29,167 23,842 8,150 31,992 23,285 7,735 Net Position Net investment in capital assets 17,006 8,457 25,463 11,753 6,047 17,800 6,283 3,474 Restricted for: Capital projects 210 210 158 158 137 Debt service 940 940 1,040 Unrestricted (deficit) 4,604 4,268 8,872 2,739 3,228 1,040 5,967 825 3,453 5,088 Total net position $22,768 $12,725 $ 35,485 $ 15,690 $9,275 $ 24,965 $ 10,698 58,567 < Prev 23 of 5 Next > MacBook Pro CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2023 (in thousands) Program Revenues Charges for Operating Grants and Capital Grants and Net (Expense) Revenue and Changes in Net Position Governmental Business- type Functions/Programs Governmental Activities: General government Judicial Public safety Health and sanitation. Expenses Services Contributions Contributions Activities Activities Total $ 5,724 $ 601 $ (5,123) $ (5,123) 1,933 1,066 $ 106 (761) (761) 7,965 1,880 518 (5,567) (5,567) 2,839 594 (2,245) (2,245) Culture and recreation 2,516 561 $ 845 (1,110) (1,110) Road maintenance 2,490 75 1,969 (446) (446) Interest on long-term debt 955 (955) Total governmental activities 24,422 Business-type activities 3,245 4,777 6.618 2,593 845 (16,207) (955) (16,207) 77 Total government $27,667 $11,395 $2,593 $922 $(16,207) $ 3,450 $3,458 3,450 $(12,757) General Revenues: Property taxes 18,346 18,346 Grants and contributions not restricted to specific programs 3,065 3,065 Investment earnings 1,416 Special item-gain on sale of land. 450 1,416 450 Total general revenues and special items 23,277 Change in net position. 7,070 3,450 Net position-January 11 15,690 Net position-December 31 $22,760 9,275 $12,725 23,277 10,520 24,965 $ 35,485 CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2022 (in thousands) Charges for Program Revenues Operating Grants and Net (Expense) Revenue and Changes in Net Position Capital Grants and Governmental Functions/Programs Expenses Services Contributions Contributions Activities Business- type Activities Total Governmental Activities: Judicial General government Public safety Health and sanitation $ 4,168 $ 155 $ (4,013) $ (4,013) 1,744 216 5,246 1,950 $ 227 170 (1,301) (1,301) (3,126) (3,126) 2,269 154 (2,115) Culture and recreation (2,115) 4,462 336 $357 (3,769) (3,769) Road maintenance 1,405 676 (729) Interest on long-term debt 1,329 Total governmental activities 20,623 2,811 1,073 357 (1,329) (16,382) Business-type activities (729) (1,329) (16,382) 4,294 4,990 17 Total government $24,917 $7,801 $1,073 $ 374 $(16,382) $713 $713 713 $(15,669) General Revenues: Property taxes 15,019 15,019 Grants and contributions not restricted to specific programs 4,189 Investment earnings 1,266 4,189 1,266 Special item-gain on sale of land 900 900 Total general revenues and special items 21,374 21,374 Change in net position Net position-January 11 Net position-December 311 4,992 10,698 $ 15,690 713 8,562 $9,275 5,705 19,260 $24,965 Culture and recreation Functions/Programs: Governmental Activities: General government Judicial Public safety Health and sanitation CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2021 (in thousands) Charges for Expenses Services Contributions Contributions Program Revenues Operating Grants and Capital Grants and Net (Expense) Revenue and Changes in Net Position Business- Governmental Activities type Activities Total $4,097 $ 116 $ (3,981) $ (3,981) 2,161 212 $ 64 (1,885) (1,885) 4,463 1,730 17 (2,716) (2,716) 2,971 566 (2,405) (2,405) 3,799 609 $740 Road maintenance (2,450) (2,450) 1,683 474 (1,209) Interest on long-term debt (1,209) 1,298 (1,298) Total governmental activities (1,298) 20,472 3,233 555 740 Business-type activities Total government (15,944) (15,944) 2,987 3,883 27 $ 923 923 $23,459 $7,116 $ 555 $ 767 $(15,944) $ 923 $(15,021) Addis General Revenues: Property taxes Grants and contributions not restricted to specific programs Investment earnings Special iten-gain on sale of land 13,800 13,800 3,060 3,060 786 786 675 675 Total general revenues and special itens 18,321 18,321 Change in net position 2,377 923 Net position-January 11 8,321 7,639 3,300 15,960 Net position-December 31 $10,698 $8,562 $ 19,260 Additional information follows: Population: Year 2023: 30,460, Year 2022: 28,331, Year 2021: 26,414. Debt limit remained at $20,200,000 for each of the three years. Net cash from operations is generally 80 percent of total revenues each year. Required a. Select X for the financial performance measures in Illustration 10-4 that can be calculated for the City of Arborland based on the information provided. Performance Measures 1. Unrestricted net position 2. Debt ratio 3. Current ratio 4. Change in net position 5. Interperiod equity 6. Business-type activities self-sufficiency 7. Capital asset condition 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.) Unrestricted Net Position 2023 2022 2021 2023 2022 2021 2023 Choose Numerator Choose Denominator Unrestricted Net Position Governmental Activities NaN % NaN% NaN% Business-Type Activities Choose Numerator: Debt ratio Choose Denominator Debt to Assets Governmental Activities < Prev 9 3 im NaN% NaN% NaN% NaN% of 5 Next > 2023 2022 2021 Required information 2023 2022 2021 2023 2022 2021 2023 2022 2021 Debt ratio Choose Numerator Choose Denominator. Debt to Assets Governmental Activities NaN % NaN% NaN% Business-Type Activities Current Ratio Choose Numerator Choose Denominator Current Ratio Governmental Activities Business-Type Activities Change in Net Position Ratio: Choose Numerator Choose Denominator < Prev 3 of 5 Next NaN % NaN% NaN% NaN times NaN times NaN times NaN times NaN times NaN times Required information 2023 2022 2021 2023 2022 2021 2023 2022 2021 Dana Choose Numerator Change in Net Position Ratio Choose Denominator = Change in Net Position Ratio NaN% NaN% NaN% Choose Numerator Interperiod Equity Choose Denominator Interperiod Equity NaN times NaN times NaN times Choose Numerator + BTA Self-Sufficiency Choose Denominator BTA self-sufficiency NaN times NaN times NaN times Capital Asset Condition Choose Numerator Choose Denominator Governmental Activities Capital Asset Condition < Prev 3 of 5 Next > NaN 2023 2022 2021 2023 2022 2021 Required information 2023 2022 2021 2023 2022 2021 Governmental Activities NaN% NaN % NaN % Business-Type Activities NaN% NaN% NaN % Bonded Debt per Capita Choose Numerator Choose Denominator: Bonded Debt per Capita NaN NaN NaN Available Legal Debt Limit Choose Numerator Choose Denominator Available Legal Debt Limit NaN% NaN% NaN% Property Taxes per Capital Choose Numerator Choose Denominator Property Taxes per Capita 9 < Prev 3 of 5 Next > 2023 2022 2021 2023 2022 2021 2023 2022 2021 Bonded Debt per Capita Choose Numerator Choose Denominator Bonded Debt per Capita NaN NaN NaN Choose Numerator Available Legal Debt Limit Choose Denominator Available Legal Debt Limit NaN% NaN% NaN% Choose Numerator + Property Taxes per Capita Choose Denominator Property Taxes per Capita NaN NaN NaN