Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,539
    Thanks
    38
    Thanked 68 Times in 64 Posts

    ISPMT vs IPMT (2002)

    I get the impression from the HELP menu that these are the same calculatons. Obviously, NOT as they return different results.
    What's the difference?

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

    Re: ISPMT vs IPMT (2002)

    They use different payment schemes.

    ISPMT assumes that the payments on the principal are constant over time, while the total payments (interest + payment on principal) vary over time.
    IPMT assumes that the total payments are constant over time, causing both payments on the principal and interest payments to vary, as in an annuity.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,539
    Thanks
    38
    Thanked 68 Times in 64 Posts

    Re: ISPMT vs IPMT (2002)

    Thanks for the quick clarification.

Posting Permissions

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