Create your response as an Excel spreadsheet (in the following format)

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

Sales (all on credit) Cost of Goods sold Gross profit Selling and administrative expense* Operating profit (EBIT) Interest expense Net income before taxes Taxes Net income Shares Earnings per share *Includes $15,000 in lease payments for each year. Assets Cash Marketable securities Accounts receivable Inventory Total current assets Net plant and equipment Total assets Liabilities and Stockholders' Equity Accounts payable Accrued expenses Total current liabilities COMPANY XYZ Income Sheet Long-term liabilities Total liabilities Common stock ($2 par) Capital paid in excess of par Retained earnings Total stockholders' equity Total liabilities and stockholders' equity Year 1 $1,400,000 850,000 $550,000 240,000 $310,000 40.000 $270,000 81.000 $189,000 30,000 $6.30 COMPANY XYZ Balance Sheet Year 1 $50,000 20,000 150,000 200,000 $420,000 650,000 $1,070,000 $175,000 25,000 $200,000 310,000 $510,000 60,000 190,000 310,000 $560,000 $1,070,000 Year 2 $1,375,000 900,000 $475,000 230,000 245,000 37.000 208,000 62.400 145,600 30,001 $4.85 Year 2 $55,000 20,000 150,000 210,000 435,000 650,000 $1,085,000 190,000 25.000 215,000 310,000 525,000 60,000 190,000 310,000 560,000 $1,085,000