g. Estimate the stock return for your chosen stock. Apply the Monte Carlo Simulation with 1,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
g. Estimate the stock return for your chosen stock. Apply the Monte Carlo Simulation with 1,000 simulations to estimate the average, median, min, max, standard deviation and the chance of loss of the return for your chosen stock in the next 30 trading days. (First you estimate the stock return. Then, you estimate the daily volatility of the stock return by applying STDEV.P function in excel. Next, you simulate the return in the next 30 trading days. After this, you apply the 1,000 simulations and calculate the average return, median return, minimum and maximum return, and the chance of loss of the return) 5 D5 File 5 6 7 8 3 Starting Price (Jul 1 22) 4 Annual volatility Daily volatility Excel Group 10 Excel file - Saved Search (Alt+Q) Home Insert Draw Page Layout Formulas Data Review Calibri BEA 14 15 16 17 9 10 Median price 11 19 Min Price 12 Max Price 13 standard deviation Mean (Average) price $52.34 $52.28 fr $45.94 $60.28 2.35 Part A Part B Run C 11 $52.36 12.20 % 0.77% D Days in the future V 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 *** View V G Simulated price H $51.84 $51.76 $51.57 $51.48 $51.35 $51.02 $51.39 $51.41 $51.16 $50.98 $50.90 $50,99 $50.35 $50.78 $51.12 $51.05 Automate Help Y General 1 2 3 Trial Random price $50.27 $50.58 $52.71 4 $52.77 5 $50.03 6 $55.71 7 $55.10 8 $54.11 9 $54.33 10 $55.37 11 12 13 $52.02 $51.80 Editing $54.00 14 $53.41 15 $49.87 16 $53.44 +0 00 .00 40 L V g. Estimate the stock return for your chosen stock. Apply the Monte Carlo Simulation with 1,000 simulations to estimate the average, median, min, max, standard deviation and the chance of loss of the return for your chosen stock in the next 30 trading days. (First you estimate the stock return. Then, you estimate the daily volatility of the stock return by applying STDEV.P function in excel. Next, you simulate the return in the next 30 trading days. After this, you apply the 1,000 simulations and calculate the average return, median return, minimum and maximum return, and the chance of loss of the return) 5 D5 File 5 6 7 8 3 Starting Price (Jul 1 22) 4 Annual volatility Daily volatility Excel Group 10 Excel file - Saved Search (Alt+Q) Home Insert Draw Page Layout Formulas Data Review Calibri BEA 14 15 16 17 9 10 Median price 11 19 Min Price 12 Max Price 13 standard deviation Mean (Average) price $52.34 $52.28 fr $45.94 $60.28 2.35 Part A Part B Run C 11 $52.36 12.20 % 0.77% D Days in the future V 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 *** View V G Simulated price H $51.84 $51.76 $51.57 $51.48 $51.35 $51.02 $51.39 $51.41 $51.16 $50.98 $50.90 $50,99 $50.35 $50.78 $51.12 $51.05 Automate Help Y General 1 2 3 Trial Random price $50.27 $50.58 $52.71 4 $52.77 5 $50.03 6 $55.71 7 $55.10 8 $54.11 9 $54.33 10 $55.37 11 12 13 $52.02 $51.80 Editing $54.00 14 $53.41 15 $49.87 16 $53.44 +0 00 .00 40 L V
Expert Answer:
Answer rating: 100% (QA)
Monte Carlo simulation is a mathematical technique used in finance to model potential investment out... View the full answer
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these accounting questions
-
Next month, the stock return for Pool Shark Corp, will be either 21% with probability 60% or -2% with probability 40%. What is the standard deviation of the monthly return?
-
Calculate the mode, mean, and median of the following data: 18 10 15 13 17 15 12 15 18 16 11
-
In this problem we will use Monte Carlo to simulate the behavior of the martingale St/Pt , with Pt as numeraire. Let x0 = S0/P0(0, T ). Simulate the process xt+h= (1+ hZt+h)xt Let h be approximately...
-
The inequality describes the range of monthly average temperatures T in degrees Fahrenheit at a certain location. (a) Solve the inequality. (b) If the high and low monthly average temperatures...
-
Thirty patients who check out of the Rock Creek County Regional Hospital each week are asked to complete a questionnaire about hospital service. Since patients do not feel well when they are in the...
-
1. What are the levels of persuasiveness of corroborating evidence? Which level will provide the most reliable evidence to auditors? Explain. 2. The audit program for accounts payable for a client...
-
Briefly describe what a credit default swap is and how it is generally used.
-
Valron Company has two support departments, Human Resources and General Factory, and two producing departments, Fabricating and Assembly. The costs of the Human Resources Department are allocated on...
-
Please explain the optimal debt ratios and why do public utilities have high debt ratios? Please explain whether dividends increase or reduce shareholder value? How do you financially evaluate an...
-
Sebastian Trains Co (ST) is a UK based rail operating company which holds three UK rail franchises. The franchises allow ST to run trains on the rail network in a particular geographical area within...
-
Caffeine was extracted from 10.0 grams of tea leaves (containing 0.5% caffeine) by solid-liquid extraction using 100.0 ml of water and liquid-liquid extraction using DCM. Initial tests on the...
-
Highlight the primary motivation behind non-stranger and stranger child abductions. Where and how are these abductions likely to happen?
-
Explain why some men misconstrue womens verbal and nonverbal communications.
-
Define and provide example of rape myths.
-
Review research findings on juvenile murderers.
-
_______ is a tool to encourage employees of an organization and increase productivity. Transactional analysis Johari window Life position None of the above
-
The Rachel Corporation purchased a building by paying $91,000 in cash on the purchase date, agreeing to pay $50,200 each year for the next seven years, and a payment of $101,000 ten years after the...
-
What are the key elements of a system investigation report?
-
Consider the 8-city traveling salesman problem whose links have the associated distances shown in the following table (where a dash indicates the absence of a link). 7190 12 2 7 98 6 3 011 221 5 4 1...
-
Suppose that a linear programming problem has 20 functional constraints in inequality form such that their right-hand sides (the bi) are uncertain parameters, so chance constraints with some a are...
-
Oxbridge University maintains a powerful mainframe computer for research use by its faculty, Ph.D. students, and research associates. During all working hours, an operator must be available to...
-
Select a publicly traded company or use a company assigned by your instructor. Using the firms most recent Form 10-K report (accessed through the SEC EDGAR database or from the companys website),...
-
Select a publicly traded company for analysis or use a company assigned by your instructor. Using the firms most recent Form 10-K report (accessed through the SEC EDGAR database or from the companys...
-
Select a publicly traded company for analysis. Using the firms most recent 10-K Report (accessed through the SEC EDGAR database at sec.gov or from the companys website), identify how financial data...
Study smarter with the SolutionInn App