Question

In: Finance

Trend Analysis - The following data pertain to Company B: (in thousands) Year 2 Year 1...

Trend Analysis - The following data pertain to Company B:

(in thousands) Year 2 Year 1
Revenue $1,285,876 $1,364,550
Net income 56,644 42,906
Accounts receivable 149,178 168,666
Inventory 158,541 179,688
Total current assets 670,337 649,903
Total asset 859,907 849,399
Total current liabilities 227,807 232,074
Total long-term liabilities 36,483 40,787
Total stockholder equity 595,617 576,538

Common-Size Income Statements - Company B reported the following income statements:

COMPANY B
INCOME STATEMENT
FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1
(in thousands) Year 2 Year 1
Sales revenue $1,285,876 $1,364,550
Costs of goods sold 682,954 743,817
Gross profit 602,922 620,733
Selling and administrative expenses 525,448 551,097
Income from operations 77,474 69,636
Interest expense (498) (652)
Interest income 903 2,371
Other income 3,506 5,455
Income before income taxes 81,385 76,810
Income tax expense 24,741 33,904
Net income 56,644 42,906

Using the data provided above, compute the following ratios for Company B for Years 1 and Years 2.

(a) Gross profit margin ratio

(b) Return on sales

(c) Asset turnover

(d) Return on assets

(e) Working capital

(f) Current ratio

(g) Accounts receivable turnover

(h) Inventory-on-hand period

(i) Long-term debt to assets

(j) Long-term debt to equity

(k) Times-interest-earned

(l) Return on equity

Please explain the formulas utilized to answer the financial ratios.

Solutions

Expert Solution

The answers are as follows: Year 1 Year 2

Gross Profit margin ratio 620733/1364550=0.4549 602922/1285876 =0.4689

Return on Sales 42906/1364550=3.144% 56644/1285876=4.4051%

Assets Turnover 1364550/854653=1.5966 1285876/854653=1.5046

(Average Assets have been used for calculating asset turnover)

Return on Assets 42906/849399=5.05% 56644/859907=6.5872%

Working Capital 649903-232074=417829 670337-227807=442530

Current Ratio 649903/232074=2.8004 670337/227807=2.9426

Accounts Receivable Turnover 1364550/158922=8.5863 1285876/158922=8.0912

(Average Receivable have been used to calculate the ratio.Since credit sales are not given the entire sales are assumed to be credit sales)

Inventory on hand period (169114.5/743817)*365=82.98 days (169114.5/682954)*365=90.38 days

Average Inventory has been used to calculate the ratio

Long Term Debt to Assets 40787/849399=0.048 36483/859907= 0.0424

Long Term Debt to Equity   40787/ 576538 = 0.0707 36483/595617=0.0613

Times Interest Earned 69636/652= 106.803 77474/498=155.57

Return on Equity 42906/576538=7.44% 56644/595617=9.51%

The formulas utilized to answer financial ratios are

  • Current Ratio
  • Accounts Receivable Turnover
  • Long term debt to equity ratio
  • Times interest earned
  • Gross proft margin
  • Return on assets
  • Return on Equity

