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 Select the cell you will place the calculated result in, type the formula =CUMIPMT (B2/12,B3 12,B1,B4,B5,1), and press the Enter key. See screenshot: Note: In the formula, B2 is the annual loan interest rate, B2/12 will get the monthly rate; B3 is the years of the loan, B3 12 will get the total …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 formula: Calculate payment for a loan | ExceljetExcel formula: Calculate payment for a loan | Exceljetexcel loan calculate total amountSchedule Loan Repayments With Excel FormulasMicrosoft Excel can be easily used to calculate the total amount of a loan to be repaid. The total amount to be repaid in a loan is a combination of the initial amount borrowed and the total amount of interest to be added, excel can very easily calculate the total amount to be paid using the PMT function. For the PMT function to calculate the entire loan to be repaid three bits of information are required:

Tags: