Join our investing community

HP with irregular payment amongst normal repayments

Discussion in 'Finance & Banking' started by jhomehelp, 26th Jul, 2011.

  1. jhomehelp

    jhomehelp New Member

    Joined:
    26th Jul, 2011
    Posts:
    1
    Location:
    nsw
    Does anyone know the name of software or excel formula used to calculate the amortisation schedule for a HP with an irregular payment included within the repayment schedule.
    For eg.
    Financed $79,780 + int chgs $13,242.74 = totalling $93,022.74,
    48 pymts as follows: 3x$1794.10, 1x$8699.56, 43x$1794.10, 1x$1794.10.
    Int rate is 8.71%.
    I cannot find one anywhere that will do this. Thanks