Our free mortgage calculator Excel is a powerful all-in-one-sheet, which combines many of the features of our other mortgages and calculator. You can use a variable-rate mortgage - or a rate mortgage fixed to analyze and discover how much you can save with extra payments. It allows you to enjoy the full refund (including insurance and interest rates), but if you want to calculate other monthly expenses of home ownership, you may try our fresh House calculator. Discover our other spreadsheets of mortgage and let us know if you need something that we don't know. This Excel worksheet is an all-in-one home mortgage calculator. Analysis of fixed or variable interest mortgage rate, you can. You can define special regular payments or manually add additional payments in the payment plan. The worksheet for other lengths of time, rate, allows to compare the amounts of loans and savings with additional payments. Calculate yields, the rest of the debt at the end of a certain number of years and tax if the interest is tax deductible. Old version 3: screenshot 1. Warning: We believe that the estimates presented in the table is correct, but we guarantee the results. Because of their personal financial situation is unique, we recommend that you consult with your financial advisors, accountants and Bank first of all the financial decisions. Information about the use of our free mortgage calculator and some definitions are included as comments in the table. Then, if you have any questions, can move the mouse pointer to a cell has a small red triangle in the corner. This mortgage calculator can be safe to answer the following questions: there are two ways to analyze your existing mortgage. The first is the initial amount of the loan and the date, and then change the history of the payment in the payment plan as required. This is the simplest solution, then we have added a new feature to the section of payments vertex42 loan amortization schedule (at the suggestion of our users), however, additional payments at the beginning. Beginning of payments in payment 25 number, so if you've already made payments for a few years, may have planned additional. The second approach is, give your mortgage balance and adjust the length of time until the payment of intellectual property is the same thing, what it currently pays. Please note that if you pay monthly, you can enter a fraction of the year by entering a value = 10 + 5/12 (for 10 years and 5 months) how,. .