📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Need Help Calculating APR on loan

kindofagilr
kindofagilr Posts: 6,825 Forumite
Part of the Furniture 1,000 Posts
Hello all,

OH got a loan out for £10,000 in 2005, in 2009 (jan) we extended the loan to £21,000 (to pay for mortgage on house) I was under the impression we DIDNT have PPI on the loan (as I thought OH had cancelled it off the original loan in 2007), but now I am not so sure and I am wondering if you can help me figure it out.

Our loan is for £21,000 we are paying it over 7 years (84 months) at a APR of 12.4% we pay £368 a month (which brings the total at the end of the loan £30,912)

So I have tried to work out what 12.4% equals in the loan, this is how I come to it

£21,000 divided by 100 = £210 (1%) x 12.4 - £2604 does that mean that the amount we should be paying back is £2604 + £21,000 = £23,604? which only comes to £281 per month?

Or have I got my maths totally wrong?

Thanks for your help guys
Debt £30,823.48/£44,856.56 ~ 06/02/21 - 31.28% Paid Off
Mortgage (01/04/09 - 01/07/39)
£79,515.99/£104,409.00 (as of 05/02/21) ~ 23.84% Paid Off

Lloyds (M) - £1196.93/£1296.93 ~ Next - £2653.79/£2700.46 ~ Mobile - £296.70/£323.78
HSBC (H) -£5079.08/£5281.12 ~ HSBC (M) - £4512.19/£4714.23
Barclays (H) - £4427.32/£4629.36 ~ Barclays (M) - £4013.78/£4215.82
Halifax (H) - £4930.04/£5132.12 ~ Halifax (M) - £3708.65/£3911.20

Asda Savings - £0

POAMAYC 2021 #87 £1290.07 ~ 2020/£3669.48 ~ 2019/£10,615.18 ~ 2018/£13,912.57 ~ 2017/£10,380.18 ~ 2016/£7454.80

~ Emergency Savings: £0

My Debt Free Diary (Link)

Comments

  • Typhoon2000
    Typhoon2000 Posts: 1,171 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    That sounds about right, I make it £375 per month at 12.4% APR, so it seems you are not paying for PPI
  • Rafter
    Rafter Posts: 3,850 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    Your maths is wrong.

    What you have calculated is the first years interest, if you weren't making payments each month to start reducing the loan.

    If you have access to a spreadsheet you can try the following formula:

    =PMT(((1+12.4%)^(1/12)-1),84,21000,0) = £367.87

    Which seems to confirm that your payment is right.

    The monthly interest on your loan is (1+12.4%)^(1/12)-1 = 0.979%

    So in January 2009 your interest bill would be £21,000 x 0.979% = £206

    You then pay £368 off to leave a balance of £20838 (£21,000 + 205 - 368)

    In February 2009 your interest bill is £20,838 x 0.979% = £204

    And so on.

    So each month you pay a little less interest and a bit more off your loan so in 84 month you will have paid the lot.

    The total interest bill over 7 years will be £9,900.

    At some point, once you have saved an emergency fund, you may want to look at trying to overpay the loan or get the APR down. 12.4% is a high interest rate.

    You could add the loan to the mortgage next time it is up for renewal if you have enough equity, although you are putting your home at risk by doing so.

    Good luck

    R.
    Smile :), it makes people wonder what you have been up to.
  • Rafter
    Rafter Posts: 3,850 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    PS - so you aren't paying PPI
    Smile :), it makes people wonder what you have been up to.
  • kindofagilr
    kindofagilr Posts: 6,825 Forumite
    Part of the Furniture 1,000 Posts
    Thanks guys :)

    Man I am stupid lmao :)

    Yes we have been looking into overpaying the loan, OH rang them the other day to ask if there are any penalites in overpaying and they said no as long as it wasnt like a lump sum settlement figure.

    So we are going to start doing that ASAP, then in a few years time we are hoping to use the loan money to overpay the mortgage as well (thats our long term plan)

    I was thinking about looking around at a lower interest rate loan to help us in the meantime but I havent done that yet

    Thanks again
    Debt £30,823.48/£44,856.56 ~ 06/02/21 - 31.28% Paid Off
    Mortgage (01/04/09 - 01/07/39)
    £79,515.99/£104,409.00 (as of 05/02/21) ~ 23.84% Paid Off

    Lloyds (M) - £1196.93/£1296.93 ~ Next - £2653.79/£2700.46 ~ Mobile - £296.70/£323.78
    HSBC (H) -£5079.08/£5281.12 ~ HSBC (M) - £4512.19/£4714.23
    Barclays (H) - £4427.32/£4629.36 ~ Barclays (M) - £4013.78/£4215.82
    Halifax (H) - £4930.04/£5132.12 ~ Halifax (M) - £3708.65/£3911.20

    Asda Savings - £0

    POAMAYC 2021 #87 £1290.07 ~ 2020/£3669.48 ~ 2019/£10,615.18 ~ 2018/£13,912.57 ~ 2017/£10,380.18 ~ 2016/£7454.80

    ~ Emergency Savings: £0

    My Debt Free Diary (Link)
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.4K Banking & Borrowing
  • 252.9K Reduce Debt & Boost Income
  • 453.3K Spending & Discounts
  • 243.4K Work, Benefits & Business
  • 598K Mortgages, Homes & Bills
  • 176.6K Life & Family
  • 256.5K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.