E COMPUTE THE BOOK VALUE PER SHARE OF COMMON STOCK F COMPUTE THE GROSS MARGIN PERCENTAGE GHOW 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 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 -4 MAKE A RECOMMENDATION TO THE LOAN COMMITTEE AS TO WHETHER THE LOAN SHOULD BE APPROVED. 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. 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 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 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%, $30 par value Common stock, $40 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