Saturday, December 15, 2007

Our Annual Budget for 2008

Here is our Annual Budget for 2008. I tried to do a link to my Excel Spreadsheet but couldn't make it work, so it is very difficult to read here. (If anyone knows how to link to a spreadsheet, please let me know! :) )

A few notes about our budget:
The Jan commission should be around $8,000 instead of the $6,000, I just didn't update that yet.
The vacation category is higher than I would like but my sister just got engaged and is planning a destination wedding in the Caribbean in the summer of '08, so I need to start saving now.
Our gifts budget is based on the actual birthdays and events that we need to buy for each month (as well as a shower and wedding gift for my sister). Our average birthday/holiday gift price is $20.
The Parties budget is for my 3 daughter's birthdays and our annual Halloween party.
The Blow money category has been increased to give my husband $50 per week. This was necessary to keep my husband on board. (He feels cheap when he can't go to lunch with his coworkers.) My blow money will remain at $20 per week.
The Commission category is a rough estimate and will be tweaked as the months get closer.



2008 Budget


EXPENSES Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
CASH - Clothing
$0 $0 $0 $300 $0 $0 $100 $100 $100 $0 $150 $0
CASH - Gifts
$50 $160 $0 $50 $210 $160 $60 $260 $20 $125 $1,285 $45
CASH - Food
$400 $400 $500 $400 $400 $500 $400 $400 $500 $400 $400 $500
CASH - Parties
$0 $0 $0 $0 $0 $0 $0 $0 $100 $50 $0 $50
CASH - Pizza
$ $80 $100 $80 $80 $100 $80 $80 $100 $80 $100 $80 $80
CASH - School Fees
$5 $5 $5 $5 $5 $0 $0 $0 $5 $5 $5 $5
CASH - School Lunch
$36 $36 $36 $36 $36 $0 $0 $0 $36 $36 $36 $36
CASH - Blow
$280 $280 $350 $280 $280 $350 $280 $280 $350 $280 $280 $350
DEBT - Chase Visa
$900 $900 $900 $900 $900 $0 $0 $0 $0 $0 $0 $0
DEBT - HELOQ
$200$200$200$200$200$1,100$1,100$1,100 $1,100 $1,100 $1,100 $1,100
HOME - Cbl/Ph
$181 $181 $181 $181 $181 $181 $181 $181 $181 $181 $181 $181
HOME - Elec
$220 $220 $187 $162 $160 $220 $220 $220 $190 $190 $190 $190
HOME - Maintenance
$25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
HOME - Mortg
$2,355$2,355$2,355$2,355$2,355$2,355$2,355$2,355$2,355$2,355$2,355$2,355
HOME - Oil
$350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
HOME - Trash
$0 $0 $65 $0 $0 $65 $0 $0 $65 $0 $0 $65
AUTO - Gas
$400 $400 $500 $400 $400 $500 $400 $400 $500 $400 $400 $500
AUTO - Insurance
$138 $138 $138 $138 $138 $138 $0 $0 $238 $138 $138 $138
AUTO - Maintenance
$25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $75
PERSONAL - Contacts
$0 $99 $0 $0 $99 $0 $0 $99 $0 $0 $99 $0
PERSONAL - Life Ins.
$0 $0 $256 $0 $0 $0 $0 $0 $0 $0 $0 $0
PERSONAL - Newspap
$8 $8 $8 $8 $8 $8 $8 $8 $8 $8 $8 $8
PERSONAL - Rx Aller
$20 $0 $0 $20 $0 $0 $20 $0 $0 $20 $0 $0
PERSONAL - Rx Prilosec
$0 $10 $0 $0 $10 $0 $0 $10 $0 $0 $10 $0
PERSONAL - Cell Ph
$0 $0 $50 $0 $0 $50 $0 $0 $50 $0 $0 $50
PERSONAL - Vacation
$500 $500 $500 $500 $500 $500 $100 $100 $0 $0 $0 $0
KIDS - Basketball
$240 $0 $0 $220 $0 $0 $0 $0 $335 $0 $0 $0
KIDS - Piano
$264 $0 $0 $0 $0 $0 $0 $264 $0 $0 $0 $0
KIDS - Preschool
$175 $175 $175 $175 $175 $175 $0 $0 $0 $0 $0 $0
KIDS - Misc. Fees
$0 $0 $40 $100 $0 $0 $0 $0 $125 $0 $0 $0
KIDS - Camp
$0 $0 $100 $0 $0 $260 $0 $0 $0 $0 $0 $0
MISCELLANEOUS
$25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
TOTAL -
$6,877$6,592$7,051$6,935$6,582$7,067$5,729$6,302$6,763$5,813$7,142$6,128


INCOME Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1st Check -
$2,276$2,276$2,276$2,276$2,276$2,276$2,276$2,276$2,276$2,276$2,276 $2,276
Commission
-$6,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000
15th Check
-$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200$2,200
Other - $0 $0 $6,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Church Check - $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Other - $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total -
$10,576$6,576$12,576$6,576$6,576$6,576$6,576$6,576$6,576$6,576$6,576 $6,576

CASH FLOW Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Begin Balance -
$0$3,699$3,683$9,208$8,849$8,843$8,352$9,199$9,473$9,286$10,049 $9,483
+ Income -
$10,576$6,576$12,576$6,576$6,576$6,576$6,576$6,576$6,576$6,576$6,576 $6,576
Sub-
$10,576$10,275$16,259$15,784$15,425$15,419$14,928$15,775$16,049$15,862$16,625$16,059 - Expens -
$6,877$6,592$7,051$6,935$6,582$7,067$5,729$6,302$6,763$5,813$7,142 $6,128
Sub-
$3,699$3,683$9,208$8,849$8,843$8,352$9,199$9,473 $9,286 $10,049 $9,483 $9,931
Save -
$3,699$3,683$9,208$8,849$8,843$8,352$9,199$9,473$9,286 $10,049 $9,483 $9,931
Ending Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0