PT 3 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 A COMPUTE WORKING CAPITAL B COMPUTE CURRENT RATIO 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 PT 4 MAKE A RECOMMENDATION TO THE LOAN COMMITTEE AS TO WHETHER THE LOAN SHOULD BE APPROVED. XYZ Company Comparative Income Statement This Year Last Year Sales (all on account) $ 5,250,000 $ 4,160,000 Cost of goods sold 4,200,000 3,300,000 Gross margin 1,050,000 860,000 Selling and administrative expenses 530,000 520,000 Net operating income 520,000 340,000 Interest expense 120,000 100,000 Net income before taxes 400,000 240,000 Income taxes (30%) 120,000 72,000 Net income 280,000 $ 168,000 Other glven data: The inventory at the beginning of last year totaled $640,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 $520,000 2.3 Last Year 168,000 XYZ Company Reconciliation of Retained Earnings This Year Net income S 280,000 $ Dividends paid Preferred stock 48.000 Common stock 22.000 Total dividends paid 120,000 Net Income retained 160,000 Retained earnings, beginning of year 440.000 Retained earnings, end of year 600,000 $ 48,000 36000 84.000 84,000 356,000 440,000 Typical ratios for companies in XYZ's industry Current ratio Acid-test ratio 1.2 Average collection period 31 days Average sale period 60 days Return on assets 9 50% Debt-to-equity ratio 0.65 Times interest earned 5.7 Price earnings ratio 10 PT1 22 GIVEN PAGE PT 3 PT 4 DIRECTIONS GIVEN PAGE 2 ROWS 1 THROUGH 54 XYZ Company Comparative Balance Sheet This Year Last Year $ 320,000 $ Assets 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 2,980,000 4,960,000 $ $ 1,300,000 S 1,200,000 2,500,000 920,000 1,000,000 1,920,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities Bonds payable, 10% Total liabilities Stockholders' equity Preferred stock, 8%. S30 par value Common stock, $40 parvalue Retained earnings Total stockholders equity Total liabilities and stockho ders 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 S State Bank has hired you as a loan officer. You have been given a file containing a loan request from XYZ Company, a manufacurer of farm machinery components. The requested loan is in the amount of $1,000,000 with a term of five years. Financial statements and other pertinent data is given on the tab of this spreadsheet labeled "GIVEN PAGE 2 ROWS 1 THROUGH 54". The president of XYZ admits that the company's performance has been inconsistent over the past several years, yet argues that XYZ has its cost under control and is currently experiencing strong sales growth over the last year. The president says that the jump in the price of the company's common stock from $20 per share last year to $36 per share this year shows investors' confidence in the improving situation at XYZ. The president believes that the $1,000,000, which will be used to purchase modernized equipment, would allow XYZ to strengthen profits in the future