I hope that someone can help. Trying to calculate the interest allocation (using goal seek in excel) on a hire purchase agreement that has a balloon payment - does anyone know if the balloon payment should include interest or if it is just capital? The balloon payment is not optional.
Replies (6)
Please login or register to join the discussion.
It is for you to make that judgement. You should look beneath the form of the payments and decide what is their substance. You are the one in the best position to do this, not us. This is part of being an accountant.
If only the Hire Purchase company put some helpful information in - like total interest payable, effective APR, schedule of repayments. Stuff like that.........
Apologies if I am asking a silly question, have had a death in the family recently and perhaps the brain is not working as well as usual.
Well, don't worry too much about it.
Provided you make a decent stab, the chances of the error being material are next to nothing.
Sum of the digits - you can do it on a fag packet and the answer's near enough.
Is it relevant? The amount financed will be the purchase price less any px less any cash up front. The term and total payments and their timing will be known. The difference between the two will be the finance charge and Excel will give you the effective rate.
I'm assuming there is no guaranteed residual value if it is straightforward HP but that can be built in if appropriate.