Reference no: EM133127827
Select a business of which you are a part or in which you have interest and download the raw data on the company's stock history. Any business that has practical meaning for you is appropriate for this assessment on Yahoo Finance
Using the Excel file with the year's stock data, conduct descriptive analysis as follows:
Create a scatterplot of the highest stock price (in the column labeled "High") against time. Write a sentence explaining the process by which you created this graph.
Create a scatterplot of the lowest stock price (in the column labeled "Low") against time. Write a sentence explaining the process by which you created this graph.
Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write a sentence explaining the process by which you created this graph.
Create a histogram of the stock trading volume (in the column labeled "Volume"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write a sentence explaining the process by which you created this graph.
Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Write a sentence explaining the process by which you calculated these statistics.
Calculate the mean, median, mode, and standard deviation of the stock volume. Write a sentence explaining the process by which you calculated these statistics.
|
Find the cost of loan capital to BTX Ltd
: BTX Ltd is using a loan of $10 million. The nominal rate of interest for the loan is 10.11%. The company pays tax at 34%. Find cost of loan capital to BTX Ltd
|
|
Find the WACC for PTX Ltd
: The cost of equity for PTX Ltd is estimated to be 24.68% with the current market value of $34 million. The tax rate is 33%. Find the WACC for PTX Ltd
|
|
Leadership in relation to strategic planning efforts
: We have discussed the importance of leadership in relation to strategic planning efforts.
|
|
Explain the endosymbiotic theory
: Explain the endosymbiotic theory for the formation of eukaryotic cells. Eukaryotes formed from union of small aerobic prokaryotes
|
|
Calculate the mean-median-mode and standard deviation
: Calculate the mean, median, mode, and standard deviation of the stock volume. Write a sentence explaining the process by which you calculated these statistics.
|
|
How should Lynn file her taxes
: Lynn usually files head of household, she has 1 child. How should Lynn file her taxes? What are the forms and the steps to file her taxes
|
|
Calculate the cost of the units completed
: Calculate the cost of the 50,000 units completed and transferred out and the 35,000 units, 60% complete, in the ending Work-in-Process Inventory
|
|
Teaming across distance and culture
: What are the major effects of the physical separation of group members? How can distance, in some cases, be beneficial to groups and teams?
|
|
Determine the amount of income or loss from each entity
: The trust received dividends of $16,000 and made distributions of $4,500 to G Jr. Determine the amount of income or loss from each entity
|