The City of Bainland has been undergoing financial difficulties because of a decrease in its tax base caused by corporations leaving the area. On January 1, 2017, the city has a fund balance of only $400,000 in its governmental funds. In 2016, the city had revenues of $1.4 million and expenditures of $1.48 million. The city's treasurer has forecast that, unless something is done, revenues will decrease at 2 percent per year while expenditures will increase at 3 percent per year. Required Create a spreadsheet to predict in what year the government will have a zero fund balance. One proposal is that the city slash its expenditures by laying off government workers. That will lead to a 3 percent decrease in expenditures each year rather than a 3 percent increase. However, because of the unemployment, the city will receive less tax revenue. Thus, instead of a 2 percent decrease in revenues, the city expects a 5 percent decrease per year. Adapt the spreadsheet created in requirement (1) to predict what year the government will have a zero fund balance if this option is taken. Another proposal is to increase spending to draw new businesses to the area. This action will lead to a 7 percent increase in expenditures every year, but revenues are expected to rise by 4 percent per year. Adapt the spreadsheet created in requirement (1) to predict what year the government will have a zero fund balance under this option.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Question

The City of Bainland has been undergoing financial difficulties because of a decrease in its tax base caused by corporations leaving the area. On January 1, 2017, the city has a fund balance of only $400,000 in its governmental funds. In 2016, the city had revenues of $1.4 million and expenditures of $1.48 million. The city's treasurer has forecast that, unless something is done, revenues will decrease at 2 percent per year while expenditures will increase at 3 percent per year.

Required

Create a spreadsheet to predict in what year the government will have a zero fund balance.
One proposal is that the city slash its expenditures by laying off government workers. That will lead to a 3 percent decrease in expenditures each year rather than a 3 percent increase. However, because of the unemployment, the city will receive less tax revenue. Thus, instead of a 2 percent decrease in revenues, the city expects a 5 percent decrease per year. Adapt the spreadsheet created in requirement (1) to predict what year the government will have a zero fund balance if this option is taken.
Another proposal is to increase spending to draw new businesses to the area. This action will lead to a 7 percent increase in expenditures every year, but revenues are expected to rise by 4 percent per year. Adapt the spreadsheet created in requirement (1) to predict what year the government will have a zero fund balance under this option.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

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