Please use excel format with formulas for a great rating. Thank you!

3. Given the following balance sheet, fill in the ratio values for 2013 and discuss how these results compare with both the industry average and prior average performance of Sophie Enterprises. SOPHIE ENTERPRISES CONSOLIDATED BALANCE SHEET, YEARS ENDED DECEMBER 31, 2012 AND 2013 Assets Thousands) 2013 2012 Cash 100 90 Receivables 220 170 Inventories 330 230 Total current assets 650 490 Property, plant, and equipment 1,850 1,650 Depreciation 330 225 Net properties 1,500 1,425 Intangibles 150 150 Total assets 2,300 2,065 LIABILITIES AND SHAREHOLDERS' EQUITY 2013 2012 Accounts payable 85 105 Short-term bank notes 125 110 Current portion of long-term debt 75 Accruals 65 85 Total current liabilities 350 300 Long-term debt 625 540 Deferred taxes 100 Preferred stock (10%, $100 par) 150 150 Common stock ($2 par, 100,000 issued) 200 200 Additional paid-in capital 325 325 Retained earnings 550 470 Common shareholders' equity 10,75 995 Total liabilities and shareholders' equity 2,300 2,065 SOPHIE ENTERPRISES CONSOLIDATED STATEMENT OF INCOME, YEARS ENDED DECEMBER 31, 2012 AND 2013 THOUSANDS) 2013 2012 Net sales $3,500 $2,990 Cost of goods sold 2,135 1,823 Selling, general, and administrative expenses 1,107 974 operating profit 258 193 Net interest expense 62 Income from operations 195 139 Income taxes 66 47 Net income 129 91 Preferred dividends 15 15 Net income available for common shares 114 76 Dividends declared 40