Writer Choice
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →38282Mr. White is the CFO of a $46 million revenue service company and has excess cash funds to invest into a specific stock. Based upon his research, he has found that Starbucks is an excellent choice for several reasons, including a current stock beta of .64 (which means that the risk is low as it is below a threshold of 1.00). However, he wishes to use the VaR calculation to quantify the upside and downside risk to the company to help him recognize if Starbucks stock is a good choice. Please see below for the assignment parameters.
1.Please visit the link below to gain a greater grasp of VaR and its application to risk. http://www.investopedia.com/articles/04/092904.asp?lgl=rira-baseline-vertical
Also, see: http://investexcel.net/value-at-risk-methods-spreadsheets/
2Next, use Yahoo Finance to gain Starbucks (SBUX ticker symbol) monthly closing stock price from 6-1-2012 to 6-1-2017. Download the information into excel. (There should be 60 data rows) Then cut and paste the date and stock close columns of data into the attached excel template. Once this is completed, the template will automatically calculate the dollar and percentage changes in monthly stock prices and graph the data accordingly.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds