ExcelBanter - Interest Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Interest Formula (https://www.excelbanter.com/excel-discussion-misc-queries/53506-interest-formula.html)

Allan

Interest Formula

Does anyone know of a formula that will calculate the amount of interest that
is in each instalment of a monthly repayment. Eg amount of borrowing £5000
repayment over 3 years interest (say) 7%. What is the capital element and the
interest element of each instalment.

Domenic

Interest Formula

Have a look at...

PPMT

and

IPMT

Hope this helps!

In article ,
"Allan" wrote:

Does anyone know of a formula that will calculate the amount of interest that
is in each instalment of a monthly repayment. Eg amount of borrowing £5000
repayment over 3 years interest (say) 7%. What is the capital element and the
interest element of each instalment.

Allan

Interest Formula

Hi Thanks for your help

"Domenic" wrote:

Have a look at...

PPMT

and

IPMT

Hope this helps!

In article ,
"Allan" wrote:

Does anyone know of a formula that will calculate the amount of interest that
is in each instalment of a monthly repayment. Eg amount of borrowing Â£5000
repayment over 3 years interest (say) 7%. What is the capital element and the
interest element of each instalment.

All times are GMT +1. The time now is 07:46 PM.