Using spreadsheets to make money for depreciation

Spreadsheet calculations of depreciation can be intimidating when seen from afar, but once understood, can be very useful. A spreadsheet of depreciation or amortization good or a table in which are also known, can be useful to save money to inform you that your mortgage offer is best for you. They can also help you plan a strategy to pay off your mortgage ahead of time with the addition of a relatively small amount to your monthly payment.

This will free up investment capital in order to make money, a lot of money. In fact, now learn to build spreadsheets to depreciation. Then you will see how to use them to pay off your mortgage quickly and then parlay that investment in big-time money.

That to enter into a amortization calculator

Most spreadsheets depreciation are easy to build when you use a good site online amortization calculator. All you have to do is enter the total amount of the loan, the interest rate and loan term. Some calculators ask the length of amortization in years, others are calling for in recent months, for example, 360 months instead of 30 years.

After you click on the Calculate button you will see the spreadsheet amortization. You will notice the payment each month is divided into two parts, principal and interest. You'll also notice the part of the interest payment, at least in the first part of the loan, will be by far the highest number. This is because each of these payments are made first by more main interests. And 'this dynamic that we're going to use to save a lot of money.

An example of saving a lot of money

This method works with any mortgage, but for our purposes, we will use these fictitious numbers. We have a mortgage of $ 225,000. The interest rate is 7.25%, and the loan term is 30 years. When we enter these numbers in our amortization calculator, we find the monthly payment of $ 1,534.90.

When we look at the first payment on our spreadsheet, we see that this $ 1,534.90, $ 175.53 goes toward principal and $ 1,359.30 for interest. When we look we see the second payment, $ 176.59 goes toward principal and $ 1,358.31 will go towards interest.

If we pay the main part of the second payment, the $ 176.59 upfront, or at the very moment of the first payment, we will save $ 1,358.31 interest. Why save all this money? Because after we make our first payment, we will have a remaining balance of the mortgage of $ 224,824.48. The difference between the amount of interest we pay to borrow that amount of money for 359 months and 358 months is $ 1,358.31. So, paying $ 176.59 by paying the first month, we will now have to pay this loan in full in 358 months instead of 359. Yes, this is amazing!

Now, if we go down the line by paying the principal amount of the next payment is due, first time every month. We will save the equivalent cost of much higher interest.

It fills a bit 'more expensive.

Over time, the payments to obtain a greater and the main interest is lowered. Yet after two years, paying 24, the main one is only $ 201.61, and after six years, the 72nd of the capital payment is still $ 269.20.

If we stopped paying our principal payments later in this moment, we have thrown away three years time to pay the mortgage off in full. This would happen because we would have paid three years in time and three years ahead of time.

Payoff your mortgage in 30 years to 15 years

And if we want to pay your mortgage in 15 years? Here's the secret. Vai to pay 180. Here, you will see that the main part of the payment is $ 515.93. If we add this amount on each of our payments the first payment of our mortgage payment to 180 of our mortgage, the mortgage would be paid in full in 180 payments, or 15 years.

$ 515.93 may seem like a lot to pay in advance, but even if you were to take the main part of the payment the number 55, $ 243.00, and add it to any payment, you would have the mortgage paid over 10 years ago.

In summary, you can use this as an approximate formula: 30 years of a mortgage, add to each payment, the amount equal to the principal portion of the payment number 180 and you pay your mortgage in 15 years. Alternatively, add each payment, the amount equal to the principal portion of the payment number 55 and you get the mortgage paid in 20 years. Although this formula does not work very well for interest rates over 10%, for interest rates around 7%, is quite accurate. Now, let's see how to turn that savings into wealth.

Invest their savings

You could, of course, become a real estate investor, but for the sake of simplicity, let's say you invested $ 1,534.90 a month in a managed fund that returns 10% annually. After 10 years you would have $ 318,127.75. Also, do not forget that he had a house, which should be paid in full. I'd say you're close enough to be rich and it all started with learning how to use the spreadsheet amortization .......