+ Reply to Thread
Results 1 to 1 of 1

Another variable to loan amortization

  1. #1
    Registered User
    Join Date
    04-26-2012
    Location
    Texas, United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Another variable to loan amortization

    I am wanting to create a loan amortization table that will first reduce an accumulated interest amount ($2500) but still calculating interest off the original loan amount ($15000). When the payment reduces the $2500 past 0, I want to find a rule that will then allow it to automatically start reducing the $15000 basically turning into a regular amortization schedule.

    I need help finding or making a rule to connect that interest only payment and then reduction of the principal.

    Attachment of where I am it is provided.

    Thanks so much for any help!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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