Using Windows Assignment DUE TODAY
icy100
office_files.zipbudget.xlsx
Monthly College Budget
| Monthly | ||||||||||||||||
| University Budget | ||||||||||||||||
| september income: | september expenses: | september cash flow: | ||||||||||||||
| $1,725 | $2,446 | -$721 | ||||||||||||||
| JAN | Select First Budget Month | |||||||||||||||
| SEP | ||||||||||||||||
| Monthly Cash After Expense | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | % INC | ||
| Cash Flow | 169 | 69 | 192 | 199 | 204 | (771) | 124 | 154 | (721) | 109 | 34 | (61) | (299) | (41.8%) | ||
| Cumulative Cash Flow | 169 | 238 | 430 | 629 | 833 | 62 | 186 | 340 | (381) | (272) | (238) | (299) | ||||
| MONTHLY INCOME | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | % INC | ||
| Financial aid (grants, scholarships, loans) paid to you | - | - | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 7,500 | 43.5% | ||
| After-tax wages from a job | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 550 | 350 | 350 | 350 | 5,200 | 31.9% | ||
| Financial help from family | 200 | 200 | 1,000 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 4,550 | 20.3% | ||
| Withdrawals from savings | 500 | 350 | 150 | - | - | - | - | - | - | - | - | - | 1,000 | 0.0% | ||
| Other (child support, public assistance, gifts, etc.) | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 900 | 4.3% | ||
| TOTAL INCOME | 1,225 | 1,075 | 2,425 | 1,625 | 1,625 | 1,625 | 1,625 | 1,625 | 1,725 | 1,525 | 1,525 | 1,525 | 19,150 | 100.0% | ||
| MONTHLY EXPENSE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | % INC | ||
| Room & Board | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 565 | 6,780 | 23.1% | ||
| Rent, mortgage, or dorm room | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 315 | 3,780 | 12.9% | ||
| Food (groceries or meal plan) | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2,400 | 8.2% | ||
| Utilities (heat, water, electricity) | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 600 | 2.0% | ||
| Tuition & Fees | 0 | 0 | 750 | 0 | 0 | 650 | 0 | 0 | 650 | 0 | 0 | 0 | 2,050 | 26.6% | ||
| Tuition you pay | - | - | 500 | - | - | 500 | - | - | 500 | - | - | - | 1,500 | 20.4% | ||
| Fees you pay | - | - | 250 | - | - | 150 | - | - | 150 | - | - | - | 550 | 6.1% | ||
| Books & Supplies | 0 | 0 | 325 | 20 | 20 | 325 | 10 | 10 | 400 | 15 | 15 | 15 | 1,155 | 16.4% | ||
| Textbooks | - | - | 225 | - | - | 275 | - | - | 325 | - | - | - | 825 | 13.3% | ||
| School supplies | - | - | 100 | 20 | 20 | 50 | 10 | 10 | 75 | 15 | 15 | 15 | 330 | 3.1% | ||
| Transportation | 224 | 174 | 174 | 219 | 174 | 174 | 274 | 219 | 174 | 174 | 224 | 269 | 2,473 | 7.1% | ||
| Gas, maintenance | 30 | 30 | 30 | 75 | 30 | 30 | 30 | 75 | 30 | 30 | 30 | 75 | 495 | 1.2% | ||
| Vehicle payment | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 129 | 1,548 | 5.3% | ||
| Transit fares | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 180 | 0.6% | ||
| Travel at holidays | 50 | - | - | - | - | - | 100 | - | - | - | 50 | 50 | 250 | 0.0% | ||
| Discretionary | 69 | 69 | 169 | 369 | 419 | 444 | 419 | 419 | 394 | 394 | 419 | 469 | 4,053 | 16.1% | ||
| Savings | - | - | - | 50 | 100 | 100 | 100 | 100 | 75 | 75 | 100 | 100 | 800 | 3.1% | ||
| Cell phone, Internet, cable | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 69 | 828 | 2.8% | ||
| Donations | - | - | - | - | - | 25 | - | - | - | - | - | 50 | 75 | 0.0% | ||
| Snacks, dining out | - | - | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 1,000 | 4.1% | ||
| Clothes | - | - | - | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 450 | 2.0% | ||
| Entertainment (movies, dates, concerts) | - | - | - | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 900 | 4.1% | ||
| Other Expenses | 198 | 198 | 250 | 253 | 243 | 238 | 233 | 258 | 263 | 268 | 268 | 268 | 2,938 | 10.8% | ||
| Insurance (car, health, renter's) | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 123 | 1,476 | 5.0% | ||
| Loan, credit card payment | - | - | 52 | 55 | 45 | 40 | 35 | 60 | 65 | 70 | 70 | 70 | 562 | 2.7% | ||
| Other | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 900 | 3.1% | ||
| TOTAL EXPENSES | 1,056 | 1,006 | 2,233 | 1,426 | 1,421 | 2,396 | 1,501 | 1,471 | 2,446 | 1,416 | 1,491 | 1,586 | 19,449 | 100.0% |
financial aid wages (after-tax) family help from savings other 0.43478260869565216 0.3188405797101449 0.20289855072463769 0 4.3478260869565216E-2
room & board tuition & fees books & supplies transportation discretionary other expenses 0.23098937040065412 0.26573998364677026 0.16353229762878169 7.1136549468520036E-2 0.16107931316434995 0.10752248569092396
chart_calcs
| ***This sheet should remain HIDDEN*** | |||||||||||||||
| september | |||||||||||||||
| Dynamic Chart Titles | |||||||||||||||
| september income: | $1,725 | ||||||||||||||
| september expenses: | $2,446 | ||||||||||||||
| september cash flow: | -721 | -$721 | |||||||||||||
| jan | feb | mar | apr | may | jun | jul | aug | sep | oct | nov | dec | year | |||
| Scroll Bar Value: | 9 | ||||||||||||||
| Cash Flow Chart: | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ||
| Cumulative: | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | -721 | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ERROR:#N/A | ||
| INCOME CHART DATA | |||||||||||||||
| Financial aid (grants, scholarships, loans) paid to you | 43.5% | ||||||||||||||
| After tax wages from a job | 31.9% | ||||||||||||||
| Financial help from family | 20.3% | ||||||||||||||
| Withdrawals from savings | 0.0% | ||||||||||||||
| Other (child support, public assistance, gifts, etc.) | 4.3% | ||||||||||||||
Event Schedule Planner 2014.docx
Event Schedule Planner 2014 - 2015
|
|
|
||||
|
To replace placeholder text with your own, just click it and start typing. Want to try other colors for this planner? Check out the Colors gallery on the Design tab.
|
||||
|
|
|
|
|
EVENT SCHEDULE PLANN
ER
2014
-
2015
PROJECT/EVENT
PROJECT OR EVENT NAM
E
ORGANIZER
ORGANIZER’S NAME
To replace placeholder text with your own, just click it and start typing.
Want to try
other colors for this planner? Check out the Colors gallery on the
Design tab.
PROJECT PHASE
STARTING
ENDING
FROSH WEEK
9.1.2014
9.3.2014
FIRST WEEK OF LABS
9.11.2014
9.17.2014
PHASE 3
[Select Date]
[Select Date]
PHASE 4
[Select Date]
[Select Date]
PHASE 5
[Select Date]
[Select Date]
PHASE 6
[Select Date]
[Select Date]
[Select Date]
[Select Date]
PROJECT PHASE
STARTING
ENDING
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
[Select Date]
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
JANUARY
FEBRUARY
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
MARCH
APRIL
MAY
JUNE
JULY
AUGUST
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
S
M
T
W
T
F
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
EVENT SCHEDULE PLANNER 2014 - 2015
PROJECT/EVENT PROJECT OR EVENT NAME
ORGANIZER ORGANIZER’S NAME
To replace placeholder text with your own, just click it and start typing.
Want to try other colors for this planner? Check out the Colors gallery on the
Design tab.
PROJECT PHASE STARTING ENDING
FROSH WEEK
9.1.2014 9.3.2014
FIRST WEEK OF LABS
9.11.2014 9.17.2014
PHASE 3
[Select Date] [Select Date]
PHASE 4
[Select Date] [Select Date]
PHASE 5
[Select Date] [Select Date]
PHASE 6
[Select Date] [Select Date]
[Select Date] [Select Date]
PROJECT PHASE STARTING ENDING
[Select Date] [Select Date]
[Select Date] [Select Date]
[Select Date] [Select Date]
[Select Date] [Select Date]
[Select Date] [Select Date]
[Select Date] [Select Date]
[Select Date] [Select Date]
SEPTEMBER OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY
S M T W T F S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
S M T W T F S
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30
S M T W T F S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
S M T W T F S
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
MARCH APRIL MAY JUNE JULY AUGUST
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
S M T W T F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
S M T W T F S
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
S M T W T F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
S M T W T F S
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31
my_graduation.pptx
Album title
Subtitle of album
Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
