excel case advanced accounting

Project Description:

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, 2015, the city has a fund balance of only $400,000 in its governmental funds. in 2014, 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.
cpa skills
accounting for state and local governments (part 1) 757
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 requirement (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.
i need to present this so an explanation of sheets would be very helpful
Skills Required:
Project Stats: Edited

Price Type: Fixed

Project Budget: $10 to $20
Completed
Total Proposals: 9
1 Current viewersl
53 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.0
    72 Jobs 31 Reviews
    $20 in 2 Days
  • 4.9
    98 Jobs 49 Reviews
    $15 in 12 Hours
  • 4.8
    128 Jobs 55 Reviews
    $20 in 1 Day
  • 4.7
    93 Jobs 44 Reviews
    $20 in 1 Day
  • 4.7
    32 Jobs 9 Reviews
    $15 in 1 Day
  • 4.3
    12 Jobs 6 Reviews
    $25 in 1 Day
  • 4.9
    14 Jobs 9 Reviews
    $25 in 1 Day
  • 4.8
    106 Jobs 55 Reviews
    $20 in 1 Day
  • 4.9
    96 Jobs 53 Reviews
    $20 in 2 Days