mortgage calculator

[Julian Campbell]

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

[Morrigan]

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

HTH

[Fred Smith]

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

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


"Julian Campbell" <[email protected]> wrote in message
news:[email protected]...
>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
>

[Ltat42a]

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.