Blog

OVERVIEW
Students will complete a series of Excel spreadsheet assignments to aid
OVERVIEW
Students will complete a series of Excel spreadsheet assignments to aid in the development of
skills necessary to compile a public budget. Through these exercises’ students will demonstrate
practical budget skills, including conducting a break-even analysis, time value of money,
calculating fixed and variable costs, adjusting for inflation, and developing budget
scenarios. There is both a practical application of knowledge as well as the theory behind the
practices. Through these exercises’ students will understand the complexities of developing a
public budget.
INSTRUCTIONS
After completing the assigned reading in the Chen, Weikert, & Williams text, go to pages 50-5
and complete the following assignment using the provided spreadsheet titled, Excel: The Local
Government Budget Process Template. This document will be provided in the Excel: The
Local Government Budget Process Assignment page.
? Using the provided Excel spreadsheet, complete all portions of questions – 2.
? For Question #- ad

d text answers at the top of the spreadsheet.
? Complete Question #2- using formulas.
? Submit the Excel file when complete.
There are tutorials on how to use Excel in the back of the Chen, Weikert, & Williams textbook.
Navigate to the Appendix- page 27. Additionally, there are several basic excel tutorial videos on
YouTube and other Internet sites.
Template Sample:
Table 7.2 Lake City: Park
Gazebo Revenues and CPA
(984–202)
Rental
Year Revenue CPI
984 $3,366.55 03.933
985 $4,564.45 07.600
986 $5,487.57 09.692
987 $6,363.24 3.67
988 $7,6.30 8.275
989 $8,000.50 23.942
990 $8,379.25 30.658
99 $8,768.42 36.67
992 $9,026.90 40.308
993 $20,45.73 44.475
994 $2,099.88 48.225
995 $22,435.85 52.383
996 $23,575.86 56.858
997 $24,924.04 60.525
998 $26,636.09 63.008
999 $28,247. 66.583
2000 $29,829.2 72.92
200 $30,79.85 77.042
2002 $30,47.06 79.867
2003 $30,927.76 84.000
2004 $33,056.72 88.908
2005 $36,66.23 95.267
2006 $39,770.85 20.558
2007 $4,430.22 207.344
2008 $40,823.03 25.254
2009 $37,668.88 24.567
200 $36,647.82 28.085
20 $39,649.70 224.935
202 $40,892.75 229.604
Share this:
FacebookX