Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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). 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management for Public Health and Not for Profit Organizations

Authors: Steven A. Finkler, Thad Calabrese

4th edition

133060411, 132805669, 9780133060416, 978-0132805667

More Books

Students also viewed these Finance questions