In: Finance
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow.
|
Qa:
Current assets/Current liabilities =2,925,000/1,220,000=2.397
Days sales outstanding (365-day year)= 365* Accounts receivable/sales =365*1575000/7,500,000 =76.65
COGS/Inventory =6,375,000/1125000 =5.67
Sales/Fixed assets =7,500,000 /1,325,000 =5.66
Sales/Total assets= 7,500,000 /4,250,000=1.765
Net income/Sales= 109,500/ 7,500,000= 1.46%
Net income/Total assets =109,500/4,250,000 =2.576%
Net income/Common equity= 109,500/2,630,000 =4.16%
Total debt/Total assets = (400000+600000+100000)/4,250,000 =25.88%
Total LIABILITIES/Total assets=(400000+600000+100000+520000)/4,250,000 =38.11%
Qb:
ROE of firm=net income/equity =109,500/2,630,000 =4.16%
ROE of industry; Use dupont analysis to calculate
ROE industry=(net income/sales)*(sales/total asset)*(asset/equity) ----- all of industry standards
Asset/equity= [1/(net income/total asset)]*(net income/equity) ----- since the value is not given directly
ROE=1.2%*3* [ (1/3.6)*9] =9%
Qc:
The firm's days sales outstanding is more than twice as long as the industry average, indicating that the firm should -Select-tighten credit or enforce a -Select-more stringent collection policy.
The total assets turnover ratio is well -Select-below the industry average so sales should be -Select-increased , assets -Select-decreased ,or both
While the company's profit margin is -Select-higher than the industry average, its other profitability ratios are -Select-low compared to the industry - net income should be -Select-higher given the amount of equity and assets.