You can figure out the total interest paid as follows:How to calculate total interest paid on a loan in Excel?Interest Formula | Calculator (Examples with Excel Template)Excel formula: Calculate loan interest in given year Excel formula: Calculate interest rate for loan | ExceljetSelect 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 number of periods (months) during the loan; B1 is the To calculate the periodic interest rate for a loan, given the loan amount, the number of payment periods, and the payment amount, you can use the RATE function. In the example shown, the formula in C10 is: = RATE( C7, C6, - C5) 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)16/10/2018 · In the example illustrated below, the operation syntax inserted into the formula bar of cell B6 is thus- =PMT (B3/12,B2,-B1) This calculates the monthly payment with interest for the loan. Figure 2. of Excel PMT 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 loan.

Tags: Calculate interest rate on loan formula excel, Calculating interest rate on a loan formula excel, Excel formula to calculate interest on car loan, Excel formula to calculate accrued interest on loan,