How to Make a Budget – Part 1

After years of hoping to find the “perfect” budget, the absence of money is still a constant struggle. A simple Google search will provide several guidelines to follow on building a budget, but these seem to always fall short, omitting major expenses or underestimating categories such as entertainment.

A few years ago my search for the “perfect” budget finally came to an end. With a strong background in Microsoft Excel, the decision was made (out of necessity) to write down all monthly expenses in a Microsoft Excel format. The result: the “(almost) perfect” budget! No budget is really perfect. They need flexibility to mold with the uncertainties life brings. However, if you follow the tips outlined below, you can come pretty dang close.

Here it is: How to Make a Budget!

Photo by @adiomanovic

Photo by: @adiomanovic

Step One: How Much Do You Have?

First, you need to figure out how much money you have. Sign up for online banking (only if its free), view your balances, count your cash, gather miscellaneous coins from under the couch cushions, car seats, and/or in the junk drawer. We need every liquid dollar you have counted and deposited into your checking account. We cannot proceed unless we know what we’re working with.

Step Two: How Much Do You Owe?

Now, go through the exact same scavenger hunt, but this time find every bill you have. All of them. Print out or write on a piece of paper every monthly recurring or one-time payment that’s owed all the way down to your Netflix subscription. You need to know the outstanding balance, day of the month it’s due, minimum monthly payment, and interest rate. Check my list below to make sure you aren’t missing one.

Common Bills

  1. Credit Cards (all of them)
  2. Store Charge Cards (these count too)
  3. Mortgage/Rent Payment
  4. Cable Bill (Comcast, Dish, Direct TV, Time Warner, Cox, etc.)
  5. Media Subscriptions (Netflix, Hulu, NBA All-Access Pass, etc.)
  6. Utility Bills (Water, Gas, Electric, Trash, Sewer, etc.)
  7. Car Payment(s)
  8. Insurance Bill (Car, Health, Life, ID Theft, Homeowners/Renters, etc.)
  9. Phone Bill (House and Cell)
  10. Gym Memberships
  11. Magazine Subscriptions
  12. Wine Club Membership
  13. Memberships (Union Dues, NRA, Other Work Subscriptions, etc.)
  14. Car Registration (Careful, this one’s annual but just as important)
  15. Home Security Systems
  16. Time Share Dues and Taxes
  17. Home Owner’s Association Dues
  18. Tuition Payments
  19. Back Taxes Owed
  20. Rental Property Expense

A lot, I know, but you are doing GREAT! Next, estimate payments made in any given month. If you use your credit cards a lot, perhaps this is the ideal time to look at what you’ve spent money on over the past month to help you out. Be thorough. Compile an average. If you have twelve months’ worth of data, add everything up in a given category and divide by twelve.

Common Expenses

  1. Babysitter
  2. Groceries
  3. Shopping
  4. Entertainment (Movies, Live Events, etc.)
  5. RedBox
  6. Dinners Out
  7. Bars
  8. Home Repairs
  9. Car Repairs

Now, let’s put all of this information in one place. Some will prefer pen and paper, but being as how we are in the 21st century, let’s just open a Microsoft Excel document. Sheet1 is where you’ll put your balance sheet. First create a list of assets in column A. Things like your house, your car, that signed baseball your grandpa gave you as a kid, etc. Then leave a few spaces and continue listing all your debts. This is the first list we created above: your mortgage, credit cards, tuition payments, car payments, etc.

How to Create a Budget

In column D, adjacent the assets listed in column A, list the true market value. If you don’t know, then run a quick google search. This number should be the “sell today” number. Sure someone is willing to pay $14,500 for your car because that’s what Kelley Blue Book says is the fair private party value, but you should put down the CarMax or trade-in number. Meaning, if you had to sell this today, what would it sell for. Next to each of your liabilities in column A, put the interest rates, minimum payments, and outstanding balances of each item (how much you owe) in columns B, C, and D, respectively.

How to Make a Budget

You should now have a complete balance sheet. Tally up your assets and tally up your liabilities. Subtract your liabilities from your assets. This is your net worth. If you sold everything you own and paid off everything you owe, this number represents how much cash you’d have left. It’s widely accepted that bigger is better in this scenario. Is it negative? Mine was. Mine was VERY negative. That’s OK. This just means you need to follow this blog and keep reading. Even if it’s positive, the goal of this blog is to grow this number.

Next on The Smart Money Maker!

Stay tuned. Next, it’s time to create your weekly budget. Click Here to find the second of two posts in this “How to Make a Budget” miniseries. Happy budgeting!

It's only fair to share...Share on Facebook4Tweet about this on TwitterShare on LinkedIn0Pin on Pinterest2Email this to someone

3 thoughts on “How to Make a Budget – Part 1

  1. Juan Hotchkiss

    I’ve learn some good stuff here. Certainly price bookmarking for revisiting. I wonder how so much attempt you put to make this sort of fantastic informative web site.

  2. JeaneHRolf

    Hey! Someone inside my Facebook group shared this
    website along with us therefore i came to look it over.
    I’m definitely enjoying the details. I’m bookmarking
    and will also be tweeting this to my followers! Terrific blog and excellent style and design.