While I’m a big fan of Mint.com and have used it for my budgeting for many years, it doesn’t let me project forward or perform what-if scenarios. What-if we take on a new car payment, or focus on paying off student loans before we pay off something else? This is where a budget spreadsheet can be handy.
But it can also be hard to know where to start. To that end, I have built you a Google Sheet that you can use to setup a 2 year projection in just a few minutes. Open it up, make a copy into your own Google Drive or download it to use with Excel or OpenOffice, and start putting in your numbers. The white cells are for you to edit, and the grey cells contain formulas. Note that the numbers in the white cells currently are just for example and should be deleted out.
Here are a few tips to make it even easier: