Question
1. Use the data from the file economic risk attached to answer the following: a. How does a 1% change in the exchange rate for
1. Use the data from the file economic risk attached to answer the following:
a. How does a 1% change in the exchange rate for the Brazilian real affect the price of the stock?
b. Is the relationship between the changes in the value of the real and returns on the stock statistically significant? Explain how you determine this.
c. If an investor owning stock in the company were to hedge the real related risk of the stock perfectly, how much lower would the risk of the investment be? (That is, how much lower would the volatility of the stock be after hedging real related risk?)
d. When the value of the real increases, how does the stock price change?
If the value of the real increases, the stock price increases.
Date | Stock price | USD/BRL |
6/29/18 | 0.20 | 3.9714 |
6/28/18 | 0.25 | 3.972 |
6/27/18 | 0.25 | 3.9706 |
6/26/18 | 0.25 | 3.9678 |
6/25/18 | 0.23 | 3.9643 |
6/22/18 | 0.31 | 3.9675 |
6/21/18 | 0.21 | 3.9767 |
6/20/18 | 0.22 | 3.9689 |
6/19/18 | 0.21 | 3.9723 |
6/18/18 | 0.21 | 3.9557 |
6/15/18 | 0.34 | 3.9661 |
6/14/18 | 0.30 | 3.9661 |
6/13/18 | 0.34 | 3.9631 |
6/12/18 | 0.34 | 3.9634 |
6/11/18 | 0.34 | 3.9567 |
6/8/18 | 0.30 | 3.9665 |
6/7/18 | 0.29 | 3.9656 |
6/6/18 | 0.29 | 3.9578 |
6/5/18 | 0.29 | 3.9635 |
6/4/18 | 0.30 | 3.9608 |
6/1/18 | 0.35 | 3.9659 |
5/31/18 | 0.40 | 3.9658 |
5/30/18 | 0.35 | 3.9758 |
5/29/18 | 0.35 | 3.9742 |
5/25/18 | 0.27 | 3.9708 |
5/24/18 | 0.29 | 3.9672 |
5/23/18 | 0.15 | 3.9757 |
5/22/18 | 0.15 | 3.9697 |
5/21/18 | 0.20 | 3.9626 |
5/18/18 | 0.20 | 3.9667 |
5/17/18 | 0.12 | 3.9834 |
5/16/18 | 0.14 | 3.9818 |
5/15/18 | 0.14 | 3.9792 |
5/14/18 | 0.14 | 3.9915 |
5/11/18 | 0.16 | 3.9744 |
5/10/18 | 0.20 | 3.9649 |
5/9/18 | 0.20 | 3.9859 |
5/8/18 | 0.21 | 3.9991 |
5/7/18 | 0.19 | 4.0067 |
5/4/18 | 0.22 | 3.989 |
5/3/18 | 0.16 | 3.9987 |
5/2/18 | 0.24 | 3.978 |
5/1/18 | 0.24 | 4.0045 |
4/30/18 | 0.24 | 4 |
4/27/18 | 0.21 | 4.0124 |
4/26/18 | 0.25 | 4.016 |
4/25/18 | 0.29 | 4.017 |
4/24/18 | 0.29 | 4.0182 |
4/23/18 | 0.21 | 4.0008 |
4/20/18 | 0.21 | 3.9961 |
4/19/18 | 0.32 | 4.0364 |
4/18/18 | 0.31 | 4.035 |
4/17/18 | 0.29 | 4.0179 |
4/16/18 | 0.29 | 3.9969 |
4/13/18 | 0.26 | 4.0107 |
4/12/18 | 0.30 | 4.0096 |
4/11/18 | 0.29 | 4.0026 |
4/10/18 | 0.20 | 3.9978 |
4/9/18 | 0.20 | 3.9961 |
4/6/18 | 0.22 | 3.9794 |
4/5/18 | 0.22 | 3.9594 |
4/4/18 | 0.24 | 3.9277 |
4/3/18 | 0.25 | 3.9198 |
4/2/18 | 0.25 | 3.9109 |
3/29/18 | 0.25 | 3.9073 |
3/28/18 | 0.23 | 3.9225 |
3/27/18 | 0.20 | 3.9373 |
3/26/18 | 0.20 | 3.909 |
3/23/18 | 0.30 | 3.8725 |
3/22/18 | 0.26 | 3.8597 |
3/21/18 | 0.26 | 3.8528 |
3/20/18 | 0.28 | 3.8525 |
3/19/18 | 0.29 | 3.8418 |
3/16/18 | 0.37 | 3.8168 |
3/15/18 | 0.35 | 3.8121 |
3/14/18 | 0.35 | 3.8205 |
3/13/18 | 0.26 | 3.8298 |
3/12/18 | 0.26 | 3.8278 |
3/9/18 | 0.30 | 3.8202 |
3/8/18 | 0.40 | 3.8308 |
3/7/18 | 0.42 | 3.8017 |
3/6/18 | 0.42 | 3.8009 |
3/5/18 | 0.40 | 3.7898 |
3/2/18 | 0.40 | 3.7927 |
3/1/18 | 0.40 | 3.7878 |
2/28/18 | 0.40 | 3.7799 |
2/27/18 | 0.40 | 3.7818 |
2/26/18 | 0.40 | 3.775 |
2/23/18 | 0.40 | 3.7797 |
2/22/18 | 0.42 | 3.7737 |
2/21/18 | 0.42 | 3.7579 |
2/20/18 | 0.42 | 3.7607 |
2/16/18 | 0.45 | 3.7689 |
2/15/18 | 0.47 | 3.7579 |
2/14/18 | 0.40 | 3.7545 |
2/13/18 | 0.35 | 3.7699 |
2/12/18 | 0.35 | 3.7656 |
2/9/18 | 0.30 | 3.7657 |
2/8/18 | 0.15 | 3.7625 |
2/7/18 | 0.35 | 3.7557 |
2/6/18 | 0.38 | 3.7433 |
2/5/18 | 0.37 | 3.7584 |
2/2/18 | 0.35 | 3.7702 |
2/1/18 | 0.36 | 3.7821 |
1/31/18 | 0.45 | 3.779 |
1/30/18 | 0.37 | 3.7757 |
1/29/18 | 0.32 | 3.7685 |
1/26/18 | 0.27 | 3.7697 |
1/25/18 | 0.37 | 3.7484 |
1/24/18 | 0.35 | 3.738 |
1/23/18 | 0.32 | 3.7332 |
1/22/18 | 0.35 | 3.7134 |
1/19/18 | 0.35 | 3.7036 |
1/18/18 | 0.35 | 3.6953 |
1/17/18 | 0.35 | 3.6915 |
1/16/18 | 0.33 | 3.7014 |
1/12/18 | 0.32 | 3.7043 |
1/11/18 | 0.30 | 3.6934 |
1/10/18 | 0.30 | 3.678 |
1/9/18 | 0.30 | 3.6897 |
1/8/18 | 0.31 | 3.6801 |
1/5/18 | 0.30 | 3.6823 |
1/4/18 | 0.44 | 3.6657 |
1/3/18 | 0.44 | 3.6793 |
1/2/18 | 0.44 | 3.6798 |
12/29/17 | 0.50 | 3.6845 |
12/28/17 | 0.46 | 3.6759 |
12/27/17 | 0.46 | 3.6945 |
12/26/17 | 0.45 | 3.6885 |
12/22/17 | 0.45 | 3.6849 |
12/21/17 | 0.45 | 3.6927 |
12/20/17 | 0.45 | 3.6955 |
12/19/17 | 0.45 | 3.6837 |
12/18/17 | 0.45 | 3.6701 |
12/15/17 | 0.45 | 3.6736 |
12/14/17 | 0.45 | 3.6627 |
12/13/17 | 0.44 | 3.6734 |
12/12/17 | 0.42 | 3.6732 |
12/11/17 | 0.45 | 3.6591 |
12/8/17 | 0.45 | 3.6606 |
12/7/17 | 0.50 | 3.658 |
12/6/17 | 0.45 | 3.6563 |
12/5/17 | 0.45 | 3.6501 |
12/4/17 | 0.45 | 3.6454 |
12/1/17 | 0.45 | 3.6317 |
11/30/17 | 0.46 | 3.6412 |
11/29/17 | 0.45 | 3.6456 |
11/28/17 | 0.48 | 3.6385 |
11/27/17 | 0.50 | 3.6212 |
11/24/17 | 0.50 | 3.6134 |
11/22/17 | 0.52 | 3.6128 |
11/21/17 | 0.52 | 3.612 |
11/20/17 | 0.59 | 3.6107 |
11/17/17 | 0.52 | 3.6177 |
11/16/17 | 0.51 | 3.6178 |
11/15/17 | 0.51 | 3.6232 |
11/14/17 | 0.45 | 3.6243 |
11/13/17 | 0.40 | 3.6241 |
11/10/17 | 0.40 | 3.614 |
11/9/17 | 0.40 | 3.6081 |
11/8/17 | 0.45 | 3.608 |
11/7/17 | 0.41 | 3.6164 |
11/6/17 | 0.38 | 3.6174 |
11/3/17 | 0.40 | 3.6221 |
11/2/17 | 0.45 | 3.6027 |
11/1/17 | 0.45 | 3.6135 |
10/31/17 | 0.52 | 3.6079 |
10/30/17 | 0.55 | 3.6139 |
10/27/17 | 0.52 | 3.6003 |
10/26/17 | 0.54 | 3.6128 |
10/25/17 | 0.57 | 3.6113 |
10/24/17 | 0.52 | 3.6076 |
10/23/17 | 0.52 | 3.6044 |
10/20/17 | 0.52 | 3.6035 |
10/19/17 | 0.54 | 3.6114 |
10/18/17 | 0.51 | 3.5946 |
10/17/17 | 0.55 | 3.6077 |
10/16/17 | 0.55 | 3.6119 |
10/13/17 | 0.50 | 3.5987 |
10/12/17 | 0.58 | 3.5777 |
10/11/17 | 0.60 | 3.5855 |
10/10/17 | 0.60 | 3.5967 |
10/9/17 | 0.59 | 3.5957 |
10/6/17 | 0.50 | 3.5923 |
10/5/17 | 0.65 | 3.5898 |
10/4/17 | 0.60 | 3.5882 |
10/3/17 | 0.60 | 3.582 |
10/2/17 | 0.62 | 3.6009 |
9/29/17 | 0.65 | 3.6051 |
9/28/17 | 0.65 | 3.6085 |
9/27/17 | 0.58 | 3.6043 |
9/26/17 | 0.65 | 3.5979 |
9/25/17 | 0.62 | 3.599 |
9/22/17 | 0.59 | 3.5972 |
9/21/17 | 0.50 | 3.6005 |
9/20/17 | 0.55 | 3.6093 |
9/19/17 | 0.55 | 3.5979 |
9/18/17 | 0.52 | 3.6041 |
9/15/17 | 0.59 | 3.5912 |
9/14/17 | 0.59 | 3.5863 |
9/13/17 | 0.55 | 3.5795 |
9/12/17 | 0.60 | 3.5842 |
9/11/17 | 0.60 | 3.5887 |
9/8/17 | 0.60 | 3.5845 |
9/7/17 | 0.50 | 3.5982 |
9/6/17 | 0.55 | 3.5975 |
9/5/17 | 0.61 | 3.5985 |
9/1/17 | 0.67 | 3.5983 |
8/31/17 | 0.68 | 3.5918 |
8/30/17 | 0.50 | 3.5763 |
8/29/17 | 0.60 | 3.5829 |
8/28/17 | 0.69 | 3.5795 |
8/25/17 | 0.65 | 3.5691 |
8/24/17 | 0.71 | 3.5749 |
8/23/17 | 0.66 | 3.5714 |
8/22/17 | 0.60 | 3.5589 |
8/21/17 | 0.60 | 3.5613 |
8/18/17 | 0.50 | 3.5592 |
8/17/17 | 0.50 | 3.5598 |
8/16/17 | 0.50 | 3.5519 |
8/15/17 | 0.50 | 3.5409 |
8/14/17 | 0.43 | 3.5591 |
8/11/17 | 0.50 | 3.5651 |
8/10/17 | 0.50 | 3.5548 |
8/9/17 | 0.48 | 3.5587 |
8/8/17 | 0.48 | 3.5527 |
8/7/17 | 0.39 | 3.5511 |
8/4/17 | 0.48 | 3.547 |
8/3/17 | 0.50 | 3.5321 |
8/2/17 | 0.50 | 3.5428 |
8/1/17 | 0.50 | 3.5391 |
7/31/17 | 0.50 | 3.5399 |
7/28/17 | 0.49 | 3.5245 |
7/27/17 | 0.41 | 3.531 |
7/26/17 | 0.50 | 3.5234 |
7/25/17 | 0.50 | 3.5362 |
7/24/17 | 0.50 | 3.5335 |
7/21/17 | 0.41 | 3.5232 |
7/20/17 | 0.41 | 3.5287 |
7/19/17 | 0.51 | 3.5337 |
7/18/17 | 0.60 | 3.529 |
7/17/17 | 0.60 | 3.5281 |
7/14/17 | 0.60 | 3.5368 |
7/13/17 | 0.60 | 3.5404 |
7/12/17 | 0.64 | 3.5373 |
7/11/17 | 0.60 | 3.54 |
7/10/17 | 0.60 | 3.5374 |
7/7/17 | 0.60 | 3.5458 |
7/6/17 | 0.60 | 3.5323 |
7/5/17 | 0.60 | 3.5273 |
7/3/17 | 0.65 | 3.5266 |
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