Description
Please create a workbook called Answer and all results should be presented in the first sheet of it. You can find the Problem and Data you may need in the following attachment. I want to understand the details (function and theory, etc) that may need to be used in this question. So please write your process and answer as specifical as possible you can.
Unformatted Attachment Preview
Computations for each ticker (TSLA, SP500 and EURUSD) should be performed
on different sheets to be placed after the results. You can put the data on a different
sheet or together with the computations of the corresponding ticker. All sheets should
be formatted professionally. Use titles when necessary, format numbers to an
appropriate number of decimals, use borders to delimitate blocks of computations like
a binomial tree for the stock or the call.
The data for the problem can be found in the following attach. The file contains
daily values for the price of TSLA, the level of the S&P 500 and the EUR/USD
exchange rate for the 3 months prior to 9/26/2023. Note that the dates for which we
have data for the EUR/USD might differ from the ones for the S&P 500 or TSLA.
Here’s the problem:
Date
TSLA
27-Jun-23
250.21
28-Jun-23
256.24
29-Jun-23
257.5
30-Jun-23
261.77
3-Jul-23
279.82
5-Jul-23
282.48
6-Jul-23
276.54
7-Jul-23
274.43
10-Jul-23
269.61
11-Jul-23
269.79
12-Jul-23
271.99
13-Jul-23
277.9
14-Jul-23
281.38
17-Jul-23
290.38
18-Jul-23
293.34
19-Jul-23
291.26
20-Jul-23
262.9
21-Jul-23
260.02
24-Jul-23
269.06
25-Jul-23
265.28
26-Jul-23
264.35
27-Jul-23
255.71
28-Jul-23
266.44
31-Jul-23
267.43
1-Aug-23
261.07
2-Aug-23
254.11
3-Aug-23
259.32
4-Aug-23
253.86
7-Aug-23
251.45
8-Aug-23
249.7
9-Aug-23
242.19
10-Aug-23
245.34
11-Aug-23
242.65
14-Aug-23
239.76
15-Aug-23
232.96
16-Aug-23
225.6
17-Aug-23
219.22
18-Aug-23
215.49
21-Aug-23
231.28
22-Aug-23
233.19
23-Aug-23
236.86
24-Aug-23
230.04
25-Aug-23
238.59
28-Aug-23
238.82
29-Aug-23
257.18
30-Aug-23
256.9
31-Aug-23
1-Sep-23
5-Sep-23
6-Sep-23
7-Sep-23
8-Sep-23
11-Sep-23
12-Sep-23
13-Sep-23
14-Sep-23
15-Sep-23
18-Sep-23
19-Sep-23
20-Sep-23
21-Sep-23
22-Sep-23
25-Sep-23
26-Sep-23
258.08
245.01
256.49
251.92
251.49
248.5
273.58
267.48
271.3
276.04
274.39
265.28
266.5
262.59
255.7
244.88
246.99
244.12
Date
S&P 500
27-Jun-23 4,378.41
28-Jun-23 4,376.86
29-Jun-23 4,396.44
30-Jun-23 4,450.38
3-Jul-23 4,455.59
5-Jul-23 4,446.82
6-Jul-23 4,411.59
7-Jul-23 4,398.95
10-Jul-23 4,409.53
11-Jul-23 4,439.26
12-Jul-23 4,472.16
13-Jul-23 4,510.04
14-Jul-23 4,505.42
17-Jul-23 4,522.79
18-Jul-23 4,554.98
19-Jul-23 4,565.72
20-Jul-23 4,534.87
21-Jul-23 4,536.34
24-Jul-23 4,554.64
25-Jul-23 4,567.46
26-Jul-23 4,566.75
27-Jul-23 4,537.41
28-Jul-23 4,582.23
31-Jul-23 4,588.96
1-Aug-23 4,576.73
2-Aug-23 4,513.39
3-Aug-23 4,501.89
4-Aug-23 4,478.03
7-Aug-23 4,518.44
8-Aug-23 4,499.38
9-Aug-23 4,467.71
10-Aug-23 4,468.83
11-Aug-23 4,464.05
14-Aug-23 4,489.72
15-Aug-23 4,437.86
16-Aug-23 4,404.33
17-Aug-23 4,370.36
18-Aug-23 4,369.71
21-Aug-23 4,399.77
22-Aug-23 4,387.55
23-Aug-23 4,436.01
24-Aug-23 4,376.31
25-Aug-23 4,405.71
28-Aug-23 4,433.31
29-Aug-23 4,497.63
30-Aug-23 4,514.87
31-Aug-23
1-Sep-23
5-Sep-23
6-Sep-23
7-Sep-23
8-Sep-23
11-Sep-23
12-Sep-23
13-Sep-23
14-Sep-23
15-Sep-23
18-Sep-23
19-Sep-23
20-Sep-23
21-Sep-23
22-Sep-23
25-Sep-23
26-Sep-23
4,507.66
4,515.77
4,496.83
4,465.48
4,451.14
4,457.49
4,487.46
4,461.90
4,467.44
4,505.10
4,450.32
4,453.53
4,443.95
4,402.20
4,330.00
4,320.06
4,337.44
4,273.53
Date
EUR/USD
26-Jun-23
1.091
27-Jun-23
1.0957
28-Jun-23
1.0916
29-Jun-23
1.0868
2-Jul-23
1.0908
3-Jul-23
1.0913
4-Jul-23
1.0885
5-Jul-23
1.0857
6-Jul-23
1.0891
9-Jul-23
1.097
10-Jul-23
1.1006
11-Jul-23
1.1014
12-Jul-23
1.1145
13-Jul-23
1.1223
16-Jul-23
1.1228
17-Jul-23
1.1238
18-Jul-23
1.1229
19-Jul-23
1.1205
20-Jul-23
1.1137
23-Jul-23
1.1125
24-Jul-23
1.1063
25-Jul-23
1.105
26-Jul-23
1.1078
27-Jul-23
1.0979
30-Jul-23
1.1024
31-Jul-23
1.0998
1-Aug-23
1.1008
2-Aug-23
1.0944
3-Aug-23
1.0952
6-Aug-23
1.1003
7-Aug-23
1.1003
8-Aug-23
1.0959
9-Aug-23
1.0978
10-Aug-23
1.0982
13-Aug-23
1.0944
14-Aug-23
1.091
15-Aug-23
1.0904
16-Aug-23
1.0875
17-Aug-23
1.0875
20-Aug-23
1.0876
21-Aug-23
1.0898
22-Aug-23
1.0847
23-Aug-23
1.0866
24-Aug-23
1.0799
27-Aug-23
1.0797
28-Aug-23
1.0826
29-Aug-23
30-Aug-23
31-Aug-23
3-Sep-23
4-Sep-23
5-Sep-23
6-Sep-23
7-Sep-23
10-Sep-23
11-Sep-23
12-Sep-23
13-Sep-23
14-Sep-23
17-Sep-23
18-Sep-23
19-Sep-23
20-Sep-23
21-Sep-23
24-Sep-23
25-Sep-23
26-Sep-23
1.0869
1.0933
1.0844
1.0776
1.0794
1.0726
1.0724
1.0698
1.0718
1.075
1.0753
1.0734
1.0637
1.0668
1.0693
1.0682
1.0653
1.0662
1.0648
1.0592
1.0522
Purchase answer to see full
attachment
