Learn how to create a budget template and net worth tracker in Excel in 6 easy steps below:
1. Start with your Net Worth
- create an assets section
- highlight input cells in yellow
- keep cells with formulas white/grey
- create an assets section
- highlight input cells in yellow
- keep cells with formulas white/grey
2. Add a Debt Tracker
- create enough rows to list all debts
- include your total balance & rate
- calculate your annual interest
Annual Interest = Rate x Total Balance
- create enough rows to list all debts
- include your total balance & rate
- calculate your annual interest
Annual Interest = Rate x Total Balance
3. Create the budget tracker
- add 4 columns for your budget
- 2 columns are for the budget
- 2 columns are for actuals
- start with income
- list all sources
- add 4 columns for your budget
- 2 columns are for the budget
- 2 columns are for actuals
- start with income
- list all sources
4. Add an Expense section
- add in the budget & actual columns
- add a SUMIF formula to the actuals
- link this to the Spending Tracker
- add in the budget & actual columns
- add a SUMIF formula to the actuals
- link this to the Spending Tracker
5. Copy these tabs
- copy 12 times to cover 1 year
- copy 24 times to cover 2 years
- copy 12 times to cover 1 year
- copy 24 times to cover 2 years
6. Create Charts for visuals
- see your progress
- look for trends
- customize
- see your progress
- look for trends
- customize
If you enjoyed this thread:
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
1. Follow me @iamcoriarnold for more of these
2. RT the first tweet to share this thread with your audience
Watch this step-by-step video to create each template in Excel:
youtu.be
youtu.be
If you'd prefer to get the templates now, you can purchase them for $7.99 here:
iamcoriarnold.gumroad.com
iamcoriarnold.gumroad.com
Loading suggestions...