interest caculation on loan compounding yearly, want for selected months

[GANESH SRINATH]

I have created a excel sheet
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


help me please

INTEREST CAL.xlsx

[Vaslo]

I have created a excel sheet
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


help me please

Attachment 292685

Ganesh,

Sorry, I'm a little confused about what you want. Perhaps take this file and manually show what you want. I don't understand what output you want - what column are you referring to?