Libroffice PMT equivalent in python

Discussion in 'Python' started by ஆமாசà¯à®šà¯, Apr 25, 2013.

  1. ஆமாசà¯à®šà¯, Apr 25, 2013
    #1
    1. Advertising

  2. On Thursday, April 25, 2013 6:46:01 AM UTC-4, ஆமாசà¯à®šà¯ wrote:
    > Hi,
    >
    >
    >
    > Are there equivalent in any Python libraries that could match function
    >
    > like PMT in libreoffice?
    >
    >
    >
    > Refer: https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#PMT
    >
    >
    >
    > --
    >
    >
    >
    > Amachu


    The PMT function in spreadsheet programs (Excel, OpenOffice Calc, LibreOffice Calc, Symphony Calc, Gnumeric) and in pocket financial calculators (Texas Instruments BA II plus, HP 10B II, Casio Fc 100, 200) will provide an answer for the initial (periodic) payment. Whereas depending on the value of number of periods NPER there may be 5 different payments as explained below

    0) the periodic payment
    This is the payment that is in constant amount and is paid or collected over the life of investment assuming the number of periods are in whole and donot have a fractional part

    If the number of periods have a fractional part such as 10.5 years of 119.25 months then besides the initial periodic payment, there may be 4 different last payments to choose from

    1) Balloon payment
    When the NPER has a fraction, then the last payment may be made or collected at the last full time period for example if NPER is 10.5 then the balloonpayment is made at the end of year 10 where you pay the periodic payment plus the remaining principal and the interest due

    2) Actual last payment
    When the NPER has a fraction, you may opt to pay or collect the last payment at the actual time period. For example if NPER is 10.5 then you will makeor collect the last payment at the end of 10 years and 6 months. This lastpayment will be the principal remaining after making 10 payments and will also include the interest on remaining principal

    3) Drop payment
    When the NPER has a fraction, you may opt to pay or collect the last payment at the end of the next full year. For example if NPER is 10.5 then you will make or collect the last payment at the end of 11 years. This last payment will be the principal remainining plus the interest on it

    4) Partial period payment
    But then if the NPER has a fraction, you may still opt to pay or collect the payment at the actual time period but the amount you pay is the fraction of time period times the remaining principal. Thus if the NPER is 10.5 you make the last payment at the end of 10 years and 6 months in amount of 0.5 * remaining_principal

    Now the present value of the periodic payments plus the last payments from case 1, 2, 3 comes out to be the same as the loan amount. But this is not the case if we use payment from case number 4, in this instance the lender collects a few extra bucks from the borrower.

    Excel financial functions were copied from those found in Lotus 123 and thefinancial functions in OpenOffice Calc, LibreOffice Calc, Symphony Calc are copies from Excel.

    This Excel PMT function http://tadxl.com/excel_pmt_function.html offers theoptions of finding any of the 5 different payments as explained in the previous paragraphs. And it even goes further and finds all periodic payments when payments are growing, shrinking, increasing or decreasing. In this last case there may be as many different payments as there are number of periods. All this is part of tadXL add-in http://tadxl.com/
    Michael Marshall, May 5, 2013
    #2
    1. Advertising

  3. On Saturday, May 4, 2013 11:37:17 PM UTC-4, Michael Marshall wrote:
    > On Thursday, April 25, 2013 6:46:01 AM UTC-4, ஆமாசà¯à®šà¯ wrote:


    > If the number of periods have a fractional part such as 10.5 years of 119..25 months then besides the initial periodic payment, there may be 4 different last payments to choose from
    >



    EDIT

    There was a typo in my text

    I meant to write

    If the number of periods have a fractional part such as 10.5 years OR 119.25 months
    Michael Marshall, May 5, 2013
    #3
  4. On Saturday, May 4, 2013 11:37:17 PM UTC-4, Michael Marshall wrote:

    > 4) Partial period payment
    >
    > But then if the NPER has a fraction, you may still opt to pay or collect the payment at the actual time period but the amount you pay is the fraction of time period times the remaining principal. Thus if the NPER is 10.5 you make the last payment at the end of 10 years and 6 months in amount of 0.5 * remaining_principal
    >


    EDIT

    Meant to write

    But then if the NPER has a fraction, you may still opt to pay or collect the payment at the actual time period but the amount you pay is the fraction of time period times the periodic payment. Thus if the NPER is 10.5 you make the last payment at the end of 10 years and 6 months in amount of 0.5 * periodic_payment
    Michael Marshall, May 5, 2013
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Justin Martin

    Pmt function in C#

    Justin Martin, Jan 31, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    5,893
    Steve C. Orr [MVP, MCSD]
    Feb 9, 2005
  2. Robert Oschler
    Replies:
    0
    Views:
    561
    Robert Oschler
    Nov 13, 2004
  3. Eric Wichterich
    Replies:
    0
    Views:
    362
    Eric Wichterich
    Oct 22, 2003
  4. Javascript PMT with FV

    , Aug 23, 2008, in forum: Javascript
    Replies:
    3
    Views:
    152
  5. Terry Jan Reedy

    Re: Libroffice PMT equivalent in python

    Terry Jan Reedy, Apr 25, 2013, in forum: Python
    Replies:
    0
    Views:
    106
    Terry Jan Reedy
    Apr 25, 2013
Loading...

Share This Page