Week 5 project

profileyolandacody
BudgetProject.xlsx

Budget Worksheet

Monthly Income January February March
Tom $ 1,000 $ 1,000 $ 1,000
Sally $ 1,900 $ 2,000 $ 1,975
Monthly Income $ 2,900 $ 3,000 $ 2,975
Expenses January February March
Rent/Utilities $ 1,000 $ 1,000 $ 1,000
Food $ 600 $ 750 $ 500
Car/Gas $ 225 $ 250 $ 300
Entertainment/Gifts $ 75 $ 100 $ 45
Cell Phone $ 60 $ 60 $ 60
Credit Card $ 150 $ 125 $ 100
Insurance $ 88 $ 88 $ 88
Internet/TV $ 60 $ 60 $ 60
Grooming/Health $ 200 $ 200 $ 200
Savings $ 100 $ 100 $ 100
Miscellaneous $ 200 $ 100 $ 400
Monthly Expenses $ 2,758 $ 2,833 $ 2,853
Monthly Income $ 2,900 $ 3,000 $ 2,975
Monthly Expenses $ 2,758 $ 2,833 $ 2,853
Net $ 142 $ 167 $ 122

Chart comparing Expenses

My Monthly Budget

January Rent/Utilities Food Car/Gas Entertainment/Gifts Cell Phone Credit Card Insurance Internet/TV Grooming/Health Savings Miscellaneous 1000 600 225 75 60 150 88 60 200 100 200 February Rent/Utilities Food Car/Gas Entertainment/Gifts Cell Phone Credit Card Insurance Internet/TV Grooming/Health Savings Miscellaneous 1000 750 250 100 60 125 88 60 200 100 100 March Rent/Utilities Food Car/Gas Entertainment/Gifts Cell Phone Credit Card Insurance Internet/TV Grooming/Health Savings Miscellaneous 1000 500 300 45 60 100 88 60 200 100 400

Changes in Budget

Monthly Income January February March
Tom $ 1,000 $ 1,000 $ 1,000
Sally $ 1,900 $ 2,000 $ 2,175
Monthly Income $ 2,900 $ 3,000 $ 3,175
Expenses January February March
Rent/Utilities $ 1,000 $ 1,000 $ 925
Food $ 600 $ 750 $ 500
Car/Gas $ 225 $ 250 $ 300
Entertainment/Gifts $ 75 $ 100 $ 45
Cell Phone $ 60 $ 60 $ 60
Credit Card $ 150 $ 125 $ 100
Insurance $ 88 $ 88 $ 88
Internet/TV $ 60 $ 60 $ 60
Grooming/Health $ 200 $ 200 $ 200
Savings $ 100 $ 100 $ 100
Miscellaneous $ 200 $ 100 $ 400
Monthly Expenses $ 2,758 $ 2,833 $ 2,778
Monthly Income $ 2,900 $ 3,000 $ 3,175
Monthly Expenses $ 2,758 $ 2,833 $ 2,778
Net $ 142 $ 167 $ 397