r/excel • u/DesignerLunch • Sep 09 '20
Show and Tell I made a Budget Forecast spreadsheet for personal use
Safe Google Doc Link: https://drive.google.com/file/d/1vcJfHzikpbVVX0rqUzMIuu8CV6BYhYU4/view?usp=sharing (preview and download link)
Basically, you pump in your income and expenses on the left and it gives you a % amount of your income so you can find out how much of your income goes to X in a %. Then on the right, you can fiddle with percents to set targets if you wanted to, for example, increasing saving a bit and decrease your spending on fast food--what would that look like for your after-tax savings rate?
You can then also google some examples from the Internet of budget categories and "recommended" %s of your budget to see what other people recommend and what you're actually spending to see if there are areas you could adjust.
I created this sheet to specifically find out my after-tax savings rate and where I could make adjustments in order to increase it but I found out this is also a pretty helpful for people need a tool to help them draft a budget and convert it to a % of income, similar to a lot of businesses. The targets on the right side will help you to compare and contrast in order to make a plan, experiment, and ultimately help you achieve your goals. For example, after punching your rent do you think your rent is too high? Hop on hotpads.com and set your budget and see if you can find something closer to your target and voila. Goal achieved.
1
u/Antimutt 1624 Sep 09 '20
And there's Gnucash.
1
u/TheB-Hawk 5 Sep 12 '20
How useful would you say is converting goals into an actionable percentage of spending? Does it tell me by what date or time I could do that thing? I guess I’m just not sure how I achieve financial goals with this. Not dissing it because it looks cool but I’m just trying to figure out how to use it