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
- . 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_forward3. The following information is available for the preparation of the government-wide financial statements for the City of Northern Pines for the year ended June 30, 2024: Expenses: General government $ 10,712,000 Public safety 22,500,000 Public works 11,290,000 Health and sanitation 6,010,000 Culture and recreation 4,198,000 Interest on long-term debt, governmental type 450,000 Water and sewer system 10,710,000 Parking system 412,000 Revenues: Charges for services, general government 1,206,000 Charges for services, public safety 210,000 Operating grant, public safety 800,000 Charges for services, health, and sanitation 2,580,000 Operating grant, health, and sanitation 1,210,000 Charges for services, culture, and recreation 1,998,000 Charges for services, water, and sewer 11,588,000 Charges for services, parking system 388,000 Property taxes 27,900,000 Sales taxes 17,600,000 Investment earnings, business-type 325,000 Special item—gain on…arrow_forwardSolve 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_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_forwardBreneman 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_forward
- The 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_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
- 1. In a county's CAFR for the current fiscal year, governmental activities expenses on the government-wide statement of activities are $200 million and governmental fund expenditures on the governmental funds statement of revenues, expenditures, and changes in fund balances are $225 million.What is a possible reason why expenditures are higher than expenses? Select one: A. Large principal payments on general obligation debt. B. Large accruals of pension benefits not requiring current resources. C. Large amounts of general obligation debt issued. D. Large amounts of depreciation expense on governmental capital assets. 2. For the question below, use the numbers from the following financial statements required in a county government's CAFR to identify where the account is reported: 1. Government-wide statement: Statement of net position 2. Government-wide statement: Statement of activities 3. Fund statement: Balance sheet–Governmental funds 4. Fund statement:…arrow_forwardAccounting The following information is available for Phelan City for the year ended December 31, 2022: Total governmental fund balance was $3,000,000 The City had $1,000,000 of capital assets in place at the beginning of the year. The City acquired $800,000 in capital assets during the current year. Accumulated depreciation including the current year depreciation on capital assets $220,000 The City sold capital assets with a book value of $240,000 for $250,000. The City issued, during the current year, $3,000,000 in general obligation bonds and the bonds are to be used for a construction project. No other bonds were issued in previous periods. At the end of the year accrued interest payable was $180,000, not legally due. Revenue accrued but not available for current period use totaled $160,000. The balance in the government-wide governmental activities net position is equal to: Group of answer choices $1,160,000. $1,310,000. $1, 320,000. $1,330,000.arrow_forwardA government reports that its public safety function had expenses of $900,000 last year and program revenues of $200,000 so that its net expenses were $700,000. On which financial statement is this information presented? Statement of activities. Statement of cash flows. Statement of revenues and expenditures. Statement of net position.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