
Comprehensive Ratio Analysis
Data for Lozano Chip Company and its industry averages follow.
Lozano Chip Company: (Thousands of Dollars) |
||||
Cash | $ 215,000 | Accounts payable | $ 600,000 | |
Receivables | 1,575,000 | Notes payable | 100,000 | |
Inventories | 1,120,000 | Other current liabilities | 520,000 | |
Total current assets | $2,910,000 | Total current liabilities | $1,220,000 | |
Net fixed assets | 1,350,000 | Long-term debt | 400,000 | |
Common equity | 2,640,000 | |||
Total assets | $4,260,000 | Total liabilities and equity | $4,260,000 |
Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) |
|
Sales | $7,500,000 |
Cost of goods sold | 6,375,000 |
Selling, general, and administrative expenses | 919,000 |
Earnings before interest and taxes (EBIT) | $ 206,000 |
Interest expense | 40,000 |
Earnings before taxes (EBT) | $ 166,000 |
Federal and state income taxes (25%) | 41,500 |
Net income | $ 124,500 |
- Calculate the indicated ratios for Lozano. Do not round intermediate calculations. Round your answers to two decimal places.
Ratio Lozano Industry Average Current assets/Current liabilities 2.0 Days sales outstanding (365-day year) days 35.0 days COGS/Inventory 6.7 Sales/Fixed assets 12.1 Sales/Total assets 3.0 Net income/Sales % 1.2 % Net income/Total assets % 3.6 % Net income/Common equity % 9.0 % Total debt/Total assets % 10.0 % Total liabilities/Total assets % 60.0 % - Use the extended DuPont equation to calculate ROE for both Lozano and the industry. Do not round intermediate calculations. Round your answers to two decimal places.
For the firm, ROE is %.
For the industry, ROE is %.
-
Outline Lozano's strengths and weaknesses as revealed by your analysis.
The firm's days sales outstanding is more than twice as long as the industry average, indicating that the firm should credit or enforce a stringent collection policy.
The total assets turnover ratio is well the industry average so sales should be , assets , or both.
While the company's profit margin is than the industry average, its other profitability ratios are compared to the industry - net income should be given the amount of equity and assets.

Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images

