When calculating mortgage repayments it's very important to remember that different countries can use different systems to calculate the compound interest. A perfect example of this is the fact that the US and Canada to use different systems in this regard. The compound interest rates on mortgages in the US are calculated on a monthly basis while the compound interest rates on mortgages in Canada are calculated semi annually.
The free Auto Loan Calculator for Excel helps you plan your next car purchase. Calculate the amount you will need to finance, based on sales price, destination charge, fees, sales tax, down payment, cash rebate, and trade-in value of an older auto. Use the Payment Calculator worksheet to create an amortization table based on the amount you've financed. Analyze different loans to choose a suitable monthly payment and minimize the total interest.
