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...
Post - Combination Balance Sheet Presented below are the balance sheets of Allen Corporation and Benson Corporation, immediately prior to a business combination. The fair values of Benson s reported...
Two corporations each hired 10 graduates. The starting salaries for each graduate are shown. Find the range of the starting salaries for Corporation A. Starting Salaries for Corporation A (in...
Debra Bishops cabinet-making shop, in Des Moines, has five tools that automate the drilling of holes for the installation of hinges. These machines need setting up for each order of cabinets. The...
When interview candiates how would you develop an evaluation rubric that would be filled out by each interviewer? How would you review the results of each interviewer's assessment?
The Guide Company requires additional cash for its business. Guide has decided to use its accounts receivable to raise the additional cash as follows: 1. On June 30, 2007, Guide assigned $200,000 of...
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...
Installment-Sales Method Calculations, Entries Coffin Corporation appropriately uses the installment-sales method of accounting to recognize income in its financial statements. The following...
Ethyl benzene (boiling point 136.2C) and styrene (boiling point 145.2C) are separated by continuous distillation in a column operated under a vacuum to keep the temperature under 110C and to avoid...
Youre planning a pizza party and you plan to give each person 3 slices of pizza. Design a program that displays the number of slices that will be leftover. The program should ask for the following...
Write an equivalent Java assignment statement for each of these mathematical expressions. A. $v=\frac{49 x^{15}}{y+z}$ B. $s=r \pi \sqrt{r^{2}+h^{2}}$ C. $a=\frac{\sin g}{c}$
In deciding whom to sue, an attorney must assess the assets of each potential defendant. If a potential defendant is not insured and has no assets that can be collected if a judgment is won,...
Who is affected by this problem? According to the client who assigned the analysis, are influential or valued people or groups affected by this problem? Is there a fairness concern relating to this...
Rolando purchases a golf cart from his employer, E-Z-Go Golf Carts, for a sizable discount. Explain the rules for determining if Rolando's purchase results in taxable income for him.
On October 1, 2021, Adoll Company acquired 2,600 shares of its $1 par value stock for $38 per share and held these shares in treasury. On March 1, 2023, Adoll resold all the treasury shares for $34...
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?
123 Anna purchased 100 shares of Delta stock on February 1, Year 2, for $46 per share, and 5 received a two-for-one stock split on December 31, Year 2. Anna sold all the shares of Delta stock on...
work i Saved QS 17-10 (Algo) Computing activity rates for activity-based costing LO P3 A company sells two types of products: standard and deluxe. It prepares the following analysis showing budgeted...
! Required information [The following information applies to the questions displayed below.] Sweeten Company had no jobs in progress at the beginning of the year and no beginning inventories. It...

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