You are a stock day trader and investing in four stocks (A, B, C, and D)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a stock day trader and investing in four stocks (A, B, C, and D) for only one day. The purchase prices and the historical price standard deviations are as follows: • Stock A: Purchase Price = $19,88, Standard Deviation = 2.16 Stock B: Purchase Price = $23.07, Standard Deviation = 1.75 Stock C: Purchase Price = $25.13, Standard Deviation = 2.13 Stock D: Purchase Price = $25.40, Standard Deviation = 4.12 You have purchased 100 shares Stock A, 200 shares of Stock B, 200 shares of Stock C, and 150 shares of Stock C. You will sell them at the end of the same day. The stock prices are normally distributed and will change in accordance with the standard deviations. The sales price of each stock can be simulated, and the total profit by stock is the difference between the purchase and sales prices, multiplied by quantity of each stock. You will realize a total profit(loss) for your 1-day trading effort. PROBLEM Use the Monte Carlo method with 1,000 simulations in Excel to determine the following: • Expected profit (loss) • Minimum profit • Maximum profit • Standard deviation of profit Likelihood of loss (%) APPROACH Create an Excel spreadsheet for the above analysis and submit the spreadsheet with all steps shown and all the data properly labeled. Please use appropriate colors/borders etc. to make your spreadsheet presentable and easy to read. Also, represent all currencies in Dollars/Cents (e.g., $2,120.37) and any percentages in integers (e.g., 19%). The spreadsheet should show: The inputs. Labels for all columns/sections. Rows numbered 1-1000 for the simulations. Simulated sales prices for each stock. Simulated total profits for each stock based on the purchase, sales, and quantity. Total profits for each simulation. Summary of the outputs (expected, minimum, maximum, and SD of profits/losses, and the likelihood of a net loss). BONUS (10 points) Provide a chart for the cumulative total profit over the 1000 simulations. You are a stock day trader and investing in four stocks (A, B, C, and D) for only one day. The purchase prices and the historical price standard deviations are as follows: • Stock A: Purchase Price = $19,88, Standard Deviation = 2.16 Stock B: Purchase Price = $23.07, Standard Deviation = 1.75 Stock C: Purchase Price = $25.13, Standard Deviation = 2.13 Stock D: Purchase Price = $25.40, Standard Deviation = 4.12 You have purchased 100 shares Stock A, 200 shares of Stock B, 200 shares of Stock C, and 150 shares of Stock C. You will sell them at the end of the same day. The stock prices are normally distributed and will change in accordance with the standard deviations. The sales price of each stock can be simulated, and the total profit by stock is the difference between the purchase and sales prices, multiplied by quantity of each stock. You will realize a total profit(loss) for your 1-day trading effort. PROBLEM Use the Monte Carlo method with 1,000 simulations in Excel to determine the following: • Expected profit (loss) • Minimum profit • Maximum profit • Standard deviation of profit Likelihood of loss (%) APPROACH Create an Excel spreadsheet for the above analysis and submit the spreadsheet with all steps shown and all the data properly labeled. Please use appropriate colors/borders etc. to make your spreadsheet presentable and easy to read. Also, represent all currencies in Dollars/Cents (e.g., $2,120.37) and any percentages in integers (e.g., 19%). The spreadsheet should show: The inputs. Labels for all columns/sections. Rows numbered 1-1000 for the simulations. Simulated sales prices for each stock. Simulated total profits for each stock based on the purchase, sales, and quantity. Total profits for each simulation. Summary of the outputs (expected, minimum, maximum, and SD of profits/losses, and the likelihood of a net loss). BONUS (10 points) Provide a chart for the cumulative total profit over the 1000 simulations.
Expert Answer:
Answer rating: 100% (QA)
Monte Carlo Simulation for Stock Day Trading This spreadsheet simulates 1000 scenarios of stock price movements for a 1day trade and calculates the pr... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The Electronic Industries Association reports that about 50% of U.S. households have a camcorder. For a randomly selected sample of 800 U.S. households, use the normal approximation to the binomial...
-
Berkshire Hathaway, the investment holding company of Warren Buffett, reports its less than 20% ownership investments according to generally accepted accounting principles. However, it also provides...
-
Let \(M\) be a Gaussian martingale with bracket \(\langle Mangle\). Prove that the process \(\langle Mangle\) is deterministic. The Gaussian property implies that, for \(t>s\), the r.v....
-
According to Equation 14.4, if the foreign interest rate falls, all other things constant, what should happen to the price of foreign money in the short run? E = exp(E++1) i-+1 (14.4)
-
Most firms in the apparel and footwear industries choose to outsource production to countries where labor is abundant (primarily, Southeast Asia and the Caribbean)but those firms do not integrate...
-
Gable Company uses three activity pools. Each pool has a cost driver. Information for Gable Company follows: Activity Pools Total Cost of Pool Cost Driver Estimated Cost Driver Machining $ 171,100...
-
Merline Manufacturing makes its product for $70 per unit and sells it for $144 per unit. The sales staff receives a commission of 10% of sales. Its December Income statement follows. MERLINE...
-
Question 12 Which is subject to VAT? O Distribution of ordinary assets to stockholders by a corporation. O Personal consumption of capital assets. Donation of capital assets O Transfer of ordinary...
-
How do you search for a target key in a linked list?
-
What are different operations we can perform on queues?
-
How many different pointers are necessary to implement a singly linear linked list?
-
What is a priority queue?
-
What are the applications of data structures?
-
A government has $3,000,000 of 6%, 10 year general obligation bonds outstanding. The bonds were issued on July 2, 2017 to finance construction of a general capital asset. Interest is payable...
-
Using (1) or (2), find L(f) if f(t) if equals: t cos 4t
-
The first sushi restaurant opens in town. Initially people are very cautious about eating tiny portions of raw fish, as this is a town where large portions of grilled meat have always been popular....
-
According to data from the U.S. Department of Agriculture's National Agricultural Statistics Service, 124 million acres of land in the United States were used for wheat or corn farming in 2004. Of...
-
Kate's Katering provides catered meals, and the catered meals industry is perfectly competitive. Kate's machinery costs $100 per day and is the only fixed input. Her variable cost consists of the...
-
A and B contribute $20,000 each to form the AB partnership and agree to share profits and losses 80% to A and 20% to B. ABs partnership items for the year are as follows: (a) What is As portion of...
-
A and B form the AB equal general partnership. A contributes \($10,000\) cash and a depreciable asset with an adjusted basis of \($40,000\) and a fair market value of \($90,000.\) B contributes...
-
Which of the following taxpayers is engaged in a specified service trade or business? (a) A lawyer (b) An architect (c) A professional soccer player (d) A freelance writer who publishes articles and...
Study smarter with the SolutionInn App