This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1 of 4 Worksheet for Chapter 7 BOC Questions 2/4/03 We like to answer the Chapter 7 questions by going through the following model, which also helps students become more familiar with Excel. Note that the data used in this file are the same as for the Chapter 6 BOC questions. following questions, giving numbers if all the required data are available or in general terms if the necessary data are not available. Note that additional data are provided in the chapter BOC model. (a) What is X’s DSO? If the industry average DSO is 30 days, and if X could reduce its accounts receivable to the point where its DSO became 50 without affecting its sales or operating costs, how would this affect: (b) Its free cash flow? (c) Its ROE? (d) Its debt ratio? (e) Its TIE ratio? (f) Its Loan/EBITDA ratio? (g) Its P/E ratio? (h) Its M/B ratio? Balance Sheets 2003 2004 Income Statements 2003 2004 Cash in bank $5 $6 Sales (net of discounts) $90.00 $100.00 Marketable securities $5 $6 Cost of goods sold (COGS) 73.00 76.00 Accounts receivable $10 $12 Admin and credit costs 5.00 6.00 Inventories $25 $26 Deprn and amortization 4.00 5.00 Current assets $45 $50 Operating Income (EBIT) $8.00 $13.00 Net fixed assets $45 $50 Interest expense 3.00 3.00 Total assets $90 $100 Taxable income $5.00 $10.00 Taxes (40%) 2.00 4.00 Accounts payable $35 $36 Net income $3.00 $6.00 Notes payable $9 $8 Dividends $1.00 $2.00 Accrued wages & taxes $5 $6 Additions to R.E. $2.00 $4.00 Current liabilities $49 $50 Long-term debt $25 $30 Total liabilities $74 $80 Common stock $1 $1 Retained earnings $15 $19 Total common equity $16 $20 Total liabilities & equity $90 $100 Days sales outstanding = Receivables/(sales/363) = 43.80 2-b. FCF 30 = Receivables/(sales/365) Receivables = 30(Sales/365) 1. Why are financial ratios used? Name five categories of ratios, and then list several ratios in each category. Would a bank loan officer, a bond analyst, a stock analyst, and a manager be likely to put the same emphasis and interpretation on each ratio? Answer: (1) Liquidity (Current, Quick), (2) Asset Management (Inventory Turnover, DSO), Debt Management (Debt/Total Assets, TIE), (3), Profitability (ROE, Profit Margin), Market Value ((P/E, Market/Book). Different analysts would probably emphasize somewhat different types of ratios. A banker considering a short-term loan would be especially interested in liquidity ratios and the debt/assets ratio to assess the short- term probability of repayment and the firm's liquidating value. Stock and bond analysts would be more interested in the long-term situation, and they would consider all types of ratios, a would managers. The data provided in the financial statements are used to illustrate a number of the following questions....
View Full Document
- Spring '11