Build a budget using a spreadsheet. Suppose you're a senior in high school and you need to continue to save for college tuition. You'll need to include income, expenses, and savings in your personal budget. Open a spreadsheet and follow these steps to populate your spreadsheet. Enter labels, Month, Projected Income, Estimated Expenses, and Savings in cells A2, B2, C2, and D2. Enter the months October through August in cells A3 through A13. Use a shortcut. Enter the following data for your income. Use the spreadsheet to calculate the totals for the following expenses. There is no need to label the type of expenses in the spreadsheet. Just add the numbers together and list as a lump sum for each month.
At the beginning of October, you had $5600 in your savings account. Enter a formula in column D to show the amount you have in savings each month. Assume all of the money that you don't spend goes into your savings account.
Estimate the answer and check the data and formulas.