Account Name Value Accounts payable 5800 Accounts receivable 10600 Accumulated depreciation 34000 Cash 17550 Common stock (10,000 shares) 46000 Cost of goods sold 6,750 Depreciation expense 600 Earnings before taxes General admin expense 950 Gross buildings equipment 123000 Gross profits 26,250 Interest expense 4,300 Inventories 7500 Long term debt 56000 Net buildings equipment 89000 Net income Operating income (EBIT) Retained earnings 16150 Sales 33,000 Short term notes payable 700 Taxes 40 8,160 Using the Data above, complete the following on the templates provided Part 1 Complete the Balance Sheet and Income Statement for XYZ Corporation Part 2 Calculate the Ratios for XYZ Corporation Part 3 Complete the Ratio analysis using Cross Sectional Analysis and Trend Analysis XYZ Corporation Balance Sheet As of December 31, 20XX Assets Liabilities and Equity XYZ Corporation Income Statement For the year ending December 31, 20XX Formula Your Answer Ratio Company Year 1 Company Year 2 Industry Average Cross Sectional Analysis ( Difference) Trend Analysis ( Change) Current Ratio 5x 3x 4x Quick Ratio 3x 1 6x 3x Total Asset Turnover 4xx 56x 7x Average Collection Period 130 days 110 days 100 days Inventory Turnover 1 20x 1 41 x 2 2x Fixed Asset Turnover 1 01x 1 20x 1 1x Debt Ratio 30 34 33 Times Interest Earned 4 0x 5 0x 6 0x Return on Common Equity 8 12 10 must show all work Complete the following on the template provided Complete the balance sheet and income statement for XYZ Corporation Calculate the ratios for XYZ Corporation, using the income statement and balance sheet completed above Complete the ratio analysis using cross sectional analysis and trend analysis for Company J, using the market data in the template

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 29, 2024

Account Name Value Accounts payable 5800 Accounts receivable 10600 Accumulated depreciation 34000 Cash 17550 Common stock (10,000 shares) 46000 Cost of goods sold 6,750 Depreciation

Account Name	Value
Account Name	Value
Accounts payable	5800
Accounts receivable	10600
Accumulated depreciation	34000
Cash	17550
Common stock (10,000 shares)	46000
Cost of goods sold	6,750
Depreciation expense	600
Earnings before taxes	?????
General & admin expense	950
Gross buildings & equipment	123000
Gross profits	26,250
Interest expense	4,300
Inventories	7500
Long-term debt	56000
Net buildings & equipment	89000
Net income	?????
Operating income (EBIT)	?????
Retained earnings	16150
Sales	33,000
Short-term notes payable	700
Taxes @40%	8,160


Using the Data above, complete the following on the templates provided:
Part 1: Complete the Balance Sheet and Income Statement for XYZ Corporation
Part 2: Calculate the Ratios for XYZ Corporation
Part 3: Complete the Ratio analysis using Cross-Sectional Analysis and Trend Analysis




XYZ Corporation
Balance Sheet
As of December 31, 20XX

Assets










Liabilities and Equity














XYZ Corporation
Income Statement
For the year ending December 31, 20XX















Formula	Your Answer



















Ratio	Company Year 1	Company Year 2	Industry Average	Cross Sectional Analysis (% Difference)	Trend Analysis (% Change)
Current Ratio	5x	3x	4x
Quick Ratio	3x	1.6x	3x
Total Asset Turnover	.4xx	.56x	.7x
Average Collection Period	130 days	110 days	100 days
Inventory Turnover	1.20x	1.41 x	2.2x
Fixed Asset Turnover	1.01x	1.20x	1.1x
Debt Ratio	30%	34%	33%
Times Interest Earned	4.0x	5.0x	6.0x
Return on Common Equity	8%	12%	10%

must show all work... Complete the following on the template provided: Complete the balance sheet and income statement for XYZ Corporation. Calculate the ratios for XYZ Corporation, using the income statement and balance sheet completed above. Complete the ratio analysis using cross-sectional analysis and trend analysis for Company J, using the market data in the template.