You are an investor and investing in four stock options (SOA, SOB, SOC, and SOD) for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are an investor and investing in four stock options (SOA, SOB, SOC, and SOD) for a single day. The purchase prices and the historical price standard deviations are as follows: SOA: Purchase Price $18.75, Standard Deviation = 1.85 SOB: Purchase Price = $22.80, Standard Deviation = 1.65 SOC: Purchase Price = $24.90, Standard Deviation = 1.15 SOD: Purchase Price = $25.40, Standard Deviation = 2.24 You have purchased 300 shares of SOA, 250 shares of SOB and SOC, and 150 shares of SOD at the prices shown above, and you will sell them at the end of the same day. By the end of the day the stock option prices will change in accordance with normal distribution and the standard deviations shown above. You will realize a total profit(loss) for your one-day trading effort. PROBLEM a) Create a Monte Carlo simulation to estimate your total 1-day profit(loss) using 10,000 simulations? Show expected profit(loss) per stock option and the total profit(loss) for the day. b) What is the average profit(loss) using 5 successive simulations? c) Based on the profit(loss) observed above, would you invest in these stock options? Why? Create an Excel spreadsheet for the above analysis and submit the spreadsheet with all steps shown and all the data properly labeled. HINT Create 10,000 simulations for all the four stocks, compute the profit(loss) for each, obtain 5 different runs using the F9-key (fn+F9 in Mac), and record the total profit(loss) in each run. Average the profit(loss) of the 5 runs to determine the answer. You are an investor and investing in four stock options (SOA, SOB, SOC, and SOD) for a single day. The purchase prices and the historical price standard deviations are as follows: SOA: Purchase Price $18.75, Standard Deviation = 1.85 SOB: Purchase Price = $22.80, Standard Deviation = 1.65 SOC: Purchase Price = $24.90, Standard Deviation = 1.15 SOD: Purchase Price = $25.40, Standard Deviation = 2.24 You have purchased 300 shares of SOA, 250 shares of SOB and SOC, and 150 shares of SOD at the prices shown above, and you will sell them at the end of the same day. By the end of the day the stock option prices will change in accordance with normal distribution and the standard deviations shown above. You will realize a total profit(loss) for your one-day trading effort. PROBLEM a) Create a Monte Carlo simulation to estimate your total 1-day profit(loss) using 10,000 simulations? Show expected profit(loss) per stock option and the total profit(loss) for the day. b) What is the average profit(loss) using 5 successive simulations? c) Based on the profit(loss) observed above, would you invest in these stock options? Why? Create an Excel spreadsheet for the above analysis and submit the spreadsheet with all steps shown and all the data properly labeled. HINT Create 10,000 simulations for all the four stocks, compute the profit(loss) for each, obtain 5 different runs using the F9-key (fn+F9 in Mac), and record the total profit(loss) in each run. Average the profit(loss) of the 5 runs to determine the answer.
Expert Answer:
Answer rating: 100% (QA)
1 Monte Carlo Simulation For each stock option SOA SOB SOC SOD you need to simulate the pric... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these finance questions
-
Average Hospital Expenses Per Day Trends: FOHC would like to understand the trends for the average Hospital Expenses Per Day in the 1st half of the year (January through June). They would also like a...
-
La variable aleatoria x es el nmero de casas vendidas por un corredor de bienes races en un solo mes para la empresa Discover Real Estate. Su distribucin de probabilidad es la siguiente. Encontrar el...
-
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...
-
Barbara buys 100 shares of DEM at $35 a share and 200 shares of GOP at $40 a share. She buys on margin and the broker charges interest of 10 percent on the loan. a. If the margin requirement is 55...
-
This chapter states that much of what a project manager does exists on the boundary of the project. Explain what is meant by this statement.
-
A stock trades for shs. 120. A put on this stock has an exercise price of shs. 140 and is about to expire. The put trades for shs. 22. How would you respond to this set of prices? Explain
-
For Example 16-1, estimate an average \(\mathrm{H}_{\mathrm{OG}}\) in the stripping section. Then calculate \(\mathrm{n}_{\mathrm{OG}}\) and \(\mathrm{h}_{\mathrm{E}}=\mathrm{H}_{\mathrm{OG}, \text {...
-
The equity sections from Atticus Groups 2015 and 2016 year-end balance sheets follow. Stockholders Equity (December 31, 2015) Common stock$4 par value, 100,000 shares authorized, 40,000 shares issued...
-
Information on Ingrid Company's direct labor costs for May 2021 is as follows: Standard direct labor rate P6.00 Actual direct labor rate P5.80 What is Ingrid's total direct labor Standard direct...
-
Everyday items, from grocery staples to home dcor, are being priced more like airline tickets and gasoline, where the sticker prices can move frequently within hours or days. Retailers say the price...
-
What authority does The IIA have in the enforcement of its standards and Code of Ethics? Explain.
-
What are the primary objectives of internal control, according to the Standards for the Professional Practice of Internal Auditing?
-
What does it mean for an auditor to exercise "due professional care"?
-
What is the director of internal auditing's responsibility for audit supervision?
-
What three key elements should be present in an effective quality assurance program for an internal auditing department?
-
You created an index of four stocks that have share prices of $120, $290, $375, and $440 and market capitalizations of $180 million, $400 million, $350 million, and %150 million, respectively....
-
Chicago Company sold merchandise to a customer for $1,500 cash in a state with a 6% sales tax rate. The total amount of cash collected from the customer was $558. $600. $642. $636. Nevada Company...
-
The _________ effect refers to the case where a buyer wants a product because others also own it.
-
Positive network externalities are particularly common in the area of _________.
-
Describe and explain how the equilibrium wage and level of employment are determined in labor markets.
Study smarter with the SolutionInn App