Question: please use Excel and show me step by step to do this hw. thank you. (10 pts) A stock has a current price of $52

please use Excel and show me step by step to do this hw. thank you. please use Excel and show me step by step to do this

(10 pts) A stock has a current price of $52 and the current risk-free rate is 3%. Suppose you create a portfolio that consists of a European call option with a strike price of $55 that expires in 6 weeks and a European put option with a strike price of $49 that also expires in 6 weeks. a. If the volatility of the stock is 25%, what is the initial cost of this portfolio? b. Find the value of the portfolio at 6 weeks if the stock price in 6 weeks is $45. Repeat this for a stock price at 6 weeks of $48, $51, $54, $57, $60 respectively. C. Make a graph of the net profit from the portfolio at 6 weeks (the value at 6 weeks minus the future value of the initial cost) as a function of the stock price at 6 weeks. (10 pts) A stock has a current price of $52 and the current risk-free rate is 3%. Suppose you create a portfolio that consists of a European call option with a strike price of $55 that expires in 6 weeks and a European put option with a strike price of $49 that also expires in 6 weeks. a. If the volatility of the stock is 25%, what is the initial cost of this portfolio? b. Find the value of the portfolio at 6 weeks if the stock price in 6 weeks is $45. Repeat this for a stock price at 6 weeks of $48, $51, $54, $57, $60 respectively. C. Make a graph of the net profit from the portfolio at 6 weeks (the value at 6 weeks minus the future value of the initial cost) as a function of the stock price at 6 weeks

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!