Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I calculate revenues in foreign currency after the dollar appreciates/depreciates by 5%. Company Revenue: 2016:$3,507 2017:$2,986 2018:$10,838 Revenue for the UK division 2016:

How do I calculate revenues in foreign currency after the dollar appreciates/depreciates by 5%.

Company Revenue:

2016:$3,507

2017:$2,986

2018:$10,838

Revenue for the UK division

2016: $1570

2017:$1482

2018:$3392

Exchange Rate: ($1 to GBR)

2016:0.8109

2017: 0.7406

2018:0.7837

If the dollar appreciates by 5%:

What is the overall Revenue in USD?

United Kingdom Revenue in GBR?

United Kingdom Revenue in USD after 5% appreciation?

% of subsidiaryrevenue from total revenue?

If the dollardepreciates by 5%:

What is the overall Revenue in USD?

United Kingdom Revenue in GBR?

United Kingdom Revenue in USD after 5% appreciation?

% of subsidiaryrevenue from total revenue?

I am unsure how to calculate in Excel.

This is for SNHU INT 620

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

Essentials Of Investments

Authors: Zvi Bodie, Alex Kane, Alan Marcus

11th Edition

1260288390, 978-1260288391

More Books

Students also viewed these Finance questions

Question

Define relevant cost. Why are historical costs irrelevant? lop52

Answered: 1 week ago