Excel Templates

I just discovered a great way to have your own financial calculators that you can modify. For example, recently I have been struggling with the fact that I am paying off capitalized interest on my private student loan, which means that the whole payment is currently tax deductible. I had two options: pay off an extra $300/month on that loan or save that $300/month in a savings account.

Mathematically, it turns out that I should save $300/month in a savings account for the first 2 years and then pay off my student loan with those savings in the third year after I have paid off my capitalized interest. There is no way to run an amortization schedule where you can change the payment amount after 24 months and add a lump sump payment in the beginning of the third year. However, that and more can be done with Excel Templates.

I also like the fact that in an Excel template, you can save the worksheet and return to it when you feel like it. If you were to use the BankRate amortization schedule, for example, then you would have to reenter your data each time you wanted to change up your payment.

Excel templates offer amortization of payments, monthly and yearly budgets, expense trackers, net worth analyzers, gas and mileage logs, etc. New templates are added by users, so new ones can sprout up any time. Modify any of the templates to meet your specific needs.

Net Worth - The Millionaire Next Door

Some of you might have heard about the formula presented in the book - Millionaire Next Door by Stanley and Danko that determines your target net worth.

The formula looks like this: Target Net Worth = Your Age X Annual Pre-Tax Income / 10

However, everyone knows that after college, you most likely have a negative net worth. Therefore, many people have come up with their own formulas to compensate for that. Here is one I like by the author of the Simple Dollar Blog:

Target Net Worth = (Your Age – 27) X Annual Pre-Tax Income / 10

The second formula gets me a lot closer to my current net worth. It's off by $3K. The top formula places me about $90K off. 

NetWorth IQ

There are several ways to track your net worth. The most convenient for me, has thus far been Mint.com because it does everything automatically. However, another way to track your net worth is through NetWorth IQ. Here are it's advantages and disadvantages.

Disadvantages:

1. You must manually enter all your data
2. All other people's data is manually entered as well and might not be accurate for comparison
3. You must enter your data every month to see the progress

Advantages:

1. You can track your net worth with a graph
2. You can see the percentage change in each category
3. You can make your net worth public so other people can comment on your progress
4. Making your net worth public might motivate you to get that number up
5. You do not need to give out personal login information
6. You can compare your net worth to others your age, or in your occupation, for example
7. You can also compare each category such as student loan debt, credit card debt, or retirement assets to others in your demographic groups