Task
In this assignment, you will solve problems on Binomial Option Pricing.
Instructions
- Use your textbook to answer the following questions from Chapter 11:
- Exercise 9, 10, and 19.
- Please, upload xls, xlsx file.
- Please, use the full computing power of Excel.
9. ABC stock is currently at 100. In the next period, the price will either increase by 10%
or decrease by 10%. The risk-free rate of return per period is 2%. Consider a call option
on ABC stock with strike K = 100.
(a) Set up a replicating portfolio to value the call.
(b) Suppose the call is trading for $7. Explain how you would exploit the resulting
arbitrage opportunity.
10. ABC stock is currently at 100. In the next period, the price will either increase by 5% or
decrease by 5%. The risk-free rate of return per period is 3%. Consider a put option on
ABC stock with strike K = 100.
(a) Set up a replicating portfolio to value the put.
(b) Suppose the put is trading for $2. Explain how you would exploit the resulting
arbitrage opportunity
19. Portfolio insurance: The current price of the stock we are holding is $100. We want to
continue to hold the stock position but modify it so that the portfolio value never drops
below $90. If the stock may move up to $130 or down to $80 after one period, how do
we modify our holding of $100 so as to make sure that it is at least of $90 value at the
end of the period? The rate of simple interest for the period is 10%.

