Trend AnalysisCritelli Company has provided the following comparative information:Year 5Year 4Year 3Year 2Year 1Net income$1,352,800$1,166,200$980,000$837,600$709,800Interest expense460,000419,800362,600276,400220,000Income tax expense432,896326,536274,400217,776170,352Average total assets9,960,4408,811,1117,542,6976,439,3065,501,775Average stockholders' equity3,340,2473,013,4372,655,8272,372,8052,093,805You have been asked to evaluate the historical performance of the company over the last five years.Selected industry ratios have remained relatively steady at the following levels for the last five years:Industry RatiosReturn on total assets17.9 %Return on stockholders' equity37.3 %Times interest earned4.6 Instructions:Calculate three ratios for Year 1 through Year 5. Round to one decimal place.a. Return on total assets:Year 5%Year 4%Year 3%Year 2%Year 10000

Introduction Ratio analysis: Financial ratios are mathematical comparisons of financial statement…

Answered: Trend Analysis Critelli Company has…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

f
Long-Term Solvency Ratios Summary data from year-end financial statements of Palm Springs Company for the current year follow. Summary Income Statement Data Sales $10, 500, 600 Cost of goods sold 6, 050,000 Selling expenses 685,000 Administrative expenses 945,000 Interest expense 783, 500 Income tax expense 427,791 8,891,291 Net income $1,609,309 Summary Balance Sheet Data Cash $84, 700 Total liabilities $749,700 Noncash assets 885,500 Stockholders' equity 220, 500 Total assets $970, 200 Total liabilities and equity $970, 200 Round answers to one decimal place. a. Compute the ratio of times - interest - earned. Answer times b. Compute the debt-to-equity ratio. Answer
Vertical analysis The following income statement data for AT&T Inc. and Verizon Communications Inc. were taken from their recent annual reports (in millions): AT&T Verizon Revenues $132,447 $127,079 Cost of services (expense) 60,611 49,931 Selling and marketing expense 39,697 41,016 Depreciation and other expenses 20,393 16,533 Operating income $ 11,746 $ 19,599 Required: a. Prepare a vertical analysis of the income statement for AT&T. Round to one decimal place. AT&T Income Statement Amount Percent Revenues Cost of services (expense) Selling and marketing expense Depreciation and other expenses Operating income b. Prepare a vertical analysis of the income statement for Verizon. Round to one decimal place. Verizon Income Statement Amount Percent Revenues Cost of services (expense) Selling and marketing expense Depreciation and other expenses Operating…
Current Position Analysis The following data were taken from the balance sheet of Albertini Company at the end of two recent fiscal years: Current Year Previous Year Current assets: Cash $486,400 $392,000 Marketable securities 563,200 441,000 Accounts and notes receivable (net) 230,400 147,000 Inventories 792,000 469,700 Prepaid expenses 408,000 300,300 Total current assets $2,480,000 $1,750,000 Current liabilities: Accounts and notes payable (short-term) $464,000 $490,000 Accrued liabilities 336,000 210,000 Total current liabilities $800,000 $700,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place. Current Year Previous Year 1. Working capital $fill in the blank 1 $fill in the blank 2 2. Current ratio fill in the blank 3 fill in the blank 4…
Ratios Analyzing Firm Profitability The following information is available for Buhler Company: Annual Data 2013 2012 Net sales $10,200,000 $9,600,000 Gross profit on sales 3,053,000 2,736,000 Net income 567,600 488,000 Year-End Data Dec. 31, 2013 Dec. 31, 2012 Total assets $8,100,000 $7,700,000 Stockholders' equity 3,800,000 3,200,000 Calculate the following ratios for 2013: Note: Round answers to one decimal place, unless otherwise noted.a. Gross profit percentage Answer % b. Return on sales Answer % c. Asset turnover (Round answer to two decimal places.)Answer d. Return on assets Answer % e. Return on common stockholders' equity (Buhler Company has no preferred stock.) Answer %
g. operating profit margin h. long -term debt ratio i. total debt ratio
Trend Analysis Critelli Company has provided the following comparative information: Year 5 Year 4 Year 3 Year 2 Year 1 Net income $940,300 $810,600 $681,200 $582,200 $493,400 Interest expense 319,700 291,800 252,000 192,100 153,000 Income tax expense 300,896 226,968 190,736 151,372 118,416 Average total assets 5,779,817 5,103,704 4,360,748 3,704,785 3,153,171 Average stockholders' equity 1,975,420 1,769,869 1,548,182 1,373,113 1,203,415 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: Industry Ratios Return on total assets 21.5 % Return on stockholders’ equity 44.4 % Times interest earned 4.6 Instructions: Calculate three ratios for Year 1 through Year 5. Round to one decimal place. a. Return on total assets: Year 5…
Horizontal Analysis of Income StatementFor 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensedcomparative income statement:Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y120Y2 20Y1Sales $910,000 $700,000Cost of goods sold 441,000 350,000Gross profit $469,000 $350,000Selling expenses $139,150 $115,000Administrative expenses 99,450 85,000Total operating expenses $238,600 $200,000Income from operations $230,400 $150,000Other income 65,000 50,000Income before income tax $295,400 $200,000Income tax expense 65,000 50,000Net income $230,400 $150,000Required:1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round to one decimal place. Use theminus sign to indicate a decrease in the "Difference" columns.Macklin Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2…
A company's year-end selected financial data is shown below. Year 2 Year 1 Current assets $250,000 $175,000 Total assets 600,000 500,000 Total liabilities 300,000 225,000 Net sales 200,000 150,000 Net income 75,000 60,000 The company's rate of return on assets and rate of return on equity for Year 2 are: a. 12% and 22%, respectively. Ob. 13% and 25%, respectively. Oc. 14% and 26%, respectively. Od. 36% and 25%, respectively.
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Υ8 20Y7 20Υ6 20Y5 20Υ4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders' equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady at the following levels for the last five years: 20Υ4-2ΟY8 Return on total assets 28% Return on stockholders' equity 18% Times interest earned 2.7 Ratio of liabilities to stockholders' equity 0.4 Required: 1.…
Comon size percentage
VERTICAL ANALYSIS Give the analysis per line item. Sabina Electronics Comparative Income Statement This year Last year This year 5,000,000 3,875,000 1,125,000 653,000 472,000 72,000 400,000 120,000 280,000 110,000 Last year 4,350,000 3,450,000 900,000 548,000 352,000 72,000 280,000 84,000 196,000 95,000 Sales 100% 100% Cost of goods sold Gross margin Selling and administrative expenses Net operating income Interest expense Net income before taxes 78% 79% 23% 21% 13% 13% 9% 8% 1% 2% 6% 2% 5% 2% 8% Income taxes (30%) Net income 2% 6% Common dividends 2% 101,000 579,000 680,000 Net income retained 170,000 3% 2% Beginning retained earnings Ending retained earnings 680,000 850,000

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS