- Start by listing all items you can think of that you pay for every month in column A. Brainstorm monthly, semi-monthly, and annual dues as well. Don't spend a lot of time on this at this time.
- When you are finished, you may want to move items around in the list to place like items with like items, then skip to column E, title it 'Net Amount'. and then go down the list and write the approximate payments you make per increment. In this example life insurance is $41.28 per quarter, water is $60 every two months. If you know the actual payment, put that in but it's nothing to interrupt yourself to correct at this point.
- Go back and title column B 'Frequency', write the frequency of payment. (In the above examples, I'd say Quarterly and Bimonthly, but you might find that confusing because bimonthly means both twice per month and every other month. As you can see, I listed both in separate columns. I told you, 'control freak'!) So let's stick with digits so we can use that in our equations: how many times a year you are required to pay. In the above, 4 and 6, and if you want, add another column after that but before the Net Amount for the multiplication sign, and after for the divided by 12 instruction*
- Then title the next column 'Net Monthly', you will write a calculation multiplying the net amount by frequency and dividing into twelve to get a monthly amount. For water, it looks like this =C18*E18/12, where c18 is 6 (times a year) and e18 is 60 (the amount due each time I pay) divided by 12 (months).
- For the last column, 'Net Annually' I use =G18*12, which is the amount I just calculated multiplied (again) by 12 for the year.
*These notations are just for show. In Excel, which is spreadsheet software, you will need to preface actual commands with the equal sign. But if you want to show an actual equal sign you will need to enclose it in quotation marks like this: ="="
You can see the actual formulas by pressing CTRL + ` (grave accent--on my keyboard it is to the left of the "1"). Hit it again to return to the standard view.
What it looks like
Showing the Formulas