I am paying off my mortgage in six years instead of 30.

I am paying off my mortgage in six years instead of 30. And as a CPA, Excel is my best friend. And today I'm going to show you a step by step tutorial on how I built my loan amortization schedule that tracks every extra principal payment that I make and how much interest it actually saves me. You have Excel open. You're going to go to File, New, and Excel actually creates all of these templates for you. They are pre-made templates for people to use. And they have things like invoice schedules, budgets, a bunch of different things. But the one that I use most is the loan amortization schedule. Because I've already used it before, it's going to be up here at the top. You're just going to click this and press Create. And Excel gives you a lot of great directions on how to use this. You see here, it tells you exactly what to type in to each cell and what each cell means. Now today, I'm just going to show an example of a mortgage. Let's say it's $200,000 with a 6% interest rate. Most mortgages are a 30 year period, so we're going to type that in here. Excel even gives the option to put in extra monthly payments, but for now, we're just going to make that cell zero. Now we're going to scroll all the way down to the bottom and make sure that we expand this chart so that the ending balance is zero. Go back up, this is zero, and you can see that total interest on this loan is $231,000 on a $200,000 mortgage. You're paying an extra 231,000. I feel like everyone can benefit for seeing their numbers down on paper, and seeing these numbers go down, it's only going to help you visualize and help motivate you to pay off things faster. I'm sure you might need more help with this, so put your numbers in the comments. I want to help all of you build a schedule yourself.