Question

Project Household Budget

Document should be a Completed Excel spreadsheet.

Instructions: Utilizing an excel spreadsheet create a household budget showing 2 columns: 1) Monthly Budget and an 2)Annualized Budget.

To help you with this endeavor, there are numerous personal financial planning or budgeting tools available on the internet, many of them are free. You may either create a fictitious profile or use your own personal information. If you choose to use your personal data on one of the website budget tools, be sure to read the sites’ privacy policies.

Grading: Based on appropriate formatting utilized within excel, ease of flow of information, utilization of formulas when appropriate, does budget category/line items make sense, and were all items that tend to impact a budget for an average household accounted for.

Answer 1

Sample household budget and its items segregated which can be used are:

Personal and Family Expenses
Category	Monthly Budget
	Current	Yearly
Alimony	$      576	$     6,914.75
Bank Charges	$        10	$        120.00
Books/Magazines	$        20	$        240.00
Business Expense	$   1,152	$   13,829.50
Care of Parent/Other	$      934	$   11,207.60
Cash — Miscellaneous	$   1,200	$   14,400.00
Cell Phone	$        15	$        180.00
Charitable Donations	$      100	$     1,200.00
Child Activities	$      150	$     1,800.00
Child Allowance/Expense	$      200	$     2,400.00
Child Care	$      150	$     1,800.00
Child Support	$      100	$     1,200.00
Child school help	$      450	$     5,400.00
Clothing — Client	$        50	$        600.00
Clothing — Co-Client	$        55	$        660.00
Clothing — Children	$        50	$        600.00
Club Dues	$      100	$     1,200.00
Credit Card Debt	$   1,500	$   18,000.00
Dining	$      600	$     7,200.00
Entertainment	$      200	$     2,400.00
Gifts	$        50	$        600.00
Groceries	$      250	$     3,000.00
Health Care - Dental	$        10	$        120.00
Health Care - Medical	$        50	$        600.00
Health Care - Prescription	$        50	$        600.00
Hobbies	$      100	$     1,200.00
Household Items	$      600	$     7,200.00
Laundry/Dry Cleaning	$      100	$     1,200.00
Personal Care	$      100	$     1,200.00
Personal Loan Payment	$      150	$     1,800.00
Pet Care	$         -	$                -
Public Transportation	$        25	$        300.00
Recreation	$      200	$     2,400.00
Self Improvement	$        50	$        600.00
Student Loan	$      600	$     7,200.00
Vacation/Travel	$   1,000	$   12,000.00
Other:	$      577	$     6,924.00
	$ 11,525	$ 138,295.00