Question: PLEASE SHOW HOW IT'S DONE ON EXCEL. PLEASE DON'T USE AI TO ANWER. I WILL RATE. ( Pricing a call and put ) A stock

PLEASE SHOW HOW IT'S DONE ON EXCEL. PLEASE DON'T USE AI TO ANWER. I WILL RATE.
(Pricing a call and put) A stock traded for $25 today will, in 1 year, be worth either $35 or $20. If the interest rate is 3%:
a. What is the value today of a 1-year European call option on the stock with exercise price $30?
b. Calculate the value today of a 1-year European put option on the stock with exercise price $30.
c. Show that putcall parity holds: That is parts a and b, show the following:
Call price+X/(1+r))= Stock price today+ Put price

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!

Q:

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Q:

13. What is a lower bound for the price of 3-month call option on a non- dividend-paying stock when the stock price is $50, the strike price is $45, and the 3-month risk-free interest rate is 8%?...

Q:

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Q:

Find the most recent price of the bond and show how it can be used to determine its YTM (Yield to Maturity). Upload your excel file to show your calculations. If the bond you have chosen has not been...

Q:

Please show all major calculations/formulas (without using excel, if possible) 10. Use the Black-Scholes formula to value the following options: a. A call option written on a stock selling for $100...

Q:

THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2017. Since Aylmer is a publicly traded company, it follows IFRS. Aylmer posted accounting transactions throughout the year....

Q:

Please show below calculations in Excel: Q3 (B-S Option Pricing) ABC stock is being traded at $115 today. Consider European put and call options with an exercise price of $110. The option expires in...

Q:

Project Description ---- FINANCIAL RESEARCH PROJECT ------- Worth 25% of the course grade. Due date is stated in the course schedule. THE PROJECT IS DESIGNED TO BE COMPLETED INDIVIDUALLY. OBJECTIVE...

Q:

OBJECTIVE The specific objective of this graded written research exercise is to prepare an "executive level financial report" to the Chief Financial Officer (CFO) of a mythical company in which you...

Q:

Hi, tutor, please complete this financial math worksheet with step by step solutions. You must have essential knowledge of options and futures, arbitrage,Black-Scholes model , and Brownian motion,...

Q:

Blue Corporation had $2,000,000 in total liabilities and $3,500,000 in total assets as of December 31, 2009. Required: Calculate Blue's debt to equity ratio.

Q:

The vector r = xl + yj + zk, called the position vector, points from the origin (0. 0, o) to an arbitrary point in space with coordinates (x, y, z). Use what you know about vectors to prove the...

Q:

5. (LO1) Some corporations, like one British company that offers its large shareholders free crematorium use, pay dividends in kind (that is, offer their services to shareholders at belowmarket...

Q:

1. The doddaballapur head office sends goods to its chikkaballapur branch at a profit of 20% on cost. If the head office sends goods for Rs 1,20,000, calculate the cost price. 2. Find out the loading...

Q:

(a) Compare the average power (kW/m) in waves with 2.5 m significant wave height versus 2 m height if both have a peak wave period of 9 s. [2 Marks + 2 Marks] (b) Calculate the energy (kWh'/m)...

Q:

The management of Maxim limited intends to replace its obsolete machine. Two machines from different manufacturers are being assessed. The machines will cost the same amount but will generate...

Q:

C code for this: The Monk is trying to explain to its users that even a single unit of time can be extremely important and to demonstrate this particular fact he gives them a challenging task. There...

Q:

Each OS/161 exception has its own code. What are the exception codes for the exceptions: interrupt , system call , and arithmetic overflow ?

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

47. Verify Equation 4.7.4.

Q:

45. A product is classified according to the number of defects it contains and the factory that produces it. Let X1 and X2 be the random variables that represent the number of defects per unit...

Q:

49. Let X have variance 2 x and let Y have variance 2 y . Starting with Using the result that Var(Z) = 0 implies that Z is constant, argue that if Corr(X , Y ) = 1 or 1 then X and Y are related by Y...