Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started