Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please help me indicate the formula in excel, than

Please help me indicate the formula in EXCEL, thank you! I need to show the...

50.1K

Verified Solution

Question

Accounting

Please help me indicate the formula in EXCEL, thank you!

I need to show the process. Can you show the calculation process in EXCEL?

On 16 May 2015 MCD is trading at $98 per share. The price of a put option on MCD expiring 18 September 2015 is $1.80 for options with X = $90 and $3.35 for options with X = $95.

You think that MCD will fall in price, and you want to speculate. Complete the table and graph the percent profit vs. the stock price at expiration.

Which strategy is preferrable? Why?

image

\begin{tabular}{|c|c|r|c|} \hline & \multicolumn{1}{|c|}{ A } & \multicolumn{2}{|c|}{ B } \\ \hline 1 & Exercise price & Put price & \\ \hline 2 & 95 & 3.35 & \\ \hline 3 & 90 & 1.8 & \\ \hline 4 & & & \\ \hline 5 & Investment & & \\ \hline 6 & A: 1000 options, X=95 & 3,350 &

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1 The wavelength for n 3 to n 2 transition of the hydrogen atom is...

Physics
Q

Post an explanation of the meaning of the following statement: "Both operating risk and profit potential for...

Finance
Q

Identify the origin of the vestibulocochlear (VIII) nerve in the brain, the foramen through which it...

Medical Sciences
Q

U.S. History question: Why did the Mexican War of 1846 take place? Was the war necessary? Was...

Psychology
Q

You are drawing 3 cards from a deck of 52. a) What is the probability you...

Basic Math
Q

A block moving horizontally on a smooth su rface with a speed of 20m s...

Physics
Q

Drag the linear equation that corresponds to each description.A line parallel to y = x...

Basic Math
Q

Question 2 (10 points) Consider a firm that is trying to hire workers....

Accounting
Q

Determine the May 31 iventery balance using the FIFO...

Accounting
Q

On January 1, 2023 Shanequa acquired a machine for $1 030 000 and estimates the...

Accounting
Q

Imperial Jewelers manufactures and sells a gold bracelet for $405.00. The company's accounting system says...

Accounting
Q

Santana Rey sees that Business Solutions's line of computer desks and chairs is popular, and...

Accounting