microsoft office assignments

Lastname_Firstname_e02_Revenue.xlsx

Income Tax

10.2%

Water

9.9%

Sales Tax

13.8%

Utility Tax

2.8%

Transfers

8.3%

Property Tax

22.0%

Non-Tax Revenue

19.8% Other Local Taxes

13.1%

Aspen Falls Projected 1st Quarter Revenue

Utility taxes have decreased and should

no longer be a burden on the taxpayers

Page 1 of 2 e02_Revenue_ann_solution.pdf

Revenue January February March Quarter Total

Percent of

Quarter

Revenue

Income Tax 218,000$ 210,000$ 205,000$ 633,000$ 10.2%

Water 113,000 225,000 275,000 613,000 9.9%

Sales Tax 283,000 285,000 290,000 858,000 13.8%

Utility Tax 56,000 57,000 58,000 171,000 2.8%

Transfers 170,000 172,000 174,000 516,000 8.3%

Property Tax 453,000 455,000 457,000 1,365,000 22.0%

Non-Tax Revenue 405,000 410,000 415,000 1,230,000 19.8%

Other Local Taxes 268,000 270,000 275,000 813,000 13.1%

Total Revenue 1,966,000$ 2,084,000$ 2,149,000$ 6,199,000$

Projected 1st Quarter Revenue

$- $50,000

$100,000 $150,000 $200,000 $250,000

$300,000

$350,000

$400,000

$450,000

$500,000

Revenue Sources

Projected 1st Quarter Revenue

January February March

Lastname_Firstname_e02_Revenue Page 2 of 2 e02_Revenue_ann_solution.pdf