Expert Answer:finish a project question

  

Solved by verified expert:Please help me finish the project that write introduction part and analysis question 1-4 in report, and using the excel tools to do calculate Question 1-4In addition, please cut a screenshot of each step of the excel formYou just finish 1-4thanks
prices_2018.xlsx

project_comm3203_w2019.pdf

Don't use plagiarized sources. Get Your Custom Essay on
Expert Answer:finish a project question
Just from $10/Page
Order Essay

Unformatted Attachment Preview

Start
End
Frequency
Name
1/1/2018
1/2/2018
1/3/2018
1/4/2018
1/5/2018
1/8/2018
1/9/2018
1/10/2018
1/11/2018
1/12/2018
1/15/2018
1/16/2018
1/17/2018
1/18/2018
1/19/2018
1/22/2018
1/23/2018
1/24/2018
1/25/2018
1/26/2018
1/29/2018
1/30/2018
1/31/2018
2/1/2018
2/2/2018
2/5/2018
2/6/2018
2/7/2018
2/8/2018
2/9/2018
2/12/2018
2/13/2018
2/14/2018
2/15/2018
2/16/2018
2/19/2018
2/20/2018
2/21/2018
2/22/2018
2/23/2018
2/26/2018
2/27/2018
2/28/2018
1/1/2018
12/31/2018
D
ROYAL BANK OF CANADA
AURORA CANNABIS EMERA
102.65
9.25
102.95
11.39
103.89
13.66
104.89
12.56
104.74
12.68
104.31
13.38
104.84
13.13
105.01
12.84
105.08
11.79
105.16
9.94
105.26
11.08
105.77
11.47
106.28
11.87
106.91
12.5
107.72
12.99
108.05
13.97
107.36
14.25
106.01
13.47
105.52
12.63
105.72
12.8
105.14
12.49
105.45
11.2
105.32
11.27
104.67
9.85
103.55
8.19
101.14
8.91
101.35
11.11
101.07
10.74
99.24
10.74
99.08
10.92
99.72
10.9
99.81
10.74
100.51
10.73
100.6
10.45
100.48
9.76
100.48
9.76
100.49
10.56
102.5
10.33
102.16
10.38
102.56
10.18
102.39
9.79
102.88
9.53
101.09
10.02
46.98
47.19
46.96
46.71
46.81
47.12
46.78
46.3
46.15
46
46.17
46.34
46.45
46.18
46.12
46.36
46.39
46.37
46.39
46.61
46.07
45.94
45.5
44.97
44.03
43.8
43.32
43.33
42.88
43.32
41.53
39.93
39.69
40.36
41.37
41.37
41.43
41.16
41.2
41.91
41.93
41.55
41.41
3/1/2018
3/2/2018
3/5/2018
3/6/2018
3/7/2018
3/8/2018
3/9/2018
3/12/2018
3/13/2018
3/14/2018
3/15/2018
3/16/2018
3/19/2018
3/20/2018
3/21/2018
3/22/2018
3/23/2018
3/26/2018
3/27/2018
3/28/2018
3/29/2018
3/30/2018
4/2/2018
4/3/2018
4/4/2018
4/5/2018
4/6/2018
4/9/2018
4/10/2018
4/11/2018
4/12/2018
4/13/2018
4/16/2018
4/17/2018
4/18/2018
4/19/2018
4/20/2018
4/23/2018
4/24/2018
4/25/2018
4/26/2018
4/27/2018
4/30/2018
5/1/2018
5/2/2018
5/3/2018
5/4/2018
100.57
99.91
100.91
100.76
100.56
101.52
101.76
101.81
101.81
101.54
102.19
102.32
102.04
102.62
102.27
100.64
99.21
99.86
98.88
98.69
99.52
99.52
98.73
98.2
97.59
98.34
97.3
98.04
98.05
97.04
96.76
96.06
96.39
96.22
97
96.63
97.28
97.98
96.55
96.61
97.18
98.15
97.64
97.67
97.71
97.66
97.83
10.39
10.24
10.85
11.31
10.8
10.79
10.92
11.22
10.98
10.89
10.84
10.55
10.41
9.92
9.71
9.28
9.74
9.54
9.18
8.7
8.96
8.96
8.74
7.78
7.34
8.13
7.8
7.13
7.6
7.64
7.75
8.41
8.6
8.13
8.31
8.42
8.3
7.73
7.94
7.52
7.44
7.37
7.79
7.59
7.66
7.73
7.74
41.36
41.53
41.54
41.01
40.91
40.6
40.85
41.13
40.74
40.57
40.58
40
40.3
40.76
40.91
41.06
40.79
40.3
40.71
40.91
40.76
40.76
41.29
41.2
41.01
41.6
41.21
41.41
40.77
40.51
40.11
40.13
40.45
40.44
40.72
40.57
40.27
40.5
40.25
40.22
40.78
41.13
39.99
40.46
40.59
41
41.15
5/7/2018
5/8/2018
5/9/2018
5/10/2018
5/11/2018
5/14/2018
5/15/2018
5/16/2018
5/17/2018
5/18/2018
5/21/2018
5/22/2018
5/23/2018
5/24/2018
5/25/2018
5/28/2018
5/29/2018
5/30/2018
5/31/2018
6/1/2018
6/4/2018
6/5/2018
6/6/2018
6/7/2018
6/8/2018
6/11/2018
6/12/2018
6/13/2018
6/14/2018
6/15/2018
6/18/2018
6/19/2018
6/20/2018
6/21/2018
6/22/2018
6/25/2018
6/26/2018
6/27/2018
6/28/2018
6/29/2018
7/2/2018
7/3/2018
7/4/2018
7/5/2018
7/6/2018
7/9/2018
7/10/2018
98.76
98.88
99.63
99.96
100.38
100.99
101.04
101.31
101.05
100.57
100.57
101.75
101.12
99.12
98.58
98.07
96.88
96.79
98
98.14
98.94
99.32
99.24
99.4
99.89
99.94
100.06
99.92
99.85
100.26
100.44
99.97
100.44
100.66
101.37
99.8
99.61
99.03
98.82
98.99
98.99
99.49
99.37
99.59
100.2
100.79
101.31
7.81
7.5
7.74
7.67
7.78
7.61
7.51
7.19
6.94
7.63
7.63
8.07
8.16
7.96
7.73
7.84
7.84
7.88
7.83
7.77
7.88
8.39
9.43
9.29
8.96
8.59
8.54
8.69
8.65
8.73
8.8
9.19
9.63
10.09
9.63
9.34
9.09
8.63
9.07
8.96
8.96
8.94
8.96
9.02
8.91
8.83
8.79
41.14
40.87
40.71
40
40.23
40.24
40.66
40.58
40.37
40.66
40.66
40.05
40.4
40.5
40.62
40.67
40.5
40.53
40.5
40.25
40.25
40.35
39.99
40.1
40.15
40.21
40.23
40.13
40.23
41.13
41
41.2
41.57
42.05
42.73
42.82
42.99
42.9
42.74
42.8
42.8
42.8
42.84
42.73
42.8
42.15
42.45
7/11/2018
7/12/2018
7/13/2018
7/16/2018
7/17/2018
7/18/2018
7/19/2018
7/20/2018
7/23/2018
7/24/2018
7/25/2018
7/26/2018
7/27/2018
7/30/2018
7/31/2018
8/1/2018
8/2/2018
8/3/2018
8/6/2018
8/7/2018
8/8/2018
8/9/2018
8/10/2018
8/13/2018
8/14/2018
8/15/2018
8/16/2018
8/17/2018
8/20/2018
8/21/2018
8/22/2018
8/23/2018
8/24/2018
8/27/2018
8/28/2018
8/29/2018
8/30/2018
8/31/2018
9/3/2018
9/4/2018
9/5/2018
9/6/2018
9/7/2018
9/10/2018
9/11/2018
9/12/2018
9/13/2018
100.58
101.51
101.46
101.94
102
101.49
101.4
101.48
101.8
102.03
100.88
101.08
101.09
101.33
101.55
101.81
101.47
101.42
101.42
100.51
101.16
101.89
101.3
101.36
102.1
101.48
102
102.8
102.9
102.59
103.97
103.68
103.64
103.96
103.81
104.49
104.78
103.66
103.66
103.77
103.76
104.06
103.58
103.65
103.75
103.18
103
8.7
8.6
8.31
7.77
7.68
7.67
7.4
7.09
7.42
6.85
6.69
6.6
6.72
6.56
6.76
6.59
6.49
6.3
6.3
5.93
5.95
6.02
5.87
5.7
5.14
6.15
6.02
6.26
7.33
7.86
7.76
8.03
8.59
9.25
8.54
9.07
8.79
8.8
8.8
8.95
8.68
8.19
8.12
8.26
9.09
9.11
8.3
42.37
42.58
42.51
42.54
42.69
42.05
42.64
42.72
42.24
42.37
42.34
42.55
42.41
42.3
42.15
41.97
42.18
42.57
42.57
42.29
42.24
41.62
39.64
40.14
40.25
40.95
41.47
41.93
41.73
41.28
40.8
40.54
40.58
40.51
40.61
40.95
41.4
41.29
41.29
41.31
41.17
41.27
41.26
41.21
40.65
40.85
40.85
9/14/2018
9/17/2018
9/18/2018
9/19/2018
9/20/2018
9/21/2018
9/24/2018
9/25/2018
9/26/2018
9/27/2018
9/28/2018
10/1/2018
10/2/2018
10/3/2018
10/4/2018
10/5/2018
10/8/2018
10/9/2018
10/10/2018
10/11/2018
10/12/2018
10/15/2018
10/16/2018
10/17/2018
10/18/2018
10/19/2018
10/22/2018
10/23/2018
10/24/2018
10/25/2018
10/26/2018
10/29/2018
10/30/2018
10/31/2018
11/1/2018
11/2/2018
11/5/2018
11/6/2018
11/7/2018
11/8/2018
11/9/2018
11/12/2018
11/13/2018
11/14/2018
11/15/2018
11/16/2018
11/19/2018
103.07
103.52
103.95
103.99
104.55
104.09
104.34
104.43
104.38
104.55
103.54
103.6
102.91
103.11
103.38
102.89
102.89
102.31
100.7
98.7
98.78
98.4
99.66
99.98
98.96
99
98.26
98.44
94.6
94.73
94.49
94.02
95.39
95.92
95.86
95.75
95.64
95.54
95.93
96.59
95.95
95.33
95.75
95.3
95.65
95.37
94.82
8.54
9.98
11.02
10.87
12.25
11.84
12.27
12.77
12.19
11.68
12.41
12.46
11.93
12.55
12.16
12.81
12.81
13.24
13.13
12.62
13.71
15.07
13.98
13.57
13.76
13.01
11.42
10.08
9.46
9.55
9.18
7.7
7.97
8.94
8.79
9.2
9.56
9.72
10.59
9.94
9.36
9.2
8.74
8.16
8.75
8.39
8.02
41.15
41.5
41.38
40.78
40.44
40.38
40.28
40.08
39.97
40.1
40.16
40.07
40.21
39.61
39.19
39.48
39.48
39.15
38.46
38.42
38.4
38.44
38.97
39.04
38.86
39.23
39.27
39.8
40.5
40.37
40.27
40.32
41.16
40.62
40.07
39.75
40.5
40.7
41.05
40.74
43.08
43.14
43.27
43.77
43.87
44
43.99
11/20/2018
11/21/2018
11/22/2018
11/23/2018
11/26/2018
11/27/2018
11/28/2018
11/29/2018
11/30/2018
12/3/2018
12/4/2018
12/5/2018
12/6/2018
12/7/2018
12/10/2018
12/11/2018
12/12/2018
12/13/2018
12/14/2018
12/17/2018
12/18/2018
12/19/2018
12/20/2018
12/21/2018
12/24/2018
12/25/2018
12/26/2018
12/27/2018
12/28/2018
12/31/2018
93.62
95.88
94.94
95.06
94.88
95.49
98.1
97.82
97.42
97.45
96.71
97.6
95.72
94.56
94.09
93.36
94.42
94.21
94.32
93.5
93.8
92.68
92.21
90.95
90.21
90.21
90.21
92.71
93.1
93.44
8.03
8.25
8
8
7.51
7.29
7.91
7.51
7.6
7.52
7.12
6.21
7.05
7.6
7.67
7.93
8.15
7.61
7.84
7.41
7.44
7.14
6.88
6.67
6.81
6.81
6.81
6.8
7.12
6.78
43.52
43.6
43.45
43.52
43.37
43.41
44.11
44.8
44.6
44.67
45.21
45.34
45.33
44.96
44.78
44.47
44.37
44.57
44.43
43.9
44.05
43.76
43.65
43.25
41.91
41.91
41.91
42.79
43.48
43.71
COMM 3203 – Financial Institutions
Winter 2019
Mini-project
(Due date: March 29, 2019)
Instructions:





