Daniel - Mgmt100-Monthly College Budget

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 1

MGMT100-N01152631

Monthly College Budget

Daniel Emmanuel Jathanna

Monthly
College Budget
year income:

year expenses:

###

year cash flow:

###

financial aid
wages (after-tax)
family help
from savings
other

$4,735

room & board

tuition & fees

books & supplies

transportation

discretionary

other expenses

october cash flow:

CASH FLOW
jan

feb

mar

apr

may

jun

jul

aug

sep

oct

nov

dec

year

JAN Select First Budget Month


#NAME?

Monthly Cash After Expense

JAN

#NAME?

#NAME?

Cash Flow

10,235

4,620

5,620

Cumulative Cash Flow

10,235

14,855

20,475

33,010

37,695

42,615

55,535

59,870

64,555

69,290

74,225

79,160

JAN

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

MONTHLY INCOME
Financial aid (grants, scholarships, loans) paid to you

After-tax wages from a job

Financial help from family

10,000.00 $ 3,000.00 $

Withdrawals from savings

9,200.00 $ 1,000.00 $

Other (child support, public assistance, gifts, etc.)

TOTAL INCOME

$ 19,700.00 $ 5,900.00

MONTHLY EXPENSE
Room & Board
Rent, mortgage, or dorm room

### $

$ 1,400.00 $

500.00

JAN
$

500.00 $

### $
$

#NAME?

12,535

1,400.00

#NAME?

#NAME?

4,685

4,920

### $

### $ 1,800.00 $ 1,800.00

3,000.00 $
1,000.00

2,000.00

#NAME?
12,920

$
$

10,000.00 $ 3,000.00 $ 3,000.00 $


9,200.00 $ 1,000.00 $ 1,000.00
500.00

### $

500.00

$
$

#NAME?

#NAME?

#NAME?

#NAME?

#NAME?

4,335

4,685

4,735

4,935

4,935

### $

1,800.00

### $ 1,800.00

$
$

10,000.00 $ 3,000.00 $ 3,000.00 $


9,200.00 $ 1,000.00 $ 1,000.00
500.00

### $

500.00

### $

1,800.00

1,000.00

500.00

79,160

### $ 1,800.00 $

10,000.00 $

YEAR

% INC
#NAME?

YEAR

% INC

#NAME?

18,600.00

#NAME?

### $

64,000.00

#NAME?

### $ 1,000.00 $

36,600.00

#NAME?

7,500.00

#NAME?

3,000.00

### $

500.00

7,400.00 $ 21,100.00 $ 6,300.00 $ 6,300.00 $ 21,500.00 $ 6,300.00 $ 6,300.00 $ 13,300.00 $ 6,300.00 $ 6,300.00 $ 126,700.00 #NAME?

#NAME?

500.00 $

500.00

#NAME?
$

#NAME?

#NAME?

#NAME?

#NAME?

500.00 $

500.00 $

500.00

500.00 $

#NAME?

500.00 $

500.00

#NAME?

#NAME?

500.00 $

YEAR

% INC

500.00 $

#NAME?
500.00

6,000.00

#NAME?

300.00

### $

300.00

### $

300.00 $

300.00

300.00

### $

300.00

300.00

### $

300.00

3,600.00

#NAME?

Food (groceries or meal plan)

150.00

### $

150.00

### $

150.00 $

150.00

150.00

### $

150.00

150.00

### $

150.00

1,800.00

#NAME?

Utilities (heat, water, electricity)

50.00

### $

50.00

### $

50.00 $

50.00 $

50.00

### $

50.00

50.00

### $

50.00 $

600.00

#NAME?

7,200.00 $

7,200.00 $

7,200.00

28,800.00

#NAME?

### $

7,200.00 $

15.00 $

15.00 $

Tuition & Fees


Tuition you pay

Fees you pay

7,200.00 $

Books & Supplies

### $

250.00 $

Textbooks

200.00 $

School supplies

50.00 $

15.00 $

120.00 $

Transportation

15.00 $
$

720.00 $

Gas, maintenance

### $

Vehicle payment

### $

Transit fares

120.00

Travel at holidays

600.00 $

Discretionary

### $
$

7,200.00 $
7,200.00 $

15.00 $

250.00 $

200.00

15.00 $

50.00 $

120.00 $

120.00

120.00 $

120.00
-

### $

120.00

### $
### $
120.00 $

15.00 $

### $

250.00 $

### $

200.00 $

### $

50.00 $

### $

15.00 $

720.00 $

120.00 $

### $

### $

120.00

### $

120.00

### $
$

600.00

120.00

7,200.00

### $

### $

120.00 $

### $

### $

120.00
-

120.00

120.00 $

### $
### $

120.00

#NAME?

810.00

#NAME?

600.00

#NAME?

210.00

#NAME?

2,640.00

#NAME?

#NAME?

28,800.00

120.00

#NAME?

#NAME?

1,440.00

#NAME?

1,200.00

#NAME?

745.00 $

595.00 $

1,095.00

695.00 $

695.00 $

695.00

695.00 $

695.00 $

695.00

695.00 $

695.00 $

695.00

8,690.00

#NAME?

Savings

500.00

### $

500.00

### $

500.00 $

500.00

500.00

### $

500.00

500.00

### $

500.00

6,000.00

#NAME?

Cell phone, Internet, cable

45.00

### $

45.00

### $

45.00 $

45.00 $

45.00

### $

45.00

45.00

### $

45.00 $

540.00

#NAME?

Donations

Snacks, dining out

Clothes

100.00 $

Entertainment (movies, dates, concerts)

50.00 $

50.00 $

Other Expenses

50.00

### $

### $

300.00 $

50.00

200.00 $

50.00 $

50.00 $

Insurance (car, health, renter's)

### $

Loan, credit card payment

### $

Other

TOTAL EXPENSES

For Professor: Jahnnis Pitty Del Cid

#NAME?

50.00

### $

9,465.00 $ 1,280.00

50.00

### $

50.00 $

50.00 $

50.00

1,780.00 $

### $

### $

### $

50.00 $

50.00

100.00 $

50.00 $

50.00 $

### $

### $

50.00

50.00

50.00 $

100.00 $

50.00

50.00 $

50.00 $

50.00 $

50.00

50.00

50.00 $

50.00 $

50.00 $

50.00

### $

### $

### $
### $
50.00 $

50.00 $

8,565.00 $ 1,615.00 $ 1,380.00 $

Printed:12/14/2016

50.00

### $

### $

### $

50.00 $

850.00

#NAME?

100.00 $

50.00 $

900.00

#NAME?

50.00 $

400.00

#NAME?

50.00 $

50.00 $

600.00

#NAME?

50.00 $

### $

50.00

8,580.00 $ 1,965.00 $ 1,615.00 $

50.00

### $

### $

50.00 $

8,565.00 $ 1,365.00 $ 1,365.00 $

#NAME?

#NAME?

#NAME?

600.00

#NAME?

47,540.00 #NAME?

You might also like