Formula - Amortization

[TwistedPixel]

Can anyone provide a formula to calculate loan payments within a worksheet
to amortize a mortgage - i.e. term, rate, and amount given? I need to
auto calculate a couple variables for 15, 20, 25, and 30 years.

Thanks!

[Ken Russell]

Have you tried the PMT Function?

--
Ken Russell

[email protected]
Remove yourhat to reply by e-mail
..

"TwistedPixel" <[email protected]> wrote in message
news:[email protected]...
> Can anyone provide a formula to calculate loan payments within a worksheet
> to amortize a mortgage - i.e. term, rate, and amount given? I need to
> auto calculate a couple variables for 15, 20, 25, and 30 years.
>
> Thanks!

[TwistedPixel]

I have. Unfortunately, I need something a little more detailed that can
extract from various cells and run a couple different scenarios.

On Sat, 04 Jun 2005 16:49:14 +1000, Ken Russell wrote:

> Have you tried the PMT Function?

[Ken Russell]

Just set up the PMT function to extract the data from cells you designate,
and set up multiple versions of the function to explore different scenarios.

--
Ken Russell

[email protected]
Remove yourhat to reply by e-mail
..

"TwistedPixel" <[email protected]> wrote in message
news:[email protected]...
>I have. Unfortunately, I need something a little more detailed that can
> extract from various cells and run a couple different scenarios.
>
> On Sat, 04 Jun 2005 16:49:14 +1000, Ken Russell wrote:
>
>> Have you tried the PMT Function?
>