+ Reply to Thread
Results 1 to 2 of 2

Home Equity Loan

  1. #1
    Forum Contributor
    Join Date
    09-27-2004
    Posts
    130

    Question Home Equity Loan

    Hi:

    I have a loan with a $20,000 principal balance at 4.65%, 5 years. Using the IPMT function the monthly payments are $374.23. However, I do not make constant payments. For example, my first three payments were $535, $1400 and $461 on 10/11/11, 11/9/11 and 12/9/11, respectively. Is there any way to keep tarck of a loan where payments are not constant. All my payments will be more than the required amount. Is the difference between my payment and the actual amount applied all to principal?

    Thanks

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,293

    Re: Home Equity Loan

    Hi,

    Since the payments vary you'll need to build a monthly table to work them out.
    Alternatively there are many Excel templates on the web, just google Excel loan repayment calculator, or something similar.
    One such is here http://www.excely.com/template/loan-calculator.shtml

    Whether the difference between the actual and minimum payment should all be applied to the principal reducing balance, or some other treatment will depend on the conditions attached to your loan, although it would be normal to reduce the outstanding balance.

    Regards
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

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