Panther Marine
Ratio Analysis
June 30, 2017, 2016, 2015
Instructions: Calculate each of the below ratios for ONLY THE CURRENT YEAR. FOLLOW the below steps to complete the ratio analysis:
1. Round ALL answers 2 decimal places
2. Must SHOW ratio descriptions (see current ratio for example)
3. MUST use excel formulas and links to IS comparative and BS comparative worksheets within this workbook (see current ratio for example)
4. MUST indicate if current year answer is favorable, unfavorable, or same in realtion to prior year AND industry (see current ratio for example)
5. USE information at bottom of this worksheet to calculate certain ratios
6. If portion of ratio is not available, still use in ratio description and use 0 as part of formula
7. Inventory calculations do NOT include estimated returns inventory
8. USE below ratios and comparative statements to write a memo to Panther Marine management explaining your findings
	6/30/2017		6/30/2016		6/30/2015		INDUSTRY		Prior Year/Industry: Favorable, Unfavorable, Same
Liquidity
Current Ratio	2.01	1	2.10		2.10		2.20		Prior Year - Unfavorable
Current Assets	1,428,076		1,513,761		1,460,080				Industry - Unfavorble
Current Liabilities	709,775		752,362		723,971
Quick Ratio		2	1.41		1.41		1.62
Cash
A/R (Net)
Short Term Investments
Current Liabilities
Accounts Receivable Turnover		3	7.62		7.82		10.00
Net Credit Sales
Beg A/R (Net)
End A/R (Net)
Avg. A/R
Inventory Turnover		4	2.97		3.27		2.50
CGS
Beg. Inventory
Ending Inventory
Avg. Inventory
Profitability
Profit Margin		5	4.34%		-2.26%		3.5%
Net Income
Net Sales
Asset Turnover		6	1.12		1.15		1.02
Net Sales
Beginning Assets
Ending Assets
Average Assets
Return on Assets		7	4.89%		-2.60%		10.50%
Net Income
Avg. Assets
Return on Common Shareholders' Equity		8	36.88%		-19.58%		18.30%
Net Income
Preferred Dividends
Beginning Common Equity
Ending Common Equity
Avg. Common Shareholders' Equity
Earnings per Share (EPS)		9	$ 3.68		$ (1.99)		$ 3.05
Net Income
Preferred Dividends
Weighted Avg. Common Shares Outstanding
Price-Earnings (P/E ) Ratio		10	11.13		(15.54)		12.54
Market Price per Share of Stock
Earnings per Share
Dividends per Share		11	$ 5.00		$ 6.00		$ 2.00
Dividends on Common Stock
Shares of Common Stock Outstanding
Solvency Ratios
Ratio of Fixed Assets to Long-Term Liabilities		12	0.83		0.78		0.80
Fixed Assets (net)
Long-Term Liabilities
	6/30/2017		6/30/2016		6/30/2015
Common Dividends	200,000		250,000		300,000
Weighted Average Common Shares	50,000		50,000		50,000
Market Price per Share	46		41		31