To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. In the example shown, the formula in C10 is: = PMT ( C6 12, C7, - C5 )We will use the formula = B5 12 = 12 for the number of years to complete the loan repayment. In other words, to borrow $120,000, with an annual rate of and to pay $1,100 monthly 17/09/2009 · how to calculate loan repayments in excel First you need to enter your data. Principle = the amount you want to borrow. The Interest Rate = the per annum interest rate divided by ;· Here are the steps for loan repayment calculation in Excel. If you would like to find out the monthly payment of your mortgage, you need to make sure the future value of the amount of money you have borrowed has been set to default which is equal to 0. The formula for calculating monthly payment is shown as follow: =-PMT(rate;length;present_value;[future_value];[type])The Excel PMT () function is used in cell C7 to calculate the monthly repayment. It takes the form: PMT (InterestRate, NumberOfPeriods, Principal, FutureValue, PaymentsDue). The interest rate should relate to a single repayment period and not the annual rate. In this example it is 1/12 th of 6%.Calculate Loan Repayments in Excel using the PMT functionExcel formula: Calculate payment for a loan | ExceljetSchedule Loan Repayments With Excel FormulasHow to calculate loan payments in 3 easy steps

Tags: Loan payment excel formula, Loan repayment schedule excel formula, Loan payment excel function, Loan payment calculator excel formula, Monthly loan payment excel formula, Home loan repayment excel formula, Loan repayment function excel, Total loan repayment formula excel,