interest on loan a/c compounding yearly, but i want it for 3,7.. months

I have created excel sheet as below


Interest Compounding Yearly


Principal 50000.00

Interest Rate 7.25% Per annum

Term 3 Months




Month Opening Balance Interest Charged Repayment Closing Balance
1 50000.00 0.00 16868.46 33131.54
2 33131.54 0.00 16868.46 16263.08
3 16263.08


here i want the total interest charged for three months in 3rd mnth interest charged column, if i select 7 mnths term total interest charged for 7 months should come in 7th month interest charged colum, if it is 13 months total interest for 12 months in 12th month interest column and remaining 1 month interest in 13th month interest charged column

kindly help

IPMT gives you the interest for a particular period.

Do you mean CUMIPMT?

I don't know how to respond. Your first example is using numbers with compounding, for which CUMIPMT should work. But your latest note states simple interest, for which the cumulative interest is basic math. Which one is it?