HOW TO CALCULATE FOREIGN CURRENCY (2024)

HOW TO CALCULATE FOREIGN CURRENCY (1)

Exchanging foreign currency is an essential practical task, which all treasurers need to tackle with confidence. Let's explore awinning technique to ensure you get it right every time.

BACK TO BASICS

Exchanging one currency for another needs us to apply a quoted market price, known as the exchange rate. Sometimes we need to multiply by the rate. Sometimes we need to divide by it.

It all depends on how the rate has been quoted. And this won’t always be the same.

MONEY FOR STUFF

Pricing is easier when we’re buying or selling physical stuff for money. We simply multiply the quantity by the money price per unit.

Let’s say the oil price is $50 per barrel, and we want to sell a million barrels. The money value for the exchange is simply:

$50 per barrel x 1 million barrels = $50m

WHY WE MULTIPLIED

We multiply by commodity prices because of the way they’re quoted. The commodity quote is a variable amount of money per fixed conventional unit of the commodity.

Oil prices are quoted in dollars per barrel. So, multiplying a number of barrels by dollars per barrel gives the dollar value for the exchange. The oil is the basis, or the ‘base’ of the conventional oil-price quote.

MONEY FOR MONEY

Currency dealing means exchanging money for money.

Does simple multiplication work for currency deals? Sometimes, but not all the time. It depends which way round the rate is quoted.

For FX, we need to ask two separate questions:

(1) Which is the base currency in the given quote?

(2) Are we converting from the base, or to the base?

WHICH IS THE BASE CURRENCY?

The base currency won’t always be the same. For example, the rate between dollars and euros can be quoted as either:

(i) A variable number of dollars per €1; or

(ii) A variable number of euros per $1.

€ / $1.25

The first-mentioned currency is conventionally the base. That’s euros in this case. The euro is the currency that there’s one fixed unit of.

This is quoted in the market as EUR/USD 1.25, meaning the base currency euro would be exchanged for dollars at a rate of €1 to $1.25.

BEST OF ORDER

Note the ordering of the currencies in the exchange-rate quote. We saw that the first-mentioned currency is the base.

This is a different convention from commodity prices, such as dollars per barrel = 50. For a commodity, it’s the second-mentioned item that is the base. In our example, this is the barrel of oil.

Currencies are conventionally quoted the other way round. This can make FX tricky.

$/€0.80

Taking another example: which is the base currency in the quote USD/EUR 0.80?

Again, the base currency is the first mentioned. In this case it’s the dollar. So the quote USD/EUR 0.80 means $1 would be exchanged

for €0.80.

Interestingly, $/€0.80 is just an alternative way of expressing our earlier quote €/$1.25. The base has jumped from euro to dollar, but it won’t make any difference to the results. So long as we apply either of the quotes correctly, they will each produce exactly the same results,

subject to any minor rounding differences. Base jumping is also an exciting extreme sport. But let’s stay with FX just now.

GETTING IT RIGHT

Having identified the base currency in our exchange rate, we need to apply it the right way round. One reliable method is to follow the rule in the following:

Base conversion rule

When converting:

  • From the base, multiply.
  • To the base, divide.

FROM THE BASE

To convert from the base currency, we multiply by the exchange rate.

Just like multiplying to apply a commodity price. Indeed, our base currency can be viewed as the commodity in the quote.

Say we need to convert €8m into dollars, by applying the exchange rate EUR/USD 1.25.

The euro is the base currency. We’re converting from the base.

So multiply:

€8m x $1.25 per euro = $10m

TO THE BASE

Let's look at an example: convert €8m into dollars, using an exchange rate of USD/EUR 0.80.

The base currency in the quote USD/EUR 0.80 is the dollar. The quote means $1 = €0.80.

We’re converting from €8m to dollars. So we’re converting to the base currency dollars this time. So, we’ll divide by the exchange rate

of 0.80:

€8m/€0.80 per dollar = $10m

PERFECT PROPORTIONS

If we tabulate our results, we see that each currency stays beautifully in proportion with the other.

$
FX rate10.80
Amounts10m8m

There are more dollars than euros in the rate $1/€0.80. There are also more dollars than euros in the final money amounts, $10m exchanged for €8m.

REAP THE REWARDS

Listen to this excellent advice from a successful student, George Worden:

  1. Don’t be disheartened if you get the wrong answers to start with.
  2. First focus on getting right answers.
  3. Once you’re getting things right, only then work on speeding up.
  4. Practice makes perfect.

If you follow Worden’s advice you’ll master FX and treasury, which are just as rewarding as base jumping. And less dangerous!

____________________

Author:Doug Williamson

Source:The Treasurer magazine

Want to learn more about foreign exchange?

Choose from:

