Question: please show the work in excel Description Go to Yahoo! Finance and choose a stock. Find calls a and puts under Options. Construct a profit



Description Go to Yahoo! Finance and choose a stock. Find calls a and puts under Options. Construct a profit chart for each of the following: 1. buy call (you need a strike price and the premium that goes with it (use the last price column for the premium)) 2. sell put (you need a strike price and the premium that goes with it (use the last price column for the premium)) 3. covered call using the current price as the purchase price for the stock; you also need a strike price and premium 4. protective put using the current price as the purchase price for the stock; you also need a strike price and premium Funko, Inc. (FNKO) Nasdaqs - NasdaqGS Real Time Price Currency in USD Add to watchlist 88 Visitors trend 2W T 10W T 9M 1 Quot Look 16.21 +0.63 (+4.04%) 15.81 -0.40 (-2.47%) At close 04:00PM EDT Alter hours: 05:59PM EDT Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Holders Sustainability Calls for March 18, 2022 Contract Name Last Trade Date Strike Last Price Bid Ask Change 5Change Volume Open Interest implied Volatility 2022-03-04 11:51AM EDT 12.50 7.80 0.00 0.00 0.00 1 0 0.00% FNKO220318C00012500 FNKO220318000015000 2022-03-15 12:41PM EDT 15.00 1.25 0.00 0.00 0.00 26 0 0.00% 2022-03-15 12:19 PM EDT 17.50 0.15 0.00 0.00 0.00 8 00 0 0 25.00% FNKO220318000017500 FNKO220318000020000 ENKO220318C00022500 2022-03-15 1:54PM EDT 20.00 0.05 0.00 0.00 0.00 7 0 50.00% 2022-03-14 1.31PM EDT 22.50 0.02 0.00 0.00 0.00 6 0 50.00% 0 0 2022-03-08 10:36AM EDT 25.00 0.00 0.05 0.00 0.00 8 FNKO220318C00025000 0 50.00% 1 0.05 0.00 0.00 ENKO220318000030000 0.00 0 2022-03-14 9:30AM EDT 30.00 50.00% 0.00 1 0 0.01 0.00 0.00 ENKO220318C00035000 50.00% 2022-03-04 10:36AM EDT 35.00 Last Trade Date Strike A Last Price Bid Ask Change Change Volume Open Interest implied Volatity 2022-03-15 2:58PM EDT 12.50 0.05 0.00 0.00 0.00 1 0 50.00% - Puts for March 18, 2022 Contract Name ENKO220318P00012500 ENKO220318P00015000 FNKO220318P00017500 FNKO220318P00020000 0.00 2 0 25.00 0.14 0.00 0.00 2022-03-15 208PM EDT 15.00 47 0 0.00% 0.00 1.40 0.00 0.00 2022-03-15 12:40PM EDT 17.50 0.00 1 3.98 0.00 0.00 0.00% 2022-03-15 12:57PM EDT 20.00 5 0 0.00% 5.20 0.00 0.00 0.00 FNKO220318P00022500 2022-03-08 3:01PM EDT 22 SO Description Go to Yahoo! Finance and choose a stock. Find calls a and puts under Options. Construct a profit chart for each of the following: 1. buy call (you need a strike price and the premium that goes with it (use the last price column for the premium)) 2. sell put (you need a strike price and the premium that goes with it (use the last price column for the premium)) 3. covered call using the current price as the purchase price for the stock; you also need a strike price and premium 4. protective put using the current price as the purchase price for the stock; you also need a strike price and premium Funko, Inc. (FNKO) Nasdaqs - NasdaqGS Real Time Price Currency in USD Add to watchlist 88 Visitors trend 2W T 10W T 9M 1 Quot Look 16.21 +0.63 (+4.04%) 15.81 -0.40 (-2.47%) At close 04:00PM EDT Alter hours: 05:59PM EDT Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options Holders Sustainability Calls for March 18, 2022 Contract Name Last Trade Date Strike Last Price Bid Ask Change 5Change Volume Open Interest implied Volatility 2022-03-04 11:51AM EDT 12.50 7.80 0.00 0.00 0.00 1 0 0.00% FNKO220318C00012500 FNKO220318000015000 2022-03-15 12:41PM EDT 15.00 1.25 0.00 0.00 0.00 26 0 0.00% 2022-03-15 12:19 PM EDT 17.50 0.15 0.00 0.00 0.00 8 00 0 0 25.00% FNKO220318000017500 FNKO220318000020000 ENKO220318C00022500 2022-03-15 1:54PM EDT 20.00 0.05 0.00 0.00 0.00 7 0 50.00% 2022-03-14 1.31PM EDT 22.50 0.02 0.00 0.00 0.00 6 0 50.00% 0 0 2022-03-08 10:36AM EDT 25.00 0.00 0.05 0.00 0.00 8 FNKO220318C00025000 0 50.00% 1 0.05 0.00 0.00 ENKO220318000030000 0.00 0 2022-03-14 9:30AM EDT 30.00 50.00% 0.00 1 0 0.01 0.00 0.00 ENKO220318C00035000 50.00% 2022-03-04 10:36AM EDT 35.00 Last Trade Date Strike A Last Price Bid Ask Change Change Volume Open Interest implied Volatity 2022-03-15 2:58PM EDT 12.50 0.05 0.00 0.00 0.00 1 0 50.00% - Puts for March 18, 2022 Contract Name ENKO220318P00012500 ENKO220318P00015000 FNKO220318P00017500 FNKO220318P00020000 0.00 2 0 25.00 0.14 0.00 0.00 2022-03-15 208PM EDT 15.00 47 0 0.00% 0.00 1.40 0.00 0.00 2022-03-15 12:40PM EDT 17.50 0.00 1 3.98 0.00 0.00 0.00% 2022-03-15 12:57PM EDT 20.00 5 0 0.00% 5.20 0.00 0.00 0.00 FNKO220318P00022500 2022-03-08 3:01PM EDT 22 SO
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
