How to calculate total interest paid on a loan in Excel?Simple loan calculator and amortization tableExcel formula: Calculate loan interest in given year How to calculate interest payments per period or total with Excel formu…Calculate total interest paid on a loan in Excel For example, you have borrowed $100000 from bank in total, the annual loan interest rate is , and you will pay the bank every month in the coming 3 years as below screenshot your loan data in Excel as below screenshot shown: 2. In Cell F3, type in the formula, and drag the formula cell’s AutoFill handle down the range as you need. =IPMT($C$3/$C$4,E3,$C$4 $C$5, $C$2) 3. In the Cell F9, type in the formula =SUM(F3:F8), and press the Enter key. Now you will get the total amount of interest payments for the calculate the total interest for a loan in a given year, you can use the CUMIPMT function. In the example shown, the total interest paid in year 1 is calculated by using 1 for start period and 12 for end period. The The formula in F5 is: = CUMIPMT(5 % 12,60,30000,1,12,0)22/02/2021 · Know at a glance your balance and interest payments on any loan with this simple loan calculator in Excel. Just enter the loan amount, interest rate, loan duration, and start date into the Excel loan calculator. It will calculate each monthly principal and interest cost through the final calculate the interest portion of a loan payment in a given period, you can use the IPMT function. In the example shown, the formula in C10 is: = IPMT ( C6 12, 1, C8, - C5 )
