MGMT100-ONB Workshop 8: Monthly College Budget Ian Daniels

Monthly
College Budget
year income: year expenses: year cash flow:

$36,600 $36,560 $40

financial aid room & board
tuition & fees
wages (after-tax)
books & supplies
family help
transportation
from savings
discretionary
other other expenses

year cash flow:

CASH FLOW

sep oct nov dec jan feb mar apr may jun jul aug year

SEP Select First Budget Month

YEAR

Monthly Cash After Expense SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG YEAR % INC
Cash Flow 130 130 130 530 (940) 130 (270) 130 130 80 130 (270) 40 0.1%
Cumulative Cash Flow 130 260 390 920 (20) 110 (160) (30) 100 180 310 40

MONTHLY INCOME SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG YEAR % INC
Financial aid (grants, scholarships, loans) paid to you - - - - - - - - - - - - 0 0.0%
After-tax wages from a job 2,600 2,600 2,600 3,000 2,600 2,600 2,600 2,600 2,600 2,600 2,600 2,600 31,600 86.3%
Financial help from family - - - - 2,600 - - 2,400 - - - - 5,000 13.7%
Withdrawals from savings - - - - - - - - - - - - 0 0.0%
Other (child support, public assistance, gifts, etc.) 0 0.0%
TOTAL INCOME 2,600 2,600 2,600 3,000 5,200 2,600 2,600 5,000 2,600 2,600 2,600 2,600 36,600 100.0%

MONTHLY EXPENSE SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG YEAR % INC
Room & Board 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 1,400 16,800 46.0%
Rent, mortgage, or dorm room 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 32.8%
Food (groceries or meal plan) 400 400 400 400 400 400 400 400 400 400 400 400 4,800 13.1%
Utilities (heat, water, electricity) - - - - - - - - - - - - 0 0.0%

Tuition & Fees 0 0 0 0 2,600 0 0 2,400 0 0 0 0 5,000 13.7%

Tuition you pay - - - - 2,600 - - 2,400 - - - - 5,000 13.7%
Fees you pay - - - - - - - - - - - - 0 0.0%

Books & Supplies 0 0 0 0 1,020 0 0 0 0 0 0 0 1,020 2.8%

Textbooks - - - - 220 - - - - - - - 220 0.6%
School supplies - - - - 800 - - - - - - - 800 2.2%

Transportation 400 400 400 400 450 400 400 400 400 450 400 400 4,900 13.4%
Gas, maintenance 150 150 150 150 200 150 150 150 150 200 150 150 1,900 5.2%
Vehicle payment 250 250 250 250 250 250 250 250 250 250 250 250 3,000 8.2%
Transit fares - - - - - - - - - - - - 0 0.0%
Travel at holidays - - - - - - - - - - - - 0 0.0%

Discretionary 550 550 550 550 550 550 950 550 550 550 550 950 7,400 20.2%
Savings 100 100 100 100 100 100 100 100 100 100 100 100 1,200 3.3%
Cell phone, Internet, cable 150 150 150 150 150 150 150 150 150 150 150 150 1,800 4.9%
Donations - - - - - - - - - - - - 0 0.0%
Snacks, dining out 100 100 100 100 100 100 100 100 100 100 100 100 1,200 3.3%
Clothes - - - - - - 400 - - - - 400 800 2.2%
Entertainment (movies, dates, concerts) 200 200 200 200 200 200 200 200 200 200 200 200 2,400 6.6%

Other Expenses 120 120 120 120 120 120 120 120 120 120 120 120 1,440 3.9%
Insurance (car, health, renter's) 120 120 120 120 120 120 120 120 120 120 120 120 1,440 3.9%
Loan, credit card payment - - - - - - - - - - - - 0 0.0%
Other - - - - - - - - - - - - 0 0.0%

TOTAL EXPENSES 2,470 2,470 2,470 2,470 6,140 2,470 2,870 4,870 2,470 2,520 2,470 2,870 36,560 100.0%

For Professor: Jahnnis Pitty Del Cid Printed Page 1 of 1