Finance Project

waqasnufast
Project1.xlsx

Sheet1

Actual Budget
Month 1 Month 2
Salary $ 4,000 $ 4,000
Students loan $ - 0 $ - 0
Scholarship proceeds $ 2,000 $ 2,000
Cash from Family $ 2,000 $ 2,000
Net Pay $ 8,000 $ 8,000
Expenses:
Housing-related Expenses:
Rent/Mortgage $ 2,200 $ 2,200
Utility – Electric $ 240 $ 240
Utility - Gas $ 190 $ 190
Cable/Internet $ 120 $ 120
Cell Phone $ 90 $ 90
Utility – Water $ 120 $ 120
Insurance (home or renters) $ 255 $ 255
Living Expenses:
Restaurant Meals $ 190 $ 190
Groceries $ 390 $ 390
Clothes $ 450 $ 450
Transportation - Monthly Pass $ 120 $ 120
Transportation - Gasoline $ 150 $ 150
Savings:
Contributions to savings plans $ 700 9% $ 940 12%
Contributions to retirement plans $ 400 5% $ 640 8%
Other:
Car Insurance $ 220 $ 220
Misc Expenses $ 400 $ 400 Expenses Includes random and impulse purchases; unused cash are save and accumulated for future use
Emergency expenses $ 300 Budgeted emergency expense for any kind of unexpected situation
Total Expenses $ 6,235 $ 7,015
Net savings in cash $ 1,765 $ 985

Sheet2

Sheet3