"Eye opening, and relieving."
How I did it: On excel, I have several columns, in this order:
- Date
- Earn
- Spend
- Checking
- Savings
- Reason
My overall budget as of now is for 2013, so I can get the big picture of how my money can be used. I entered in my paycheck for every other Friday. I located all of my bills (rent/utilities, phone, insurance, credit card, savings account transfer [~10% of my monthly income], student loans***) and entered in their costs on their respective due dates. This gives me a good picture of how much money I have right before my next pay check, and how much I would be able to spend on other items.
Next, I approximated how much money I needed for the essentials: gas and food. I have allotted myself $100/mo on gas, and $150/mo for food. To be honest, this may fluctuate as I get a better picture of my average spending. So I've been TRACKING MY BANK ACCOUNT to get a better idea of what this may change to.
Because we all need to get out, I know I need to consider money for "fun" items. However, I have decided to make credit card payments largely above the minimum, which helps quickly eliminate accrued interest. My fun endeavors (bowling, night out on the town, movies, etc.) are filed under "credit card" at the moment. Again, this may change.
Additionally, I have considered big costs (upcoming oral surgery, hope to buy a puppy, live-in boyfriend's birthday present) and added them to my spreadsheet.
All the above should generally cover the year's worth of expenses, with some expected fluctuation.
***My biggest struggle right now are my student loans. Interest on my few private loans are obscene (8.25-10.625%) so paying the minimum monthly bill barely tackles the principal loan. Additionally, payments are scheduled to make the payments last anywhere from 8-20 years, depending on which loan I'm looking at. If I paid only minimum payments, I would end up paying $40,000 in interest alone; this is ADDITIONAL money I'm being charged just because I had to borrow large sums for an education.
Once I saw how much money I would accumulate after ALL my aforementioned costs, I was able to up how much money went to student loans (~$590 to $1000). The snowball will be applied to the loan with the highest interest, and work its way down as everything gets paid off. I used
a Vertex excel spreadsheet to figure this out.
Whether or not a loan is paid off, I will still apply $1000 to my loans each month. The spreadsheet can work this out for you.
With my higher payments, the total amount of interest I'll end up paying is now ~$7,000, and my first loan will disappear by August. This has been reflected in my budget overview.
Lessons & tips:
- Use excel and understand basic functions, mostly just adding and subtracting cells. However, it's resourceful to know other functions. For example, you can use conditional formatting to better see when your money will be tighter. If/then statements are also helpful when you think you can pay off a debt. Once you finished paying it off, excel can be programmed to remove it from future dates and the money can be applied elsewhere.
- For debt, use the Vertex spreadsheets mentioned above.
- NEVER PAY JUST MINIMUM PAYMENTS. For me, it works out to pay significantly more on my highest interest loan at the moment. Maybe it will be better for you to attack the principal amount of the largest loan. Just make sure that your biggest obstacle is being paid off with as much money as you can spare.
- In that same breath, if this budget is made because of money issues, be prepared to cut costs. For me, it's eating out less
- It's perfectly fine to set money aside for fun, life is stressful sometimes. This budget was largely to ensure I could LIVE WITHIN MY MEANS (issue number one for ANYONE that needs to budget) and address my financial issues.
Resources:
- Microsoft Excel
- Vertex42
- Enjoying math (I'm an engineer, I seriously loved optimizing numbers)
For real though, if anyone is ever willing to divulge their income/required payments to me (just numbers, nothing I could do with it) I would be more than happy to make a budget for you. I seriously enjoyed it, it was satisfying seeing that I can pay off $45,000 in loans in 4 years, all while still saving money and going out sometimes.
2 people found this helpful
Jan 17, 07:38AM PST
| 4 comments
| 15 cheers