ABCDGHIJKLMNOPQRSTUVWXYZ
1
Budgeting Workbook Intructions
2
This is an interactive budgeting tool designed to help you understand your Bill, One-Time Costs and Monthly Expenses, and How your Financial Resources will be factored into Budgeting. The Workbook will automatically calculate your personal details into the worksheets (All Years-Budget Breakdown and MD Y1)
3
The Grey cells with White font are formulas and the cells are protected (locked).
4
The Brown Cells with White Font are the areas that you should complete. (please pay attention to the notes on the right side)
5
The White Cells with Brown Font can be modified for exceptions (such as ASP tuition)
6
IMPORTANT NOTE: If you wish to Unprotect the Cells with Calculations, Go to Review Tab at top of worksheet, select Unprotect Sheet and type the password: budget
7
StepsInstructionsLink
8
Step 1Go to tab below: All Years - Budget Breakdown. Complete your expected/actual monthly costs (please note that we default the categories to the Allowable Cost of Attendance provided).
9
Step 2Go to tab below: Go to your specific MD Year, Tab MD Y1, MD Y2, MD Y3, MD Y4. The figures that you entered in Step 1 (Tab: All Years- BUdget Breakdown) will carry over into the MD YR tabs. In these tabs, you can enter the Financial Aid, Personal Resources and Wages into the Brown Cells as applicable. https://finaid.med.brown.edu/cost-attendance
10
Step 3Review the Bottom Overview: BUDGET BREAKDOWN BY MONTH in the Tab that corresponds with your academic year. For example, if you are in your second year, select MD Y2. If figures in row 64 (Personal Resources Balance By Month) are Red, this reflects the credit in your checking account that should be available. If Brown, this is your shortfall.https://finaid.med.brown.edu/financial-wellness/budgeting
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100