Use Norm.S.Inv(Rand( )) to produce a simulation of monthly stock prices, as illustrated below. 1 SIMULATING A
Question:
Use Norm.S.Inv(Rand( )) to produce a simulation of monthly stock prices, as illustrated below.
Transcribed Image Text:
1 SIMULATING A LOGNORMAL PRICE PROCESS 2 Initial stock price 3 Mean return, m 4 Return sigma, s 5 Delta t 12 12% 35% 8% <-- =1/12 Random Stock Month price 12 7 number 1 0.3021 12.4963 <-- =C8*EXP($B$3*$B$5+$B$4*SQRT($B$5)*B9) 0.9810 0.1774 -1.1420 10 2 13.9371 11 12 13 3 14.3318 16 4 12.8982 15 0.5932 13.8325 14 0.7335 15.0463 14 -1.7615 0.6826 0.4070 15 12.7198 13 16 8 13.7649 17 14.4869 12 18 10 -0.7262 13.5974 11 -0.5846| 0.9055 19 11 12.9464 20 12 14.3293 10 21 9 22 8 23 Cell B20 contains formula 24 0 1 2 3 4 5 6 7 8 9 10 11 12 =NORMSINV(RAND()) 25 -- - - - - -
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (6 reviews)
Sure the image you sent shows a table that simulates monthly stock prices using the Excel functions ...View the full answer
Answered By
Kennedy Odhiambo
As a professional writer, I have been in the field for over 5 years having worked as a lecture in different tertiary institutions across the world. With this impeccable experience, I assure provision of a good and supporting environment for students to learn.
5.00+
2+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
Monthly stock prices for two competing firms are as follows. a. Calculate the sample mean, the sample variance, and the sample standard deviation for each firms stock price. b. Which firm had the...
-
Below you will find the closing stock prices for eBay over a three-week period. Calculate the simple three-day and five-day moving averages for the stock and graph your results. Are there any...
-
A portion of the monthly stock prices (rounded to the nearest dollar) for Starbucks Corp. and Panera Bread Co. from 2010 to 2013 are reported in the following table. a. State the null and the...
-
Draw an ER model according to the below information. NOTE: Use a word or any website to produce the diagrams. Dont use handwriting. In ERD diagram: 1. Entity: There are 6 Entity in this diagram:...
-
A U.S. pension fund has a domestic portfolio with an expected return of 10 percent and a standard deviation of 12 percent. It also invests in a foreign equity fund that has an expected dollar return...
-
Server Farm Inc. (SFI) needs to upgrade its server computers. Company management has identified the following two options: (1) Shift to a Windows based platform from its current Unix-based platform,...
-
Kasper Industries produces custom molds that are used by producers of molded products (e.g., ski boots and snowboards). Many of its customers use just-in-time (JIT) manufacturing, and on-time...
-
The pretax financial income of Truttman Company differs from its taxable income throughout each of 4 years, as shown on page 1058. Pretax financial income for each year includes a non-deductible...
-
Hlo this is Acoounting (intro to accounting) course. I need help with this question. Thanks. A cash flow statement is organized into three categories: operating, financing, and investing activities...
-
Icy Treats, Inc., is a seasonal business that sells frozen desserts. At the peak of its summer selling season the firm has $35,000 in cash, $125,000 in inventory, $70,000 in accounts receivable, and...
-
The great Indian mathematical genius Ramanujan showed that The n ! indicates the factorial: n! = n*(n - 1) = (n - 2) *...* 2 * 1 0! = 1 Excel?s function Fact computes the factorial. Use this series...
-
Run a few of the lognormal price path simulations. Examine the price pattern for trends. Find one or more of the following technical patterns:support arearesistance areauptrend/downtrendhead and...
-
Harpreet understands that inventory turnover refers to the number of times that a company can sell and replace its inventory over the course of the year, but doesnt understand the meaning of asset...
-
Discuss the challenges and opportunities associated with implementing advanced sustainable drainage systems (SuDS) in urban development projects to mitigate the impacts of urbanization on storm water...
-
what extent does proper sleep hygiene contribute to the reduction of stress-related symptoms ? Explain
-
Use the below assignment instructions to make a python program. This program should utilize some of the functions given by card.py and deck.py. Please give all the code necessary to complete the...
-
Provide statistics that show a decline in manufacturing jobs in the United States has not caused manufacturing output to decline and the narrative that we don't make anything here anymore may not be...
-
Explore the principles of structural health monitoring (SHM) using advanced sensor technologies and data analytics to assess the condition, performance, and resilience of civil infrastructure, and...
-
Brett Terrible, your department supervisor, hates you for informing the federal government that he has been taking advantage of his position as the Controller at a publicly traded company to embezzle...
-
What are some of the possible sources of information about a company that could be used for determining the companys competitive stance?
-
What are the inputs, processing, and outputs of UPSs package tracking system?
-
What technologies are used by UPS? How are these technologies related to UPSs business strategy?
-
What strategic business objectives do UPSs information systems address?
-
Chapter 5, Problem 5/024 Your answer is incorrect. Locate the centroid of the area shown in the figure by direct integration. (Caution: Carefully observe the proper sign of the radical involved.) Set...
-
Include at least five main chapters of Abstract, Introduction, Main Body, Conclusions and References. Abstract includes the objective of research, the methods of research and the major...
-
02.E02 Given a business system report in which significant deficiencies exist, identify the required steps to complete the initial determination proce < < Back Save / Return Later Summary Next...
Study smarter with the SolutionInn App