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, 2020, 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 1. Create a spreadsheet to predict in what year the government will have a zero fund balance. 2. 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 require- ment (1) to predict what year the government will have a zero fund balance if this option is taken. 3. 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.
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, 2020, 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 1. Create a spreadsheet to predict in what year the government will have a zero fund balance. 2. 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 require- ment (1) to predict what year the government will have a zero fund balance if this option is taken. 3. 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.
SWFT Essntl Tax Individ/Bus Entities 2020
23rd Edition
ISBN:9780357391266
Author:Nellen
Publisher:Nellen
Chapter1: Introductin To Taxation
Section: Chapter Questions
Problem 12P
Related questions
Question
Please help with 1,2,3
Transcribed Image Text:Accounting for State and Local Governments (Part 1) 579
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, 2020, 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
1. Create a spreadsheet to predict in what year the government will have a zero fund balance.
2. 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 require-
ment (1) to predict what year the government will have a zero fund balance if this option is taken.
3. 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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
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.Recommended textbooks for you