Personal Budget Exercise – Excel
Creating a spreadsheet track personal business expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2,500.
You will create a personal budget to demonstrate your ability to correctly create and format an Excel spreadsheet and incorporate appropriate formulas to provide a useful budgeting tool for personal financing. After completing your budget, you will answer 3 “critical thinking” questions about your budget.
Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories:
Housing (mortgage or rent)
Food
Utilities
Misc.
Car payment
Entertainment
Insurance
Gas
Student Loans
Savings
Note: All requirements must be met
Requirement
Points Allocated
Comments
Custom Header titled, “My Household Budget.”
0.25
This Custom Header text must be Arial 14 point, Bold, and be centered on the page.
Custom Footer with your name in the Right Section and automatic pagination in the Left Section.
0.25
Text format is Arial 10 point, Normal.
Enter column headings :
ITEM, MONTHLY BUDGET,
Months – January through December
0.25
All column headings must use the following text formatting:
Arial 10 point
Bold
Centered text in column
All capital letters
Set Page Layout to Landscape
0.25
Use Print Preview to review how spreadsheet would print.
Use your own personal budget categories or the list provided to set up the rows under ITEM.
0.25
Text format is Arial 10 point, Normal.
Align text Left in the cell.
Format all numeric for Currency, using two decimal places. If you have this set up correctly MS Excel will automatically insert a “$” in front of the amounts that you enter.
0.25
I will be able to tell if you simply typed in the “$.” This will…