- Complete the balance sheet and sales information using the following financial data: Balance sheet Cash ________ Current liabilities _________ Accounts Receivable ________ Long-term debt 120,000 Inventories ________ Common stock _________ Total assets $600,000 Retained earnings 195,000 Total liabilities and equity _________ Sales ________ Cost of good sold ____40%sales__ Current ratio: 2.o X…arrow_forwardWhich of the following statements is TRUE about Verizon's financial statements? verizon Consolidated Balance Sheets (In millions of dollars) As of As of Dec 31, 2020 $ 22,171 Dec 31, 2019 $ 2,594 ASSETS Cash and cash equivalents Accounts receivable 23,917 25,429 Inventories 1,796 1,422 Prepaid expenses and other current assets 6,710 8,028 Total current assets 54,594 37,473 Property and equipment, net Intangible assets Other long-term assets 94,833 91,915 152,814 151,640 10,699 $ 291,727 14,240 Total assets $ 316,481 LIABILITIES & EQUITY Debt maturing within one year $ 5,889 $ 10,777 Accounts payable and accrued liabilities 20,658 21,806 Other current liabilities 13,113 12,285 Total current liabilities 39,660 44,868 Long-term debt 123,173 100,712 Other long-term liabilities 84,376 83,312 Total liabilities 247,209 228,892 Common stock and additional paid in capital 13,833 13,858 Retained earnings 60,464 53,147 Accumulated other comprehensive income (5,025) (4,170) Total shareholders'…arrow_forwardN1. Account Calculate the following ratios for Lake of Egypt Marina, Inc. as of year-end 2021. (Use sales when computing the inventory turnover and use total stockholders' equity when computing the equity multiplier. Round your answers to 2 decimal places. Use 365 days a year.)arrow_forward
- Ratio Analysis Presented below are summary financial data from Pompeo’s annual report: Amounts in millions Balance sheet Cash and cash equivalents $2,712 Marketable securities 27,128 Accounts receivable (net) 14,051 Total current assets 58,632 Total assets 184,617 Current liabilities 66,017 Long-term debt 12,738 Shareholders’ equity 119,487 Income Statement Interest expense 539 Net income before taxes 24,512 Calculate the following ratios: (round to two decimal places) a. Times-interest-earned ratio b. Quick ratio c. Current ratioarrow_forwardThe Davidson Corporation's balance sheet and income statement are provided here. Davidson Corporation: Balance Sheet as of December 31, 2018 (Millions of Dollars) Assets Liabilities and Equity Cash and equivalents $ 15 Accounts payable $ 100 Accounts receivable 515 Accruals 220 Inventories 830 Notes payable 230 Total current assets $ 1,360 Total current liabilities $ 550 Net plant and equipment 2,550 Long-term bonds 1,500 Total liabilities $ 2,050 Common stock (100 million shares) 260 Retained earnings $ 1,600 Common equity $ 1,860 Total assets $ 3,910 Total liabilities and equity $ 3,910 Davidson Corporation: Income Statement for Year Ending December 31, 2018 (Millions of Dollars) Sales $ 6,000 Operating costs excluding depreciation and amortization 3,780 EBITDA $ 2,220 Depreciation and amortization 420 EBIT $ 1,800 Interest 164 EBT $ 1,636 Taxes…arrow_forwardRefine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…arrow_forward
- How do I solve this?arrow_forwardBased on the financial statements provided, compute the following financial ratios. Show your workings and round your figures to 2 decimal places. Ratio 2020 2019 Current Ratio Quick Ratio Debt Ratio (%)arrow_forwardSuppose the 2022 financial statements of 3M Company report net sales of $23.1 billion. Accounts receivable (net) are $3.2 billion at the beginning of the year and $3.25 billion at the end of the year. Compute 3M’s accounts receivable turnover. - Accounts Recievable turnover ratio=? (times) Compute 3M’s average collection period for accounts receivable in days - Average collection period =? (days)arrow_forward
- The following items are reported on a company's balance sheet: Cash $112,300 Marketable securities 131,400 Accounts receivable (net) 45,200 Inventory 170,000 Accounts payable 270,000. Determine the current ratio ?arrow_forwardSelected financial data for Wilmington Corporation is presented below. WILMINGTON CORPORATION Balance Sheet As of December 31 Year 7 Year 6 Current Assets Cash and cash equivalents $ 634,527 $ 335,597 Marketable securities 166,106 187,064 Accounts receivable (net) 284,226 318,010 Inventories 466,942 430,249 Prepaid expenses 60,906 28,060 Other current assets 83,053 85,029 Total Current Assets 1,695,760 1,384,009 Property, plant and equipment 1,384,217 625,421 Long-term investment 568,003 425,000 Total Assets $3,647,980 $2,434,430 Current Liabilities Short-term borrowings $ 306,376 $ 170,419 Current portion of long-term debt 155,000 168,000 Accounts payable 279,522 314,883 Accrued liabilities 301,024 183,681 Income taxes payable 107,509 196,802 Total Current Liabilities 1,149,431…arrow_forwardSome recent financial statements for Smolira Golf Corporation follow. Assets Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment Total assets Sales Cost of goods sold Depreciation Taxable income Taxes (22%) Earnings before interest and taxes Interest paid Net income Dividends Retained earnings 2020 $35,585 $38,940 28,846 43,112 18,401 3,970 SMOLIRA GOLF CORPORATION 2021 Income Statement a. Price-earnings ratio b. Dividends per share c. Market-to-book ratio d. PEG ratio SMOLIRA GOLF CORPORATION 2020 and 2021 Balance Sheets 2021 Liabilities and Owners' Equity Current liabilities $57,956 $110,898 $ 465,585 $ 27,000 37,022 Accounts payable Notes payable Other $ 521,433 Total $ 523,541 $ 632,331 Total liabilities and owners' equity Long-term debt times Owners' equity Common stock and paid-in surplus Accumulated retained earnings times times Total $ 512,454 363,528 45,963 $102,963 20,883 $ 82,080 18,058 $ 64,022 Smolira Golf Corporation has 52,000…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





