Excel: The Federal Budget Process Assignment

EXCEL: THE FEDERAL BUDGET PROCESS ASSIGNMENT INSTRUCTIONS

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 reading Module 3: Week 3, in Chen in the Budget Tools textbook, go to page 44, complete
the following assignment:
 Using an Excel spreadsheet, complete all portions of questions 1–3.
 You need to create a new Excel file for this assignment.
 Use formulas to calculate each question. You may use separate tabs for each question.
 Submit the Excel file when complete.

There are tutorials on how to use Excel in the back of the Budget Tools textbook. Navigate to the
Appendix- page 271. Additionally, for those who are less familiar with Excel- there are tutorials in the back of the Budget Tools book. Additionally, there are several basic excel tutorial videos
on YouTube and other Internet sites

Last Completed Projects