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...
-
A water pipe having a 2.5 cm inside diameter carries water into the basement of a house at a speed of 0.90 m/s and a pressure of 170kPa. If the pipe tapers to 1.2 cm and rises to the second floor 7.6...
-
a. Prove that any comparison-based algorithm to sort 4 elements requires 5 comparisons. b. Give an algorithm to sort 4 elements in 5 comparisons.
-
The University of Toronto Faculty of Applied Science and Engineering is considering the purchase of a special-purpose machine for $60,000. It is expected to have a useful life of three years with no...
-
The intangible assets section of Redeker Company at December 31, 2010, is presented below. Patent ($70,000 cost less $7,000 amortization)..... $63,000 Franchise ($48,000 cost less $19,200...
-
QUESTION 2 25 Marks Brilliant Coaches Ltd (Brilliant) entered into a contract with Benz Ltd (Benz) tor the lease of two buses. The model and size of the buses are stated in the contract but Benz does...
-
Net Gain before Discount, Discount and Net Capital Gain. The informaion is based on Australian Tax Legislation Ned Una, a resident taxpayer, sold the following assets during the 2021/22 tax year....
-
Question 2 0/1 pt 398 Details In triangle ABC, mZA = 28 degrees, mLC132 degrees, and the length of AB = 6. Find the measures of the other sides and angles. m/B- length of AC= degrees (Round your...
-
Which capital investment appraisal techniques are most suitable for use in public sector organizations?
-
List and explain five rules of thumb for improving written communication.
-
Why is human error often an incomplete root cause?
-
Whatare themaindifferences between traditional budgets and performancebased budgets?
-
Explain in a few words how managements role has changed with the advent of TQM.
-
Please help so i have a better understanding You are considering opening a new plant. The plant will cost $97.2 million upfront and will lake one year to build. After that, it is expected to produce...
-
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...
-
Hudson Company's trial balance as of January 1. the beginning of its fiscal year, is given below: Hudson Company is a manufacturer that uses a job-order costing system. During the year, the following...
-
Gitano Products operates a job-order costing system and applies overhead cost to jobs on the basis of direct materials used in production (not on the basis of raw materials purchased). In computing a...
-
Almeda Products, Inc., uses a job-order cost system. The company's inventory balances on April 1 , the start (3) Underapplied by $4,000 of its fiscal year, were as follows: Required: 1. Prepare...
Study smarter with the SolutionInn App