3 PM Required information The government wide financial statements for the City of Arborland for a three-year period are presented CITY OF ANBORLAND Statements of Net Position As of December 31 (in thousands) 7923 Business Governmental Activities -type Activities 2003 Business Govermental type Activities Activities Total Assets Current assets Cash Investments $ 30,354 $14,00 248 11,94 306 1,834 $8,201 1.43 3,417 5,947 216 23 1,751 41 73 3,336 34 AN 2,310 38,314 (37,339) 37.341 1949 3,001 28,544 (5.481) 3,570 44,00 (15.280 45.34 1,000 3,000 47 820 1.249 2.49 3,796 4,64 17,499 21.11 21,26 290 Receivables (0) Prepaid expenses Inventories total current assets Capital assets Land depreciable assets Accumulated depreciation Total capital assets (net) fatal assets Liabilities Accounts payable Deferred reven Other re Total current abilities Bonds payable Total liabilities Net Position Netvestment in capital assets Restricted for Capital projects Det service Unrestricted (deficit) Total not position to search O 119 200 #114,71 WASC ii D 25.000 1,217 ne 1,547 5.500 12,911 HE'RE S TOP5 1,054 3,111 201 114 PEME 5,90 66,934 (29.220) SPMO 440 3,137 47 2.119 5,303 25.909 3.301 9,0 11.09 $1, $18.403 CITY OF ARBORLAND Statement of Activities for the Year Ended Deceber 31, 201 (hand) e 290 905 ZOW POSLE 13.345 15,195 146 3,00 WAACH 164 Total 112,364 196 1,421 -2,034 7,570 1,792 1,700 193 BAND 3,109 13,00 (33.294) 245 3.200 810 ==== 200 ICKE seker 194 204 9,455 EXOD 1813 1 HEAVE 3,41 35,000 24,500 204 1,04 CATE $31,557 Governwentat Activities 121,004 949 2,415 186 182 2550 100 11,40 LIKO 31.351 40,351 2,093 237 4,709 23.400 24,000 7,301 145 A13 VE HELP $12.00 2821 Busines type Activities $43,20 IM 1,49 24 Total $3,0 1,141 4,30 200 44 246 44,500 3,429 1,00 16,31 49,140 (AME) (14.3822 50101747 4 375 379 241 2,453 237 1,434 3.324 35,00 NAJLE 12,411 145 833 119 1.00 5,002 2/20 $13,39 $25,4 17-11 74F Cloudy Ques 1 M of 1 a /Brittany%20Jones/OneDrive/Desktop/Question%2018%20-%20Homework%209-10%20-%20Connect.pdf Q E A Q CITY OF ARORLAND Statement of Activities For the Year Ended beceber 31, 2023 Program Reven Operating Net (Expense) Rend Changes in het Position Finess Expenses for Grants and Services Contributions Capital Grants and Governmental Type ributions Activities 15,712 Activities Total $(5,5) 1,541 1114 (3,1) (M) 7,973 918 (4,775) 2,879 2,916 $1,245 (2) (1,380) (141) 1,641 7,309 ME 3,41 3310 192 $28,714 114,043 11,002 General Reven Property tax Grants and contributions et restricted to specific program Investment vari Special (te-gain on sale of land fotal general revenues and special i Change is fet position Net position January Net position CITY OF ARBORLAND Statement of activiti for the Year Ended December 11, 2012 (thousands) Program Rev Changes Charges Capital Operating Grants and for Grand Several Services Contributions Contributions Activities $ 163 (4,0) $4,200 1,72 5.254 $ 3,958 2,42 162 (4,03 (29) (2,367) (4) (29) 1,300 32 1.005 878 3,939 21,430 4.ME $24,941 11,401 1:3 General even Property taxe Grants and contributions not restricted to specific programs Investment revenues and special Spain sale of las Total general Change position et position-January 1 net position december 11 Functions/Program Svetal Activities: General govern Judicial Palle safety Health and sanitation Culture and recreation Foad satenance Interest on long-tere dest Total governmental activities Business-type activities Total government Functions/Program Several Activition) General goverment Ja Polic safety Health and sanitation Oltare and recreatio Radiance Interest on long-tere dett Tal vental activities Pustis-type activities CATE SPEC In 1 1,004 2,200 ATA 149 115 STA'S 224 3,41 3.000 13,649 SPITE TOST (34,198) $(1,1) 1,5 4,05 2,21 154 16,59 11,09 1544 111, TRVO BCA, MA 14,410 4,799 1,444 3.99 24N2 www 37,499 NY'S S WAYS $4,7 4 QIPTF $LID ATM 11,900 338,433 (Ex) and et Position APPEE Type Activities A X 137.229 $13, (1))) (4,715) (2,205) (1,000) (17) (63 14,31 1 (1,8) 19,144 4,465 3,116 me 24.472 11,37 30.106 (909) (1) (2,4) (2,30) (****) (329) (0,20) (32,341) A00 (172) 14,400 4,700 1,0 w CTICE 4,54 25,411 10.10 fo B 942 1 File C/Users/Brittany%20Jones/OneDrive/Desktop/Question%2016%20-%20Homework%209-10a%20-%20Connect.pdf Q +En A V AL MARLE Net position December 31 $ 19,674 $13,843 $ 33,557 CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2021 (in thousands) Net (Expense) Revenue and Program Revenues Operating Capital Changes in Net Position Business- type Activities Grants and Functions/Prograss Governmental Activities: Grants and Contributions Contributions Governmental Activities Expenses General government Judicial $ 4,297 $ (4,173) 2,01 $ 72 4 Public safety Health and sanitation 4,863 (2,501) (3,100) 3,971 (3,005) CI Culture and recreation Road maintenance 4,159 $1,220 1,941 490 4 1,654 (2,054) (1,473) (159) (18,000) 23,752 Interest on long-tere debt Tatal governmental activities Business-type activities Total government 587 1,220 3,387 35 $27,139 $547 $1,255 $18,000) General Revenue Property taxes 14,600 Grants and contributions not restricted to s specific programs 3,140 Investment earnings 906 Special item-gain on sale of land 1,275 Total general revenues and special items Change in net position 1,921 731 Net position-January 1 10,721 11,439 Net position-December 31 $12,642 $12,370 Additional information follows: Population Year 2023 30,500, Year 2022: 28,371, Year 2021 25,454. Debt limit remained at $20,400,000 for each of the three years. Net cash from operations is generally B0 percent of total revenues each year. tev 11 15 2021 Oc CS-285282 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) B . O Charges for Services $ 124 228 1,738 966 889 3,945 4,001 58,028 $ 711 $ 731 1 H @ Total $ (4,179) (2,501) (),100) (3,005) (2,050) (1,473) (1,000) (58,000) 731 $(17,360) 54,400 3,140 906 1,375 19891 2,652 23AXO $ 25,012 74F Cloudy 16 89 -0 @ 951 PM omework 9-10 18 Part 2 of 2 2.26 point d Mc Gran Choose Numerator Accumulated Depreciation Choo Nuneate Choose Nuntator Thoaks Numa 2023 2022 (2021 2023 (2322 12021 2023 2002 2021 General Bonded Debt General Borded Debt 2023 2922 avot (2023 (2.22 Property Tax Levy 2021 Capital Asset odten Choose Uroondeat Average Cost of Deprecuble Capil Asse Business Type Active Bonded Dele pe Capta Choose Desonator Aendable Legal Debt Line Choose Determinator Piperty lampa Population Legal Debt Lind Pepolation 27 broupMe Chouse Dermato Lloge C Chege Chegg Libra Ofescape Free PLN Sied Capital Aer Condo MI Bunded Debt per Capta Praliable Legal De Property Taxa per Capita NaN NaN NaN NaN% NaN% NAN NaN NAN NIN NaN% NaN% NaN% NaN NAN NaN D Current Assets 2023 2022 2021 2023 2022 2021 2023 2022 2021 Choose Numerator Choose Numerator Choose Numerator Change in Net Position 2023 2022 2021 Net Revenues (ISUA Login Current Ratio Choose Denominator Governmental Activities Business-Type Activities Change in Net Position Ratio Choose Denominator Current Liabilities Total Beginning Net Position Interperiod Equity Choose Denominator ISTA Self-Sufficiency GroupMe Total Expenses Log In C Chegg: Chegg Libra... Savod Current Ratio Change in Net Position Ratio Interperiod Equity NaN times NaN times NaN times NaN times NaN times NaN times NaN% NaN% NaN% NaN times NaN times NaN tinses PDFescape-Fr da Financial Se... M: Unrestricted Net Position / 2023 2022 2021 2023 2022 2021 Choose Numerator 2023 2022 2021 2023 2022 2021 Choose Numerator Choone Numerator Total Liables Unrestricted Net Position Choose Denominator Governmental Activities Business-Type Activities Debt ratio Choose Denominator: Governmental Activities Business-Type Activities Current Ratio Choose Banc Total Revenue Total Assets Saved Unrestricted Net Position Debt to Assets NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% 3 PM Required information The government wide financial statements for the City of Arborland for a three-year period are presented CITY OF ANBORLAND Statements of Net Position As of December 31 (in thousands) 7923 Business Governmental Activities -type Activities 2003 Business Govermental type Activities Activities Total Assets Current assets Cash Investments $ 30,354 $14,00 248 11,94 306 1,834 $8,201 1.43 3,417 5,947 216 23 1,751 41 73 3,336 34 AN 2,310 38,314 (37,339) 37.341 1949 3,001 28,544 (5.481) 3,570 44,00 (15.280 45.34 1,000 3,000 47 820 1.249 2.49 3,796 4,64 17,499 21.11 21,26 290 Receivables (0) Prepaid expenses Inventories total current assets Capital assets Land depreciable assets Accumulated depreciation Total capital assets (net) fatal assets Liabilities Accounts payable Deferred reven Other re Total current abilities Bonds payable Total liabilities Net Position Netvestment in capital assets Restricted for Capital projects Det service Unrestricted (deficit) Total not position to search O 119 200 #114,71 WASC ii D 25.000 1,217 ne 1,547 5.500 12,911 HE'RE S TOP5 1,054 3,111 201 114 PEME 5,90 66,934 (29.220) SPMO 440 3,137 47 2.119 5,303 25.909 3.301 9,0 11.09 $1, $18.403 CITY OF ARBORLAND Statement of Activities for the Year Ended Deceber 31, 201 (hand) e 290 905 ZOW POSLE 13.345 15,195 146 3,00 WAACH 164 Total 112,364 196 1,421 -2,034 7,570 1,792 1,700 193 BAND 3,109 13,00 (33.294) 245 3.200 810 ==== 200 ICKE seker 194 204 9,455 EXOD 1813 1 HEAVE 3,41 35,000 24,500 204 1,04 CATE $31,557 Governwentat Activities 121,004 949 2,415 186 182 2550 100 11,40 LIKO 31.351 40,351 2,093 237 4,709 23.400 24,000 7,301 145 A13 VE HELP $12.00 2821 Busines type Activities $43,20 IM 1,49 24 Total $3,0 1,141 4,30 200 44 246 44,500 3,429 1,00 16,31 49,140 (AME) (14.3822 50101747 4 375 379 241 2,453 237 1,434 3.324 35,00 NAJLE 12,411 145 833 119 1.00 5,002 2/20 $13,39 $25,4 17-11 74F Cloudy Ques 1 M of 1 a /Brittany%20Jones/OneDrive/Desktop/Question%2018%20-%20Homework%209-10%20-%20Connect.pdf Q E A Q CITY OF ARORLAND Statement of Activities For the Year Ended beceber 31, 2023 Program Reven Operating Net (Expense) Rend Changes in het Position Finess Expenses for Grants and Services Contributions Capital Grants and Governmental Type ributions Activities 15,712 Activities Total $(5,5) 1,541 1114 (3,1) (M) 7,973 918 (4,775) 2,879 2,916 $1,245 (2) (1,380) (141) 1,641 7,309 ME 3,41 3310 192 $28,714 114,043 11,002 General Reven Property tax Grants and contributions et restricted to specific program Investment vari Special (te-gain on sale of land fotal general revenues and special i Change is fet position Net position January Net position CITY OF ARBORLAND Statement of activiti for the Year Ended December 11, 2012 (thousands) Program Rev Changes Charges Capital Operating Grants and for Grand Several Services Contributions Contributions Activities $ 163 (4,0) $4,200 1,72 5.254 $ 3,958 2,42 162 (4,03 (29) (2,367) (4) (29) 1,300 32 1.005 878 3,939 21,430 4.ME $24,941 11,401 1:3 General even Property taxe Grants and contributions not restricted to specific programs Investment revenues and special Spain sale of las Total general Change position et position-January 1 net position december 11 Functions/Program Svetal Activities: General govern Judicial Palle safety Health and sanitation Culture and recreation Foad satenance Interest on long-tere dest Total governmental activities Business-type activities Total government Functions/Program Several Activition) General goverment Ja Polic safety Health and sanitation Oltare and recreatio Radiance Interest on long-tere dett Tal vental activities Pustis-type activities CATE SPEC In 1 1,004 2,200 ATA 149 115 STA'S 224 3,41 3.000 13,649 SPITE TOST (34,198) $(1,1) 1,5 4,05 2,21 154 16,59 11,09 1544 111, TRVO BCA, MA 14,410 4,799 1,444 3.99 24N2 www 37,499 NY'S S WAYS $4,7 4 QIPTF $LID ATM 11,900 338,433 (Ex) and et Position APPEE Type Activities A X 137.229 $13, (1))) (4,715) (2,205) (1,000) (17) (63 14,31 1 (1,8) 19,144 4,465 3,116 me 24.472 11,37 30.106 (909) (1) (2,4) (2,30) (****) (329) (0,20) (32,341) A00 (172) 14,400 4,700 1,0 w CTICE 4,54 25,411 10.10 fo B 942 1 File C/Users/Brittany%20Jones/OneDrive/Desktop/Question%2016%20-%20Homework%209-10a%20-%20Connect.pdf Q +En A V AL MARLE Net position December 31 $ 19,674 $13,843 $ 33,557 CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2021 (in thousands) Net (Expense) Revenue and Program Revenues Operating Capital Changes in Net Position Business- type Activities Grants and Functions/Prograss Governmental Activities: Grants and Contributions Contributions Governmental Activities Expenses General government Judicial $ 4,297 $ (4,173) 2,01 $ 72 4 Public safety Health and sanitation 4,863 (2,501) (3,100) 3,971 (3,005) CI Culture and recreation Road maintenance 4,159 $1,220 1,941 490 4 1,654 (2,054) (1,473) (159) (18,000) 23,752 Interest on long-tere debt Tatal governmental activities Business-type activities Total government 587 1,220 3,387 35 $27,139 $547 $1,255 $18,000) General Revenue Property taxes 14,600 Grants and contributions not restricted to s specific programs 3,140 Investment earnings 906 Special item-gain on sale of land 1,275 Total general revenues and special items Change in net position 1,921 731 Net position-January 1 10,721 11,439 Net position-December 31 $12,642 $12,370 Additional information follows: Population Year 2023 30,500, Year 2022: 28,371, Year 2021 25,454. Debt limit remained at $20,400,000 for each of the three years. Net cash from operations is generally B0 percent of total revenues each year. tev 11 15 2021 Oc CS-285282 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) B . O Charges for Services $ 124 228 1,738 966 889 3,945 4,001 58,028 $ 711 $ 731 1 H @ Total $ (4,179) (2,501) (),100) (3,005) (2,050) (1,473) (1,000) (58,000) 731 $(17,360) 54,400 3,140 906 1,375 19891 2,652 23AXO $ 25,012 74F Cloudy 16 89 -0 @ 951 PM omework 9-10 18 Part 2 of 2 2.26 point d Mc Gran Choose Numerator Accumulated Depreciation Choo Nuneate Choose Nuntator Thoaks Numa 2023 2022 (2021 2023 (2322 12021 2023 2002 2021 General Bonded Debt General Borded Debt 2023 2922 avot (2023 (2.22 Property Tax Levy 2021 Capital Asset odten Choose Uroondeat Average Cost of Deprecuble Capil Asse Business Type Active Bonded Dele pe Capta Choose Desonator Aendable Legal Debt Line Choose Determinator Piperty lampa Population Legal Debt Lind Pepolation 27 broupMe Chouse Dermato Lloge C Chege Chegg Libra Ofescape Free PLN Sied Capital Aer Condo MI Bunded Debt per Capta Praliable Legal De Property Taxa per Capita NaN NaN NaN NaN% NaN% NAN NaN NAN NIN NaN% NaN% NaN% NaN NAN NaN D Current Assets 2023 2022 2021 2023 2022 2021 2023 2022 2021 Choose Numerator Choose Numerator Choose Numerator Change in Net Position 2023 2022 2021 Net Revenues (ISUA Login Current Ratio Choose Denominator Governmental Activities Business-Type Activities Change in Net Position Ratio Choose Denominator Current Liabilities Total Beginning Net Position Interperiod Equity Choose Denominator ISTA Self-Sufficiency GroupMe Total Expenses Log In C Chegg: Chegg Libra... Savod Current Ratio Change in Net Position Ratio Interperiod Equity NaN times NaN times NaN times NaN times NaN times NaN times NaN% NaN% NaN% NaN times NaN times NaN tinses PDFescape-Fr da Financial Se... M: Unrestricted Net Position / 2023 2022 2021 2023 2022 2021 Choose Numerator 2023 2022 2021 2023 2022 2021 Choose Numerator Choone Numerator Total Liables Unrestricted Net Position Choose Denominator Governmental Activities Business-Type Activities Debt ratio Choose Denominator: Governmental Activities Business-Type Activities Current Ratio Choose Banc Total Revenue Total Assets Saved Unrestricted Net Position Debt to Assets NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN% NaN%
