ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 1 /4 Buscar 'Recortar pagina' The government-wide financial statements for the City of Arborland for a three-year period are presented. CITY OF ARBORLAND Exportar archivo PDF Statements of Net Position As of December 31 (in thousands) Editar PDF 2020 2019 Business Business Governmental type Governmental type Gov Activities Activities Total Activities Activities Total A Crear archivo PDF V Assets Current assets: Cash $ 13,839 $ 1.850 $ 15.689 5,781 $ 5.803 $ 11,584 Investments 738 296 1.034 1,038 186 1,224 Comentar Receivables (net) 2,997 .814 4,811 3947 1,613 5.560 Prepaid expenses 258 13 271 751 762 Inventories 31 63 94 476 53 529 Total current assets 17,863 ,036 21,899 11,993 7,666 19,659 Combinar archivos Capital assets: Land 2,230 2,601 4,831 2,570 1,809 4,379 Depreciable assets 37,850 17,764 55,614 57,905 Accumulated depreciation 22,220) 40, 105 17,732) 17,800 17,539) (4,681 11,026) 28,758) Organizar paginas Total capital assets (net) 22,541 15,684 38,225 24,943 8,583 33,526 Total assets 10,404 19,720 60,124 36,936 16,249 53, 185 Liabilities Accounts payable 1,730 717 2,447 37 869 381 1,250 Censurar Deferred revenue 37 320 320 Other, current 1,759 250 2,009 1,653 195 1,848 Total current liabilities 3,526 967 4,493 842 576 3,418 Bonds payable 16,400 7,500 23,90 9,400 550 26,950 Total liabilities 19,926 8,467 28,393 2,242 8,126 30,368 Net Position Net investment in capital assets 14,748 6,591 21,339 0,665 5,195 15,860 Crea, edita y firma Restricted for: formularios y acuerdos en PDF Capital project 190 190 156 156 Debt service 1,038 Unrestricted (deficit) 100% 49 2,928 5,763 Total net position 5 8,123 $ 22,817 Iniciar version de prueba gratuita 215.9 x 279.4 mm Type here to search O e N 5:38 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 1 / 4 CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2020 (in thousands) Buscar 'Recortar pagina' Net (Expense) Revenue and Program Revenues Changes in Net Position Operating Capital Charges for Grants and Grants and Governmental Business- type Exportar archivo PDF Functions/Programs Expenses Services Contributions Contributions Activities Activities Total Governmental Activities General government $ 5,722 $ 581 $ (5,141) $ (5,141) Judicial 1.93 966 $ 104 (861) (861) Editar PDF Public safety 7,963 1,780 418 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 480 55 1,869 (556) (556) Crear archivo PDF V Interest on long-term debt 953 (953) (953) Total governmental activities 4,294 Business-type activities 3,145 1,515 218 2,391 '45 57 16,643) $ 3,130 6,643) 3, 130 Total government $27,439 $10,733 $2,391 $ 802 $(16,643) $ 3,130 $(13,513) Comentar General Revenues: Property taxes 18,046 18,046 Combinar archivos Grants and contributions not restricted to specific programs 2,815 Investment earnings 1.216 2,815 1,216 Special item-gain on sale of land 350 350 Organizar paginas Total general revenues and special items 22,427 22,427 Change in net position 5 ,784 14 694 3, 130 Net position-January 1 1 123 8,914 22,817 Net position-December 31 $ 20,478 $11,253 $ 31,731 Censurar CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2019 (in thousands) Net (Expense) Revenue and Crea, edita y firma Changes in Net Position Functions/Programs Expenses Program Revenues formularios y acuerdos en PDF Charges Operating Capital Governmental Business- Total for Grants and Grants and Activities type Itps://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=1.&postSubmissionView=13252713744964352&wid=1325271431... 1/4 Iniciar version de prueba gratuita 215.9 x 279.4 mm Type here to search O N 5:39 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion T 2 / 4 Statement of Activities For the Year Ended December 31, 2019 (in thousands) Program Revenues Net (Expense) Revenue and Buscar 'Recortar pagina' Functions/Programs Changes in Net Position Expenses Charges Operating Capital Governmental Business- Total for Grants and Grants and Activities type Exportar archivo PDF itps://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=1.&postSubmissionView=13252713744964352&wid=1325271431... 1/4 Editar PDF 0/8/2020 Assignment Print View Crear archivo PDF V Services Contributions Contributions Activities Governmental Activities: General government $ 4,158 $ 153 $ (4,005) $ (4,005) Judicial 1,742 214 $ 167 (1,361) (1,361) = Comentar Public safety 5,244 1.948 130 (3, 166) Health and sanitation 2,229 152 4,262 (2,077) (3, 166) ( 2, 077 ) Culture and recreation 332 $ 355 (3,575) 3,575) Road maintenance 1.305 626 (679) (679) Combinar archivos Interest on long-term debt 1,179 Total governmental activities 20, 119 2,799 923 4,292 355 (16,042) 16,042) Business-type activities 4.790 15 $ 513 513 Total government $24,411 $7,589 $ 923 $ 370 $(16,042) $ 513 $(15,529) Organizar paginas General Revenues: Property taxes 14,619 14,619 Grants and contributions not restricted to specific Censurar programs 4,039 1,166 4,039 Investment earnings 1 166 Special item-gain on sale of land 700 700 Total general revenues and special items 20,524 20,524 Change in net position 4,482 10,212 513 4,995 Net position-January 7,610 17,822 Crea, edita y firma Net position-December 31 $ 14,694 $8,123 6 22,817 formularios y acuerdos en PDF CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2018 Iniciar version de prueba gratuita (in thousands) Net (Expense) Revenue and 215.9 x 279.4 mm Type here to search O N ~ ( " ) 5:40 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 2 /4 Total generarrevenues and SpecialCMS LU,ULT 20,ULT Change in net position 4,482 513 4,995 Net position-January 10,212 7,610 17,822 Net position-December 31 $ 14,694 $8,123 $ 22,817 Buscar 'Recortar pagina' CITY OF ARBORLAND Statement of Activities For the Year Ended December 31, 2018 Exportar archivo PDF (in thousands) Program Revenues Net (Expense) Revenue and Changes in Net Position Charges Operating Capital Business- Editar PDF for Functions/Programs Expenses Services Grants and Grants and Governmental type Governmental Activities: Contributions Contributions Activities Activities Total General government $ 4,047 $ 114 $ (3,933) $ (3,933) Crear archivo PDF V Judicial 2,001 80Z Public safety 4,363 (1,731) (1,731) 728 62 (2,620) (2,620) Health and sanitation Culture and recreation 2,721 3 709 466 $ 620 (2,255) (2,550) (2,255) 539 (2,550) = Comentar Road maintenance 1,613 470 Interest on long-term debt 1,143) 1, 198 1, 143) (1,198) Total governmental activities 9,652 3,055 547 (1, 198) 620 25 (15,430) (15,430) Business-type activities 2,887 3,833 $ 971 971 Combinar archivos Total government $22,539 $6,888 $ 547 $ 645 6 (15,430) $ 971 $ (14,459) General Revenues: Organizar paginas Property taxes 13,600 Grants and contributions not restricted to specific 13,600 programs 3.040 3.040 Investment earnings 756 756 Censurar Special item-gain on sale of land Total general revenues and special items 525 525 17,921 17,921 Change in net position 2.491 7,721 971 3,462 Net position-January 1 6,639 14,360 Net position-December 31 $ 10,212 $7,610 $ 17,822 Crea, edita y firma Additional information follows: 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 formularios y acuerdos en PDF is generally 80 percent of total revenues each year. Required Iniciar version de prueba gratuita 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 215.9 x 279.4 mm Type here to search O N 5:41 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 2 / 4 Net position-January 1 7,721 6,639 14,360 Net position-December 31 $ 10,212 $7,610 $ 17,822 Buscar 'Recortar pagina' Additional information follows: 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 s generally 80 percent of total revenues each year Exportar archivo PDF 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. Editar PDF Performance Measures 1. Unrestricted net position 2. Capital asset condition X Lo Crear archivo PDF V 3. Debt to assets 4. Current ratio Comentar 5. Quick ratio 6. Change in net position Combinar archivos 7. Interperiod equity 8. BTA self-sufficiency 9. Revenue dispersion X X X X X Organizar paginas 10. Bonded debt per capita 11. Available legal debt limit 12 Property taxes per capita Censurar Crea, edita y firma 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 formularios y acuerdos en PDF answer in thousands except for Bonded debt per Capita, Available Legal Debt Limit and Property Taxes per Capita whose values should be entered ittps://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=1.&postSubmissionView=13252713744964352&wid=1325271431... 2/4 Iniciar version de prueba gratuita 215.9 x 279.4 mm Type here to search O N 9 5:42 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC Archivo Edicion Ver Firmar Ventana Ayuda X Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 3 / 4 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 Buscar 'Recortar pagina' https://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=1.&postSubmissionView=132527 13744964352&wid=1325271431... 2/4 10/8/2020 Assignment Print View Exportar archivo PDF computation.) 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 Editar PDF Unrestricted Net Position Choose Numerator Choose Denominator Unrestricted Net Position Total Revenue Unrestricted Net Position Governmental Activities Lo Crear archivo PDF V 2020 4,602 + 2019 2,835 + Infinity % 2018 3,233 + Infinity % Infinity % Comentar Business-Type Activities 2020 2019 NaN 9% 2018 NaN % NaN % Combinar archivos Capital Asset Condition Choose Numerator Choose Denominator Organizar paginas Accumulated Depreciation Average Cost of Depreciable Capital Assets Capital Asset Condition Governmental Activities 2020 2019 1 1 11 NaN| % Censurar 2018 NaN|9 Nan % Business-Type Activities 2020 2019 NaN % 2018 Nan % Nan % Crea, edita y firma Debt to Assets formularios y acuerdos en PDF Choose Numerator Choose Denominator Total Liabilities + Total Assets = Debt to Assets Governmental Activities Iniciar version de prueba gratuita 2020 2019 NaN % 2018 11 11 11 NaN % JAN% Type here to search O E m N P X W 5:43 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion 4 /4 Quick Ratio Choose Numerator Choose Denominator Quick Assets [Current Liabilities =|Quick Ratio Governmental Activities Buscar 'Recortar pagina' 2020 2019 NaN times 2018 1 1 11 NaN times NaN times Business-Type Activities Exportar archivo PDF 2020 2019 NaN times 2018 NaN times NaN times Editar PDF Change in Net Positon https://ezto.mheducation.com/hm.tpx?todo=c15SinglePrintView&singleQuestionNo=1.&postSubmissionView=132527 13744964352&wid=1325271431... 3/4 Crear archivo PDF V 10/8/2020 Assignment Print View Comentar 2020 2019 2018 Combinar archivos Interperiod Equity Choose Numerator Choose Denominator Net Revenues Total Expenses 2020 Interperiod Equity Organizar paginas 2019 NaN times 2018 NaN times NaN times Censurar BTA Self-Sufficiency Choose Numerator Choose Denominator BTA Service Charge Revenues BTA Total Expenses BTA self-sufficiency 2020 2019 NaN times 2018 Nan times Crea, edita y firma NaN times formularios y acuerdos en PDF Revenue Dispersion 2020 75% Iniciar version de prueba gratuita 2019 2018 Nan % Type here to search O Ei N P X W 5:44 PM 10/8/2020ACCT 585 WEEK 6 PROBLEM 1.pdf - Adobe Acrobat Reader DC X Archivo Edicion Ver Firmar Ventana Ayuda Inicio Herramientas CityofStLouisMO_C... ACCT 585 WEEK 6 ... X (? Iniciar sesion T 4 /4 2020 2019 NaN times 2018 NaN times NaN times Buscar 'Recortar pagina' Revenue Dispersion Choose Numerator Choose Denominator Non-Tax Revenue Sources Total Revenue 2020 Revenue Dispersion 2019 11 11 11 NaN Exportar archivo PDF NaN 2018 Nan Editar PDF Bonded Debt per Capita Choose Numerator Choose Denominator General Bonded Debt 2020 Bonded Debt per Capita 2019 NaN Lo Crear archivo PDF V 2018 11 11 11 11 NaN Nam Comentar Available Legal Debt Limit Choose Numerator Choose Denominator General Bonded Debt Legal Debt Limit 11 11 11 11 Available Legal Debt Limit 2020 Combinar archivos 2019 NaN 2018 NaN 9 NaN Organizar paginas Property Taxes per Capita Choose Numerator Choose Denominator |Property Taxes per Capita 2020 Censurar 2019 NaN NaN 2018 NaN Crea, edita y firma formularios y acuerdos en PDF References Worksheet Difficulty: 3 Hard Learning Objective: 10-04 Identify, calculate, interpret, and analyze key ratios that measure financial performance. Iniciar version de prueba gratuita Type here to search O Ei P X W 5:45 PM 10/8/2020