Question

In: Finance

show EQUATIONS IN EXCEL not just answers A call option on Project Cash Flow Consulting Inc.'s...

show EQUATIONS IN EXCEL not just answers

A call option on Project Cash Flow Consulting Inc.'s stock (PCF) has a market price of $7.00.

The stock currently sells for $30/share (P), and the option has a strike price of $25/share (X).
What is the exercise value (payoff) of the call option?
What is the option's time value based on the option's market price and the exercise value?

Solutions

Expert Solution

CELL REFERENCES ARE PROVIDED. WE HAVE TO USE EXCEL :" MAX FUNCTION" TO GET FIRST ANSWER.


Related Solutions

show EQUATIONS IN EXCEL not just answers Q3 Use the Black-Scholes Option Pricing model to value...
show EQUATIONS IN EXCEL not just answers Q3 Use the Black-Scholes Option Pricing model to value a call option on the stock of Houston-based Long-Range Videoing Equipment Inc. d.b.a. Outfield Sign Stealers Inc. Current stock price $15 d1 0.24495 Option strike price $15 d2 0 Option time to maturity 6 months N(d1) 0.596752427 Stock return variance 0.12 N(d2) 0.5 risk-free rate 6%
In excel, use payoffs to show the trading position created when a call option is bought...
In excel, use payoffs to show the trading position created when a call option is bought with strike price X2 = $60 and a put option is sold with strike price X1 = $40. What's the new position when X1 = X2 = $50?
Call-a-way Inc. has identified a project with the following cash flows: Year Cash Flow 1 $   950...
Call-a-way Inc. has identified a project with the following cash flows: Year Cash Flow 1 $   950 2   1,040 3   1,130 4   1,075 If the discount rate is 10 percent, what is the present value of these cash flows?  What is the present value at 18%?  What is the present value at 24%?  Do not round intermediate calculations and round your final answer to 2 decimal places. Dudley Corp. have identified a project with the following cash flows: Year Cash Flow 1 $    940 2...
Compute all answers in (Solver) Excel, and show your equations. Q1. Assume:      TC = 5...
Compute all answers in (Solver) Excel, and show your equations. Q1. Assume:      TC = 5 + 2q + .5q2       P = 20 – 3q What is the profit max price, q, TR, cost?
For the following project, calculate the undiscounted cash flow. Put result in Excel
For the following project, calculate the undiscounted cash flow. Put result in Excel    Year 0 1 2 3 4 5 Unit Price - $105 $110 $115 $120 $125 Units Sold - 900 1000 1100 1200 1300 Net Sales - Variable Costs - $54,000 $60,000 $66,000 $72,000 $78,000 Fixed Costs - $15,000 $15,750 $16,538 $17,364 $18,233 Depreciation - $10,000 $10,000 $10,000 $10,000 $10,000 PBIT - Tax@40% - NOPAT - Adjustments Add back Depreciation - CapEx -$100,000 - - - - -...
Using Excel (if applicable), A company is considering a project that has the following cash flow...
Using Excel (if applicable), A company is considering a project that has the following cash flow and WACC data. Note: CF0, CF2, and CF4 are negative Should the company take on this project if its WACC is 15? Justify your answer using NPV, IRR, and MIRR. WACC: 15% Year 0    1 2 3 4 Cash flows - $15,000 $25,000 - $2,000 $12,000 - $1,000
EXCEL: (show equations pls)Fred Flintstone has just become the product manager for Yabba Dabba Doo, a...
EXCEL: (show equations pls)Fred Flintstone has just become the product manager for Yabba Dabba Doo, a consumer packaged product with a retail price of $2.00. Retail margins on the product are 33%, while wholesalers take a 12% margin. Yabba and its direct competitors sell a total of 40 million units annually, and Yabba has 24% market share of this total. Variable manufacturing costs for Yabba are $0.09 per unit. Fixed manufacturing costs are $1,800,000. The advertising budget for Yabba is...
What are the equations for Cash flow from Assets? What is another word for Cash Flow...
What are the equations for Cash flow from Assets? What is another word for Cash Flow from Assets?
Please show how it would be done on EXCEL gilmore, Inc., just paid a dividend of...
Please show how it would be done on EXCEL gilmore, Inc., just paid a dividend of $2.35 per share on its stock. The dividends are expected to grow at a constant rate of 4.1 percent per year, indefinitely. If investors require a return of 10.4 percent on this stock. What is the current price? What will the price be in three years? and in fifteen years?
*Solve without using Excel, write out the equations* Suppose a project requires an initial cash outflow...
*Solve without using Excel, write out the equations* Suppose a project requires an initial cash outflow of $34,900. The project will last for four years with the annual cash flows given below. The required rate of return is 12%. Year Cash Flow Cash Flows 1 12,500 2 19,700 3 0 4 10,400 A) Compute the net present value of the project. Should the firm invest in this project based on net present value? Why? B) Compute the internal rate of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT