a.
Identify the financial performance measures that can be calculated for City A.
a.
Explanation of Solution
Government Accounting Standards Board (GASB): Government accounting standards board (GASB) is an independent board that establishes reporting standards for the local and state government, and also for government not-for-profit organizations that has to adhere to the generally accepted accounting principles (GAAP).
The following ratios can be calculated:
- Business-type activities self-sufficiency.
- Revenue dispersion.
- Inter-period equity.
- Quick ratio.
- Debt to assets.
- Capital asset condition.
Current ratio .- Unrestricted net position.
- Change in net position.
b.
Ascertain the various ratios for City A for 2020.
b.
Explanation of Solution
Government-wide financial statements: These are the financial statements that report the government’s net position and changes in net position. These statements report the governmental activities, business-type activities, and the activities related to proprietary funds and fiduciary funds. These statements are prepared based on the accrual accounting. The two government-wide financial statements are Statement of Net Position and Statement of Activities.
- Compute the unrestricted net position:
For Governmental activities:
For Business type activities:
The unrestricted net position is 17% for governmental activities and 68% for business type activities.
- Compute the Capital asset condition:
For Governmental activities:
For Business type activities:
The capital asset condition is 40% for governmental activities and 36% for business type activities.
- Compute the Debt to assets ratio:
For Governmental activities:
For Business type activities:
The debt to assets is 57% for governmental activities and 49% for business type activities.
- Compute the current ratio:
For Governmental activities:
For Business type activities:
The current ratio is 2.76 times for governmental activities and 5.95 times for business type activities.
- Compute the quick ratio:
For Governmental activities:
For Business type activities:
The quick ratio is 2.68 times for governmental activities and 5.85 times for business type activities.
- Compute the change in net position:
For Governmental activities and Business type activities:
The change in net position is $4,900.
- Compute the interperiod equity:
For Governmental activities and Business type activities:
The interperiod equity is 1.10 times.
- Compute the BTA self-sufficiency:
For Governmental activities and Business type activities:
The BTA self-sufficiency is 1.80 times.
- Compute the revenue dispersion:
For Governmental activities:
The revenue dispersion is 34.6%.
- Compute the bonded debt per capita:
For Governmental activities:
The bonded debt per capita is $522.68.
- Compute the available legal debt limit:
For Governmental activities:
The available legal debt limit is 79.5%.
- Compute the property taxes per capita:
For Governmental activities:
The property taxes t per capita is $522.68.
c.
Assess the overall financial condition on the City A.
c.
Explanation of Solution
The overall financial condition of City A, is very strong. Most of the ratios indicate a positive performance, however a few things need to be taken care of.
Want to see more full solutions like this?
Chapter 10 Solutions
Loose-leaf For Accounting For Governmental & Nonprofit Entities
- -The City of Havisham has a fiscal year ending December 31, Year 5. If the city were to produce financial statements right now, the following figures would be included: -Governmental activities: Assets = $800,000, Liabilities = $300,000, and Change in Net Position for the period = increase of $100,000 - Business-type activities: Assets = $500,000, Liabilities = $200,000, and Change in Net Position for the period = increase of $60,000 - Governmental funds: Assets = $300,000, Liabilities = $100,000, and Change in Fund Balances = increase of $40,000 -Proprietary funds: Assets = $700,000, Liabilities = $300,000, and Change in Net Assets for the period = increase of $70,000 Other information: The city council is considered the highest level of decision-making authority for the government. Where applicable, current financial resources are viewed by the government as available if collected within 75 days of the end of a fiscal year. For each of the following, indicate whether the overall…arrow_forwardI need answer of this question accountingarrow_forwardUsing the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown and for the “Total Governmental Funds:”a. Current Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response Ratioarrow_forward
- Changes in mix of revenues and expenditures must be interpreted with care. The data that follow were drawn from the city of Boulder, Colorado’s CAFR. Dates have been changed. They are from two statistical-section schedules showing the mix of revenue and expenditures for a 10-year period. They include amounts only from the general fund, special revenue funds, and debt service funds. 2020 2021 (amounts in thousands) Revenues Sales and use taxes $ 97,397 $104,136 General property taxes 29,474 29,434 Other taxes 20,278 21,184 Charges for services 27,030 22,670 Intergovernmental 16,420 13,348 Proceeds from bonds and notes 54,830 Other 20,660 21,473 Total revenues $266,089 $212,245 Expenditures General government and administration $ 27,717 $ 30,185 Public safety 47,825 48,202 Public works 22,178 27,896 Housing and human services 13,384 20,226 Culture and recreation 25,677 28,089 Capital outlay 29,111 19,218 Debt service 13,574 16,375…arrow_forwardNeed Help with this Questionarrow_forward. Using the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown and for the “Total Governmental Funds:”a. Current Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response Ratioarrow_forward
- Breneman City reported bonds payable of $5,500,000 in the governmental activities column of its statement of net position for fiscal year ended June 30, 2021. During fiscal year ended June 30, 2022, the City issued bonds payable totaling $1,000,000, and made principal payments on bonds payable totaling $220,000. Prepare the three journal entries required to adjust the governmental funds statements to the government-wide statements for fiscal year ended June 30, 2022.arrow_forwardThe following information is available for the preperation of the Government- wide financial statements for the City of Southren Springs as of April 30, 2020: Cash and cash equivalents, governmental activities $480,000; Cash and cash equivalents, business- type activities $700,000; Receivables, Governemntal activities $450,000; Receivables, business-type activites $1,330,000; Inventories, business - type activities $520,000; Capitol assets, net governmental activities $12,500,000; Capitol Assets, net, business-type activities $7,200,000; Accounts payable, Governmental activites $650,000; Accounts payable, business - type activities $559,000; General obligation bonds, governmental activities $7,800,00; Revenue binds, business -type activities$3,210,000 Long term liability for compensated absences, governmental activities $359,000 From the preceeding information, prepare (in good form) a statement of Net Position for the City of Southern Springs as of April 30,2020. Assume that…arrow_forward1. The following information is available for the preparation of the government-wide financialstatements for the City of Shortsville for the year ended June 30, 2017: Expenses:General government — $12,900,000Public safety — 21,600,000Public works — 11,100,000Health and sanitation — 5,700,000Culture and recreation — 4,200,000Interest on long-term debt, governmental type — 900,000Water and sewer system — 11,700,000Parking system — 319,000 Revenues:Charges for services, general government — 2,000,000Charges for services, public safety — 430,000Operating grant, public safety — 900,000Operating grant, health and sanitation — 1,400,000Charges for services, culture and recreation — 3,250,000Charges for services, water and sewer — 13,000,000Charges for services, parking system — 400,000Property taxes — 29,300,000Sales taxes — 19,800,000Investment earnings, business-type — 425,000 Other Financing Sources (Uses):Special item-gain on sale of unused land, governmental type — 116,000Transfers from…arrow_forward
- Solve using excel......Using the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown, including “Total Governmental Funds:”a. Current Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response Ratioarrow_forwardThe following information pertains to the City of Williamson for 2020, its first year of legal existence. For convenience, assume that all transactions are for the general fund, which has three separate functions: general government, public safety, and health and sanitation. Receipts: Property taxes $320,000 Franchise taxes 42,000 Charges for general government services 5,000 Charges for public safety services 3,000 Charges for health and sanitation services 42,000 Issued long-term note payable 200,000 Receivables at end of year: Property taxes (90% estimated to be collectible) 90,000 Payments: Salary: General government 66,000 Public safety 39,000 Health and sanitation 22,000 Rent: General government 11,000 Public safety 18,000 Health and sanitation 3,000 Maintenance: General government 21,000 Public safety 5,000 Health and sanitation 9,000 Insurance: General government 8,000 Public safety ($2,000 still prepaid…arrow_forwardUsing the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown and for the “Total Governmental Funds:”a. Current Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response RatioReconciliation of the Governmental Funds Balance Sheetto the Statement of Net Position September 30, 2015Total fund balances- governmental funds $ 157,315,850Amounts reported for governmental activities in the statement of netposition are different because:Capital assets used in governmental activities are not current financialresources and therefore are not reported in the governmental funds. 1,241,213,205Net OPEB obligations are created through the estimated calculation of the county'semployer contribution toward the retiree's benefits. The amount greater or less than the 5,549,497annual required contribution is posted as an asset/(liability).Deferred outflows for bond refunding losses are…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education