📨 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!

Interest question

I'm trying to do the credit card shuffle, using Martin's worksheet. Could anyone please explain how I calculate an interest rate that is only shown on my bill as a monthly rate? I assume the sheet is set up to work out on an annual rate, but I'm a dunce as to how to convert it.

TIA
Lynne

Comments

  • CLAPTON
    CLAPTON Posts: 41,865
    10,000 Posts Combo Breaker
    Forumite
    if you use exel then if M is the monthly interest rate then

    =power(1+M/100,12)-1 will give the APR

    so if monthly is say 1.2%
    the APR is 15.39%

    or simply multiply by 13 which gives an approximate value so 1.2 x 13 = 15.6% (not exact but not too bad)
    EU tariff on agricultual product 12.2%
    some dairy products 42.1% cloths 11.4%
    EU Clinical Trials Directive stops medical advances
  • Thanks! That's very helpful!

    Lynne
  • Clariman
    Clariman Posts: 1,484
    Part of the Furniture 1,000 Posts Combo Breaker
    Forumite
    Or use an interest rate conversion tool like this one.

    Clariman
    Author of the first Stoozing FAQ on the Internet and Creator of the SOA & Snowball calculators at Lemonfool.co.uk
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
  • 355.8K Banking & Borrowing
  • 254.9K Reduce Debt & Boost Income
  • 456.2K Spending & Discounts
  • 248.4K Work, Benefits & Business
  • 606K Mortgages, Homes & Bills
  • 179K Life & Family
  • 263.8K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K 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.