When you are shopping for a new house you’ll want to know how much your loan is going to cost you each month. If you already have a loan then you’ll be interested in how you are progressing with your loan. In each case you can use Excel to calculate the loan repayments and to determine how much the loan is costing you. To help you out, we’ve found a great template for you to download and use.
Important Note: This worksheet assumes your loan is a standard fixed interest loan that is repaid by monthly payments of principle and interest. It gives you a guide to what your payments might be. However only your lender can tell you exactly what you will pay as actual repayments may vary from these figures and they may also include additional fees and taxes.