Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

NEED HELP with C and C x Data Table (Click on the icon to import the table into a spreadsheet.) China Cheap Date in Exchange

image text in transcribedimage text in transcribedNEED HELP with C and C

x Data Table (Click on the icon to import the table into a spreadsheet.) China Cheap Date in Exchange Exchange Rate Cheap Date in Relative Country City Local Currency Rate Quote 7 April 2014 In USD to NYC Australia Sydney AUD 111.96 USD = 1 AUD 0.9290 104.01 112% Brazil Rio de Janeiro BRL 135.43 USD = 1 BRL 0.4363 Canada Ottawa CAD 78.33 USD = 1 CAD 0.9106 Shanghai CNY 373.87 USD = 1 CNY 0.1619 France Paris EUR 75.57 USD = 1 EUR 1.3702 Germany Berlin EUR 76.49 USD = 1 EUR 1.3702 Hong Kong Hong Kong HKD 467.03 USD = 1 HKD 0.1289 India Mumbai INR 1,379.64 USD = 1 INR 0.0167 Indonesia Jakarta IDR 314,700 USD = 1 IDR 0.0001 Japan Tokyo JPY 10,269.07 USD = 1 JPY 0.0097 Malaysia Kuala Lumpur MYR 117.85 USD = 1 MYR 0.3048 Mexico Mexico City MXN 423.93 USD = 1 MXN 0.0769 New Zealand Auckland NZD 111.52 USD = 1 NZD 0.8595 Phillipines Manila PHP 1,182.88 USD = 1 PHP 0.0222 Russia Moscow RUB 2,451.24 USD = 1 RUB 0.0283 Singapore Singapore SGD 77.89 USD = 1 SGD 0.7939 South Africa Cape Town ZAR 388.58 USD = 1 ZAR 0.0946 United Kingdom London GBP 73.29 USD = 1 GBP 1.6566 United States New York City USD 93.20 1 USD 1.0000 93.20 100% United States San Francisco USD 88.72 1 USD 1.0000 Source: Data drawn from The Random Walk, Mapping the World's Prices 2014, Deutsche Bank Research, 09 May 2014, Figures 30 and 32, with author calculations. 'Relative to NYC' is calculated as = Cheap Date in USD/93.20. Note: The cheap date combines the local currency cost of a cab ride for two, two McDonald's hamburgers, two soft drinks, two movie tickets, and two beare. In 2012 Deutsche Bank had included canding a bouquet of rocec in the data but did not include that in the 2014 indey making the two Print Done Done Score: 1 of 3 pts 1 of 15 (15 complete) % Problem 1-1 (algorithmic) Comparing Cheap Dates Around the World. Comparison of prices or costs across different country and currency environments requires translation of the local currency into a single common currer product or service across countries. Deutsche Bank has recently started publishing a comparison of cheap datesand evening on the town for two to eat at McDonald's, see a movie, and drink a bee cost of the date can be compared across cities relative to the base case of a cheap date in USD in New York City. After completing the table E answer the following questions. a. Which city in the table is truly the cheapest date? b. Which city in the table is the most expensive-cheap date? c. If the exchange rate in Moscow on the Russian ruble (RUB) was USD0.0435/RUB, instead of USD0.0283 / RUB, what would be the USD price? d. If the exchange rate in Shanghai was CNY6.55/USD, what would be its cost in USD and relative to a cheap date in New York City? a. Which city in the table is truly the cheapest date? (Select the best choice below.) O A. The truly cheapest cheap date could be had in Mexico City, Mexico, at only 25% of what it costs in New York City. OB. The truly cheapest cheap date could be had in Manila, Phillipines, at only 25% of what it costs in New York City. OC. The truly cheapest cheap date could be had in Jakarta, Indonesia, at only 25% of what it costs in New York City. D. The truly cheapest cheap date could be had in Mumbai, India, at only 25% of what it costs in New York City. b. Which city in the table is the most expensive-cheap date? (Select the best choice below.) O A. The most expensive-cheap date would be Sydney at 130% of the cost of New York City. O B. The most expensive-cheap date would be Paris at 130% of the cost of New York City. C. The most expensive-cheap date would be London at 130% of the cost of New York City. OD. The most expensive-cheap date would be Berlin at 130% of the cost of New York City. c. If the exchange rate in Moscow on the Russian ruble (RUB) was USD0.0435/RUB, instead of USDO.0283 / RUB, what would be the USD price? The cheap date in Moscow is USD - (Round to the nearest cent.) Enter your answer in the answer box and then click Check Answer x Data Table (Click on the icon to import the table into a spreadsheet.) China Cheap Date in Exchange Exchange Rate Cheap Date in Relative Country City Local Currency Rate Quote 7 April 2014 In USD to NYC Australia Sydney AUD 111.96 USD = 1 AUD 0.9290 104.01 112% Brazil Rio de Janeiro BRL 135.43 USD = 1 BRL 0.4363 Canada Ottawa CAD 78.33 USD = 1 CAD 0.9106 Shanghai CNY 373.87 USD = 1 CNY 0.1619 France Paris EUR 75.57 USD = 1 EUR 1.3702 Germany Berlin EUR 76.49 USD = 1 EUR 1.3702 Hong Kong Hong Kong HKD 467.03 USD = 1 HKD 0.1289 India Mumbai INR 1,379.64 USD = 1 INR 0.0167 Indonesia Jakarta IDR 314,700 USD = 1 IDR 0.0001 Japan Tokyo JPY 10,269.07 USD = 1 JPY 0.0097 Malaysia Kuala Lumpur MYR 117.85 USD = 1 MYR 0.3048 Mexico Mexico City MXN 423.93 USD = 1 MXN 0.0769 New Zealand Auckland NZD 111.52 USD = 1 NZD 0.8595 Phillipines Manila PHP 1,182.88 USD = 1 PHP 0.0222 Russia Moscow RUB 2,451.24 USD = 1 RUB 0.0283 Singapore Singapore SGD 77.89 USD = 1 SGD 0.7939 South Africa Cape Town ZAR 388.58 USD = 1 ZAR 0.0946 United Kingdom London GBP 73.29 USD = 1 GBP 1.6566 United States New York City USD 93.20 1 USD 1.0000 93.20 100% United States San Francisco USD 88.72 1 USD 1.0000 Source: Data drawn from The Random Walk, Mapping the World's Prices 2014, Deutsche Bank Research, 09 May 2014, Figures 30 and 32, with author calculations. 'Relative to NYC' is calculated as = Cheap Date in USD/93.20. Note: The cheap date combines the local currency cost of a cab ride for two, two McDonald's hamburgers, two soft drinks, two movie tickets, and two beare. In 2012 Deutsche Bank had included canding a bouquet of rocec in the data but did not include that in the 2014 indey making the two Print Done Done Score: 1 of 3 pts 1 of 15 (15 complete) % Problem 1-1 (algorithmic) Comparing Cheap Dates Around the World. Comparison of prices or costs across different country and currency environments requires translation of the local currency into a single common currer product or service across countries. Deutsche Bank has recently started publishing a comparison of cheap datesand evening on the town for two to eat at McDonald's, see a movie, and drink a bee cost of the date can be compared across cities relative to the base case of a cheap date in USD in New York City. After completing the table E answer the following questions. a. Which city in the table is truly the cheapest date? b. Which city in the table is the most expensive-cheap date? c. If the exchange rate in Moscow on the Russian ruble (RUB) was USD0.0435/RUB, instead of USD0.0283 / RUB, what would be the USD price? d. If the exchange rate in Shanghai was CNY6.55/USD, what would be its cost in USD and relative to a cheap date in New York City? a. Which city in the table is truly the cheapest date? (Select the best choice below.) O A. The truly cheapest cheap date could be had in Mexico City, Mexico, at only 25% of what it costs in New York City. OB. The truly cheapest cheap date could be had in Manila, Phillipines, at only 25% of what it costs in New York City. OC. The truly cheapest cheap date could be had in Jakarta, Indonesia, at only 25% of what it costs in New York City. D. The truly cheapest cheap date could be had in Mumbai, India, at only 25% of what it costs in New York City. b. Which city in the table is the most expensive-cheap date? (Select the best choice below.) O A. The most expensive-cheap date would be Sydney at 130% of the cost of New York City. O B. The most expensive-cheap date would be Paris at 130% of the cost of New York City. C. The most expensive-cheap date would be London at 130% of the cost of New York City. OD. The most expensive-cheap date would be Berlin at 130% of the cost of New York City. c. If the exchange rate in Moscow on the Russian ruble (RUB) was USD0.0435/RUB, instead of USDO.0283 / RUB, what would be the USD price? The cheap date in Moscow is USD - (Round to the nearest cent.) Enter your answer in the answer box and then click Check

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Theory And Practice Of Investment Management

Authors: Frank J Fabozzi, Harry M Markowitz

2nd Edition

0470929901, 9780470929902

More Books

Students also viewed these Finance questions

Question

How have psychologists and others confounded sex and gender?

Answered: 1 week ago