Our free loan calculator Excel is a powerful tool for all-in-one with spreadsheet Excel that combines many of the features of our other calculators for mortgages and loans. Parses a variable - rate of interest or a fixed rate mortgage and understand how much you can save by additional payments. It provides the full mortgage payment (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 mortgage other leaves and let us know if you need something that we don't know. This Excel worksheet is an all-in-one mortgage loan calculator. Discusses a fixed rate or variable mortgage. You can define other periodical payments, or manually add additional payments in the payment plan. Use the worksheet, lengths of time, price, volume of compare loans and economies, additional payments. It also calculates the balance at the end of a certain number of years and tax, pay the interest is tax deductible. 1 3 old version: screenshot. Warning: We believe that the estimates in the table is correct, but we cannot guarantee the results. Because of their personal financial situation is unique, you should probably consult their institutions, accounting and financial advisors before financial decisions. Information about the free use of our calculator of mortgage and some terms are included as a comment in the cell of the table. If you have any questions, you can move vertex42 loan calculator the mouse cursor on any cell, which has a small red triangle in the corner. This mortgage calculator can help answer some of these questions: there are several ways to analyze your existing mortgage. The first is the original amount of the loan and the date type and then click payment history of the settings in the application for payment per hour. This is the simplest solution, so we've added a new feature, in the section of the additional payments (at the suggestion of our users), indicating that you authorized payment start special refunds. So, if you have made additional payments for a few years, demand the 25 number of payments payment start. The second approach is to install the balance of the mortgage loan and return the length of your pay period currently until payment PI is equivalent to the. Don't forget: If you pay monthly, can be a fraction of a year after entering a value, such as 10 + 5/12 (for 10 years and 5 months) = enter. .