While most people know how much they need to make to cover their monthly bills, for me, it is not that easy. Maybe my brain just does not work that way or maybe our debt and income fluctuates too much. Either way, my mother came up with a brilliant, yet so simple way to "forecast" how much money you will have (or in my case, NOT have...haha) on any given day. All you need is a spreadsheet program, like Excel, and you can make up your own little "Money Forecast Calendar."
| CHECKING | ||||||||
| Mon | Tue | Wed | Thurs | Fri | Sat | Sun | ||
| 23 | 24 | 25 | 26 | 27 | 28 | 29 | ||
| Car 150.00 | Fuel 30.00 | |||||||
| ($150.00) | ($30.00) | |||||||
| $1,000.00 | $1,000.00 | $850.00 | $820.00 | $820.00 | $820.00 | $820.00 | ||
| Mon | Tue | Wed | Thurs | Fri | Sat | Sun | ||
| 30 | 31 | 1 | 2 | 3 | 4 | 5 | ||
| Phone 25.00 Ins 100.00 | Rent 550.00 | CC 100.00 | Tran 400.00 | |||||
| ($125.00) | ($550.00) | ($100.00) | $400.00 | |||||
| $820.00 | $695.00 | $145.00 | $45.00 | $45.00 | $445.00 | $445.00 | ||
So this is a little example of what my mom created, and I love using it!! If you look at the numbers I plugged in, you can see that after paying $100 for my credit card, I will have $45 until I get paid on Friday and make a transfer of $400. It is such a simple formula, but it can give you a look into the future to see where more money can be saved or spent. It has really helped me know much money I have to save for my upcoming bills and if I can afford that $10 trip to Dairy Queen. As for the yellow highlighting, that just helps me see what my current balance should be.
THANKS MOM!!


