Re: Formula - Amortization

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Have you tried the PMT Function?

--
Ken Russell

kenrussellyourhat@xxxxxxxxxxxxxxxx
Remove yourhat to reply by e-mail
..

"TwistedPixel" <twistedpixel@xxxxxxxxxx> wrote in message
news:pan.2005.06.04.05.46.59.251863@xxxxxxxxxxxxx
> 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!


.

Relevant Pages

  • Re: Fair Market value Spread sheet for donations.
    ... > Ken Russell ... > Remove yourhat to reply by e-mail ... >> totals at the bottom. ...
    (microsoft.public.excel.misc)
  • Re: BIMDAS - Order of Calculation
    ... "Atreides" wrote in message ... > "Ken Russell" wrote: ... >> Remove yourhat to reply by e-mail ... >>> I've recently noticed that Excel flies in the face of standard ...
    (microsoft.public.excel.misc)
  • Re: How do I set up a tickler file?
    ... Why not use Outlook's calendar function? ... Ken Russell ... Remove yourhat to reply by e-mail ... "moe3rd" wrote in message ...
    (microsoft.public.excel.misc)
  • Re: Help me Please
    ... Ken Russell ... Remove yourhat to reply by e-mail ... "Ritchie" wrote in message ... >> to help I would be willing to compensate in monetary funds. ...
    (microsoft.public.excel.misc)