Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Total Interest Paid (2002)

    IPMT finds the interest for a given period of a loan. How do you find the TOTAL interest paid over the full period? Is there a formula or is this an array formula using IPMT?

    DUH...never mind. Just figured it out.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Total Interest Paid (2002)

    The Analysis ToolPak add-in contains a function CUMIPMT (cumulative interest payment).

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Total Interest Paid (2002)

    Glad you figured it out.

    For others who might be looking for it, tha analysis toolpack has a funtion CUMIPMT which calculates the CUMulative Interest PayMenT on a loan given the start and end periods

    Steve

Posting Permissions

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