Results 1 to 4 of 4

Amortization Schedule

This is a discussion on Amortization Schedule within the Excel Questions forums, part of the Question Forums category; Can anyone help. Which function or formula would be best to use to create an amortization schedule table of values ...

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    509

    Default

    Can anyone help. Which function or formula would be best to use to create an amortization schedule table of values if I had a house at 150,000 at 9% for 30 years.

    Thanks in advance.

    Bill

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,946

    Default

    check out pmt(). Post back if it's not clear...

    paddy

  3. #3
    Board Regular
    Join Date
    May 2002
    Posts
    509

    Default

    Okay, I have the PMT function down but can I have a complete table of all the payments complete with payment amount, interest paid?

  4. #4
    Board Regular
    Join Date
    May 2002
    Posts
    890

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com