Suppose a stock price follows a binomial distribution. We want to create a random price path for

Question:

Suppose a stock price follows a binomial distribution. We want to create a random price path for the stock in a VBA macro. Here ? s the input with some sample output. Write a VBA for an appropriate subroutine.

? In the VBA message box, use Chr(13) to start a new line.

? Use range names in the spreadsheet to transfer values from the spreadsheet to the VBA routine.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Financial Modeling

ISBN: 9780262027281

4th Edition

Authors: Simon Benninga

See More Books

Question Posted: Dec 29, 2020 12:34 AM

See More Questions

Suppose a stock price follows the Ito process dS = aS dt + bS dB, (1) where a, b, , are all constants non-zero constants, and , 6= 0, 1. Find F(S), a differentiable function of the stock price,...
You are provided with the following information for Waterway Inc. for the month ending June 30, 2020. Waterway uses the periodic method for inventory. Date Description Quantity Unit Cost or Selling...
Suppose a stock price can go up by 15 percent or down by 13 percent over the next year. You own a one-year put on the stock. The interest rate is 10 percent, and the current stock price is $60. (a)...
Which of the following statements represent(s) how expenses affect equity? If expenses increase, then total equity decreases. If expenses decrease, then equity will decrease. Higher expenses result...
Consider a U.S. portfolio manager who holds a portfolio of French stocks currently worth 10 million. In order to hedge against a potential depreciation of the euro, the portfolio manager proposes to...
A company has new equipment costs of $3 million, which will be depreciated to zero using straight-line depreciation over 8 years. The company expects to bring in revenues of $6 million per year for 8...
Which of the four methods for handling missing data would tend to lead to an underestimate of the spread (e.g., SD) of the variable? What are some benefits to this method?
Johns Cream Soda, Inc., makes specialty soft drinks. At the end of 2012, Johns had total assets of $390,000 and liabilities totaling $260,000. Requirements 1. Write the companys accounting equation,...
Two Wheeler Dealer had sales totaling $198,464 last year. The cost of the goods sold was $177,228. Expenses totaled $60,905. What was the net profit margin for the year? Group of answer choices 4.65%...
Let's investigate the possibility of heteroskedasticity in time-series data by looking at a model of the black market for U.S. dollars in Brazil that was studied by R. Dornbusch and C. Pechman. In...
Create a VBA subroutine [call it Exercise3( ) ] which generates five random digits of either 1 or 0 and prints them out on the screen in a message box like the following: Microsoft Excel The random...
Repeat the last exercise. This time compute the average price of a path: Microsoft Exoel The number of up moves: 0, 1, 2, 3, 3 The price path is: 30, 39, 50.7, 65.91, 59.32 The average price along...
The angle of incidence is adjusted so there is maximum linear polarization for the reflected light from a transparent piece of plastic in air. (a) There is (1) no, (2) maximum, or (3) some light...
The Tokyo Olympics. After watching how the tokyo olympics became the most expensive summer game ever video answer the following questions. Q 3 : As you saw in the video, the capital investment a city...
write at least two paragraphs discussing the experiences of individuals who identify outside the traditional binary gender system (male/female.) Please explore the challenges they face and how...
Newly formed S&J Iron Corporation has 163,000 shares of $5 par common stock authorized. On March 1, Year 1, S&J Iron issued 9,000 shares of the stock for $12 per share. On May 2, the company issued...
Use the SMOKE for this question. The variable cigs is the number of cigarettes smoked per day. How many people in the sample do not smoke at all? What fraction of people claim to smoke 20 cigarettes...
Transcribed image text : Reproduced below from Farthington Supply's accounting records is the accounts receivable subledger along with selected general ledger accounts. Dec. 31/19 Balance Credit...
What problem does Manchester encoding address? What alternative to Manchester encoding is also discussed in this chapter?
1-Stern observed all of the following results EXCEPT _______ in his experiment. A-one of the recombinant phenotypes was associated with an X chromosome of normal length B-the number of car, B+ male...
Are there any ethical issues raised by these smart products such as their impact on consumer privacy? Explain your answer .
Which features of organizations do managers need to know about to build and use information systems successfully?
Analyze Sears using the competitive forces and value chain models. What are Searss strengths? What are its weaknesses?
Choose two stocks from the same industry to minimize the influence of other confounding factors. You choose the industry that you are relatively more familiar with, and then estimate the implied...
why should Undertake research to review reasons for previous profit or loss?
A pension fund's liabilities has a PV01 of $200 million. The plan has $100 billion of assets with a weighted average modified duration of 8. The highest duration bond that the plan can invest in has...

Suppose a stock price follows a binomial distribution. We want to create a random price path for

Question:

A B. 1 Microsoft Excel 3 InitialPrice 1.3 The number of up moves: 0, 1, 2, 2, 3 The price path is: 30, 39, 50.7, 45,63, 59,32 5 Down 0.9 7 OK 9. 30 234656789

Step by Step Answer:

answer Here is a VBA s...View the full answer

Financial Modeling

Students also viewed these Business questions