We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 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!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

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 Forumite
    10,000 Posts Combo Breaker
    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 Forumite
    Part of the Furniture 1,000 Posts Combo Breaker
    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
  • 354.8K Banking & Borrowing
  • 254.5K Reduce Debt & Boost Income
  • 455.6K Spending & Discounts
  • 247.6K Work, Benefits & Business
  • 604.5K Mortgages, Homes & Bills
  • 178.6K Life & Family
  • 262.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K 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.