ACG4501 Writing Project Part 3
Tico
Week2WritingProject.xlsE 10-20
| ACG4501 | ||||||
| Part 2- Writing Project | ||||||
| Term: August 2020 | ||||||
| Name: Humberto Rosales Rosales | ||||||
| 10-20 a. | Which of the financial performance measures in Illustration 10-4 can be calculated for the City of Arborland based on the information that is provided? | |||||
| Unrestricted net position | ||||||
| Capital asset condition | ||||||
| Debt to assets | ||||||
| Current ratio | ||||||
| Quick ratio | ||||||
| Change in net position | ||||||
| Interperiod equity | ||||||
| Business Type Activities self-sufficiency | ||||||
| Revenue Dispersion | ||||||
| Bonded debt per capita | ||||||
| Available legal debt limit | ||||||
| Property taxes per capita | ||||||
| 10-20 b. | Calculate at least 5 of those ratios identified in part a in the space provided below. Complete for FY 2018, 2019, and 2020. Remember to use formulas. | 2020 | 2019 | 2018 | ||
| Ratio: Unrestricted net position | Governmental activities | 17% | 14% | 13% | ||
| Business type activities | 68% | 51% | 85% | |||
| Ratio: Debt to asset ratio | Governmental activities | 57% | 61% | 68% | ||
| Business type activities | 49% | 61% | 57% | |||
| Ratio: Current ratio | Governmental activities | 2.76 | 4.49 | 2.03 | ||
| Business type activities | 5.95 | 6.19 | 6.86 | |||
| Ratio: Quick ratio | Governmental activities | 2.68 | 4.31 | 1.92 | ||
| Business type activities | 5.85 | 6.10 | 6.75 | |||
| Ratio: BTA self-sufficiency | Business type activities | 1.80 | 1.00 | 1.41 | ||
| 2020 | 2019 | 2018 | ||||
| Governmental activities | Business Type Activities | Governmental activities | Business Type Activities | Governmental activities | Business Type Activities | |
| Unrestricted fund | $ 4,597 | $ 3,546 | $ 3,075 | $ 2,178 | $ 2,683 | $ 3,163 |
| Total revenue | $ 26,543 | $ 22,066 | $ 20,378 | |||
| Charges for services | $ 3,860 | $ 5,218 | $ 2,769 | $ 4,290 | $ 2,610 | $ 3,708 |
| Capital grants and contributions | $ 495 | $ 7 | $ 350 | $ 10 | $ 320 | $ 20 |
| Total liabilities | $ 19,266 | $ 7,167 | $ 18,785 | $ 8,066 | $ 19,064 | $ 6,965 |
| Total assets | $ 34,040 | $ 14,740 | $ 30,989 | $ 13,309 | $ 28,062 | $ 12,195 |
| Total current assets | $ 9,299 | $ 3,966 | $ 8,468 | $ 3,506 | $ 6,424 | $ 3,192 |
| Total current liabilities | $ 3,366 | $ 667 | $ 1,885 | $ 566 | $ 3,164 | $ 465 |
| Prepaid expenses | $ 253 | $ 8 | $ 251 | $ 6 | $ 171 | $ 5 |
| Inventories | $ 26 | $ 58 | $ 101 | $ 48 | $ 167 | $ 49 |
| General revenues and special items | $ 20,302 | $ 18,399 | $ 16,921 | |||
| Operating grants and contributions | $ 1,886 | $ 548 | $ 527 | |||
| Expenses | $ 23,973 | $ 2,895 | $ 18,859 | $ 4,287 | $ 17,602 | $ 2,637 |
Unrestricted Fund
------------------------
Total Revnue
Total Liabilities
--------------------
Total Assets
Total Current Assets
-------------------------------
Total Current Liabilities
Total Current Assets - Prepaid Expenses - Inventories
----------------------------------------------------------------------
Total Current Liabilities
Changes of Services
---------------------------
Expenses
Total Revenue = General Revenues and Special Items
+ Changes of Services
+ Operating Grants and Contributions
+ Capital grants and Contributions
