Question: SOLVE IN EXCEL AND SHOW FORMULAS. 1 . If the Annual Volatility of Stock x Y Z = 2 7 % , then what is

SOLVE IN EXCEL AND SHOW FORMULAS.
1. If the Annual Volatility of Stock xYZ=27%, then what is XYZ's daily volatility?
2. If you are holding a $600,000,000( $600 million) position in Stock XYZ, what is the annual volatility (or annual = annual standard deviation) of XYZ in dollars ( $ 's)?
3. If you are holding a $600,000,000( $600 million) position in Stock XYZ, what is the daily volatilitv (or dailv = dailv standard deviation) in dollars ( $ 's)?
4. What is the 1-day, 95% VaR for a $600 million equity position in Stock XYZ if Stock XYZ's annual volatility is 27%?[Use the Excel NORM.INV() function].
5. What is the 5-day, 98% VaR of a $600 million equity position in Stock XYZ if Stock XYZ's annual volatility is 27%?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!