Scribd
Upload
106 views1 page

Monthlycollegebudget

The document is a monthly budget for a college student for the month of January. It lists the student's income of $5,796 which includes financial aid and wages. It then lists expenses totaling $5,191 including $2,886 for tuition and fees, $860 for room and board, and $795 for discretionary expenses. The budget shows a January cash flow of $605 which is the amount left over after expenses are subtracted from income.

Uploaded by

api-455095596
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
106 views1 page

Monthlycollegebudget

The document is a monthly budget for a college student for the month of January. It lists the student's income of $5,796 which includes financial aid and wages. It then lists expenses totaling $5,191 including $2,886 for tuition and fees, $860 for room and board, and $795 for discretionary expenses. The budget shows a January cash flow of $605 which is the amount left over after expenses are subtracted from income.

Uploaded by

api-455095596
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Nikeya Ferrigon

MGMT100-0NA Workshop 8: Monthly College Budget


N01232778

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

$5,796 $5,191 $605

1 2 3 4 5

january cash flow:

CASH FLOW

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

JAN Select First Budget Month


JAN

Monthly Cash After Expense JAN #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? YEAR % INC
Cash Flow 605 (3,141) (1,355) (1,445) (1,525) (1,445) (1,875) (1,495) (1,805) (1,355) (1,805) (785) (17,426) 10.4%
Cumulative Cash Flow 605 (2,536) (3,891) (5,336) (6,861) (8,306) (10,181) (11,676) (13,481) (14,836) (16,641) (17,426)

MONTHLY INCOME JAN #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? YEAR % INC
Financial aid (grants, scholarships, loans) paid to you 5,246 - - - 3,498 - - - - - - - 8,744 90.5%
After-tax wages from a job 350 350 350 350 350 350 350 500 500 500 500 800 5,250 6.0%
Financial help from family 100 - 100 100 - 100 100 200 - - 100 300 1,100 1.7%
Withdrawals from savings - - - - - - - - - - - - 0 0.0%
Other (child support, public assistance, gifts, etc.) 100 300 100 150 250 80 - 350 - 150 150 600 2,230 1.7%
TOTAL INCOME 5,796 650 550 600 4,098 530 450 1,050 500 650 750 1,700 17,324 100.0%

MONTHLY EXPENSE JAN #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? YEAR % INC
Room & Board 860 860 860 660 860 860 910 910 910 970 970 970 10,600 16.6%
Rent, mortgage, or dorm room 160 160 160 160 160 160 160 160 160 160 160 160 1,920 3.1%
Food (groceries or meal plan) 350 350 350 150 350 350 400 400 400 460 460 460 4,480 6.7%
Utilities (heat, water, electricity) 350 350 350 350 350 350 350 350 350 350 350 350 4,200 6.7%

Tuition & Fees 2,886 0 0 0 3,498 0 0 0 0 0 0 0 6,384 55.6%


Tuition you pay 2,826 - - - 3,498 - - - - - - - 6,324 54.4%
Fees you pay 60 - - - - - - - - - - - 60 1.2%

Books & Supplies 180 1,616 80 0 0 0 0 0 0 0 0 0 1,876 3.5%


Textbooks 80 - - - - - - - - - - - 80 1.5%
School supplies 100 1,616 80 - - - - - - - - - 1,796 1.9%

Transportation 160 160 160 160 160 160 160 160 160 160 160 160 1,920 3.1%
Gas, maintenance - - - - - - - - - - - - 0 0.0%
Vehicle payment - - - - - - - - - - - - 0 0.0%
Transit fares 160 160 160 160 160 160 160 160 160 160 160 160 1,920 3.1%
Travel at holidays - - - - - - - - - - - - 0 0.0%

Discretionary 795 945 595 915 895 745 1,045 1,265 595 665 1,215 1,145 10,820 15.3%
Savings 50 50 50 50 50 50 50 50 50 50 50 50 600 1.0%
Cell phone, Internet, cable 45 45 45 45 45 45 45 45 45 45 45 45 540 0.9%
Donations - - - 20 - - - - - 20 20 20 80 0.0%
Snacks, dining out 250 300 250 250 250 250 250 350 250 250 350 250 3,250 4.8%
Clothes 150 150 - 150 250 100 350 460 - - 300 430 2,340 2.9%
Entertainment (movies, dates, concerts) 300 400 250 400 300 300 350 360 250 300 450 350 4,010 5.8%

Other Expenses 310 210 210 310 210 210 210 210 640 210 210 210 3,150 6.0%
Insurance (car, health, renter's) - - - - - - - - - - - - 0 0.0%
Loan, credit card payment 210 210 210 210 210 210 210 210 210 210 210 210 2,520 4.0%
Other 100 - - 100 - - - - 430 - - - 630 1.9%

TOTAL EXPENSES 5,191 3,791 1,905 2,045 5,623 1,975 2,325 2,545 2,305 2,005 2,555 2,485 34,750 100.0%

For Professor: Jahnnis Pitty Del Cid Printed 04/10/2019 Page 1 of 1

You might also like