Excel Case Study
My Household Budget
ITEM
MONTHLY BUDGET
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Item Total
Housing
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $12,000.00
Utilities
$250.00 $136.00 $146.00 $150.00 $142.00 $155.00 $270.00 $290.00 $267.00 $260.00 $210.00 $200.00 $200.00 $2,426.00
Car Payment
$300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,600.00
Insurance
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
Student Loans
$200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $2,400.00
Food
$200.00 $270.00 $210.00 $240.00 $150.00 $140.00 $145.00 $190.00 $200.00 $175.00 $145.00 $210.00 $240.00 $2,315.00
Misc.
$100.00 $120.00 $110.00 $220.00 $160.00 $140.00 $100.00
$80.00
$90.00 $110.00 $190.00
$90.00
$65.00 $1,475.00
Entertainment
$100.00
$65.00
$85.00 $115.00 $140.00 $160.00 $140.00
$90.00
$65.00
$85.00 $100.00
$75.00
$90.00 $1,210.00
Gas
$150.00 $110.00 $148.00 $166.00 $115.00 $177.00 $154.00 $126.00
$98.00 $134.00 $155.00 $187.00 $100.00 $1,670.00
Savings
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
Monthly Budget Total:
$2,500.00
Total Monthly Expense.
$2,401.00 $2,399.00 $2,591.00 $2,407.00 $2,472.00 $2,509.00 $2,476.00 $2,420.00 $2,464.00 $2,500.00 $2,462.00 $2,395.00 $29,496.00
Compare to Budget.
$99.00 $101.00
-$91.00
$93.00
$28.00
-$9.00
$24.00
$80.00
$36.00
$0.00
$38.00 $105.00
$504.00
$150.00
Average Expense
$1,000.00
$202.17
$300.00
$100.00
$200.00
$192.92
$122.92
$100.83
$139.17
$100.00
My Personal Budget
$100.00
Housing
$100.00
Utilities
$100.00
Car Payment
$200.00
$1,000.00
Insurance
Student Loans
$200.00
Food
$100.00
Misc.
$300.00
$250.00
Entertainment
Question 1. I would choose to make double payments for my Car
ITEM
MONTHLY BUDGET
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
Item Total
Housing
$1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $12,000.00
Utilities
$250.00 $136.00 $146.00 $150.00 $142.00 $155.00 $270.00 $290.00 $267.00 $260.00 $210.00 $200.00 $200.00 $2,426.00
Car Payment
$300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $3,600.00
Insurance
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
Student Loans
$200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $2,400.00
Food
$200.00 $270.00 $210.00 $240.00 $150.00 $140.00 $145.00 $190.00 $200.00 $175.00 $145.00 $210.00 $240.00 $2,315.00
Misc.
$100.00 $120.00 $110.00 $220.00 $160.00 $140.00 $100.00
$80.00
$90.00 $110.00 $190.00
$90.00
$65.00 $1,475.00
Entertainment
$100.00
$65.00
$85.00 $115.00 $140.00 $160.00 $140.00
$90.00
$65.00
$85.00 $100.00
$75.00
$90.00 $1,210.00
Gas
$150.00 $110.00 $148.00 $166.00 $115.00 $177.00 $154.00 $126.00
$98.00 $134.00 $155.00 $187.00 $100.00 $1,670.00
Savings
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
Monthly Budget Total:
$2,500.00
Total Monthly Expense.
$2,401.00 $2,399.00 $2,591.00 $2,407.00 $2,472.00 $2,509.00 $2,476.00 $2,420.00 $2,464.00 $2,500.00 $2,462.00 $2,395.00 $29,496.00
Compare to Budget.
$99.00 $101.00
-$91.00
$93.00
$28.00
-$9.00
$24.00
$80.00
$36.00
$0.00
$38.00 $105.00
$504.00
$150.00
Average Expense
$1,000.00
$202.17
$300.00
$100.00
$200.00
$192.92
$122.92
$100.83
$139.17
$100.00
My Personal Budget
$100.00
Housing
$100.00
Utilities
$100.00
Car Payment
$200.00
$1,000.00
Insurance
Student Loans
$200.00
Food
$100.00
Misc.
$300.00
$250.00
Entertainment
Question 1. I would choose to make double payments for my Car