Journal BUS 629
RANBABY
PersonalBudgetTemplate.xlsxJanuary
| Directions for the workbook: Enter your financial information in the monthly income and expense (housing costs, automobile costs, loans, savings, entertainment costs, personal expeneses, and miscellaneous) cells. Enter amounts for your projected monthly income and total projected costs cells. The total cells as well as the Total Projected Income, Total Projected Expenses, and Difference cells will automatically calculate for you. After you have entered financial information for two months, view the YTD Budget sheet to view a yearly projection of your personal budget. | |||
| January | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of January worksheet | |
February
| February | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of February worksheet | |
March
| March | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of March worksheet | |
April
| April | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of April worksheet | |
May
| May | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of May worksheet | |
June
| June | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of June worksheet | |
July
| July | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of July worksheet | |
August
| August | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of August worksheet | |
September
| September | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of September worksheet | |
October
| October | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of October worksheet | |
November
| November | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of November worksheet | |
December
| December | |||
| Total Projected Income | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of December worksheet | |
YTD Budget
| Year-To-Date Monthly Budget | |||
| See Individual Months Below | Total Projected Expenses | Difference | |
| $0.00 | $0.00 | $0.00 | |
| Monthly Income | Projected Monthly Income | ||
| Income 1 | |||
| Income 2 | |||
| Income 3 | |||
| Income 4 | |||
| Income 5 | |||
| Income 6 | |||
| Total | 0.00 | ||
| Housing Costs | Total Projected Cost | Automobile Costs | Total Projected Cost |
| Mortgage | Auto 1 | ||
| Rent | Auto 2 | ||
| Electric | Taxi | ||
| Gas | Gas | ||
| Water | Insurance | ||
| Internet | License | ||
| Cable | Maintenance | ||
| Phone | Car Wash | ||
| Security | Radio Subscription | ||
| Insurance | Other | ||
| Groceries | Other | ||
| Total | 0.00 | Total | 0.00 |
| Loans | Total Projected Cost | Savings | Total Projected Cost |
| Credit Card | Savings account | ||
| Credit Card | 401K | ||
| Personal loan | Investments | ||
| Student loans | Other | ||
| Total | 0.00 | Total | 0.00 |
| Entertainment Costs | Total Projected Cost | Personal Expenses | Total Projected Cost |
| Dinner | Clothing | ||
| Movie Theater | Child Care | ||
| Sporting Events | Prescriptions | ||
| Rent Movies | Medical | ||
| Buy Movies | Dental | ||
| CD's | Other | ||
| Total | 0.00 | Total | 0.00 |
| Miscellaneous | Total Projected Cost | ||
| Dog Food | |||
| Vet | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Add miscellensous item | |||
| Total | 0.00 | End of YTD Budget worksheet and end of workbook | |
