Question

In: Finance

For 5 points of extra credit, prepare a graph in Excel that plots the daily price...

For 5 points of extra credit, prepare a graph in Excel that plots the daily price fluctuations (daily closing price) from the day you purchased the stock to the current date. You need to create a graph for only one stock. To find the historical daily prices, Yahoo/Finance has a good tool.

Solutions

Expert Solution

We have collected the data of Share price Movement of Goldman Sachs from Yahoo Finance. Below is for your kind perusal

Date Close Price
Feb-27 198.1
Feb-28 196.7
Mar-01 198.2
Mar-04 195.98
Mar-05 196
Mar-06 194.74
Mar-07 192.77
Mar-08 195.24
Mar-11 195.97
Mar-12 196.63
Mar-13 197.25
Mar-14 197.47
Mar-15 198.26

Let us assume that you purchased the stock of Goldman Sachs on 27th of Feb, 2019. @198.1


USING A LINE CHART TO PRESENT THE SAME.


Related Solutions

The Cash Budget– Extra Credit * Would like to have answer in excel with equations shwoing...
The Cash Budget– Extra Credit * Would like to have answer in excel with equations shwoing 1.    The financial staff at Exotic Foods Inc., a food importer, wholesaler, and distributor, has estimated the following sales figures for the first half of 2018: Month Sales Other Expenses January $100,000 $3,000 February $120,000 $3,200 March $150,000 $3,500 April $180,000 $3,800 May $150,000 $3,500 June $120,000 $3,200 July $150,000 $3,500 August $180,000 $3,800 Actual November and December 2017 sales were $200,000 and $90,000, respectively....
Create 3 PowerShell Scripts. The first 2 are worth 2 points each. The 3rd one is extra credit, wo...
Create 3 PowerShell Scripts. The first 2 are worth 2 points each. The 3rd one is extra credit, worth 1 point. Script 1: Add/Remove Users Fields: Username, FirstName, LastName, Description, OUPath, Password, Action (Add | Remove) Script 2: Create Security Groups Fields: Name, Description, OUPath, Scope (DomainLocal | Global | Universal), Category (Distribution | Security) Script 3: Modify Security Group Membership Fields: GroupName, Username, Action (Add | Remove)
Apple Case- Segregation of  Duties-Chapter 5 Extra Credit Apple sells all products on 30 day trade credit....
Apple Case- Segregation of  Duties-Chapter 5 Extra Credit Apple sells all products on 30 day trade credit. Ernst & Young CPAs is performing an audit of Apple and is becoming familiar with the department documents of the beverage wholesaler. Ernst & Young CPAs is hoping that they can reduce control risk to a minimum level but only if control activities are found which include segregation of duties and safeguarding of assets. For each numbered item choose which department within the organization...
Choose a stock and gather 5 years of daily adjustedstock price data and download to be...
Choose a stock and gather 5 years of daily adjustedstock price data and download to be opened in Excel. Calculate the mean, median, mode, range and standard deviation of the adjusted daily closing price for this stock. Interpret these statistics and discuss relevance is the mode useful? Produce a histogram for the adjusted daily closing price Produce a time plot (scatter plot) of the closing date versus the stock price. How has the stock trended over time? Are there patterns?...
Week 5 Extra Credit Assignment Collect two sets of data from two different related/similar populations (for...
Week 5 Extra Credit Assignment Collect two sets of data from two different related/similar populations (for example: Male & female). 1) Test a claim about the population mean for one of the sets. 2) Test a claim about the population standard deviation for one of the sets. 3)  Test a claim about both population standard deviations. 4) Test a claim about both population means (for example the mean for the one population equals the mean of the other population). You are...
Aggregate Demand: Draw me an AD graph, start at the equilibrium of Price Level 5 and...
Aggregate Demand: Draw me an AD graph, start at the equilibrium of Price Level 5 and RGDP at 100.Show me what happens when people feel that the economy is “safer” and the spend more. Assume the shift changes Price Level by 2 and RGDP by 20. What effect from class is this and explain the shift.
Aggregate Supply: Draw me a SRAS(AS) graph, start at the equilibrium of Price Level 5 and...
Aggregate Supply: Draw me a SRAS(AS) graph, start at the equilibrium of Price Level 5 and RGDP at 100. Assume there is minimum wage law now in effect. The minimum wage is higher that the wage rate prior. Show me this, assume the shift changes Price Level by 2 and RGDP by 20. Explain the shift.
5.) GRAPH. Qd= 104-2p and a Qs= -24+8p. If the government imposes a fixed price of...
5.) GRAPH. Qd= 104-2p and a Qs= -24+8p. If the government imposes a fixed price of 15 dollars how will this market be affected? Explain. 6.)How has this price imposition of 15 dollars affect the previous consumer surplus? Whom is benefiting from this price imposition? 7.)List the determinants of demand and supply.
URGENT!! 5.From the following, prepare a cost sheet and the price to be quoted. 1.1.2018 31.12.2018...
URGENT!! 5.From the following, prepare a cost sheet and the price to be quoted. 1.1.2018 31.12.2018 Raw materials 20,000 32,000 Work-in-progress 26,500 14,000 Finished Goods 16,000 18,000 Purchases of raw materials 90,000 Carriage inwards 2,000 Direct wages 40,000 Direct expenses 15,000 Works overheads 22,500 Administration overheads 10,000 Selling and distribution overheads 14,000 Sales 2,20,000. The Company wants to Quote the price for the order received from the customer, where the material required is 4000 and labour 3000. Expected profit 25%...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per...
A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Selling price per unit $321 5 Manufacturing costs: 6   Variable per unit produced: 7     Direct materials $141 8     Direct labor $69 9     Variable manufacturing overhead $40 10   Fixed manufacturing overhead per year $127,600 11 Selling and administrative expenses: 12   Variable per unit sold $5 13   Fixed per year $65,000 14 15 Year 1 Year 2 16 Units in beginning inventory 0 17 Units produced during the year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT