Question
In: Finance
Please do in excel showing all the work 1)The exercise price on one of Flanagan Company's...
Please do in excel showing all the work
1)The exercise price on one of Flanagan Company's call options is $15, its exercise value is $22, and its time value is $5. What are the option's market value and the price of the stock?
2)Assume that you have been given the following information on Purcell Corporation's call options: Current stock price = $15 Time to maturity of option = 6 months Variance of stock return = 0.12 dl = 0.24495 d2 = 0.00000 Strike price of option = $15 Risk-free rate = 6% N(dl ) = 0.59675 N(d2 ) = 0.50000 According to the Black-Scholes option pricing model, what is the option's value?
3)The current price of a stock is $33, and the annual risk-free rate is 6%. A call option with a strike price of $32 and with 1 year until expiration has a current value of $6.56. What is the value of a put option written on the stock with the same exercise price and expiration date as the call option?
Solutions
Expert Solution
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.
jeff jeffy answered 4 months agoRelated Solutions
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper...
Please do in excel showing the work
Wansley Lumber is considering the purchase of a paper company,
which would require an initial investment of $300 million. Wansley
estimates that the paper company would provide net cash flows of
$40 million at the end of each of the next 20 years. The cost of
capital for the paper company is 13%. a. Should Wansley purchase
the paper company? b. Wansley realizes that the cash flows in Years
1 to 20 might...
Please do in excel showing the work Wansley Lumber is considering the purchase of a paper...
Please do in excel showing the work Wansley
Lumber is considering the purchase of a paper company, which would
require an initial investment of $300 million. Wansley estimates
that the paper company would provide net cash flows of $40 million
at the end of each of the next 20 years. The cost of capital for
the paper company is 13%. a. Should Wansley purchase the paper
company? b. Wansley realizes that the cash flows in Years 1 to 20
might...
Pleas use Excel®—showing all work and formulas (attach excel sheet please) Dwight Donovan, the president of...
Pleas use Excel®—showing all work and formulas
(attach excel sheet please)
Dwight Donovan, the president of Donovan Enterprises is
considering two investment opportunities. Because of limited
resources he will be able to only invest in one of them. Project A
is to purchase a machine that will enable factory automation; the
machine is expected to have a useful life of four years and no
salvage value. Project B supports a training program that will
improve the skills of employees operating...
Needs to be done in excel showing all the work The Campbell Company is considering adding...
Needs to be done in excel showing all the work
The Campbell Company is considering adding a robotic paint
sprayer to its production line. The sprayer's base price is
$920,000, and it would cost another $20,000 to install it. The
machine falls into the MACRS 3-year class, and it would be sold
after 3 years for $500,000. The MACRS rates for the first three
years are 0.3333, 0.4445, and 0.1481. The machine would require an
increase in net working capital...
please don't do it by excel, do it manually and show work! 1. A manufacturing company...
please don't do it by excel, do it manually and show
work!
1. A manufacturing company decides to buy solar cells in
anticipation of rising electricity costs. The company is modeling
its purchase to save it $20,000 for the first year, and this saving
increases 5% each year for the next 20 years as the solar cells
generate enough electricity to compensate for the rising power
bills. If the expected rate of return for the company equals 8%,
what is...
****ANSWERS ARE GIVEN BUT MUST SHOW ALL WORK; PLEASE (NO EXCEL OR SPSS)***** ---------------------------------------------------------------------- 1. To...
****ANSWERS ARE GIVEN BUT MUST SHOW ALL WORK; PLEASE (NO
EXCEL OR SPSS)*****
----------------------------------------------------------------------
1. To answer this question, refer to the following hypothetical
data collected using replicated measures design.
Subject
1
2
3
4
5
6
7
8
9
10
Pre
50
49
37
16
80
42
40
58
31
21
Post
56
50
30
25
90
44
60
71
32
22
A. In a two-tailed test of H 0 using α=0.05, what is p(obtained)
for the...
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if
you do this :)
15.35 Refer to the Johnson Filtration problem introduced in this
section. Suppose that in addition to information on the number of
months since the machine was serviced and whether a mechanical or
an electrical repair was necessary, the managers obtained a list
showing which repairperson performed the service. The revised data
follow.
Repair Time in Hours
Months Since Last Service
Type of Repair...
PLEASE SHOW WORK FOR ALL, IF YOU'RE ONLY GOING TO DO ONE OF THESE AND NOT...
PLEASE SHOW WORK FOR ALL, IF YOU'RE ONLY GOING TO DO ONE OF
THESE AND NOT ALL, DONT ANSWER
12. P. Rose, Inc. is considering a new four-year expansion
project that requires an initial fixed asset investment of
$1,950,000. The asset will be depreciated straight-line to zero
over its six-year tax life, after which time it will be worthless.
The project is estimated to generate $2,145,000 in annual sales,
with costs of $1,205,000. The fixed asset will have a market...
PLEASE SHOW WORK FOR ALL, IF YOU'RE ONLY GOING TO DO ONE OF THESE AND NOT...
PLEASE SHOW WORK FOR ALL, IF YOU'RE ONLY GOING TO DO ONE OF
THESE AND NOT ALL, DONT ANSWER
1. Assume that the risk-free rate is 5 percent and that the
market risk premium is 7 percent. If a stock has a required rate of
return of 13.75 percent, what must its beta be?
a.
1.25
b.
1.35
c.
1.37
d.
1.60
e.
1.96
2. Your family recently obtained a 30-year $100,000 fixed-rate
mortgage. Which of the following statements is...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
Voters arrive at a polling station at an average of 4 per minute
(Poisson) where the service rate is 50 per hour (Poisson).
a. What is the average number of voters in the system with 5
voter booths? (10 pts)
b. What is the minimum number of voting booths needed to keep
the average time in the system under three minutes? (10 pts)
PLEASE SHOW ALL WORK IN...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A chemist has a substance which was either phenol or resorcinol. He puts the substance in...
- I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
- Discuss system hardening strategies and techniques including updates and patches, default logon/passwords, anonymous access, removal of...
- What types of stories do you enjoy? Why are stories important?
- Read the privacy policy of a large, popular website. Write a brief summary. Identify the site...
- When σ is unknown and the sample is of size n ≥ 30, there are two...
- Draw a directed graph consisting of five nodes, each of which is path connected to every...
ADVERTISEMENT