Take a look at the PMT function in Help.

In article ,
Grd wrote:

Hi,

I need to work out what a potential monthly mortgage payment would be in
excel but the calculation is too complicated for me.

Is there an easy way to create this calculation. Maybe a function that does
it for you?

Any help is greatly appreciated.

Tx

Suzanne