| Create a Personal Monthly Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started. |
| Title of this worksheet is in cell at right. Next instruction is in cell A5. | Personal Monthly Budget |
| Projected Monthly Income label is in cell at right. Enter Income 1 in cell C5 and Extra Income in C6 to calculate Total monthly income in C7. Next instruction is in cell A7. | Projected Monthly Income | | | Projected Balance
(Projected income minus expenses) | | | $927.69 |
| | Income 1 | $6,800.00 |
| | Extra income | $400.00 | | Actual Balance
(Actual income minus expenses) | | | $1,686.86 |
| Projected Balance is auto calculated in cell H4, Actual Balance in H6, and Difference in H8. Next instruction is in cell A9. | Total monthly income | $7,200.00 |
| | | | | Difference
(Actual minus projected) | | | $759.17 |
| Actual Monthly Income label is in cell at right. Enter Income 1 in cell C10 and Extra Income in C11 to calculate Total monthly income in C12. Next instruction is in cell A14. | Actual Monthly Income |
| | Income 1 | $6,982.17 |
| | Extra income | $550.00 |
| | Total monthly income | $7,532.17 |
| | Housing | | | | | Entertainment |
| Enter details in Housing table starting in cell at right and in Entertainment table starting in cell G14. Next instruction is in cell A27. | 0 | Projected
Cost | Actual
Cost | Difference | | 0 | Projected
Cost | Actual
Cost | Difference |
| | Mortgage or rent | $1,955.00 | $1,955.00 | $0.00 | | Video/DVD | $0.00 | $0.00 | $0.00 |
| | Phone | $98.00 | $98.00 | $0.00 | | CDs | $0.00 | $0.00 | $0.00 |
| | Electricity | $200.00 | $207.00 | -$7.00 | | Movies | $0.00 | $0.00 | $0.00 |
| | Gas | $150.00 | $220.00 | -$70.00 | | Concerts | $0.00 | $0.00 | $0.00 |
| | Water and sewer | $100.00 | $112.00 | -$12.00 | | Sporting events | $0.00 | $0.00 | $0.00 |
| | Cable | $25.00 | $25.00 | $0.00 | | Live theater | $0.00 | $0.00 | $0.00 |
| | Waste removal | $10.00 | $10.00 | $0.00 | | Other | $0.00 | $0.00 | $0.00 |
| | Maintenance or repairs | $100.00 | $0.00 | $100.00 | | Other | $0.00 | $0.00 | $0.00 |
| | Supplies | $75.00 | $40.00 | $35.00 | | Other | $0.00 | $0.00 | $0.00 |
| | Other | $0.00 | $0.00 | $0.00 | | Subtotal | | | $0.00 |
| | Subtotal | | | $46.00 |
| | Transportation | | | | | Loans |
| | 0 | Projected
Cost | Actual
Cost | Difference | | 0 | Projected
Cost | Actual
Cost | Difference |
| Enter details in Transportation table starting in cell at right and in Loans table starting in cell G26. Next instruction is in cell A37. | Vehicle payment | $550.00 | $550.00 | $0.00 | | Personal | $0.00 | $0.00 | $0.00 |
| | Bus/taxi fare | $0.00 | $0.00 | $0.00 | | Student | $100.00 | $100.00 | $0.00 |
| | Insurance | $195.00 | $195.00 | $0.00 | | Credit card | $0.00 | $0.00 | $0.00 |
| | Licensing | $0.00 | $0.00 | $0.00 | | Credit card | $0.00 | $0.00 | $0.00 |
| | Fuel | $250.00 | $75.00 | $175.00 | | Credit card | $0.00 | $0.00 | $0.00 |
| | Maintenance | $0.00 | $0.00 | $0.00 | | Other | $0.00 | $0.00 | $0.00 |
| | Other | $100.00 | $0.00 | $100.00 | | Subtotal | | | $0.00 |
| | Subtotal | | | $275.00 |
| | Insurance | | | | | Taxes |
| | 0 | Projected
Cost | Actual
Cost | Difference | | 0 | Projected
Cost | Actual
Cost | Difference |
| | Home | $212.00 | $212.00 | $0.00 | | Federal | $176.31 | $176.31 | $0.00 |
| Enter details in Insurance table starting in cell at right and in Taxes table starting in cell G35. Next instruction is in cell A44. | Health | $0.00 | $0.00 | $0.00 | | State | $0.00 | $0.00 | $0.00 |
| | Life | $29.00 | $29.00 | $0.00 | | Local | $0.00 | $0.00 | $0.00 |
| | Other | $0.00 | $0.00 | $0.00 | | Other | | | $0.00 |
| | Subtotal | | | $0.00 | | Subtotal | | | $0.00 |
| | Food | | | | | Savings or Investments |
| | 0 | Projected
Cost | Actual
Cost | Difference | | 0 | Projected
Cost | Actual
Cost | Difference |
| | Groceries | $500.00 | $626.00 | -$126.00 | | Retirement account | $300.00 | $285.00 | $15.00 |
| | Dining out | $100.00 | $0.00 | $100.00 | | Investment account | $200.00 | $198.00 | $2.00 |
| Enter details in Food table starting in cell at right and in Savings table starting in cell G42. Next instruction is in cell A50. | Other | | | $0.00 | | Other | $250.00 | $250.00 | $0.00 |
| | Subtotal | | | -$26.00 | | Subtotal | | | $17.00 |
| | Pets | | | | | Gifts and Donations |
| | 0 | Projected
Cost | Actual
Cost | Difference | | 0 | Projected
Cost | Actual
Cost | Difference |
| | Food | | | $0.00 | | Charity 1 | $100.00 | $75.00 | $25.00 |
| | Medical | | | $0.00 | | Charity 2 | | | $0.00 |
| | Grooming | | | $0.00 | | Charity 3 | | | $0.00 |
| Enter details in Pets table starting in cell at right and in Gifts table starting in cell G48. Next instruction is in cell A58. | Toys | | | $0.00 | | Subtotal | | | $25.00 |
| | Other | | | $0.00 |
| | Subtotal | | | $0.00 |
| | Personal Care | | | | | Legal |
| | 0 | Projected
Cost | Actual
Cost | Difference | | LEGAL | Projected
Cost | Actual
Cost | Difference |
| | Medical | $0.00 | $0.00 | $0.00 | | Attorney | $0.00 | $0.00 | $0.00 |
| | Hair/nails | $250.00 | $195.00 | $55.00 | | Alimony | $0.00 | $0.00 | $0.00 |
| | Clothing | $150.00 | $115.00 | $35.00 | | Payments on lien or judgment | $0.00 | $0.00 | $0.00 |
| | Dry cleaning | $0.00 | $0.00 | $0.00 | | Other | | | $0.00 |
| | Health club | $97.00 | $97.00 | $0.00 | | Subtotal | | | $0.00 |
| | Organization dues or fees | $0.00 | $0.00 | $0.00 |
| | Other | | | $0.00 |
| | Subtotal | | | $90.00 |
| Enter details in Personal Care table starting in cell at right and in Legal table starting in cell G54. Next instruction is in cell A61. | | | | | | Total Projected Cost | | | $6,272.31 |
| | | | | | | Total Actual Cost | | | $5,845.31 |
| Total Projected Cost is auto calculated in cell J61, Total Actual Cost in J63, and Total Difference in J65. |
| | | | | | | Total Difference | | | $427.00 |
CollegeMe
budgetplan.xlsx
