analysis of the financial health

User Generated

13yxzz_

Business Finance

Description

For companies Target and Costco. Find the following information.
Assets
a. Record the following weekly market activity for the company’s stock for the previous year (any day such as Friday, Monday etc.). Make sure to record:
i. Closing price
ii. One source:search online for yahoo finance, click on quotes & info, type in your company name – follow instructions on web page, click on search, click on historical data, click on daily – change to weekly, click on apply, get close price.
iii. Analyze, evaluate, and discuss the information
b. List the total of Property, Plant, and Equipment
i. List the total of all assets and total of current assets.
ii. Identify the method or methods used by your company to value the inventories.
1. List the total dollar value of the inventory.
2. Compute the percentage of inventories to total assets.
c. List the Cost of Goods Sold and the Gross Profit.
i. Calculate the percentage of Cost of Goods Sold to Net Sales and the percentage of Gross Profit to Net Sales.
d. Analyze/assess/discuss your findings

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: TARGET AND COSTCO

1

Target and Costco
Name
Institution
Date

TARGET AND COSTCO

2

The Costco and Target stock returns can be obtained from the stock prices for the
previous year and presented as below;

Close prices-Costco
260
240
220
200
180
Close

160
140
120
100

Average Standard
deviation

Maximum Minimum

$205.88

$241.46

$19.07

$171.62

During the past year, the Costco stock prices averaged at $205.88 with a standard
deviation of $19.02. The stock prices increased by 33% from as low as $171.62 on 11/20/2017 to

TARGET AND COSTCO

3

$228.74 at the end of one-year period. The maximum stock price during this period was $241.46
recorded on 9/3/2018 while the lowest price was $171.62 recorded at 11/20/2017. The company
stock prices showed a steady increase from 3/19/2018 to 9/3/2018.
Returns
Average Standard Maximum Minimum
deviation
0.59%
2.85%
7.87%
-6.84%
Observably, during this period, the Costco stock recorded an annual return average return
if 0.59% and a standard deviation of 2.85%. The highest daily return was 7.87% while the lowest
return was -6.84%.
Target stock prices

Close prices - Target
100
90
80
70
Close

60
50
40

Average

Standard Maximum Minimum
deviation
$ 75.91 $
7.81 $ 88.74
$ 55.88
Target corporation stock recorded an average price of $75.91 and a standard deviation of
$7.81 during the past year. Additionally, the maximum stock price was $88.74 recorded on

TARGET AND COSTCO

4

9/3/2018 while the lowest stock price was $55.88 recorded at the beginning of the one-year
period. The value of the company stock grew by 39% during the period under review.
Stock returns
Average Standard
Maximum Minimum
deviation
0.70%
3.88%
15.40%
-8.35%
Target corporation recorded an annual average return of 0.70% and a standard deviation
of 3.88%. The daily stock return was highest at 15.40% and lowest at -8.35%.

The companies’ Property, plant and equipment for the financial year ...


Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags