Results 1 to 7 of 7

Excel Loan Payment Amortization Schedule

Threaded View

gacollege Excel Loan Payment... 11-16-2010, 12:26 PM
alansidman Re: Excel Loan Payment... 11-16-2010, 01:38 PM
shg Re: Excel Loan Payment... 11-16-2010, 02:21 PM
martindwilson Re: Excel Loan Payment... 11-16-2010, 08:54 PM
alansidman Re: Excel Loan Payment... 11-16-2010, 11:49 PM
gacollege Re: Excel Loan Payment... 11-17-2010, 11:46 AM
shg Re: Excel Loan Payment... 11-17-2010, 12:18 PM
  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