143x Filetype XLSX File size 0.03 MB Source: www.lamission.edu
Sheet 1: Simple Budget
Simple Student Budget Worksheet | Start by entering your monthly (or weekly or biweekly) income. Including Financial aid. Then list your expenses. | ||||||||||
How much can I save? | Where do I want to put my savings? | ||||||||||
Income | |||||||||||
$3,450.00 | Savings | 40% | $160 | ← Choose how to divide up your savings. Fill in the % you would like to put towards each savings category (totaling 100%). You can change the labels the categories if necessary. | |||||||
Total Expenses | Emergency | 25% | $100 | $400 | |||||||
$3,050.00 | Debt Payoff | 20% | $80 | ||||||||
Total Savings | Other Goals | 15% | $60 | ||||||||
$400.00 | Total | 100% | $400 | ||||||||
http://www.vertex42.com/ExcelTemplates/simple-budget-worksheet.html | © 2013 Vertex42 LLC | ||||||||||
What are my expenses? | |||||||||||
description | amount | ||||||||||
Car | $300.00 | ← Enter your expenses | |||||||||
Rent | $1,200.00 | ||||||||||
Utilities | $100.00 | ||||||||||
School Debt | $200.00 | ||||||||||
Credit Cards | $500.00 | ||||||||||
Groceries | $400.00 | ||||||||||
Other | $350.00 | ||||||||||
Total Expenses | $3,050.00 |
HELP | ||
http://www.vertex42.com/ExcelTemplates/simple-budget-worksheet.html | © 2013-2014 Vertex42 LLC | |
Instructions | ||
1) | Decide whether the worksheet is going to represent a week, month, or two-period period. You may want this to match your pay period. | |
2) | Enter your Income in cell C4 | |
3) | List your expense categories in the table | |
4) | Enter the amount you will budget for each expense category | |
5) | Assuming you have money left over, choose how to divide up your savings. Fill in the % you would like to put towards each savings category (totaling 100%). You can change the labels for the savings categories. | |
When you are ready for something more advanced, visit Vertex42.com to find more budget spreadsheets and tools. | ||
Additional Help | ||
The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template. | ||
TEMPLATE | Vertex42.com: Money Management Template | |
TEMPLATE | Vertex42.com: Family Budget Planner | |
TIPS | Vertex42.com: Spreadsheet Tips Workbook | |
ARTICLE | Vertex42.com: How to Make a Budget with a Spreadsheet | |
ARTICLE | Vertex42.com: Budgeting Tips |
no reviews yet
Please Login to review.