Answered step by step
Verified Expert Solution
Question
1 Approved Answer
User With a share price of $23.50 at the end of 6 months, the portfolio value with put options is $8,265.00, and without put options
User With a share price of $23.50 at the end of 6 months, the portfolio value with put options is $8,265.00, and without put options the value is $7,990.00. Now the data table option will be used to determine what these values would be if the share price at the end of 6 months changes between $15 and $35 in increments of $1.00. Enter these values in cells A29:A49, as below. Refer to your Excel spreadsheet. Follow the process to use the data table option. Select cells A28:C49. Click the Data tab in the Ribbon. Click What-If Analysis in the Forecast group. Select Data Table. When the Data Table dialog box appears, enter $B$9 in the Column input cell: box. Doing so references the formulas used to calculate the portfolio values with and without put options but will replace the share price at the end of 6 months, originally in cell B9, with the new share prices in cells A29:A49. Cells B29:C49 will automatically be populated with the new portfolio values. Enter the values (in dollars) of the portfolio with and without put options. A B C 27 Share Price Value with Options Value Without Options 28 =B17 $8,265.00 =B21
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started