Question: How to set excel formulas calculations for below? Please provide answer in excel only to get the answer 0.000150. Below I am getting the answer

How to set excel formulas calculations for below? Please provide answer in excel only to get the answer 0.000150.

Below I am getting the answer 0.000113 instead of 0.000150.

How to set excel formulas calculations for below? Please provide answer in

Then, to calculate the new call option premium, use the formula below and this table, Therefore, Putoption=2.7183(0.021870.49315068)(0.0074770/(0.368781)0.0073529/(0.342631))=0.000150/ premium Resulting in a put option premium listed of 0.000150/. To calculate the total cost, use the following formula: Total cost= Notional principal Put option premium Total cost =10,400,0000.000150/= Then, to calculate the new call option premium, use the formula below and this table, Therefore, Putoption=2.7183(0.021870.49315068)(0.0074770/(0.368781)0.0073529/(0.342631))=0.000150/ premium Resulting in a put option premium listed of 0.000150/. To calculate the total cost, use the following formula: Total cost= Notional principal Put option premium Total cost =10,400,0000.000150/=

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!

How to set excel formulas calculations for below? How I get the answer 0.000150. I need only the calculations in excel for 0.000150. Please provide answer in excel only to get the answer 0.000150....

Start with the partial model in the file Ch 1 3 P 1 8 Build a Model.xlsx . Webmasters.com has developed a powerful new server that would be used for corporations' Internet activities. It would cost $...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Answer all parts of the qus Answer THREE 1. Critically outline and assess the Marshall-Hicks laws of derived labour demand. Discuss how a trade union might attempt to minimize the adverse...

I only need E part solved. Please get back to me as soon as possible because deadline is in a few hours. Thanks This exam is open book and is to be your individual work ONLY. You are not allowed to...

drr The website to access the 10K is http://www.sec.gov/edgar/searchedgar/companysearch.html. You should use the 12/31/19 10K filing. This company is in the same industry as P&S. a. Identify the...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

1. The Hawaiian alphabet consists of 12 letters. How many six-character strings can be made using the Hawaiian alphabet? 2. How many 2n-digit positive integers can be formed if the digits in odd...

Suppose that, for a certain mathematics class, the scores are normally distributed with a mean of 75 and a standard deviation of 9. The teacher wishes to give As to the top 5% of the students and Fs...

Accounting question A zero-coupon bond with a face value of $1,000 that matures in 15 years sells today for $455. What is the yield to maturity (YTM)? (Use annual compounding. Enter your answer as a...

Intro to python questions What is the type of the following code? stock_tickers ={ 'GE': 'General Electric', 'AAL' 'American Airlines', 'AAPL': 'Apple', 'DIS': 'Disney', 'DAL' : 'Delta', 'MSFT' :...

2. Carrot Computers and its competitors purchase touch screens for their tablet computers from several suppliers. The six makers of touch screens have market shares of, respectively, 19 percent, 18...

LO22.1 Explain why agricultural prices and farm income are unstable.

LO22.2 Discuss why there has been a huge employment exodus from agriculture to other U.S. industries over the past several decades.