Results 1 to 7 of 7

Excel Loan Payment Amortization Schedule

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2003
    Posts
    15

    Excel Loan Payment Amortization Schedule

    I have attached a loan payment schedule that will break out the interest and principle to apply to an outstanding loan balance. The only issue I have is that I tested it with a 20 year $ 39,300 note (see attached) and it did not zero out on the 240th payment. I have looked over it until I am dazed....... I know it is something simple.....

    This will be a great sheet if problem is solved!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1