You must work and hand in the project in groups of minimum two (2) and
maximum four (4) students.
The mini-project report together with the Excel file should be submitted on
Brightspace by only one team member no later than the beginning of class on the
due date.
A hard copy of the assignment (not the Excel file) will be submitted to the instructor
at the beginning of class on the due date. Only one write-up must be submitted by
each group.
Late submissions will not be accepted and will automatically be given a grade of
zero.
All submissions must be typed! Points can be deducted for poor presentation and
organization of the work. This project counts for 10% of your final grade.
Evaluating Value at Risk (VaR)
The purpose of this exercise consists in computing a VaR measure for a $1 million trading
portfolio of an investment bank. The portfolio is composed of $350,000 of Emera (EMA)
stock, $150,000 of Aurora Cannabis (ACB) stock and $500,000 of Royal Bank (RY) stock.
The file prices_2018.xls (that can be downloaded from Brightspace) contains daily
historical closing prices over the last year (2018) for the three stocks.
1) Calculate the daily arithmetic returns for each of the stocks over the sample
period. Using “Tools/Data Analysis/Descriptive statistics” calculate the mean,
standard deviation, kurtosis, and skewness for each of the historical distributions of
returns. Based on these statistics, do the historical distributions of returns of the
three stocks look like the normal distribution? (explain)
2) Using “Tools/Data Analysis/Histogram” visually inspect the historical distribution
of returns of each of the stocks. Do they resemble to the normal distribution?
3) What are the VaRs (1.5%,1 day) and VaRs(1.5%, 20 days) at the end of 2018 of
the investments in each of the stocks if they were held separately and assuming a
normal distribution of daily returns? Answer using the parametric method for
computing the VaR with the standard deviations obtained in 1), and the function
1
“normsinv” for deriving the value of the standard normal deviate (alpha)
corresponding to the chosen confidence level.
4) By assuming a normal distribution for the daily returns, what is the portfolio
VaR(1.5%,1 day) at the end of 2018? (Use “Tools/Data analysis/Correlation” to
compute the correlations of the daily returns of the three stocks.) What can you say
if you compare the portfolio VaR with the sum of the VaRs obtained in 3)?
5) Compute the historical VaR (1.5%,1-day) at the end of 2018 of the position on the
RY stock. Compare and interpret the differences between the VaR(1.5%,1-day)
estimates from the two different VaR models for the position in the RY stock.
6) For the RY stock, compute the standard deviation of its returns for each day using
the returns from the previous 20 trading days. Compute the VaR(1.5%,1 day) for
each day using the standard deviation of returns for 20 previous days (thus, you
obtain a dynamic VaR). Plot the bank’s daily returns together with each day VaR
and compute the number of times the daily return exceeded the VaR (remember
that the VaR corresponds to a loss). Is the result coherent with the confidence level
you use for computing the VaR?
7) What is the portfolio VaR(1.5%,1 day) at the end of 2018 using the historical
simulation approach rather than by assuming normal distributions as in 4)? (Hint:
Rank the daily portfolio returns using for example the function “sort” or use a
function for finding a percentile.)
2

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP