Complete the following on the template provided:

1. Complete the balance sheet and income statement for XYZ Corporation.
2. Calculate the ratios for XYZ Corporation, using the income statement and balance sheet completed above.
3. Completetheratioanalysisusingcross-sectionalanalysisandtrendanalysisforCompanyJ,usingthemarketdatainthetemplate.

You are given the following information about XYZ Corporation: Account Name Accounts payable Value 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 Taxes @40% 700 8,160 Required: 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 Use this Templates for Part 1: XYZ Corporation Balance Sheet As of December 31, 20XX Assets Current Assts Total Current Assets Total Assets Liabilities and Equity Liabilities Total Current Liabilities Total Liabilities Equity Total Equity Total Liabilities and Equity XYZ Corporation Income Statement For the year ending December 31, 20XX Sales Net Income Use the Template below for Part Two: Ratio Formula Your Answer Operating Profit Margin After Taxes Gross Profit Margin Average Collection Period Total Asset Turnover Fixed Asset Turnover Inventory Turnover Debt to Total Assets Times Interest Earned Use this template for Part 3: Ratio Current Ratio Quick Ratio Total Asset Turnover Average Collection Period Inventory Turnover Fixed Asset Turnover Debt Ratio Times Interest Earned Return on Common Equity Summarize Your Findings Below: Company Year 1 5x 3x .4xx 130 days 1.20x 1.01x 30% 4.0x 8% Cross Sectional Analysis Trend Company Industry (% Analysis Year 2 Average Difference) (% Change) 3x 4x 1.6x 3x .56x .7x 110 days 100 days 1.41 x 2.2x 1.20x 1.1x 34% 33% 5.0x 6.0x 12% 10%