please provide me work book(Excel) with formulas in Excel to value options based on block sholes...

please provide me work book(Excel) with formulas in Excel to value options based on block sholes model

Expert Solution

given screenshot will contain the formulas for block sholes model

included an example for better understanding

jeff jeffy answered 2 years ago

1) (note: Please also provide the excel formulas used to solve it ) You work for a...

1) (note: Please also provide the excel formulas used to solve it ) You work for a soft-drink company in the quality control division. You are interested in the standard deviation of one of your production lines as a measure of consistency. The product is intended to have a mean of 12 ounces, and your team would like the standard deviation to be as low as possible. You gather a random sample of 18 containers. Estimate the population standard deviation at...

I really would appreciate it if someone could provide me with the Excel formulas to calculate...

I really would appreciate it if someone could provide me with the Excel formulas to calculate the last five (5) columns of the spreadsheet listed below. # of Trading Days Before/After Event Date DATE Closing Prices Procter&Gamble MKT-Rf Rf Returns Honeywell Expected Returns Procter&Gamble (ER) Abnormal Returns Procter&Gamble (AR) AR t-test AR Significant (Y/N) ? Cumulative Abnormal Returns Procter&Gamble (CAR) -270 1/2/2004 49.4950 -0.17 0.003 -269 1/5/2004 49.7400 1.2 0.003 0.4950056 -268 1/6/2004 49.4900 0.2 0.003 -0.5026136 -267 1/7/2004 49.0500...

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...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are...

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

Please show work and answers with the excel formulas According to the Sleep Foundation, the average...

Please show work and answers with the excel formulas According to the Sleep Foundation, the average night's sleep is 6.5 hours. Assume the standard deviation is 0.5 hours and thatthe probability distribution is normal. A. What is the probability that a randomly selected person sleeps more than 8 hours? B).What is the probability that a randomly selected person sleeps 6 hours or less? C). Doctors suggest getting between 7 and 9 hours of sleep each night? What percentage of the population...

Please show me how to do the following in excel. An additional "show formulas" would also...

Please show me how to do the following in excel. An additional "show formulas" would also be helpful. NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter...

PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter &...

PLEASE INCLUDE EXCEL FORMULAS OR WORK Prepare (7) operating budgets for the year by quarter & budgeted Income Statement for the Candy business Sales Information: Company advertises that it will match the competition (Internal factor) Five year historical selling total units per year: 220k, 210k, 180k, 196k, & 200k Surrounding shopping area includes discount stores (i.e. Target, Walmart) selling similar product for $15, $20 respectively (external factor) Stock Market down 25% in last 3 months, oil per barrel at record...

Hello! If possible can you please teach me in excel formulas? You have recently won the...

Hello! If possible can you please teach me in excel formulas? You have recently won the super jackpot in the Washington State Lottery. On reading the fine print, you discover that you have the following two options: a. You will receive 30 annual payments of $270,000, with the first payment being delivered today. The income will be taxed at a rate of 30 percent. Taxes will be withheld when the checks are issued. b. You will receive $550,000 now,...

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City....

please use excel and provide the formulas The Times-Observer is a daily newspaper in Metro City. Like many city newspapers, the TimesObserver is suffering through difficult financial times. The circulation manager is studying other papers in similar cities in the United States and Canada. She is particularly interested in what variables relate to the number of subscriptions to the paper. She is able to obtain the following sample information on 25 newspapers in similar cities. Ignore the data in the...

Question