eLearning courses: 45-90 minutes to complete, available online 24/7.

Training courses: live skills-based training sessions.

Treasury and Cash Management qualifications: internationally recognised courses from entry to master level.

All our courses will provide you with valuable knowledge as well as easy-to-share digital credentials to demonstrate your learning achievements.

Discover more resource articles

HOW TO CALCULATE FOREIGN CURRENCY (2024)

FAQs

What is the formula for calculating foreign currency? ›

If you don't know the exchange rate, you can use the following simple currency conversion calculation to find it: take your starting amount (original currency) and divide it by ending amount (new currency) = exchange rate.

How do you determine the value of foreign currency? ›

The value of a currency, like any other asset, is determined by supply and demand. An increase in demand for a particular currency will increase the value of the currency, while an increase in supply will decrease the currency's value. The exchange rate is the value of one country's currency in relation to another.

How do you solve foreign currency? ›

To convert from a base currency, you would multiply by the exchange rate. If the exchange rate is greater than 1, you will get a larger number—that is, you will get more of the second currency in exchange for the first.

How can I calculate my currency? ›

Multiply the money you've budgeted by the exchange rate. The answer is how much money you'll have after the exchange. If "a" is the money you have in one currency and "b" is the exchange rate, then "c" is how much money you'll have after the exchange. So a * b = c, and a = c/b.

How do you manually calculate currency? ›

Calculate an FX rate using this simple formula: Your starting figure (in your local currency) divided by the final number (in the new foreign currency) = the exchange rate.

How do I calculate foreign currency in Excel? ›

Use the Currencies data type to calculate exchange rates

Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes. For example, enter "USD/EUR" to get the exchange rate from one United States Dollar to Euros. Select the cells and then select Insert > Table.

Do you multiply or divide to convert currency? ›

It is easy to confuse whether you need to multiply or divide by the exchange rate. One way to remember is with the rule: If you are going from the “1” to the other currency then multiply. If you are going to the “1” from the other currency then divide.

What is the 3 strongest currency? ›

List of Highest Currencies in the World 2024
CurrencySymbolINR Value In Rs (As on May 2024)
Kuwaiti Dinar1 KWD271.43
Bahraini Dinar1 BHD221.42
Omani Rial1 OMR216.86
Jordanian Dinar1 JOD117.91
6 more rows

How do exchange rates work for dummies? ›

The exchange rate gives the relative value of one currency against another currency. An exchange rate GBP/USD of two, for example, indicates that one pound will buy two U.S. dollars. The U.S. dollar is the most commonly used reference currency, which means other currencies are usually quoted against the U.S. dollar.

How to calculate exchange rate between three currencies? ›

The most popular triangular opportunities are usually found with the CHF, EUR, GBP, JPY, and U.S. dollars in order to convert from euros to home currencies. The cross rate should equal the ratio of the two corresponding pairs; therefore, EUR/GBP = EUR/USD divided by GBP/USD, just like GBP/CHF = GBP/USD x USD/CHF.

How does foreign currency work? ›

Foreign currency exchange converts one currency into another, but it's not usually at a 1:1 ratio. Exchange rates change regularly based on fluctuations in global trade markets. When an international money transfer is made between currencies, the rate calculates the difference based on the markets at that exact time.

How do you explain foreign currency? ›

The exchange rate gives the relative value of one currency against another currency. An exchange rate GBP/USD of two, for example, indicates that one pound will buy two U.S. dollars. The U.S. dollar is the most commonly used reference currency, which means other currencies are usually quoted against the U.S. dollar.

How do you calculate dollar value? ›

The formula below calculates the real value of past dollars in more recent dollars: Past dollars in terms of recent dollars = Dollar amount × Ending-period CPI ÷ Beginning-period CPI. In other words, $100 in January 1942 would buy the same amount of "stuff" as $1,233.76 in March 2005.

How do I convert USD to CAD manually? ›

To convert US Dollars ($, USD) to Canadian Dollars (CAD), we multiply the given value of US Dollars by 1.26 because 1 US Dollar = 1.26 Canadian Dollars. Want to find complex math solutions within seconds? Use our free online calculator to solve challenging questions.

Top Articles
Latest Posts
Article information

Author: Allyn Kozey

Last Updated:

Views: 5827

Rating: 4.2 / 5 (43 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Allyn Kozey

Birthday: 1993-12-21

Address: Suite 454 40343 Larson Union, Port Melia, TX 16164

Phone: +2456904400762

Job: Investor Administrator

Hobby: Sketching, Puzzles, Pet, Mountaineering, Skydiving, Dowsing, Sports

Introduction: My name is Allyn Kozey, I am a outstanding, colorful, adventurous, encouraging, zealous, tender, helpful person who loves writing and wants to share my knowledge and understanding with you.