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...
-
A. The AR(1) model for the civilian unemployment rate, UER t = 0.0405 0.4674UERt 1, was developed with five years of data. What would be the drawback to using the AR(1) model to predict changes in...
-
Hominy, Inc., has debt outstanding with a face value of $2.15 million. The value of the firm if it were entirely financed by equity would be $11.4 million. The company also has 195,000 shares of...
-
What are some of the major ways that information technology is helping MNEs overcome the problems of time and space?
-
Refer to the information in Exercise. In exercise Pro-Weave manufactures stadium blankets by passing the products through a weaving department and a sewing department. The following information is...
-
You would use the. capacity syringe to administer a combination dose of 5 units short-acting insulin and 56 units of Intermediate-acting Insulin.
-
Lu Ltd. has experienced the following accounting earnings and taxable income: The differences between accounting and taxable income are caused by differences between accounting and tax expenses that...
-
Point A is at (-7,5) and point C is at (5,-1). Find the coordinates of point B on bar (AC) such that AB is 5 times as long as BC.
-
_____ is the process of eliminating or combining tasks and/or changing the work sequence to improve performance.
-
Upper management has a decision to make. They call you to a meeting and tell you they need some information to solve a problem they describe to you. You: a. Respond in a manner that conveys personal...
-
_____ provides a conceptual framework for designing or enriching jobs based on core job characteristics.
-
Your department has designed a product that is to be fabricated by Sauls department. Saul has been with the company longer than you have; he knows his department. Saul comes to you to change the...
-
_____ is a process of reviewing historical items, such as revenues, and relating those changes to some business factor to form a predictive chart.
-
Please help with complete solution. 19. Spending of College Freshmen The average amounts spent by college freshmen for school items are shown. Construct a pie graph for the data....
-
A red card is illuminated by red light. What color will the card appear? What if its illuminated by blue light?
-
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...
-
How do teams work?
-
Task characteristics, reward systems, and team size are all ____________ that can make a difference in group effectiveness. (a) group processes (b) group dynamics (c) group inputs (d) human resource...
-
When a new team member is anxious about questions such as Will I be able to influence what takes place? the underlying issue is one of ____________. (a) relationships (b) goals (c) processes (d)...
Study smarter with the SolutionInn App