I wouls like to be able to work out my monthly mortgage payment (interest
only) by inputing the following details

amount of loan ( figure to entered ?)
term of loan (in years 1 to 25)
interest rate ( current figure to be entered ie 4.75)
My monthly repayment is ( display answer)

Thanks for your help

Julian

Hmm...it sounds like the function IPMT function. Take a look at that.

HTH


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=386965

Excel's PMT function will calculate your answer for you.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Julian Campbell" wrote in message
...
I wouls like to be able to work out my monthly mortgage payment (interest only)
by inputing the following details

amount of loan ( figure to entered ?)
term of loan (in years 1 to 25)
interest rate ( current figure to be entered ie 4.75)
My monthly repayment is ( display answer)

Thanks for your help

Julian

Julian Campbell Wrote:
I wouls like to be able to work out my monthly mortgage payment
(interest
only) by inputing the following details

amount of loan ( figure to entered ?)
term of loan (in years 1 to 25)
interest rate ( current figure to be entered ie 4.75)
My monthly repayment is ( display answer)

Thanks for your help

Julian

I have a loan calculator spreadsheet already set up to use. If you'll
send me your email address, I send it to you.


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=386965