Ask Experts Questions for FREE Help!
  Advanced
Register  |  Log in  
   Ask    
 Answer  
  Help  

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Business & Careers > Finance   »   Excel Monte Carlo Simulation

 
Question Tools Search this Question Display Modes
Question
 
 
#1  
Old Apr 28, 2007, 05:27 AM
bambie
New Member
bambie is offline
 
Join Date: Apr 2007
Posts: 1
bambie See this member's comment history on his/her Profile page.
Excel Monte Carlo Simulation

One of the problems with derivative pricing models is that it assumes volatility is strictly proportional, so that if the stock price doubles, we assume that the volatility of the asset price will double as well. However, empirical tests suggest that the volatility doesn?t go up as much as our model predicts when prices rise, and doesn?t decline as much as the model predicts when prices fall. There are many ways to model this observation. One simple way is to assume that stock volatility is composed of two parts: a proportional part and a fixed part (the proportional part assumes the lognormal distribution and the fixed part assumes a normally distributed asset ? this means that the actual distribution will be somewhere between the normal and lognormal).

Assume a stock has a price of $40/share and the volatility is given by the following function:


At the current price, the volatility of price (P) and return (R) are given by



If the price of the stock declines, the price volatility will decline, but the return volatility will increase (and the opposite if the asset price rises). An obvious drawback of this model is that stock prices can be negative, as volatility does not go to zero as the stock price approaches zero.

a.The Black-Scholes model will not give exact prices for options on this asset, as a central assumption of BS is violated. Can we still use risk-neutral valuation techniques? Why (or why not).

b.Would a call option on this asset be path-dependent? Why (or why not).

c.Compute the current market price of the following options. You may need to use Monte Carlo simulation to get the correct answer. Compare your prices to a Black-Scholes price using the current volatility of 25%. (Assume risk-free rate is 5% and the expected return of the stock is 12% per year):

2-year call option with a strike of 50
2-year put option with a strike of 30

Reply With Quote
 
     



Question Tools Search this Question
Search this Question:

Advanced Search
Display Modes

 
Similar Sponsors

Similar Questions
Question Asker Topic Answers Last Post
Space Simulation like privateer for PS2 lucasstoehr Games 0 Dec 27, 2006 11:25 PM
How to get better with Excel chucksearcy Spreadsheets 2 Nov 17, 2006 07:50 AM
Accounting Simulation jigglypuff Finance & Accounting 0 Mar 18, 2006 11:29 AM
excel desmon1 Spreadsheets 2 Oct 7, 2005 04:56 AM
excel help thetachi464 Spreadsheets 1 Mar 27, 2005 04:16 AM




Copyright ©2003 - 2007, Ask Me Help Desk.
All times are GMT -8. The time now is 03:01 PM.

Content Relevant URLs by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.