Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Derivatives can be valued using risk neutral valuation. The spreadsheet Risk Neutral Valuation.xlsx simulates 10,000 values of stock price (assuming log normal distribution) at expiration

Derivatives can be valued using risk neutral valuation. The spreadsheet Risk Neutral Valuation.xlsx simulates 10,000 values of stock price (assuming log normal distribution) at expiration of derivative. Each stock price results in a derivative payoff. These derivative payoffs are discounted and averaged to get derivative value. The formula in column C is set to price a European call with strike price of $50 but can be changed to price any other derivatives. Value the following derivative:

Current stock price = 20 + number of the first letter of your last name + number of the second letter of your last name. Assume A = 1, B = 2, and so on until Z = 26.

The derivative will expire after six months. Its payoff will equal the absolute difference between the price at that time and todays price, up to a maximum of $5. For example, if price today is $50 and the price at expiration is $47.2, you will get $2.8. If the price at expiration is $53.6, you will get $3.6. If the price at expiration is $30 or $90, you will get $5.

Risk-free rate is 5% per annum compounded continuously and stock volatility is 20% per annum.

How would you go about valuing the derivative theoretically - as in what are the steps? I know the excel sheet is not provided.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Almanac Of Online Trading

Authors: Terry Wooten

1st Edition

0071358595, 978-0071358590

More Books

Students also viewed these Finance questions

Question

Describe prepayment, acceleration, and extension clauses.

Answered: 1 week ago