Budget Analysis Exercise, writing homework help

User Generated

Qnaal_Gur_Ghgbe

Writing

Description

Everything is in the Excel File. Simple Budget Calculations. I dont have the notes i missed the class so it will be better if your good at the calculations. Thanks I will tip extra for good work.

Unformatted Attachment Preview

City of Omaha General Fund Budget 2008-2016 2008 Budget $ % of Total 2016 Budget $ Revenues Property Tax Motor Vehicle Tax Sales Tax Restaurant Tax Business Taxes Licenses and Permits Intergovernmental Revenues Service Charges Interest and Miscellaneous Prior Year Fund Balance TOTAL REVENUES 52.242.954 9.081.400 117.117.201 29.634.895 8.800.811 7.757.200 16.955.899 3.182.105 3.764.336 78.519.348 9.408.238 131.466.507 19.084.888 33.775.353 8.620.323 4.877.090 19.252.164 3.218.475 3.015.778 Expenditure Appropriations General Government Planning Parks and Recreation Fire Police Public Works Convention & Tourism Library Other Budgetary Accounts TOTAL APPROPRIATIONS 10.683.404 5.358.880 14.907.520 63.670.372 87.222.525 14.676.418 255.600 7.938.606 43.823.476 12.369.393 6.972.304 17.688.172 66.914.984 115.920.343 17.322.527 10.564.133 63.486.308 Notes: General Government includes Mayor, City Council, City Clerk, Law, Human Resources, Human Rights and Relations, and Finance. % of Total 2008-2016 Change $ Change % Change Other Budgetary Accounts includes Retiree Health Insurance, Workers' Compensation, County Jail, 911, Information Technology Services, Lease Payments, and Misc. Assignment: 1. Calculate total revenues and expenditures for each year. 2. Calculate each revenue source and expenditure category as a percentage of the total budget for each year (for example, property tax for 2008 = 52,242,954/total revenue * 100). 3. Calculate the amount change from 2008 to 2016 for each revenue source and expenditure, and for total revenues and expenditures (=2016 amount - 2008 amount). 4. Calculate the % change from 2008 to 2016 for each revenue source and expenditure, and for total revenues and expenditures (= amount change/2008 amount * 100). 5. Write a brief analysis (two-three paragraphs). This should include the total amount of the budget, how much it has changed over time, the major revenue sources and which have experienced the greatest change, the major expenditure categories and which have experienced the most change (be sure to include $'s and %'s in your discussion, do not talk generally).
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, I have attached the completed work below. I attached it in both Excel and Word file format so that you can use the one that suits you. I hope you find it satisfactory. Let me know if you need further help with it. Thanks.

City of Omaha General Fund Budget 2008-2016
2008 Budget

$

2016 Budget

% of Total

$

2008-2016 Change

% of Total

$ Change

% Change

Revenues
Property Tax
Motor Vehicle Tax
Sales Tax
Restaurant Tax
Business Taxes
Licenses and Permits
Intergovernmental Revenues
Service Charges
Interest and Miscellaneous
Prior Year Fund Balance
TOTAL REVENUES

52.242.954
9.081.400
117.117.201
29.634.895
8.800.811
7.757.200
16.955.899
3.182.105
3.764.336
248.536.801

21,02
3,65
47,12
0,00
11,92
3,54
3,12
6,82
1,28
1,51

78.519.348
9.408.238
131.466.507
19.084.888
33.775.353
8.620.323
4.877.090
19.252.164
3.218.475
3.015.778
311.238.164

25,23
3,02
42,24
6,13
10,85
2,77
1,57
6,19
1,03
0,97

26.276.394
326.838
14.349.306
19.084.888
4.140.458
(180.488)
(2.880.110)
2.296.265
36.370
(748.558)
62.701.363

50,30
3,60
12,25
100,00
13,97
-2,05
-37,13
13,54
1,14
-19,89
25,23

Expenditure Appropriations
General Government
Planning
Parks and Recreation
Fire
Police
Public Works
Convention & Tourism
Library
Other Budgetary Ac...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags