StepsMore formula: Calculate cumulative loan interest | Exceljetexcel loan calculate total amountExcel formula: Calculate loan interest in given year Excel formula: Calculate cumulative loan interest | 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 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: =List 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 Excel CUMIPMT function is a financial function that returns the cumulative interest paid on a loan between a start period and an end period. You can use CUMIPMT to calculate and verify the total interest paid on a loan, or the interest determine the amount due for loan payment, given a loan duration/term, a Rate of Interest, and the initial loan amount, we can utilize the Excel PMT Operation 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
