Using the Abbreviated Budget, compute the Measures of Solvency for Bay City, Texas for 2022.? Only use the Amended Budget FY 2022 column to compute & place those findings into
Using the Abbreviated Budget, compute the Measures of Solvency for Bay City, Texas for 2022.
Only use the Amended Budget FY 2022 column to compute & place those findings into the chart to create a graph.
Abridged Budget
| Abridged Budget for Bay City, Texas, 2022 | ||||||
| Combined Revenue and Expenditures Summary | ||||||
| Actual FY 2020 | Actual FY 2021 | Amended Budget FY 2022 | Projected FY 2022 | Adopted FY 2023 | % Change Budget FY 2022 to Adopted FY 2023 | |
| Funding Sources | ||||||
| Property Tax | 5,728,874 | 5,965,544 | 6,212,202 | 6,121,770 | 6,631,192 | 6.74% |
| Sales and Use Tax | 4,999,150 | 4,980,165 | 5,082,000 | 5,078,250 | 5,063,000 | -0.37% |
| Franchise Tax | 1,258,458 | 1,263,438 | 1,298,000 | 1,273,000 | 1,361,000 | 4.85% |
| Hotel/Motel Tax | 666,649 | 640,386 | 600,000 | 615,000 | 620,000 | 3.33% |
| Licenses and Permits | 205,985 | 193,014 | 193,500 | 194,895 | 198,500 | 2.58% |
| Charges for Services | 10,084,944 | 10,939,588 | 11,007,000 | 11,205,112 | 12,414,500 | 12.79% |
| Fines and Penalties | 283,393 | 331,851 | 312,300 | 327,504 | 335,800 | 7.52% |
| Other Revenues/Sources | 1,081,024 | 1,348,616 | 195,500 | 225,000 | 421,500 | 111% |
| Miscellaneous | 1,951,026 | 2,535,633 | 1,561,998 | 1,752,373 | 1,818,508 | 16.42% |
| Intergovernmental | 1,595,999 | 2,914,125 | 1,882,000 | 1,637,000 | 1,102,000 | -41.45% |
| Prior Fund Balance | – | – | 2,646,000 | – | 1,485,000 | -43.88% |
| Total Revenues & Transfers | 27,855,502 | 31,112,361 | 30,990,500 | 28,429,904 | 31,442,000 | 1.46% |
| Expenditures | ||||||
| General Government | 3,959,232 | 3,959,356 | 4,478,530 | 4,430,150 | 4,781,654 | 6.77% |
| Streets | 3,430,354 | 3,838,132 | 4,451,662 | 4,449,400 | 4,020,859 | -9.68% |
| Public Safety | 4,981,814 | 5,499,838 | 5,646,810 | 5,642,289 | 5,628,051 | -0.33% |
| Parks & Recreation | 2,345,165 | 2,229,613 | 2,522,498 | 2,283,145 | 2,249,436 | -10.83% |
| Water & Sewer | 10,024,756 | 9,050,489 | 10,148,000 | 8,653,369 | 11,112,000 | 9.50% |
| Airport | 793,689 | 897,916 | 673,000 | 672,675 | 873,000 | 29.72% |
| Hotel Motel | 623,421 | 649,757 | 1,017,000 | 711,230 | 717,000 | -29.50% |
| Interest & Sinking | 1,377,673 | 4,184,105 | 2,053,000 | 2,052,933 | 2,060,000 | 0.34% |
| Total Revenues & Transfers | 27,536,105 | 30,309,206 | 30,990,500 | 28,895,191 | 31,442,000 | 1.46% |
| Government-Wide Financial Analysis City of Bay City, Texas Net Position (in dollars) | ||||||
| Total 2022 | ||||||
| Curent Assets | $ 15,429,273 | |||||
| Capital Assets | $ 50,380,696 | |||||
| Total Assets | $ 65,815,497 | |||||
| Current Liabilities | $ 5,863,375 | |||||
| Noncurrent Liabilities | $ 24,983,882 | |||||
| Total Liabilities | $ 30,847,257 | |||||
| Restricted Assets | $ 7,532,535 | |||||
| Unrestricted Assets | $ 27,185,504 |
Financial Indicators
| Bay City, Texas FY 2022 | ||||
| Current, Operating, and Net Asset Ratio | ||||
| Dollar Amount | Ratio | |||
| Cash Solvency: | ||||
| 1 | Current Ratio | Current Assets | ||
| Current Liabilites | ||||
| Ratio | ERROR:#DIV/0! | |||
| Budget Solvency | ||||
| 2 | Operating Ratio | Total Revenue | ||
| Total Expenses | ||||
| Ratio | ERROR:#DIV/0! | |||
| Long-Run Solvency | ||||
| 3 | Net Asset Rato | Total Assets | ||
| Restricted + Unrestricted Assets | ||||
| Ratio | ERROR:#DIV/0! | |||
Measures of Solvency Ratios for Bay City, TX
FY 2022
Current Ratio Operating Ratio Net Asset Rato 0 0 0
Type of Ratio
Ratios
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
