Derive the first stocks monthly VaR at a 98% confidence level and interpret your results in dollars.
Fantastic news! We've Found the answer you've been seeking!
Question:
Derive the first stock’s monthly VaR at a 98% confidence level and interpret your results in dollars. Assume the investment for this stock is $1,000,000. To save time,
you do not need to derive the VaRs for the second and third stock.
(The columns continue from the bottom of the previous to the top of the next)
Transcribed Image Text:
A B 1 Year/Month Value 2 2012M09 3 2012M10 4 2012M11 5 2012M12 6 2013M01 7 2013M02 8 2013M03 9 2013M04 10 2013M05 11 2013M06 12 2013M07 13 2013M08 14 2013M09 15 2013M10 16 2013M11 17 2013M12 18 2014M01 19 2014M02 20 2014M03 21 2014M04 22 2014M05 23 2014M06 24 2014M07 25 2014M08 26 2014M09 27 2014M10 28 2014M11 29 2014M12 30 2015M01 31 2015M02 32 2015M03 33 2015M04 34 2015M05 35 2015M06 36 2015M07 m m 678 37 38 120.56 120.115 120.08 118.705 118.574 118.185 118.052 118.626 117.792 117.864 118.182 118.073 118.971 119.608 119.782 119.819 120.682 121.486 122.108 122.015 122.911 123.117 123.571 123.414 123.084 124.823 125.074 126.068 126.018 126.173 126.002 126.964 127.981 128.517 127.966 al с E Year/Month Value 2015M08 2015M09 2015M10 2015M11 2015M12 2016M01 2016M02 2016M03 2016M04 2016M05 2016M06 2016M07 2016M08 2016M09 2016M10 2016M11 2016M12 2017M01 2017M02 2017M03 2017M04 2017M05 2017M06 2017M07 2017M08 2017M09 2017M10 2017M11 2017M12 2018M01 2018M02 2018M03 2018M04 2018M05 2018M06 129.325 129.236 128.707 129.338 130.942 132.128 132.479 132.439 133.329 134.261 133.827 135.051 136.261 137.122 138.308 138.57 139.029 139.039 140.179 140.094 140.73 142.215 141.857 144.076 144.537 144.797 145.87 147.144 148.375 148.825 148.67 149.488 150.009 149.777 149.788 F LL G H Year/Month Value 2018M07 2018M08 2018M09 2018M10 2018M11 2018M12 2019M01 2019M02 2019M03 2019M04 2019M05 2019M06 2019M07 2019M08 2019M09 2019M10 2019M11 2019M12 2020M01 2020M02 2020M03 2020M04 2020M05 2020M06 2020M07 2020M08 2020M09 2020M10 2020M11 2020M12 2021M01 2021M02 2021M03 2021M04 2021M05 150.576 151.33 151.634 152.207 151.82 152.777 152.176 154.086 154.124 153.863 155.248 155.797 154.99 154.578 155.574 155.915 157.657 157.188 158.28 158.29 158.638 157.914 159.647 159.26 158.847 159.824 159.69 159.594 159.132 159.171 159.159 159.29 159.833 160.148 160.096 J Year/Month Value 2021M06 2021M07 2021M08 2021M09 2021M10 2021M11 2021M12 2022M01 2022M02 2022M03 2022M04 2022M05 2022M06 2022M07 2022M08 160.652 160.881 161.463 162.195 161.659 162.696 163.897 162.988 163.879 163.887 163.746 165.064 165.464 165.538 165.941 A B 1 Year/Month Value 2 2012M09 3 2012M10 4 2012M11 5 2012M12 6 2013M01 7 2013M02 8 2013M03 9 2013M04 10 2013M05 11 2013M06 12 2013M07 13 2013M08 14 2013M09 15 2013M10 16 2013M11 17 2013M12 18 2014M01 19 2014M02 20 2014M03 21 2014M04 22 2014M05 23 2014M06 24 2014M07 25 2014M08 26 2014M09 27 2014M10 28 2014M11 29 2014M12 30 2015M01 31 2015M02 32 2015M03 33 2015M04 34 2015M05 35 2015M06 36 2015M07 m m 678 37 38 120.56 120.115 120.08 118.705 118.574 118.185 118.052 118.626 117.792 117.864 118.182 118.073 118.971 119.608 119.782 119.819 120.682 121.486 122.108 122.015 122.911 123.117 123.571 123.414 123.084 124.823 125.074 126.068 126.018 126.173 126.002 126.964 127.981 128.517 127.966 al с E Year/Month Value 2015M08 2015M09 2015M10 2015M11 2015M12 2016M01 2016M02 2016M03 2016M04 2016M05 2016M06 2016M07 2016M08 2016M09 2016M10 2016M11 2016M12 2017M01 2017M02 2017M03 2017M04 2017M05 2017M06 2017M07 2017M08 2017M09 2017M10 2017M11 2017M12 2018M01 2018M02 2018M03 2018M04 2018M05 2018M06 129.325 129.236 128.707 129.338 130.942 132.128 132.479 132.439 133.329 134.261 133.827 135.051 136.261 137.122 138.308 138.57 139.029 139.039 140.179 140.094 140.73 142.215 141.857 144.076 144.537 144.797 145.87 147.144 148.375 148.825 148.67 149.488 150.009 149.777 149.788 F LL G H Year/Month Value 2018M07 2018M08 2018M09 2018M10 2018M11 2018M12 2019M01 2019M02 2019M03 2019M04 2019M05 2019M06 2019M07 2019M08 2019M09 2019M10 2019M11 2019M12 2020M01 2020M02 2020M03 2020M04 2020M05 2020M06 2020M07 2020M08 2020M09 2020M10 2020M11 2020M12 2021M01 2021M02 2021M03 2021M04 2021M05 150.576 151.33 151.634 152.207 151.82 152.777 152.176 154.086 154.124 153.863 155.248 155.797 154.99 154.578 155.574 155.915 157.657 157.188 158.28 158.29 158.638 157.914 159.647 159.26 158.847 159.824 159.69 159.594 159.132 159.171 159.159 159.29 159.833 160.148 160.096 J Year/Month Value 2021M06 2021M07 2021M08 2021M09 2021M10 2021M11 2021M12 2022M01 2022M02 2022M03 2022M04 2022M05 2022M06 2022M07 2022M08 160.652 160.881 161.463 162.195 161.659 162.696 163.897 162.988 163.879 163.887 163.746 165.064 165.464 165.538 165.941 A B 1 Year/Month Value 2 2012M09 3 2012M10 4 2012M11 5 2012M12 6 2013M01 7 2013M02 8 2013M03 9 2013M04 10 2013M05 11 2013M06 12 2013M07 13 2013M08 14 2013M09 15 2013M10 16 2013M11 17 2013M12 18 2014M01 19 2014M02 20 2014M03 21 2014M04 22 2014M05 23 2014M06 24 2014M07 25 2014M08 26 2014M09 27 2014M10 28 2014M11 29 2014M12 30 2015M01 31 2015M02 32 2015M03 33 2015M04 34 2015M05 35 2015M06 36 2015M07 m m 678 37 38 120.56 120.115 120.08 118.705 118.574 118.185 118.052 118.626 117.792 117.864 118.182 118.073 118.971 119.608 119.782 119.819 120.682 121.486 122.108 122.015 122.911 123.117 123.571 123.414 123.084 124.823 125.074 126.068 126.018 126.173 126.002 126.964 127.981 128.517 127.966 al с E Year/Month Value 2015M08 2015M09 2015M10 2015M11 2015M12 2016M01 2016M02 2016M03 2016M04 2016M05 2016M06 2016M07 2016M08 2016M09 2016M10 2016M11 2016M12 2017M01 2017M02 2017M03 2017M04 2017M05 2017M06 2017M07 2017M08 2017M09 2017M10 2017M11 2017M12 2018M01 2018M02 2018M03 2018M04 2018M05 2018M06 129.325 129.236 128.707 129.338 130.942 132.128 132.479 132.439 133.329 134.261 133.827 135.051 136.261 137.122 138.308 138.57 139.029 139.039 140.179 140.094 140.73 142.215 141.857 144.076 144.537 144.797 145.87 147.144 148.375 148.825 148.67 149.488 150.009 149.777 149.788 F LL G H Year/Month Value 2018M07 2018M08 2018M09 2018M10 2018M11 2018M12 2019M01 2019M02 2019M03 2019M04 2019M05 2019M06 2019M07 2019M08 2019M09 2019M10 2019M11 2019M12 2020M01 2020M02 2020M03 2020M04 2020M05 2020M06 2020M07 2020M08 2020M09 2020M10 2020M11 2020M12 2021M01 2021M02 2021M03 2021M04 2021M05 150.576 151.33 151.634 152.207 151.82 152.777 152.176 154.086 154.124 153.863 155.248 155.797 154.99 154.578 155.574 155.915 157.657 157.188 158.28 158.29 158.638 157.914 159.647 159.26 158.847 159.824 159.69 159.594 159.132 159.171 159.159 159.29 159.833 160.148 160.096 J Year/Month Value 2021M06 2021M07 2021M08 2021M09 2021M10 2021M11 2021M12 2022M01 2022M02 2022M03 2022M04 2022M05 2022M06 2022M07 2022M08 160.652 160.881 161.463 162.195 161.659 162.696 163.897 162.988 163.879 163.887 163.746 165.064 165.464 165.538 165.941
Expert Answer:
Answer rating: 100% (QA)
To calculate the first stocks monthly VaR at a 98 confidence level we need to perform the following ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
The curve known as the Bernoulli spiral (Figure 7) has parametrization r(t) = (e t cos 4 t , e t sin 4t). (a) Evaluate s(1) = ||' (u) du. It is convenient to take lower limit -co because _lim_r(1) =...
-
Predict the product of the reaction of p-methyl benzoic acid with each of the following: (a) LiAlH 4 , then H 3 O + (b) N-Bromosuccinimide in CCl 4 (c) CH 3 MgBr in ether, then H 3 O + (d) KMnO 4 , H...
-
Use the Integral Test to determine the convergence or divergence of the following series, or state that the conditions of the test are not satisfied and, therefore, the test does not apply. Data from...
-
The following errors or irregularities could occur in the executing and recurding of manufacturing transactions and in the safeguarding of work in process in the Leslie Company: 1. Goods of inferior...
-
Freed Corporation has outstanding $800,000 of 8 percent bonds callable at 104. On September 1, immediately after recording the payment of the semiannual interest and the amortization of the discount,...
-
2. Suppose f is a quadratic polynomial function that has a y-intercept at (0, -3) and roots at x = 2 and x = . (a) Sketch a graph of f. Include the given information. (b) Write an equation for f in...
-
Check my Demarco and Janine Jackson have been maried for 20 years and have four children who qualify as their dependents (Damarcus, Janine, Michael, and Candice). The couple recelved salary income of...
-
Why is the ability to collect retail deposits such an important feature? How do banks create money? Explain the theory of the credit multiplier. Define universal banking. Discuss the advan- tages and...
-
What research problem related to your previous coursework would you like to research? Which of your previous academic disciplines is related to this research problem and why? Why do you believe this...
-
Write a Java program to print the area and perimeter of a circle (use variables). Perimeter-2xr Area-xr **r*r =3.14 r is the rayon of the circle To test give 10 as value for r. 2 Write a Java program...
-
Find all six trigonometric functions of if the given point is on the terminal side of 0. Answer exactly. (1,2) sin (0) cos (8) tan (0) cot (0) sec (9) csc (0) Question Help: Video eBook Written...
-
What is the "crisis" that Rural Alaska is facing over energy cost and generation? How does this crisis impact residents in Rural Alaska? How does it impact the economy of Rural Alaska?
-
What object will the following code produce? glBegin(GL_POLYGON); glColor3f(1, e, e); glVertex3f(-0.6, 0.75, 0.5); glColor3f(0, 1, e); glVertex3f(0.6, -0.75, 0); glColor3f(e, e, 1); glVertex3f(0,...
-
es The following transactions are February activities of Swing Hard Incorporated, which offers golfing lessons in the northeastern United States. a. Swing Hard collected $23,600 from customers for...
-
(8%) Problem 6: A student attaches a f= 3.5 kHz oscillator to one end of a metal rail of length L = 25 m. The student turns on the oscillator and uses a piezoelectric gauge at the other end to...
-
Sunbeam Corporation manufactures and sells a variety of small household appliances, including toasters, food processors, and waffle grills. Exhibit 3.26 presents a statement of cash flows for Sunbeam...
-
Conceptually, why should an analyst expect valuation based on dividends and valuation based on the free cash flows for common equity shareholders to yield identical value estimates?
-
United Van Lines purchased a truck with a list price of $250,000 subject to a 6 percent discount if paid within 30 days. United Van Lines paid within the discount period. It paid $4,000 to obtain...
-
The mean free path \(\lambda\) of a molecule of gas is the average distance it travels before collision with another molecule. It is given by \[\lambda=C \frac{m}{ho d^{2}}\] where \(m\) and \(d\)...
-
A rectangular gate (width \(w=2 \mathrm{~m}\) ) is hinged as shown, with a stop on the lower edge. At what depth \(H\) will the gate tip? Water H 0.55 m 0.45 m P3.46 Hinge Stop
-
Gates in the Poe Lock at Sault Ste. Marie, Michigan, close a channel \(W=34 \mathrm{~m}\) wide, \(L=360 \mathrm{~m}\) long, and \(D=10 \mathrm{~m}\) deep. The geometry of one pair of gates is shown;...
Study smarter with the SolutionInn App