This spreadsheet measures your expenses against income to calculate your savings and investing percentage, as well as how much money will be left over at the end of the year. It also takes taxes into consideration for a better prediction. I like using this sheet to see what expenses I can lower or eliminate to be able to afford more into my investing or savings accounts.
If you are trying to target a specific save percentage for example, you can test changing the values on different blue boxes (cells in column B) and the formula will automatically update with the new data. Keep altering values until you get the desired target outcome. Just make sure your final total remains in the positives. Once it turns negative, it means you don’t have enough to afford all activities (expenses, investing, saving, etc) for the given values in the blue boxes.
Thanks for all of your positive feedback. Let me know if you have any questions or need any help with these spreadsheets. Or if you have any ideas for improvement or new sheets.