Using analytic solver platform

Assignment Help Financial Management
Reference no: EM131453372

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: EM131453372

Questions Cloud

Breakfast cereal competition : You won a breakfast cereal competition. what is the most valuable prize?
According to the historical cash flows : According to the historical cash flows, the farm expects an annual net cash flow of $450,500. Using a 5% discount rate, how much should the son pay for farmland
Treasury interest rate increase before you have to default : How much can the 10-year treasury interest rate increase before you have to default?
Deposit today to make these withdrawals : How much do you have to deposit today to make these withdrawals?
Using analytic solver platform : You should also find net gain or loss after the 90 days. Using a data table in Excel or using Analytic Solver Platform,
Market yield for bonds of similar risk and maturity : The bonds mature in three years. The market yield for bonds of similar risk and maturity is 12%. The entire bond issue was purchased by United Intergroup, Inc.
Annual interest rates : annual interest rates
What is the internal rate of return for this investment : They forecast you can sell the building for in two years (time 2). If your discount rate is , what is the internal rate of return for this investment?
Incentive to misstate cost accounting data on particular job : What feature of these businesses creates an incentive to misstate cost accounting data on particular jobs? What can customers do to protect themselves from over

Reviews

Write a Review

Financial Management Questions & Answers

  Repaid in equal annual instalments

Big brothers inc borrows $165315 from the bank at 6.52 percent per year compounded annually to purchase new machines. This loan is to be repaid in equal annual instalments at the end of each year over the next 3 years. How much will each annual payme..

  Explain the automobile insurance

Explain the automobile insurance (listed below) and provide an appropriate example of this type of insurance. Discuss the relationship between risk and this type of insurance. Describe the risk management tools. Discuss the legal principles of risk a..

  Calculate the tax cost of partnership earnings this year

Kari is a partner in Lizard Partnership. This year, Kari's share of partnership ordinary income is $20,000 and she received a cash distribution of $30,000. Kari's tax basis in her partnership interest at the beginning of the year was $50,000. Her mar..

  Lockboxes should be located

Lockboxes should be located?

  What is your estimate of an appropriate stock price

TwitterMe, Inc., is a new company and currently has negative earnings. The company’s sales are $2.6 million and there are 142,000 shares outstanding. If the benchmark price–sales ratio is 6.2, what is your estimate of an appropriate stock price?

  How much would she have after the same three periods

how much would she have after the same three periods? Explain why the previous number are higher

  The functional currency for the subsidiary

Fenwicke Company organized and began operating a subsidiary in a foreign country on Jan. 1, 2015, by investing LCU 40,000. This subsidiary immediately borrowed LCU 100,000 on a 5-year note with 10 percent interest payable annually beginning on Jan 1,..

  Dividends will be paid on the stock over the next nine years

Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years because the firm needs to plow back its earnings to fuel growth. The company will pay a $15 per share dividend 10 years from today ..

  Calculate the net present value of the proposed mine

Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years af..

  What will be the percentage change in the price of the bond

A Bond pays a 8 percent coupon rate with 10 years to maturity, makes semiannual payments, and has a yield-to-maturity of 6 percent. If market interest rates suddenly rise 1 percent, what will be the percentage change in the price of the bond? Did it ..

  What is the yield on municipal bond with coupon rate

What is the yield on a $1,000,000 municipal bond with a coupon rate of 8%, paying interest annually, versus the yield of a $1,000,000 corporate bond with a coupon rate of 10% paying interest annually? Assume that you are in the 25% tax bracket.

  Calculate call value of owens corning warrants

When Owens Corning emerged from bankruptcy in 2006, the debt holders became the sole owners of the company. But the old stockholders were not left entirely empty handed. They were given warrants to buy the new common stock at any point in the next se..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd