Question

Calculate the ratios for year 2 that are listed below:

COMPANY XYZ

Income Sheet

Year 1		Year 2
Sales (all on credit)	$1,400,000		$1,375,000
Cost of Goods sold	850,000		900,000
Gross profit	$550,000		$475,000
Selling and administrative expense*	240,000		230,000
Operating profit (EBIT)	$310,000		245,000
Interest expense	40,000		37,000
Net income before taxes	$270,000		208,000
Taxes	81,000		62,400
Net income	$189,000		145,600
Shares	30,000		30,001
Earnings per share	$6.30		$4.85
*Includes $15,000 in lease payments for each year.

COMPANY XYZ

Balance Sheet Assets	Year 1	Year 2
Cash	$50,000	$55,000
Marketable securities	20,000	20,000
Accounts receivable	150,000	150,000
Inventory	200,000	210,000
Total current assets	$420,000	435,000
Net plant and equipment	650,000	650,000
Total assets	$1,070,000	$1,085,000
Liabilities and Stockholders’ Equity
Accounts payable	$175,000	190,000
Accrued expenses	25,000	25,000
Total current liabilities	$200,000	215,000
Long-term liabilities	310,000	310,000
Total liabilities	$510,000	525,000
Common stock ($2 par)	60,000	60,000
Capital paid in excess of par	190,000	190,000
Retained earnings	310,000	310,000
Total stockholders’ equity	$560,000	560,000
Total liabilities and stockholders’ equity	$1,070,000	$1,085,000

Create your response to this:

Ratio Description	Ratio	Formula - showing numbers (labels) 435,000 (Current Assets)/215,000 (Current Liabilities)
Current Ratio
Quick Ratio (Acid Test Ratio)
Days Sales Outstanding (Average Collection Period)
Inventory Turnover
Fixed Asset Turnover
Total Asset Turnover
Debt Ratio
Times Interest Earned
Gross Profit Margin
Net Profit Margin
Return on Assets
Return on Equity

Answer 1

Ratio Description	Ratio	Formula - showing numbers (labels)				rounded to two decimal
Current Ratio	2.0	435,000 (Current Assets)/215,000 (Current Liabilities)				2.02
Quick Ratio (Acid Test Ratio)	1.0	225000(Current Assets-Inventory)/215,000 (Current Liabilities)				1.05
Days Sales Outstanding (Average Collection Period)	39.8	Avg Acc rec 150000/Sales 1375000*365				39.82
Inventory Turnover	4.4	900000 COGS/Avg inventory (200000+210000)/2				4.39
Fixed Asset Turnover	2.1	1375000 Sales/Avg fixed assets (650000+650000)/2				2.12
Total Asset Turnover	1.3	1375000 Sales/Avg xassets (1070000+1085000)/2				1.28
Debt Ratio	0.5	525000 Total liabilities/1085000 total assets				0.48
Times Interest Earned	6.6	245000 Operating profit/37000 Interest expenses				6.62
Gross Profit Margin	34.5	475000 Gross profit/1375000 sales				34.55
Net Profit Margin	10.6	145600 net Income/1375000 sales				10.59
Return on Assets	78.4	Avg assets (1070000+1085000)/2/1375000 Sales*100				78.36
Return on Equity	40.7	Avg equity 560000/sales 1375000*100				40.73
If any doubt please comment