Other given data: The inventory at the beginning of last year totaled S640,000 Total assets at the beginning of last year were $4,320,000 Stockholders' equity at the beginning of last year was $3,016,000. There has been no change in preferred or common stock over the last two years Accounts receivable at the beginning of last year totaled S$20,000 XYZ Company Comparative Income Statement This Year Sales (all on account) 5.250,000 Cost of goods sold 4.200,000 Gross margin 1,050,000 Selling and administrative expenses 530,000 Net operating income 520,000 Interest expense 120,000 Net income before taxes 400,000 Income taxes (30%) 120,000 Net income 280,000 XYZ Company Reconciliation of Retained Earnings Last Year 4.160,000 3.300,000 860,000 $20,000 340,000 100,000 240,000 22.000 168,000 Typical ratios for companies in XYZ's industry This Year 280,000 Last Year 168,000 Net income Dividends paid: Preferred stock Common stock Total dividends paid Net income retained Retained earnings, beginning of year Retained earnings, end of year 48,000 72.000 120.000 160,000 440.000 600,000 43,000 36.000 84,000 84,000 356.000 440,000 Current ratio Acid-test ratio Average collection period Average sale period Return on assets Debt-to-equity ratio Times interest eamed Price-camins ratio 31 days 60 days 9.50% 0.65 5.7 10 XYZ Company Comparative Balance Sheet This Year Last Year Assets 320,000 Current assets Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and equipment, net Total assets 900,000 1,300,000 80.000 2,600,000 3.100.000 5.700,000 420,000 100,000 600,000 800.000 60.000 1.980,000 2980.000 4.960.000 1,300,000 1.200,000 2.500,000 920,000 1,000,000 1.920,000 Liabilities and Stockholders' Equity abilities: Current liabilities Bonds payable, 10% Total liabilities Stockholders' equity Preferred stock, 8%, $30 par value Common stock, S40 parvalue Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 600,000 2,000,000 600.000 3.200,000 5.700,000 600,000 2.000.000 440,000 3.040,000 4.960,000 PT 1 BEGIN BY ASSESSING THE RATE OF RETURN THAT THE COMPANY IS GENERATING BY A COMPUTING THE RETURN ON TOTAL ASSETS FOR BOTH THIS YEAR AND LAST YEAR B COMPUTING THE RETURN ON COMMON STOCKHOLDERS' EQUITY FOR BOTH THIS YEAR AND LAST YEAR C DETERMINING IF XYZ'S FINANCIAL LEVERAGE IS POSITIVE OR NEGATIVE. EXPLAIN YOUR ANSWER ASSESS THE WELL-BEING OF THE COMMON STOCKHOLDERS FOR BOTH THIS YEAR AND LAST YEAR COMPUTE THE EARNINGS PER SHARE B COMPUTE THE DIVIDEND YIELD RATIO FOR COMMON STOCK C COMPUTE THE DIVIDEND PAYOUT RATIO FOR COMMON STOCK D COMPUTE THE PRICE-EARNINGS RATIO E COMPUTE THE BOOK VALUE PER SHARE OF COMMON STOCK COMPUTE THE GROSS MARGIN PERCENTAGE G HOW DO INVESTORS REGARD XYZ COMPANY AS COMPARED TO OTHER COMPANIES IN THE INDUSTRY? H WHAT DOES THE DIFFERENCE BETWEEN MARKET VALUE PER SHARE AND BOOK VALUE PER SHARE SUGGEST? ASSESS CREDITOR RATIOS IN ORDER TO DETERMINE DEBT PAYING ABILITY FOR BOTH THIS YEAR AND LAST YEAR COMPUTE WORKING CAPITAL B COMPUTE CURRENT RATIO C COMPUTE ACID-TEST RATIO D COMPUTE THE AVERAGE COLLECTION PERIOD E COMPUTE THE AVERAGE SALE PERIOD F COMPUTE THE DEBT-TO-EQUITY RATIO G COMPUTE THE TIMES INTEREST EARNED MAKE A RECOMMENDATION TO THE LOAN COMMITTEE AS TO WHETHER THE LOAN SHOULD BE APPROVED MAKE A DE PT3 PT 4
