Your stockbroker suggests that you buy 1,000 shares of International Business Electronics (IBE). The stock currently...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your stockbroker suggests that you buy 1,000 shares of International Business Electronics (IBE). The stock currently is selling at $38.75 per share. From research over the internet you discovered that the stock is quite volatile and based on recent past data distribution is as follows: 21% of the weeks it goes up $1.00 17% of the weeks it goes up $0.50 10% of the weeks it remains unchanged 35% of the weeks it goes down $0.50 17% of the weeks it goes down $1.00 (a) Calculate theoretical expected profit/ loss per share and for 1000 shares 1 23 st 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B Price Ch Q3-Stock Simulation Theoretically, the expected value of the investment is given by S (P x V) P = Probability of stock at a given state V = Change in value of the stock Expected Value per share= Σ (P x V) = Expected Profit/Loss for 1500 shares = Using simulation we can find expected value as follows; 1.0 0.5 0.0 -0.5 -1.0 E Prob. 0.21 0.17 0.10 0.35 0.17 Cum Prob R# F G (b) Create a worksheet to simulate the price of the stock and the value of your portfolio for 20 weeks assuming the above distribution. You should have 20 rows in the main part of your worksheet, one for each week. You should have separate columns for the week. number, a random number, the price change for that week, the closing price of the stock that week, the value of your portfolio. Have separate cells at the top of the worksheet for the resulting High, Low, and Close for the stock price over the 20 weeks, that is the highest price the stock reaches, the lowest price the stock reaches, and the closing price after 20 weeks. Have separate cells that shows the amount of money you would have made (or lost) on the investment of 1,000 shares and per share. Use only the random numbers provided. (c) Based on your simulations, is this a good investment? Discuss. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 A Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 B R# 47 2 8 13 78 94 89 24 47 2 8 13 78 41 77 96 82 22 96 92 C Pr Ch E Price at end of week F G Portfolio Value H Stock Price High Low J Close Your stockbroker suggests that you buy 1,000 shares of International Business Electronics (IBE). The stock currently is selling at $38.75 per share. From research over the internet you discovered that the stock is quite volatile and based on recent past data distribution is as follows: 21% of the weeks it goes up $1.00 17% of the weeks it goes up $0.50 10% of the weeks it remains unchanged 35% of the weeks it goes down $0.50 17% of the weeks it goes down $1.00 (a) Calculate theoretical expected profit/ loss per share and for 1000 shares 1 23 st 4 5 6 7 8 9 10 11 12 13 14 15 16 17 A B Price Ch Q3-Stock Simulation Theoretically, the expected value of the investment is given by S (P x V) P = Probability of stock at a given state V = Change in value of the stock Expected Value per share= Σ (P x V) = Expected Profit/Loss for 1500 shares = Using simulation we can find expected value as follows; 1.0 0.5 0.0 -0.5 -1.0 E Prob. 0.21 0.17 0.10 0.35 0.17 Cum Prob R# F G (b) Create a worksheet to simulate the price of the stock and the value of your portfolio for 20 weeks assuming the above distribution. You should have 20 rows in the main part of your worksheet, one for each week. You should have separate columns for the week. number, a random number, the price change for that week, the closing price of the stock that week, the value of your portfolio. Have separate cells at the top of the worksheet for the resulting High, Low, and Close for the stock price over the 20 weeks, that is the highest price the stock reaches, the lowest price the stock reaches, and the closing price after 20 weeks. Have separate cells that shows the amount of money you would have made (or lost) on the investment of 1,000 shares and per share. Use only the random numbers provided. (c) Based on your simulations, is this a good investment? Discuss. 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 A Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 B R# 47 2 8 13 78 94 89 24 47 2 8 13 78 41 77 96 82 22 96 92 C Pr Ch E Price at end of week F G Portfolio Value H Stock Price High Low J Close
Expert Answer:
Answer rating: 100% (QA)
Answer a Q3Stock Simulation Expected Value per share 387 Expected profit loss for 1000 shares 38700 ... View the full answer
Related Book For
Introduction To Derivatives And Risk Management
ISBN: 9781305104969
10th Edition
Authors: Don M. Chance, Robert Brooks
Posted Date:
Students also viewed these accounting questions
-
3 4 5 6 7 8 9 10 11 12 13 A 14 Cost of the Asset 15 Life of the Asset in Years 16 Book Value of the Asset after 5 years 17 Depreciable Basis 18 Yearly depreciation 19 After tax Salvage Value in year...
-
Suppose that Weston (WN) currently is selling at $ 80 per share. You buy 250 shares, using $ 15,000 of your own money and borrowing the remainder of the purchase price from your broker. The rate on...
-
A 1 defects size B D E 88888888888888888888888888 2 21 3 24 4 16 5 12 6 15 7 5 8 28 9 20 10 31 11 25 12 20 13 24 14 16 15 19 16 10 17 17 18 13 19 22 20 18 21 39 22 30 23 24 24 16 25 19 26 17 27 15...
-
An abc-sequence balanced three-phase wye-connected source supplies power to a balanced wye-connected load. The line impedance per phase is 1 + j10, and the load impedance per phase is 20 + j20. If...
-
Describe the two ways whereby capital market securities pass from the issuer to the public.
-
Davids basis in the Jimsoo Partnership is $53,000. In a proportionate liquidating distribution, David receives cash of $7,000 and two capital assets: (1) Land A with a fair market value of $20,000...
-
Consider a wheel with \(n\) sectors. If the wheel pointer lands on sector \(i\), the payoff obtained is \(r_{i}\) for every unit bet on that sector. The chance of landing on sector \(i\) is \(p_{i},...
-
1. Discuss the factors that may cause Jane to intentionally and unintentionally distort her ratings of Barb and George. 2. Evaluate the kinds of training programs that could help minimize the factors...
-
Rubber and Steel Company is planning to manufacture a new product. The variable manufacturing costs will be $57 per unit and the fixed costs are estimated to be $6819 The selling price of the product...
-
The trial balance of Rosiak Fashion Center contained the following accounts at November 30, the end of the companys fiscal year. Adjustment data: 1. Supplies on hand totaled 2,100. 2. Depreciation is...
-
The following information is available for the Rollin' Baby Company which produces two types of strollers, standard and deluxe. Standard Deluxe Total Sales volume (units) 4,000 3,500 $147,000 7,500...
-
Briefly, what are some of the commonly reported expense categories?
-
Monetarists are most likely to believe that: A. there is a causal relationship running from inflation to money. B. inflation can be affected by changing the money supply growth rate. C. rapid...
-
In theory, setting the policy rate equal to the neutral interest rate should promote: A. stable inflation. B. a balanced budget. C. greater employment.
-
What are the four Cs?
-
What is an expense?
-
Ali borrows $239,000 to buy a house on March 1. The bank quotes the mortgage rate of 7.75 percent. The loan repayment schedule is asking for the payment to be repaid in equal monthly payments over 20...
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
Repeat the previous problem, but close the positions on September 20. Use the spreadsheet to find the profits for the possible stock prices on September 20. Generate a graph and use it to identify...
-
Suppose your firm is a derivatives dealer that has recently created a new product. In addition to market and credit risk, what additional risks does it face that are associated more with new products?
-
Explain how the implied repo rate on a spread transactions differs from that on a nearby futures contracts?
-
Th e quick ratio for Company A is closest to: A . 0.43. B . 0.57. C . 1.00.
-
Based on Exhibit 1, the fi nancial leverage ratio for Company B is closest to: A . 0.55. B . 1.22. C . 2.22. EXHIBIT 1 Common-Size Balance Sheets for Company A, Company B, and Sector Average Company...
-
Based on Exhibit 1, which ratio indicates lower liquidity risk for Company A compared with Company B? A . Cash ratio. B . Quick ratio. C . Current ratio. EXHIBIT 1 Common-Size Balance Sheets for...
Study smarter with the SolutionInn App