Accounting For Governmental & Nonprofit Entities
18th Edition
ISBN: 9781259917059
Author: RECK, Jacqueline L., Lowensohn, Suzanne L., NEELY, Daniel G.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 10, Problem 19EP
Examine the following tables from the Financial Trend Monitoring Report for the Town of Oakdale for the most recent fiscal year-end. The performance indicators selected are total revenue and revenue per capita. The town provides three reference groups with which to compare Oakdale: Aaa-rated municipalities, comparison municipalities, and the state median. Because local government budgeting in this state is driven by the property tax levy cap, this is a key variable in comparing municipalities.
Required
- a. Prepare a histogram or bar graph that shows Oakdale in relation to the three reference groups: Aaa-rated median, comparison reference group, and state median for FY total revenue and a separate graph for FY revenue per capita.
- b. Evaluate the financial performance of Oakdale for the fiscal year. Use information from the tables and the graph you prepared for part a to support your analysis.
- c. What other performance measures would you like to see before you conclude the town is in good or bad shape for the fiscal year shown?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
From 2013 – 2016, what was the total spending in each of the four calendar years? In each of the years 2013 - 2016, how much was spent in each of the three categories of government (Education, General Government, and Public Works)?
In 2016, which account (use the field “Account Desc” for this answer) was the largest in the General Government category?
In 2016, who was Somerville’s largest vendor as measured by total dollars spent? How many separate payments did the city make to this vendor? What was the average amount of each payment to this vendor? Why did the city pay this vendor?
How much in expenditures did Somerville have related to Property, Plant and Equipment (use the field “Item Class” for this answer) in the General Government category in each of the years 2013 – 2016? How much in expenditures in each of those years were related to repairs and maintenance?
Prepare a pivot table that shows a line chart of Somerville’s expenditures in each of the three categories of government…
Calculate the government-wide financial position ratio, the quick ratio, and the debt per capita ratio (assuming a population of 250,000) for the City of Cottonwood using the financial statements on the previous page.
1. Enter the government-wide financial position ratio for the City of Cottonwood, along with the calculation you used to arrive at your answer.
2. Enter the quick ratio for the City of Cottonwood, along with the calculation you used to arrive at your answer.
3. Enter the debt per capita ratio for the City of Cottonwood, along with the calculation you used to arrive at your answer. Assume a population of 250,000.
1-The city of Seaview operated at an $ 543,000 surplus this year. The surplus suggests that the municipal tax system is: Select one:
a. Efficient
b. Fair
C. Convenient
d. Sufficient
2-The correlation between rate and base are called the dynamic forecast. Select one:
O True O False
Chapter 10 Solutions
Accounting For Governmental & Nonprofit Entities
Ch. 10 - The GASB indicates that economic condition is...Ch. 10 - What is the Financial Trend Monitoring System and...Ch. 10 - The International City/County Management...Ch. 10 - Prob. 4QCh. 10 - Prob. 5QCh. 10 - Prob. 6QCh. 10 - Prob. 7QCh. 10 - Illustration 104, adapted front Crawford and...Ch. 10 - What is EMMA and when would someone want to use...Ch. 10 - Prob. 10Q
Ch. 10 - Prob. 11QCh. 10 - Prob. 17.1EPCh. 10 - Which of the following terms or concepts focuses...Ch. 10 - Prob. 17.3EPCh. 10 - Prob. 17.4EPCh. 10 - Prob. 17.5EPCh. 10 - Prob. 17.6EPCh. 10 - Prob. 17.7EPCh. 10 - Prob. 17.8EPCh. 10 - Prob. 17.9EPCh. 10 - Prob. 17.10EPCh. 10 - Prob. 17.11EPCh. 10 - Which of the following would be considered a sign...Ch. 10 - Prob. 17.13EPCh. 10 - Prob. 17.14EPCh. 10 - What is Electronic Municipal Market Access, or...Ch. 10 - Prob. 18EPCh. 10 - Examine the following tables from the Financial...Ch. 10 - Prob. 20EPCh. 10 - Prob. 21EP
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Most cities publish their budgets and financial projects on their websites for citizens to view. Look at the local budget statements for your town of las vegas, nv or another nearby city. What did you learn by viewing these statements from your city and what do you think about your chosen city’s current financial position? Did you notice any areas where you believe there should be improvements to the budget numbers? Make sure you include a link to the financial information from your chosen city.arrow_forwardA local government has the following transactions during the current fiscal period. Prepare journal entries without dollar amounts, first for fund financial statements and then for government-wide financial statements.a. The budget for the police department, ambulance service, and other ongoing activities is passed. Funding is from property taxes, transfers, and bond proceeds. All monetary outflows will be for expenses and fixed assets. A deficit is projected.b. A bond is issued at face value to fund the construction of a new municipal building. c. A computer is ordered for the tax department.d. The computer is received.e. The invoice for the computer is paid.f. The city council agrees to transfer money from the general fund as partial payment for a special assessments project but has not yet done so. The city will be secondarily liable for any money borrowed for this work.g. The city council creates a motor pool to service all government vehicles.…arrow_forwardA local government has the following transactions during the current fiscal period. Prepare journal entries without dollar amounts, first for fund financial statements and then for government-wide financial statements. The budget for the police department, ambulance service, and other ongoing activities is passed. Funding is from property taxes, transfers, and bond proceeds. All monetary outflows will be for expenses and fixed assets. A deficit is projected. A bond is issued at face value to fund the construction of a new municipal building. A computer is ordered for the tax department. The computer is received. The invoice for the computer is paid. The city council agrees to transfer money from the general fund as partial payment for a special assessments project but has not yet done so. The city will be secondarily liable for any money borrowed for this work. The city council creates a motor pool to service all government vehicles. Money is transferred from the general fund to…arrow_forward
- NEED BOTH QUESTIONS. .... As the tax assessor for Indian Creek County, you have been informed that due to budgetary demands, a tax increase will be necessary next year. The total market value of the property in the county is $900,000,000. Currently, the assessment rate is 35% and the tax rate is 30 mills. The county commission increases the assessment rate to 45% and the tax rate to 35 mills. (a)How much property tax (in $) was collected under the old rates? (b)How much more tax (in $) revenue will be collected under the new rates?arrow_forwardAs the tax assessor for Indian Creek County, you have been informed that due to budgetary demands, a tax increase will be necessary next year. The total market value of the property in the county is $300,000,000. Currently, the assessment rate is 35% and the tax rate is 40 mills. The county commission increases the assessment rate to 55% and the tax rate to 45 mills. (a)How much property tax (in $) was collected under the old rates? (b)How much more tax (in $) revenue will be collected under the new rates?arrow_forwardAs the tax assessor for Indian Creek County, you have been informed that due to budgetary demands, a tax increase will be necessary next year. The total market value of the property in the county is $400,000,000. Currently, the assessment rate is 35% and the tax rate is 30 mills. The county commission increases the assessment rate to 45% and the tax rate to 35 mills. (a) How much property tax (in $) was collected under the old rates? $ (b) How much more tax (in $) revenue will be collected under the new rates? $arrow_forward
- Budget planners for a certain community have determined that $6,391,000 will be required to provide all government services next year. The total assessed property value in the community is $110,000,000. What tax rate is required to meet the budgetary demands? (Express your answer as a tax rate per $100 to two decimal places rounded up.) ______arrow_forwardThe 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, 2020: Expenses: General government $ 12,060,000 Public safety 24,509,000 Public works 11,578,000 Health and sanitation 6,163,000 Culture and recreation 4,509,000 Interest on long-term debt, governmental type 739,000 Water and sewer system 10,977,000 Parking system 418,000 Revenues: Charges for services, general government 1,340,000 Charges for services, public safety 214,800 Operating grant, public safety 816,300 Charges for services, health and sanitation 2,409,000 Operating grant, health and sanitation 1,237,600 Charges for services, culture and recreation 2,248,100 Charges for services, water and sewer 11,852,000 Charges for services, parking system 396,700 Property taxes 27,719,800 Sales taxes…arrow_forwardThe following information is available for the preparation of the government-wide financial statements for the City of Northren Pines fot the year ended June 30,2020: Expenses: General government $11,960,000; Public Safety $23,900.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 $721,000; Water and Sewer system $10,710,000 Parking system $409,000 Revenues: Charges for service, general governemnt $1,510,000; Charges for services, public safety $210,000; Operating grant, public safety $798,000; Charges for services health and sanitation $2,335,000; Operating grant, health and sanitation $1,210,000; Charges for service, culture and recreation $1,998,000; Charges for services, water and sewer $11,588,000; Changes for services, parking system $388,000; Property Taxes $27,112,000; Sales Taxes $20,698,000 investment earnings, business-type $325,000; Special Item - gain on sale of unused land,…arrow_forward
- To what extent do the unique features of government accounting make a difference on the financial statements? The transactions that follow relate to the Danville County Comptroller’s Department over a two-year period. Year 1• The county appropriated $12,000 for employee education and training.• The department signed contracts with outside consultants to conduct accounting and auditing workshops. The total cost was $10,000.• The consultants conducted the workshops and were paid $10,000.• The department ordered books and training materials, which it estimated would cost $1,800. As of year-end, the materials had not been received. Year 2• The county appropriated $13,500 for employee education and training.• The department received and paid for the books and training materials that it ordered the previous year. Actual cost was only $1,700. The county’s accounting policies require that the books and training materials be charged as an expenditure when they are received (as opposed to being…arrow_forwardBecause of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment for Jefferson Community College for the nine most recent years: Construct a time series plot. What type of pattern exists in the data? Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. What is the forecast for year 10?arrow_forwardCalculate the property tax rate required to meet the budgetary demands of the community. Note: When calculating budgetary demands, always round up. (Round your answers to two decimal places.) Community Total AssessedProperty Valuation Total TaxesRequired perecent per $100 per $1000 mills Ellingham $56,000,000 $2,500,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
What is Business Analysis?; Author: WolvesAndFinance;https://www.youtube.com/watch?v=gG2WpW3sr6k;License: Standard Youtube License