How do I calculate the budget assumptions below? I have to create a simple budget spreadsheet for a town that includes these revenue categories and the figures from the calculations. These are your beginning revenues assumptions. Thank you.

Taxes:

Your town has a residential home base of 28,350 units with an average assessed home value of $140,000. The town collects an assessed rate of .115/100 of assessed value. Calculate the residential tax revenue.

Businesses in your town generate approximately $150,000,000 in sales revenue. Your town applies a sales tax rate of 2.35%. Calculate the business tax revenue.

Service Fees:

Your town provides trash/water/sewer services for its residents and businesses at a rate of $135/month. Your home base is 28,350 and your number of businesses is 400. Calculate the service fee revenue.

IGAs:

Your town operates a landfill and charges $60.50 per ton for use of the landfill. There are currently three IGAs with other localities in effect. 1- 50,000 tons per year, 2- 7,500 tons per month, 3- 35,000 tons per quarter. Calculate the IGA revenue.

State Assistance:

Your town has a population of 147,000 residents. The state provides you a formula assistance of $2 per person. Calculate the state assistance.

Federal Assistance

Your town’s population is broken down by age as follows:

40,000 under age 18

80,000 between the ages of 18 and 65

27,000 over the age of 65

The federal government provides assistance in the amounts of $5,000 for every resident under age 18 and $3,500 for every resident over the age of 65. Calculate the federal assistance.

Grants:

Your town has received a grant to improve its water treatment plant. The grant is for $75,000,000 over five years to be used by the town to modernize your water treatment plant. Calculate the grant revenue for the next fiscal year.