Comprehensive Lending Guide Bookmark Site
click to download Budgeting Worksheet (MS Excel worksheet that calculates your running spend and cash position. Requires MS Excel or other spreadsheet to open: try excel viewer if you don't have Excel)
The worksheet is segmented into three sections:
Open file: college-budget.xls (MS Excel file should be downloaded to your desktop)
Move to the tab "Budget Worksheet" and enter all of the available or expected financial aid you will receive for the academic year (either Year 1, Year 2, etc.)
Enter available financial aid amounts for:
Understand that your fixed aid includes: — grants and scholarships — stafford student loans — PLUS loans — other one-time aid These aid positions are usually fixed and awarded only once each academic year. You are not likely going to get any more money from these sources during the year. Understand your variable aid sources include: — private student loans — work wages — other flexible aid These aid positions are "variable sources" meaning that you can turn to these aid sources if needed when your cash position becomes low.
This is important information to know when you manage your budget throughout the year.
Move to the tab "Budget Worksheet" and scroll down the worksheet to cell number: A30.
Now budget the expected costs for the academic year. Your college is required to send you costs upon acceptance of your application.
Make a best estimate on what you expect to spend for:
Understand that your fixed expenses, such as: — tuition and fees — monthly housing — monthly insurance payments — books are fixed expense -- meaning, that there is nothing you can do to cut these fees. Your financial aid must cover these expenses. Understand your flexible payments, such as: — food and home living supplies — clothing — transportation (fuel, repairs) — recreation and entertainment — travel home are "variable" expenses. These expenses can be reduced and in some cases eliminated in months where your cash position is low.
Move to the tab "Budget Worksheet" and scroll down the worksheet to cell number: A49.
This area shows any financing gap that you may have by subtracting the cost of education from total financial aid. If it shows a negative number, you need to 1 of 2 things:
You need to generate a positive cash position for the academic year.
Now it's time to view and manage your budget for the year.
Move to the tab "School Year 1 " (for students attending their first year, and so forth).
The worksheet has allocated your aid and expense budget by month. Your net cash position at the start of your academic year should be positive and equal to your total financial aid (since no money has been spent).
Now move down to Cell: A49
This section shows your budgeted costs allocated by month and by category. This is how much money you have to spend for each category during the academic year. As you start school, you will enter the total money spent under each month for each category.
For example, let's say your tuition bill for the year was $5,000 and paid in full in September. You will enter $5,000 in the "yellow" input cell under September for the category: Tuition and Fees (Cell: G55).
Since you budgeted $5,000 for tuition, the net annual spend position should be $0 (Cell D57). This means that your annual spend equals your budgeted expense. Any additional spend for tuition will put you in a negative spend position.
You must enter "actual spends" each month for each category. Your actual spends include credit card charges, cash payments, checks, and other. You need to keep tabs on everything you expense to make sure you stay within budget.
We have suggestions on how to manage and record your daily spend:
You need to watch the "your annual net spend position" for each category. It must remain at $0 or more. Anything less than $0 puts you in a negative cash position (based on your budget).
Unless you find additional aid or reduce other expenses, you will run out of money before your academic year is over.
That takes us back to our earlier discussion about "fixed" and "variable" financial aid and expenses.
Since most federal aid programs and scholarships are fixed, you are not likely going to find any additional aid from these sources.
Likewise, most tuition, room and board, books and fees are fixed expenses. You won't be able to reduce these expenses.
You will need to look at "variable" financial aid resources and "variable" expense items to bring your cash position back to positive:
If you find that cash is running low, you have the option of applying for Private Student Loans to help fill the gap.
You can borrow up to $30,000 each academic year and defer repayments until after you graduate. You can get the money in as little as 5 business day.
click for information about this aid source