HP with irregular payment amongst normal repayments

Discussion in 'Loans & Mortgage Brokers' started by jhomehelp, 26th Jul, 2011.

Join Australia's most dynamic and respected property investment community
  1. jhomehelp

    jhomehelp New Member

    Joined:
    1st Jul, 2015
    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
     

Property Investors! Ready to Pay Less Tax? Estimate how much Property Depreciation you can claim on your Investment Property. Washington Brown's calculator is the first calculator to draw on real properties to determine an accurate estimate.