Suppose a stock price follows a binomial distribution. We want to create a random price path for the stock in a VBA macro. Here is the input with some sample output:

Write a VBA an appropriate subroutine.

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

Transcribed Image Text:

B 1 To run macro: [Ctrl]+f E L 2 3 Initial price 30 Microsoft Excel 4 Up 1.3 5 Down 0.9 6 The number of up moves: 0.1.2.2.2.2 The price path is 30, 39, 50.7, 45.63, 41.067, 36.9603 7 8 9 OK 10 11