Current Assts
Accounts Receivables 10600
Cash 17550
Inventories 7500
Total Current Assets 35650
Gross buildings & equipment 123000
Less: Accumulated depreciation -34000
Net buildings & equipment 89000
Total Assets 178000
Liabilities and Equity
Liabilities
Accounts payable 5800
General & admin expense 950
Total Current Liabilities 6750
Long-term debt 56000
Total Liabilities 69500
Equity
Common Stock 46000
Retained earnings 16150
Total Equity 62150
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 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%
Summarize Your Findings Below
