Mortgage calc

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

I remember once seeing a mortgage calc in Excel, showing
total payment etc etc.

Anyone know the calc, or where I can find it?

Cheers,
Gary
 
=ROUND(PMT($H11/12,(H10*12),-I6),2)

where H11 is the annual rate
H10 is the No of years
I6 is the borrowed amt
 
Back
Top