budget plan

mariya92
Budgetplan.xlsx

Sheet1

income Jan Feb March April May June July August Sept October November Dec Total
salary/wage 1 $205 $205 $205 $205 $205 $205 $205 $205 $205 $205 $205 $205 $2,460
salary/wage 2 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220 $220 $2,640
Total income $425 $425 $425 $425 $425 $425 $425 $425 $425 $425 $425 $425 $5,100
Expenses:
tranportation
car insurance $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $180
fuel $29 $29 $29 $29 $29 $29 $29 $29 $29 $29 $29 $29 $348
others $11 $24 $35
subtotal $55 $44 $44 $44 $44 $44 $44 $44 $44 $44 $44 $68 $563
Home:
Mortgage/Rent $61 $61 $61 $61 $61 $61 $61 $61 $61 $61 $61 $61 $732
Household supplies $10 $10
Groceries $21 $23 $44
others $9 $7 $16
subtotal $101 $61 $68 $61 $61 $61 $61 $61 $61 $61 $61 $84 $802
utilities
gas/electricity $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $21 $252
water $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $168
subtotal $35 $35 $35 $35 $35 $35 $35 $35 $35 $35 $35 $35 $420
Health:
Medical $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $240
Healtth insurance $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $14 $168
others $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $72
subtotal $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $480
Educational:
tuition fee $75 $67 $47 $0 $70 $59 $35 $0 $55 $7 $0 $0 $415
books $16 $16 $32
subtotal $91 $67 $47 $0 $70 $59 $35 $0 $55 $7 $16 $0 $447
loans:
repayment
car loan $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $240
credit cards $19 $19 $19 $19 $19 $19 $19 $19 $19 $19 $19 $19 $228
subtotal $39 $39 $39 $39 $39 $39 $39 $39 $39 $39 $39 $39 $468
savings:
emergency $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $660
kids college $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $720
retirement $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $540
subtotal $160 $160 $160 $160 $160 $160 $160 $160 $160 $160 $160 $160 $1,920
Total Expenses $521 $446 $433 $379 $449 $438 $414 $379 $434 $386 $395 $426 $5,100