Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

calculate C and D for me I am lost. I included the excel spreadsheet incase you need to see it thats why it looks like

calculate C and D for me I am lost. I included the excel spreadsheet incase you need to see it thats why it looks like a lot. will like if u are right
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Y costs 25 euros, and Component Z costs 110 Butish pounds. The targest market for the 520 as Japar, where the product sells for 32,300 Japaneser yen, Natirally, Yohe in intimately concerned with economic conditions that could adversely affect dollar exclange rates. rvoce: Goumn 2 equals 1.0 divided by column 1. However, rounding differences do occur. Source: Adapted fromithe Walt Street Journal (wsj.com), November 13, 2020. Note: Column 1 shows how many units of each foreign currency a U.S. dollar would buy, column 2 shows how many units a franc would buy, and so on for the other columns. Source: Adapted from data provided in Table Exchange Rates for November 13, 2020. Spot and Forward Exchange Rates (Number of Units of Foreign Currency per U.S. Dollar): Friday, November 13,2020 The data has been collected in the Microsoft Excel file below. Downlond the spreadsheet and perform the required analysis to answer the questions intermediate calculations. a. How much in dollars does it cost Yohe to produce the 5Y207 Round your answer to the fiearest cent. 5 What is the dollar sale price of the 5 Y:20? Round your answer to the nearest cent. b. What is the dollar profit that Yohe makes on the sale of the 5/202 Round wour answer to the nearest cent. 5 What is the percentage profit? Round your answer to two decimal places. C. If the U,5. dollar was to weaken by 7% against all foreign currencies, what would be the dollar and percentage profits for the 5V-207 found yout antwer far the dollar profit to the nearest cent and for the percentage profit to two decimal places. Dollar prefit: 5 Verceriaget probit d. Th the U.5. dollar was to weahen by 7 Wh only agairst the Japanese yen and remained constans relatwe to all obier foreigh currencien, whiat would be the doliar and percentage profits for the 5y20 ? Round your acower for the dollar profic to the nesest cent and for the percentage profic to two decimal ploces: Dollar profic: $. Percentage profit: Y costs 25 euros, and Component Z costs 110 Butish pounds. The targest market for the 520 as Japar, where the product sells for 32,300 Japaneser yen, Natirally, Yohe in intimately concerned with economic conditions that could adversely affect dollar exclange rates. rvoce: Goumn 2 equals 1.0 divided by column 1. However, rounding differences do occur. Source: Adapted fromithe Walt Street Journal (wsj.com), November 13, 2020. Note: Column 1 shows how many units of each foreign currency a U.S. dollar would buy, column 2 shows how many units a franc would buy, and so on for the other columns. Source: Adapted from data provided in Table Exchange Rates for November 13, 2020. Spot and Forward Exchange Rates (Number of Units of Foreign Currency per U.S. Dollar): Friday, November 13,2020 The data has been collected in the Microsoft Excel file below. Downlond the spreadsheet and perform the required analysis to answer the questions intermediate calculations. a. How much in dollars does it cost Yohe to produce the 5Y207 Round your answer to the fiearest cent. 5 What is the dollar sale price of the 5 Y:20? Round your answer to the nearest cent. b. What is the dollar profit that Yohe makes on the sale of the 5/202 Round wour answer to the nearest cent. 5 What is the percentage profit? Round your answer to two decimal places. C. If the U,5. dollar was to weaken by 7% against all foreign currencies, what would be the dollar and percentage profits for the 5V-207 found yout antwer far the dollar profit to the nearest cent and for the percentage profit to two decimal places. Dollar prefit: 5 Verceriaget probit d. Th the U.5. dollar was to weahen by 7 Wh only agairst the Japanese yen and remained constans relatwe to all obier foreigh currencien, whiat would be the doliar and percentage profits for the 5y20 ? Round your acower for the dollar profic to the nesest cent and for the percentage profic to two decimal ploces: Dollar profic: $. Percentage profit

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_2

Step: 3

blur-text-image_3

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

Financial Modeling Using Excel And VBA

Authors: Chandan Sengupta

1st Edition

0471267686, 978-0471267683

More Books

Students also viewed these Finance questions

Question

x-3+1, x23 Let f(x) = -*+3, * Answered: 1 week ago

Answered: 1 week ago