Find net gain or loss after the given time period

Reference no: EM131960795

Question: You are considering buying a stock that currently has a price of $38.75. Looking at historical data you found that for the past 100 trading days, the stock went up $1 on 23 days, up $.50 on 16 days, remained unchanged on 12 days, went down $0.75 on 35 days, and down $1 on 14 days.

Simulate the price of the stock for the next 90 days. You should also find net gain or loss after the 90 days. Using a data table in Excel or using Analytic Solver Platform, repeat the simulation 100 times to find the average price after 90 days, and create a frequency distribution of the net change.

Reference no: EM131960795

Questions Cloud

What is the maximum price you can afford to pay for a house : You are considering buying a house close to the university so that you can devote more time to your academic career. You have estimated that you can afford.

Decision making process : The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.

Compute the current cost of financing options : We are considering constructing a new $130 million 320-suite tower on our Venetian property. Please compute the current cost of using each of these financing.

Which proposal will be the final outcome : The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.

Find net gain or loss after the given time period : Simulate the price of the stock for the next 90 days. You should also find net gain or loss after the 90 days. Using a data table in Excel.

Make a stacked bar chart that shows the total cost : Make a stacked bar chart that shows the total cost, including the design, implementation, and maintenance costs over an expected system life of seven years.

Explain the steps involved in 3d transformation : Explain the steps involved in 3d transformation

Types of coats using the same workers : Jordan's jackets produces two types of coats using the same workers. The production function and marginal product of labor for each type can be expressed as :

What is the interest expense for the loan : You are considering borrowing 1 million SEK for one month at an APR of 12%. The bank will require a (no-interest) compensating balance of 6% of the face value.

User Account

All Pages