Related Solutions

Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1...
Trend Analysis - The following data pertain to Company A: (in millions) Year 2 Year 1 Revenue $39,474 $35,137 Net income 5,658 5,642 Accounts receivable 4,389 3,725 Inventory 2,290 1,926 Total current assets 10,151 9,130 Total assets 34,628 29,930 Total current liabilities 7,753 6,860 Total long-term liabilities 9,641 7,702 Total stockholder equity 20,000 18,000 Common-Size Income Statements - Company A reported the following income statements: COMPANY A INCOME STATEMENT FOR THE YEARS ENDED DECEMBER YEAR 2 AND YEAR 1 (in...
1. The following cost data for the year just ended pertain to Devere company, a greeting...
1. The following cost data for the year just ended pertain to Devere company, a greeting card manager: USD Direct Material 2,100,000 Advertising expense 98,000 Depreciation on factory building 115,000 Direct Labour: wages 505,000 cost of finished goods inventory at year-end 115,000 indirect labour: wages 140,000 production supervisor's salary 47,000 service department cost 100,000 Direct Labour: Fringe benefits 87,000 Indirect labour: fringe benefits 31,000 Benefits for a production supervisor 10,000 total overtime premiums paid 55,000 Cost of idle time: production...
Question The following data pertain to the operations of a manufacturing company for the year 2018...
Question The following data pertain to the operations of a manufacturing company for the year 2018 Item Amount (sh) Sales revenues 1,000,000 Direct materials inventory, Jan 1, 2018 15,000 Direct labour 300,000 Depreciation, plant   60,000 Depreciation, equipment 40,000 Cutting tools used 10,000 Indirect labour 5,000 Factory lighting and power 10,000 Factory supervisor’s salary 50,000 Indirect materials 10,000 Finished goods inventory, Jan 1, 2018 30,000 Work in progress inventory, December 31, 2018 20,000 Office Supplies 10,000 Finished goods inventory, December 31,...
Draw the trend analysis based on following sales data for four years and analyse the fifth-year...
Draw the trend analysis based on following sales data for four years and analyse the fifth-year projected sales. Mention the possible relationship between the sales and the year on the basis of linear regression. Also mention the R-square value and its interpretation. Year Sales 1 900 2 1100 3 1200 4 1450 5
The following data pertain to the Marie Manufacturing Company for the year ended December 31, 2004....
The following data pertain to the Marie Manufacturing Company for the year ended December 31, 2004. The company used 51,000 direct labor hours during 2004. Beginning direct material inventory                           $    42,000 Ending direct material inventory 48,000 Beginning work-in-process inventory 84,000 Ending work-in-process inventory 93,000 Beginning finished goods inventory 124,000 Ending finished goods inventory 133,000 Direct material purchased 850,000 Indirect material used in production 4,000 Factory supplies used 6,200 Depreciation on the factory 60,000 Depreciation on the sales office 4,000 Depreciation...
1. The following data pertain to April operations for Schnitzels Company:                   Unit sold           &nbsp
1. The following data pertain to April operations for Schnitzels Company:                   Unit sold                                                90.000          Unit produced                                        100.000          Sales price per unit                                $ 12                                    Fixed                            Variable Materials                     -                               $2    per unit produced Direct Labor                -                                 1.5 per unit produced Factory Overhead $200.000                      $0.5 per unit produced Marketing and Administrative       0.2 per unit sold $140.000        Required:        Prepare an operating income statement for 20A using direct costing    
The following data pertain to the Vesuvius Tile Company for July.Work in process, July 1 (in...
The following data pertain to the Vesuvius Tile Company for July.Work in process, July 1 (in units) .......................................................................................................................20,000Units started during July ...................................................................................................................................?Total units to account for ..................................................................................................................................65,000Units completed and transferred out during July ................................................................................................?Work in process, July 31 (in units) .....................................................................................................................15,000Total equivalent units: direct material .................................................................................................................65,000Total equivalent units: conversion ......................................................................................................................?Work in process, July 1: direct material .............................................................................................................$164,400Work in process, July 1: conversion ...................................................................................................................?Costs incurred during July: direct material .........................................................................................................?Costs incurred during July: conversion ..............................................................................................................659,400Work in process, July 1: total cost...
The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit...
The following data pertain to April pertain for Jennings      Manufacturing Company:          Beginning Inventory……………….3,000          Unit sold……………………………9,000          Unit Produced………………………8,000          Sales price per unit…………………$30          Direct Manufacturing cost per unit…$10          Fixed factory overhead-total……….$40,000          Fixed factory overhead-per unit……$5          Commercial expenses (all fixed)…..$50,000          Required: Prepare an income statement using absorption costing Prepare an income statement using direct costing Provide computation explaining the difference in        operating income between the two methods.
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,283,300 $1,106,300 $929,700 $794,600 $673,400 Interest expense 436,300 398,300 344,000 262,200 208,800 Income tax expense 410,656 309,764 260,316 206,596 161,616 Average total assets 7,676,786 6,777,477 5,789,545 4,915,349 4,181,043 Average stockholders' equity 2,629,713 2,353,830 2,056,858 1,822,477 1,595,735 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,052,000 $906,900 $762,100 $651,400 $552,000 Interest expense 357,700 326,500 282,000 215,000 171,100 Income tax expense 336,640 253,932 213,388 169,364 132,480 Average total assets 6,350,000 5,606,364 4,789,450 4,067,606 3,459,809 Average stockholders' equity 2,169,072 1,941,970 1,697,327 1,504,388 1,317,422 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT