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) Assets Current assets: Cash Investments Receivables (net) Prepaid expenses Inventories Total current assets Capital assets: Land Depreciable assets Accumulated depreciation Total capital assets (net) Total assets Liabilities Accounts payable Deferred revenue Other, current Total current liabilities Bonds payable Total liabilities Net Position Net investment in capital assets Restricted for: Capital projects Debt service Unrestricted (deficit) Total net position 2020 Business Governmental type Activities Activities Total Governmental Activities 2019 Business type Activities Total Governmental Activities 2018 Business type Activities Total $ 13,839 738 $ 1,850 $ 15,689 $ 5,781 $ 5,803 $ 11,584 $ 10,856 $ 5,392 $ 16,248 296 1,034 1,038 2,997 1,814 4,811 3,947 186 1,613 1,224 829 184 1,013 5,560 2,115 1,477 3,592 258 13 271 751 11 762 176 10 186 31 63 94 476 53 529 172 54 226 17,863 4,036 21,899 11,993 7,666 19,659 14,148 7,117 21,265 2,230 2,601 37,850 17,764 4,831 55,614 2,570 1,809 4,379 1,976 1,609 3,585 40,105 17,800 57,905 36,847 15,301 52,148 (17,539) (4,681) (22,220) (17,732) (11,026) (28,758) (20,680) (8,902) (29,582) 22,541 15,684 38,225 24,943 8,583 33,526 18,143 8,008 26,151 40,404 19,720 60,124 36,936 16,249 53,185 32,291 15,125 47,416 1,730 717 2,447 869 381 1,250 1,783 320 2,103 37 37 320 320 107 107 1,759 250 2,009 1,653 195 1,848 1,789 195 1,984 3,526 967 4,493 2,842 576 3,418 3,679 515 4,194 16,400 7,500 23,900 19,400 7,550 26,950 18,400 7,000 25,400 19,926 8,467 28,393 22,242 8,126 30,368 22,079 7,515 29,594 14,748 6,591 21,339 10.665 5,195 15,860 6,021 3,072 9,093 190 938 4,602 190 156 156 135 135 $ 20,478 4,662 $11,253 938 9,264 $ 31,731 1,038 1,038 2,835 2,928 5,763 823 3,233 823 4,538 7,771 $ 14,694 $ 8,123 $ 22,817 $ 10,212 $ 7,610 $ 17,822 Functions/Programs Expenses CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2020 (in thousands) Charges for Services Program Revenues Operating Capital Grants and Grants and Contributions Contributions Governmental Activities General government Governmental Activities: Judicial Public safety $ 5,722 $ 581 $ (5,141) Net (Expense) Revenue and Changes in Net Position Business- type Activities Total $ (5,141) 1,931 966 $ 7,963 1,780 104 418 (861) (861) (5,765) (5,765) Health and sanitation 2,829 574 (2,255) (2,255) Culture and recreation 2,416 559 $ 745 (1,112) (1,112) Road maintenance 2,480 55 1,869 (556) (556) Interest on long-term debt 953 (953) (953) Total governmental activities 24,294 Business-type activities 3,145 4,515 6,218 2,391 745 57 (16,643) (16,643) Total government $27,439 $10,733 $ 2,391 $ 802 $(16,643) $ 3,130 $ 3,130 3,130 $(13,513) General Revenues: Property taxes Grants and contributions not restricted to specific programs Investment earnings Special item-gain on sale of land Total general revenues and special items Change in net position Net position-January 1 Net position-December 31 18,046 18,046 2,815 2,815 1.216 1,216 350 22,427 5,784 14,694 350 22,427 $ 20,478 3,130 8,123 $11,253 22,817 $ 31,731 8,914 CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2019 (in thousands) Functions/Programs Expenses Charges for Services Program Revenues Operating Capital Grants and Grants and Contributions Contributions Governmental Activities: General government $ 4,158 $ 153 Judicial Public safety 1,742 5,244 214 1,948 $ 167 130 Health and sanitation 2,229 152 Culture and recreation 4,262 332 $ 355 Road maintenance 1,305 626 Interest on long-term debt 1,179 Total governmental activities 20,119 2,799 923 355 Business-type activities 4,292 4,790 Total government $24,411 $7,589 $ 923 $ 370 S| |5|| Governmental Activities $ (4,005) (1,361) (3,166) (2,077) (3,575) Net (Expense) Revenue and Changes in Net Position Business- type Activities Total $ (4,005) (1,361) (3,166) (2,077) (3,575) (679) (1,179) (16,042) (679) (1,179) (16,042) 15 $ (16,042) $ 513 $ 513 513 $(15,529) General Revenues: Property taxes Grants and contributions not restricted to specific programs Investment earnings Special item-gain on sale of land Total general revenues and special items Change in net position Net position-January 1 Net position-December 31 14,619 14,619 4,039 4,039 1,166 1,166 700 700 20,524 20,524 4,482 10,212 $ 14,694 513 7,610 $8,123 4,995 17,822 $ 22,817 Functions/Programs Expenses CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2018 (in thousands) Charges for Services Program Revenues Operating Grants and Contributions Contributions Capital Grants and Governmental Activities Net (Expense) Revenue and Changes in Net Position Business- type Activities Total Governmental Activities: General government Judicial Public safety Health and sanitation $ 4,047 $ 114 2,001 208 $ 4,363 1,728 2,721 466 Culture and recreation 3,709 539 Road maintenance 1,613 470 Interest on long-term debt 1,198 Total governmental activities 19,652 3,055 547 g| |+8| $ (3,933) $ (3,933) (1,731) (1,731) (2,620) (2,620) (2,255) (2,255) $ 620 (2,550) (2,550) (1,143) (1,143) (1,198) (1,198) Business-type activities 2,887 3,833 620 25 (15,430) (15,430) $ 971 Total government $22,539 $6,888 $ 547 $ 645 $ (15,430) $ 971 971 $(14,459) Additional information follows: General Revenues: Property taxes Grants and contributions not restricted to specific programs Investment earnings Special item-gain on sale of land Total general revenues and special items Change in net position Net position-January 1 Net position-December 31 13,600 13,600 3,040 3,040 756 756 525 525 17,921 17,921 2,491 7,721 971 6,639 3,462 14,360 $ 10,212 $7,610 $ 17,822 Population: Year 2020: 30,450, Year 2019: 28,321, Year 2018: 26,404. Debt limit remained at $20,150,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. Capital asset condition 3. Debt to assets 4. Current ratio 5. Quick ratio 6. Change in net position 7. Interperiod equity 8. BTA self-sufficiency 9. Revenue dispersion 10. Bonded debt per capita 11. Available legal debt limit 12 Property taxes per capita b. Calculate those ratios identified in part a for FY 2020. 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.) 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 Choose Numerator Choose Numerator Choose Numerator Choose Numerator Choose Numerator Change in Net Positon 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 2020 2019 2018 Choose Numerator Choose Numerator Choose Numerator Choose Numerator Choose Numerator Choose Numerator + + + + + + + + Unrestricted Net Position Choose Denominator Governmental Activities = = = Business-Type Activities Unrestricted Net Position. % % % = % % = % Capital Asset Condition Choose Denominator = Capital Asset Condition Governmental Activities = % % = % Business-Type Activities = % = % = % Debt to Assets Choose Denominator = Debt to Assets Governmental Activities Business-Type Activities = = = % % % = % % = % Current Ratio Choose Denominator =Current Ratio Governmental Activities + Business-Type Activities + + + + + + + + + + + + + + + + + + + + = = times times times = times = times = times Quick Ratio Choose Denominator = Quick Ratio Governmental Activities = = = Business-Type Activities Interperiod Equity Choose Denominator times times times = times = times = times Interperiod Equity = times times = times BTA Self-Sufficiency Choose Denominator =BTA self-sufficiency = times times times Revenue Dispersion Choose Denominator Bonded Debt per Capita Choose Denominator Available Legal Debt Limit Choose Denominator =Revenue Dispersion % = % = % = Bonded Debt per Capita =Available Legal Debt Limit = % = % = % Property Taxes per Capita Choose Denominator = Property Taxes per Capita www measu = =