Question

Stock $A$, whose price is $$\$ 30$$, has an expected return of $11 \%$ and a volatility of $25 \%$. Stock B, whose price is $$\$ 40$$, has an expected return of $15 \%$ and a volatility of $30 \%$. The processes driving the returns are correlated with correlation parameter $\rho$. In Excel, simulate the two stock price paths over 3 months using daily time steps and random samples from normal distributions. Chart the results and by hitting F9 observe how the paths change as the random samples change. Consider values for $\rho$ equal to $0.25,0.75$, and 0.95 .

   Stock $A$, whose price is $$\$ 30$$, has an expected return of $11 \%$ and a volatility of $25 \%$. Stock B, whose price is $$\$ 40$$, has an expected return of $15 \%$ and a volatility of $30 \%$. The processes driving the returns are correlated with correlation parameter $\rho$. In Excel, simulate the two stock price paths over 3 months using daily time steps and random samples from normal distributions. Chart the results and by hitting F9 observe how the paths change as the random samples change. Consider values for $\rho$ equal to $0.25,0.75$, and 0.95 .
 
Show more…
Options, Futures, and Other Derivatives
Options, Futures, and Other Derivatives
John C. Hull 10th Edition
Chapter 14, Problem 18 ↓

Instant Answer

verified

Step 1

For stock A: Daily expected return = 11% / 252 (number of trading days in 3 months) Daily volatility = 25% / sqrt(252) For stock B: Daily expected return = 15% / 252 Daily volatility = 30% / sqrt(252)  Show more…

Show all steps

lock
AceChat toggle button
Close icon
Ace pointing down

Please give Ace some feedback

Your feedback will help us improve your experience

Thumb up icon Thumb down icon
Thanks for your feedback!
Profile picture
Stock $A$, whose price is $$\$ 30$$, has an expected return of $11 \%$ and a volatility of $25 \%$. Stock B, whose price is $$\$ 40$$, has an expected return of $15 \%$ and a volatility of $30 \%$. The processes driving the returns are correlated with correlation parameter $\rho$. In Excel, simulate the two stock price paths over 3 months using daily time steps and random samples from normal distributions. Chart the results and by hitting F9 observe how the paths change as the random samples change. Consider values for $\rho$ equal to $0.25,0.75$, and 0.95 .
Close icon
Play audio
Feedback
Powered by NumerAI
Need help? Use Ace
Ace is your personal tutor. It breaks down any question with clear steps so you can learn.
Start Using Ace
Ace is your personal tutor for learning
Step-by-step explanations
Instant summaries
Summarize YouTube videos
Understand textbook images or PDFs
Study tools like quizzes and flashcards
Listen to your notes as a podcast
Continue solving this problem
Create a free account to:
  • View full step-by-step solution
  • Ask follow-up questions with Ace AI
  • Save progress and study later
Continue Free
Numerade

Get step-by-step video solution
from top educators

Continue with Clever
or



By creating an account, you agree to the Terms of Service and Privacy Policy
Already have an account? Log In

A free answer
just for you

Watch the video solution with this free unlock.

Numerade

Log in to watch this video
...and 100,000,000 more!


EMAIL

PASSWORD

OR
Continue with Clever