90.2K

Verified Solution

Link Copied!

Please recall the company that you selected for the Module 1 SLP. Please review the companys dividends over the past three years. Then, answer the following questions in Word (except for the Excel portion specifically noted):

What has occurred with companys dividend payout, dividend yield, and dividend per share over the past three years? Do you have any explanations for what has occurred?

How does your selected companys dividend payout, dividend yield, and dividend per share compare to other companies in its industry? Has the companys dividend strategy been similar to other companies in its industry?

You are now to use Excel and plot your selected companys earnings and dividends over the past three years. Do you notice any patterns?

What is your estimate for your companys dividend per share next year? Please justify why you made that decision. Now locate a company that has reduced or eliminated its common stock cash dividend over the past year. Why did the company reduce or eliminate its dividend? What has happened to the companys stock price over the year?

Below is the info I have done on nike can you help me with the questions above according to the info I have gathered on nike inc. please? The research is below.

	Nike Liquidity ratios
year	2015	2014	2013
current assest	15,976,000	13,696,000	13,626,000		current asset/ current liability = current ratio
current liabilities	6,334,000	5,027,000	3,926,000
current ratio	2.52	2.72	3.47
	Nike quick ratio
year	2015	2014	2013
cash and equivalent	3,852,000	2,220,000	3,337,000
short-term investment	2,072,000	2,922,000	2,628,000		cash and equialent + short-term investment + accounts receivable/ current liabilities = quick ratio
accounts receivable	3,358,000	3,434,000	3,117,000
total quick assests	9,282,000	8,576,000	9,082,000
current liabilities	6,334,000	5,027,000	3,926,000
quick ratio	1.47	1.71	2.31
	asset management ratio
	inventory turnover
year	2015	2014	2013
cost of sales	16,534,000	15,353,000	14,279,000		cost of sales/inventory = inventory turnover
inventory	4,337,000	3,947,000	3,434,000
inventory turnover	3.81	3.89	4.16
	total assets turnover
year	2015	2014	2013
Revenue	30,601,000	27,799,000	25,313,000		revenue/total assets = total asset turnover
total assets	21,600,000	18,594,000	17,584,000
total asset	1.42	1.5	1.44
	fixed asset turnover
year	2015	2014	2013
revenues	30,601,000	27,799,000	25,313,000		revenues/property, plant, and equipment = fixed asset turnover
property, plant and equipment	3,011,000	2,834,000	2,452.00
fixed asset turnover	10.16	9.81	10.32
	days sales outstanding
year	2015	2014	2013
accounts receivable	3,358,000	3,434,000	3,117,000		accounts receivable/revenue X days in period = days sales outstanding
revenue	30,601,000	27,799,000	25,313,000
days sales outstanding	40.05	43.98	43.84
	dept management ratios
	EBITDA coverage
year	2015	2014	2013
					net income + tax expense + intrest expense +deprciation + amortization = EBITDA
net income	3,273,000	2,693,000	2,472,000		principal repayment + intrest expence + lease payment = EBIT
income tax expense	932,000	851,000	805,000		EBITDA + lease/interest payment + principal repayment + lease = EBITDA ratio
interest expense	0	0	0
lease payment	0	0	0
principle repayment on dept	1,079,000	1,199,000	1,210,000
depreciation	649,000	586,000	502,000
amortization	0	0	0
total EBITDA	4,854,000	4,130,000	3,779,000
EBITDA coverage ratio	2.81	2.31	2.21
	times interest earned
	nike has no interest expense
	total debt to total assets
year	2015	2014	2013
long-term debt	1,079,000	1,199,000	1,210,000		long-term-dept/total assets = total dept to total assets ratio
total assets	21,600,000	18,594,000	17,584,000
Total debt to total assets ratio	0.05	0.06	0.07
	Profitability ratio
	return on common equity
year	2015	2014	2013	2012
net income	3,273,000	2,693,000	2,472,000	2,223,000	total assets - total liabilities = total equity
total assets	21,600,000	18,594,000	17,584,000	15,465,000
total liability	8,893,000	7,770,000	6,428,000	5,084,000	(total equity of prior year + total equity of current year)/ 2 = average total equity
total equity	12707000	10824000	11156000	10381000	net income/ average total equity = return on equity ratio
average equity	11,756,500	10,990,000	10,768,000
return on equity ratio	27.82%	24.50%	22.96%
	return on total assets
year	2015	2014	2013	2012
net income	3,273,000	2,693,000	2,472,000	2,223,000	total assets of current year + total assets of prior year/2 = average total assets
total assets	21,600,000	18,594,000	17,584,000	15,465,000
					net income/ average total assets = return on assets ratio
average total assets	20,097,000	18,089,000	16,524,000
return on asset ratio	16.29%	14.89%	14.96%
	basic earning power
year	2015	2014	2013
net income	3,273,000	2,693,000	2,485,000		(net income - perferred dividends)/total shares outstanding = basic earning power
perferred dividends	0	0	0
total shares outstanding	1,714,000	1,767,000	1,795,000
basic earning power	1.9	1.52	1.38
	Profit margin on sales
year	2015	2014	2013
total revenue	30,601,000	27,799,000	25,313,000		(revenue - cost of goods sold)/ revenue = gross margin
cost of goods sold	16,534,000	15,353,000	14,279,000
gross Profit	14067000	12446000	11034000
Profit margin	45.97	44.77	43.59
	Market value ratio
	market/book
year	2015	2014	2013
total equity	12,707,000	10,824,000	11,154,000		(total equity - Peferred stock)/ shares outstanding = market/book ratio
perfered stock	0	0	0
shares outstanding	1,714,000	1,767,000	1,795,000
market/book ratio	7.41	6.13	6.21
	price/earning ratio
year	2015	2014	2013
share price	$57.00	$38.86	$31.60		share price/ earning per share = price/earning ratio
earnings per share	$1.91	$1.55	$1.40
price/earning ratio	$29.84	$25.07	$22.57
	Price/cash flow
year	2015	2014	2013
					share price/free cash flow per share = price/cash flow ratio
share price	57.00	38.86	31.60
free cash flow per share	2.10	1.17	1.10
price/cash flow ratio	27.14	33.21	31.60

Answer & Explanation Solved by verified expert

See Answer