Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each of the four revenues set an estimate for the 2020 budget. In order to make the estimate, examine the pattern of amount and

For each of the four revenues set an estimate for the 2020 budget. In order to make the estimate, examine the pattern of amount and percent change and the averages for each revenue (that you calculated in 1., above). See if there is a pattern of change to guide your job in establishing a budget estimate for 2020 (assume that you don't know that the COVID-19 pandemic was coming in 2020). Provide a one-sentence reason or logic for your 2020 estimate in the space available under each revenue.

Trend Report for City of Buffalo Budget Year Budget Estimate
2014 2015 2016 2017 2018 2019 Average Change 2020
Revenues
Utilities Gross Receipts Tax $8,578,707.00 $10,252,619.00 $7,597,549.00 $8,299,294.00 $7,748,401.00 $9,578,834.00 $8,675,900.67
Amout Change $1,673,912.00 -$2,655,070.00 $701,745.00 -$550,893.00 $1,830,433.00 $200,025.40
Percent Change 19.51% -25.90% 9.24% -6.64% 23.62% 4%
Reason for 2020 Estimate
State Aid, Revenue Sharing $173,285,233.00 $161,285,233.00 $161,285,233.00 $161,285,233.00 $161,527,752.00 $161,285,233.00 $163,325,652.83
Amout Change -$12,000,000.00 $0.00 $0.00 $242,519.00 -$242,519.00 -$2,400,000.00
Percent Change -7% 0% 0% 0% 0% -1%
Reason for 2020 Estimate
Sales Tax $75,464,896.00 $80,265,980.00 $81,958,947.00 $82,053,440.00 $84,916,124.00 $87,707,325.00 $82,061,118.67
Amout Change $4,801,084.00 $1,692,967.00 $94,493.00 $2,862,684.00 $2,791,201.00 $2,448,485.80
Percent Change 6% 2% 0% 3% 3% 3%
Reason for 2020 Estimate
Metered Water Sales $35,652,757.00 $34,652,165.00 $35,037,733.00 $35,438,769.00 $34,597,070.00 $39,017,861.00 $35,732,725.83
Amout Change -$1,000,592.00 $385,568.00 $401,036.00 -$841,699.00 $4,420,791.00 $673,020.80
Percent Change -3% 1% 1% -2% 13% 2%
Reason for 2020 Estimate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Behavioral Finance And Wealth Management

Authors: Michael M. Pompian

2nd Edition

1118014324, 978-1118014325

More Books

Students also viewed these Finance questions

Question

How appropriate is it to conduct additional research?

Answered: 1 week ago

Question

What information remains to be obtained?

Answered: 1 week ago