Thread by @iamcoriarnold

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

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

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

4. Add an Expense section

- 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

6. Create Charts for visuals

- 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

Watch this step-by-step video to create each template in Excel:

If you'd prefer to get the templates now, you can purchase them for $7.99 here:

iamcoriarnold.gumroad.com/l/ninsa