Liabilities/Financial Analysis And Colgate’s Annual Report

Week 5 Discussions and Required Resources – Part 1 and Part 2 must be at least 200 words

 

Part 1: Liabilities and Financial Analysis

Discuss current liabilities and long-term     liabilities.  What are the differences between the two?      Illustrate your understanding of liabilities, making sure to identify major     types of current liabilities.

Part 2: Colgate’s Annual Report

Obtain a copy of Colgate’s annual report from a valid academic source found elsewhere on the   Internet.  Use this information to answer the following questions. If   researching online, go to the Colgate company website(http://www.colgate.com). Use the   ratios discussed in Chapter 11 (dividend payout ratio and return on common   stockholders’ equity) to evaluate Colgate’s dividend and earnings performance   from a stockholder’s perspective. Your answer should illustrate understanding   of dividend ratios and return on equity ratios, an analysis of financial   statements.

Required Resource

Text

Kimmel, P. D., Weygandt, J. J., & Kieso, D. E. (2016). Financial accounting: Tools for business decision making (8th ed.). Retrieved from https://content.ashford.edu/

· Chapter 10: Reporting and Analyzing Liabilities

· Chapter 11: Reporting and Analyzing Stockholders’ Equity

(Chapters 10-11 are in the attachments) 

Website

Colgate Corporate Website (www.colgate.com)

Recommended Resource

Website

Textbook Student Companion Site.  http://bcs.wiley.com/he-bcs/Books?action=index&itemId=1118953908&bcsId=9831

(Chapters 10-11 PowerPoints are in the attachments)

Week 5 Discussions and Required Resources

Part 1 and Part 2 must be at least 200 words

 

 Part 1: Liabilities and Financial Analysis

 

Discuss current liabilities and long-term liabilities.  What are the differences between the two?  Illustrate your understanding of liabilities, making sure to identify major types of current liabilities.

 

 

Part 2: Colgate’s Annual Report

 

 

Obtain a copy of Colgate’s annual report from the Ashford Online Library or from a valid academic source found elsewhere on the Internet.  Use this information to answer the following questions. If researching online, go to the Colgate company website(http://www.colgate.com). Use the ratios discussed in Chapter 11 (dividend payout ratio and return on common stockholders’ equity) to evaluate Colgate’s dividend and earnings performance from a stockholder’s perspective. Your answer should illustrate understanding of dividend ratios and return on equity ratios, an analysis of financial statements.

 

 

Required Resource

Text

Kimmel, P. D., Weygandt, J. J., & Kieso, D. E. (2016).  Financial accounting: Tools for business decision making  (8th ed.). Retrieved from https://content.ashford.edu/

 

· Chapter 10: Reporting and Analyzing Liabilities

· Chapter 11: Reporting and Analyzing Stockholders’ Equity

 

(Chapters 10-11 are in the attachments) 

 

Website

Colgate Corporate Website (www.colgate.com)

 

Recommended Resource

Website

 

Textbook Student Companion Site.  http://bcs.wiley.com/he-bcs/Books?action=index&itemId=1118953908&bcsId=9831

 

(Chapters 10-11 PowerPoints are in the attachments)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Chapter 3 And Chapter 4 Homework Principles Of Accounting II

Chapter 3

1.Rustafson Corporation is a diversified manufacturer of consumer goods. The company’s activity-based costing system has the following seven activity cost pools:

Activity Cost Pool Estimated
Overhead Cost
Expected Activity
Labor-related $ 51,000 8,000 direct labor-hours
Machine-related $ 14,900 20,525 machine-hours
Machine setups $ 44,000 500 setups
Production orders $ 18,000 400 orders
Product testing $ 50,000 1,700 tests
Packaging $ 67,125 5,200 packages
General factory $101,125 8,000 direct labor-hours

 

 

 

 

Required:
1.  Compute the activity rate for each activity cost pool. (Round your answers to 2 decimal places.)

 

 

 

 

 

 

 

General factory                  $                 per DLH

 

2.

 

2.  Compute the company’s predetermined overhead rate, assuming that the company uses a single plantwide predetermined overhead rate based on direct labor-hours. (Round your answer to 2 decimal places.)

Predetermined overhead rate                 $  per DLH
 

3.

Sultan Company uses an activity-based costing system.
At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools:

Activity Cost Pool
Activity Measure Estimated
Overhead Cost Expected
Activity
Labor-related Direct labor-hours $ 280,000 40,000 DLHs
Purchase orders Number of orders $   90,000 1,500 orders
Parts management Number of part types $ 120,000 400 part types
Board etching Number of boards $ 360,000 2,000 boards
General factory Machine-hours $ 400,000 80,000 MHs

Required:
1.  Compute the activity rate for each of the activity cost pools.

 

 

 

 

 

General factory                          $                  per MH

 

2.   The expected activity for the year was distributed among the company’s four products as follows:

Expected Activity

Activity Cost Pool                                      Product A        Product B        Product C        Product D
Labor-related (DLHs) 5,800 7,900 3,700 5,400
Purchase orders (orders) 55 30 20 87
Parts management (part types) 35 28 36 19
Board etching (boards) 410 907 412 0
General factory (MHs) 2,600 8,100 4,800 5,500

Using the ABC data, determine the total amount of overhead cost assigned to each product. (Leave no cells blank – be certain to enter “0” wherever required.)

 

 

Labor-related (DLHs)                                    $

 

 

 

General factory (MHs)

Total                                                               $

 

Rusties Company recently implemented an activity-based costing system. At the beginning of the year, management made the following estimates of cost and activity in the company’s five activity cost pools:

 

Activity Cost Pool

Activity Measure Expected
Overhead
Cost

Expected Activity
Labor-related Direct labor-hours $ 272,000 30,000 DLHs
Purchase orders Number of orders $   63,000 750 orders
Product testing Number of tests $ 182,000 1,200 tests
Template etching Number of templates $ 320,000 8,000 templates
General factory Machine-hours $ 837,000 60,000 MHs

 

4.

 

Required:
1.  Compute the activity rate for each of the activity cost pools. (Round your answers to 2 decimal places.)

 

 

 

 

 

General factory                             $                            per MH

 

5.

 

2.  The expected activity for the year was distributed among the company’s four products as follows:
Expected Activity

Activity Cost Pool Product A Product B Product C Product D
Labor-related (DLHs) 7,600 11,200 3,800 9,400
Purchase orders (orders) 160 190 110 240
Product testing (tests) 105 535 260 400
Template etching (templates) 2,400 0 5,500 0
General factory (MHs) 12,500 16,500 13,200 18,800

Using the ABC data, determine the total amount of overhead cost assigned to each product. (Do not round intermediate calculations. Round your answers to the nearest dollar amount.)

Total
Overhead Cost
Product A                                        $

Product B                                        $

Product C                                        $

Product D                                        $
 

6.

Gino’s Restaurant is a popular restaurant of Boston, Massachusetts. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. The intern, in consultation with the owner, identified the following major activities:

Activity Cost Pool                                     Activity Measure Serving a party of diners                Number of parties served Serving a diner                               Number of diners served Serving drinks                                Number of drinks ordered

A group of diners who ask to sit at the same table is counted as a party. Some costs, such as the costs of cleaning linen, are the same whether one person is at a table or the table is full. Other costs, such as washing dishes, depend on the number of diners served.

Data concerning these activities are shown below.

Serving a Party Serving a Dinner Serving Drinks Total
Total cost $ 31,000 $ 214,000 $ 67,000 $ 312,000
Total activity 6,000 parties 15,000 diners 10,000 drinks

Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. She knew that the total cost for the month was $312,000 and that 15,000 diners had been served. Therefore, the average cost per diner was $20.80 ($312,000 ÷ 15,000 diners = $20.80 per diner).

Required:
1.   Compute the activity rates for each of the three activities.(Round your answers to 2 decimal places.)

 

 

Serving Drinks                                $                 per drink

2.  According to the activity-based costing system, what is the total cost of serving each of the following parties of diners? (Do not round intermediate calculations. Round your final answers to 2 decimal places.)

a. A party of four diners who order three drinks in total.
b. A party of two diners who do not order any drinks.
c. A lone diner who orders two drinks.

 

 

Party of one diner who orders two drinks                                      $

3.  Convert the total costs you computed in Requirement 2 above to costs per diner. In other words, what is the average cost per diner for serving each of the following parties? (Do not round intermediate calculations. Round your final answers to 2 decimal places.)

a. A party of four diners who order three drinks in total.
b. A party of two diners who do not order any drinks.
c. A lone diner who orders two drinks.

 

 

Party of one diner who orders two drinks                                       $                 per diner

 

7.

Adria Company recently implemented an activity-based costing system. At the beginning of the year, management made the following estimates of cost and activity in the company’s five activity cost pools:

 

Activity Cost Pool
Activity
Measure Expected
Overhead
Cost
Expected
Activity
Labor-related Direct labor-hours $206,500 35,000 DLHs
Purchase orders Number of orders $  68,040 900 orders
Material receipts                    Number of receipts          $160,860        1,400 receipts
Relay assembly Number of relays $302,400 10,500 relays
General factory Machine-hours $805,000 70,000 MHs
 

 

Required:
1. Compute the activity rate for each of the activity cost pools.(Round your answer to 2 decimal places.)

 

 

 

 

 

General factory                        $                 per MH

 

8.

2.   The expected activity for the year was distributed among the company’s four products as follows:

Expected Activity

Activity Cost Pool Product A Product B Product C Product D
Labor-related (DLHs) 5,600 7,600 9,900 8,900
Production orders (orders) 135 300 80 435
Material receipts (receipts) 360 175 220 545
Relay assembly (relay) 0 4,550 0 6,950
General factory (MHs) 10,300 20,700 16,500 20,500

Using the ABC data, determine the total amount of overhead cost assigned to each product. (Do not round intermediate calculations. Round your answers to the nearest dollar amount.)

 

Product A                                                          $

Product B                                                          $

Product C                                                          $

Product D                                                          $

Chapter 4

1.

The PVC Company manufactures a high-quality plastic pipe that goes through three processing stages prior to completion.

Information on work in the first department, Cooking, is given below for May:

Production data:
Pounds in process, May 1: materials 100%
complete; conversion 90% complete                                               81,000
Pounds started into production during May                                     460,000
Pounds completed and transferred to
the next department                                                                                   ? Pounds in process, May 31:
materials 80% complete; conversion 20% complete                       55,000
Cost data:
Work in process inventory, May 1:
Materials cost                                                                          $  158,200
Conversion cost                                                                       $    50,500
Cost added during May:
Materials cost                                                                          $  822,300
Conversion cost                                                                       $  277,520

The company uses the weighted-average method.

Required:
1.  Compute the equivalent units of production.

Equivalent units of production

2.  Compute the costs per equivalent unit for the month. (Round your answers to 2 decimal places.)

Cost per equivalent unit                     $

3.  Determine the cost of ending work in process inventory and of the units transferred out to the next department. (Round your intermediate calculation to 2 decimal places and final answers to the nearest whole dollar amount.)

Materials                    Conversion                       Total
Cost of ending work in process inventory                            $
$
$

Cost of units completed and transferred out                         $
$
$

4.  Prepare a cost reconciliation report for the month. (Round your intermediate calculation to 2 decimal places and final answers to the nearest whole dollar amount.)
Costs to be accounted for:

Cost Reconciliation

 

 

Total cost to be accounted for                                                                                 $

Costs accounted for as follows:

 

 

Total cost accounted for                                                                                         $

 

2.

Brady Products manufactures a silicone paste wax that goes through three processing departments—Cracking, Blending, and Packing. All raw materials are introduced at the start of work in the Cracking Department. The Work in Process T-account for the Cracking Department for a recent month is given below:

Work in Process—Cracking Department
Inventory, May 1                      228,200 Completed and transferred to
the Blending Department               ?
Materials                                  757,990
Conversion                               403,410

Inventory, May 31                    ?

The May 1 work in process inventory consisted of 70,000 pounds with $142,100 in materials cost and $86,100 in conversion cost. The May 1 work in process inventory was 100% complete with respect to materials and 80% complete with respect to conversion. During May, 341,000 pounds were started into production. The May 31 inventory consisted of 121,000 pounds that were 100% complete with respect to materials and 60% complete with respect to conversion. The company uses the weighted-average method to account for units and costs.

Required:
1.  Determine the equivalent units of production for May.

Equivalent units of production

2.  Determine the costs per equivalent unit for May. (Round your answers to 2 decimal places.)

Cost per equivalent unit                           $

3.  Determine the cost of the units completed and transferred to the Blending Department during May. (Round your intermediate calculation to 2 decimal places. Round your final answers to nearest whole dollar amount.)
Cost of units completed and transferred out

3.

Materials                      Conversion                         Total
Nature’s Way, Inc., keeps one of its production facilities busy making a perfume called Essence de la Vache. The perfume goes through two processing departments: Blending and Bottling.

The following incomplete Work in Process account is provided for the Blending Department for March:

Work in Process—Blending
March 1 balance                                        32,800 Completed and transferred
to Bottling (760,000 ounces)                    ?
Materials                                                 153,600
Direct labor                                               71,200
Overhead                                                 489,000

March 31 balance                                          ?

The $32,800 beginning inventory in the Blending Department consisted of the following elements: materials,
$7,900; direct labor, $3,600; and overhead applied, $21,300.
Costs incurred during March in the Bottling Department were: materials used, $45,000; direct labor, $17,600;
and overhead cost applied to production, $106,000.

Required:
1.  Prepare journal entries to record the costs incurred in both the Blending Department and Bottling Department during March.

a. Raw materials were issued for use in production.
b. Direct labor costs were incurred.
c. Manufacturing overhead costs for the entire factory were incurred, $636,000. (Credit Accounts Payable and use
a single Manufacturing Overhead control account for the entire factory.)
d. Manufacturing overhead was applied to production using a predetermined overhead rate.
e. Units that were complete with respect to processing in the Blending Department were transferred to the Bottling
Department, $662,000.
f. Units that were complete with respect to processing in the Bottling Department were transferred to Finished
Goods, $790,000.
g. Completed units were sold on account for $1,320,000. The cost of goods sold was $680,000.

Items                                      General Journal                                               Debit                           Credit a. (Click to select)

(Click to select)

(Click to select)

b.             (Click to select)

(Click to select)

(Click to select)

c.             (Click to select)

(Click to select)

d.             (Click to select)

(Click to select)

(Click to select)

e.             (Click to select)

(Click to select)

f.             (Click to select)

(Click to select)

g.             (Click to select)

(Click to select)

(Click to select)

(Click to select)

 

2.  Post the journal entries from (1) above to T-accounts. The following account balances existed at the beginning of March. (The beginning balance in the Blending Department’s Work in Process account is given above.) (Record the transactions in the given order.)

Raw materials $  208,600
Work in process-Bottling department $    52,000
Finished goods $    16,000

After  posting  the  entries  to  the  T-accounts,  find  the  ending  balances  in  the  inventory  accounts  and  the manufacturing overhead account.
Accounts Receivable
(Click to select)

Raw Materials

Bal.                                                                                (Click to select)

Bal.

 

 

Work in Process – Blending Department

Bal.                                                                                (Click to select)

(Click to select)

(Click to select)

(Click to select)

Bal.

 

 

Work in Process – Bottling Department

Bal.                                                                                (Click to select)

(Click to select)

(Click to select)

(Click to select)

(Click to select)

Bal.

 

 

Finished Goods

Bal.                                                                                (Click to select)

(Click to select)
Bal.

 

 

Manufacturing Overhead

(Click to select)                                                                    (Click to select)

Bal.

 

 

Accounts Payable

(Click to select)

Salaries and Wages Payable

(Click to select)

Sales

(Click to select)

Cost of Goods Sold
(Click to select)

4.

The following information pertains to Yap Company’s Grinding Department for the month of April:

Units Materials
Costs
Beginning work in process 50,000 $13,200
Started in April 96,000 $118,800
Units completed and transferred out 112,500
Ending work in process 33,500

All materials are added at the beginning of the process. Using the weighted-average method, the cost per equivalent unit for materials is closest to:

$1.38

$1.02

$0.90

5.

Jaderston Corporation uses the weighted-average method in its process costing system. Data concerning the first processing department for the most recent month are listed below:

Beginning work in process inventory:
Units in beginning work in process inventory 200
Materials costs $2,500
Conversion costs $2,800
Percent complete with respect to materials 60%
Percent complete with respect to conversion 35%
Units started into production during the month 6,900
Units transferred to the next department during the month 6,400
Materials costs added during the month $136,300
Conversion costs added during the month $243,400
Ending work in process inventory:
Units in ending work in process inventory 700
Percent complete with respect to materials 55%
Percent complete with respect to conversion 50%

Note: Your answers may differ from those offered below due to rounding error. In all cases, select the answer that is the closest to the answer you computed. To reduce rounding error, carry out all computations to at least two decimal places.

The cost per equivalent unit for materials for the month in the first processing department is closest to:

$19.55

$20.12

$20.46

$19.05

6.

In January, one of the processing departments at Seidl Corporation had ending work in process inventory of
$43,000. During the month, $133,000 of costs were added to production and the cost of units transferred out from the department was $104,000.

In the department’s cost reconciliation report for January, the cost of beginning work in process inventory for the department would be:

$61,000

$14,000

$90,000

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Logistic Management Case Study

Assessment Topic 

 

Assignment 2

 

T0317 due week 10

 

International Intermodals / Hubs

 

After reading further background material on the concept of an intermodal company and relevant case studies on related companies, prepare a 2500 word report analysing the important features of an intermodal. This can be located in Australia or an international location (i.e. ACFS in Australia).

Identify logistics management strategies to resolve any issues related to the operational aspects of the company.

In your report you need to consider:

The main problems at with the current logistics network in NSW or as it applies to the city where your intermodal is located

How they might be resolved

What, if any, involvement should the NSW Government have in the resolution of the problems

Sustainability should be used here from chapter 14 along with learning outcomes from week 7 to week 10.

 

To support your analysis and recommendations, you need to:

Use a minimum of 8 academic journal articles, plus the text supporting your identification of problems and proposals / recommendations to resolve the problems (better marks will be awarded for more than 8).

As a report is due the usual formatting applies.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Finance

RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm’s debt is priced at par, so the market value of its debt equals its book value. Since dollars are in thousands, number of shares are shown in thousands too.

a. Calculate the indicated ratios for Barry.

b. Construct the DuPont equation for both Barry and the industry.

c. Outline Barry’s strengths and weaknesses as revealed by your analysis.

d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2018. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.)

Barry Computer Company: Balance Sheet as of December 31, 2018 (in Thousands)
Cash $ 77,500 Accounts payable $129,000
Receivables 336,000 Other current liabilities 117,000
Inventories 241,500 Notes payable to bank 84,000
   Total current assets $ 655,000    Total current liabilities $330,000
    Long-term debt 256,500
Net fixed assets 292,500 Common equity (36,100 shares) 361,000
Total assets $ 947,500 Total liabilities and equity $947,500

 

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in Thousands)
Sales   $1,607,500
Cost of goods sold    
      Materials $717,000  
      Labor 453,000  
      Heat, light, and power 68,000  
      Indirect labor 113,000  
      Depreciation 41,500 1,392,500
Gross profit   $ 215,000
Selling expenses   115,000
General and administrative expenses   30,000
      Earnings before interest and taxes (EBIT)   $ 70,000
Interest expense   24,500
      Earnings before taxes (EBT)   $ 45,500
Federal and state income taxes (40%)   18,200
Net income   $ 27,300
Earnings per share   $ 0.75623
Price per share on December 31, 2018   $ 12.00

 

 

Ratio Barry Industry Average
Current ___ 2.0×
Quick ___ 1.3×
Days sales outstanding a ___ 35 days
Inventory turnover ___ 6.7×
Total assets turnover ___ 3.0×
Profit margin ___ 1.2%
ROA ___ 3.6%
ROE ___ 9.0%
ROIC ___ 7.5%
TIE ___ 3.0×
Debt/Total capital ___ 47.0%
M/B ___ 4.22
P/E ___ 17.86
EV/EBITDA ___ 9.14
a Calculation is based on a 365-day year.

 

4-24 DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm’s financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm’s financial statements are as follows:

Industry Average Ratios
Current ratio 3× Fixed assets turnover 6×
Debt-to-capital ratio 20% Total assets turnover 3×
Times interest earned 7× Profit margin 3%
EBITDA coverage 9× Return on total assets 9%
Inventory turnover 10× Return on common equity 12.86%
Days sales outstanding a 24 days Return on invested capital 11.50%
a Calculation is based on a 365-day year.

 

Balance Sheet as of December 31, 2018 (Millions of Dollars)
Cash and equivalents $ 78 Accounts payable $ 45
Accounts receivable 66 Other current liabilities 11
Inventories 159 Notes payable 29
   Total current assets $303    Total current liabilities $ 85
    Long-term debt 50
       Total liabilities $135
Gross fixed assets 225 Common stock 114
   Less depreciation 78 Retained earnings 201
Net fixed assets $147    Total stockholders’ equity $315
Total assets $450 Total liabilities and equity $450

 

 

Income Statement for Year Ended December 31, 2018 (Millions of Dollars)
Net sales $795.0
Cost of goods sold 660.0
   Gross profit $135.0
Selling expenses 73.5
EBITDA $ 61.5
Depreciation expense 12.0
   Earnings before interest and taxes (EBIT) $ 49.5
Interest expense 4.5
   Earnings before taxes (EBT) $ 45.0
Taxes (40%) 18.0
Net income $ 27.0

 

a. Calculate the ratios you think would be useful in this analysis.

b. Construct a DuPont equation, and compare the company’s ratios to the industry average ratios.

c. Do the balance sheet accounts or the income statement figures seem to be primarily responsible for the low profits?

d. Which specific accounts seem to be most out of line relative to other firms in the industry?

e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?

 

 

 

 

 

 

 

 

The following will hopefully help you with your Du Ponts:

First , please note that the third and last ratio of the Du Pont equation (p. 124) is Total Assets/Total Common Equity. This ratio is what we refer to as the “Equity Multiplier.” People often get confused about the denominator in this ratio. If you look at Table 3-1 on page 68, you will see that Total Common Equity is the TOTAL of the common stock and retained earnings. For the company that number is $940mm. Now, go back to the Du Pont on page 124 and look at the equity multiplier. They use that same $940mm. They do not just use the “common stock” number.

Now, look at problem 4-24 where they use some slightly different wording. It shows that “total stockholder equity” = $315mm. That is your number for the Du Pont. It is a common (no pun intended!) error for learners to think “total common equity” (for the DuPont)? That must mean “Common stock”! They then use only the $114mm instead of the total $315mm and incorrectly calculate the Du Pont.

Second,  remember (read page 124) that the Du Pont should calculate the very same number that you derive by calculating the ROE ratio. Du Pont does not give you a different ROE, it helps you understand more about that same number (such as, why is the ratio the way it is). So, if your ROE ratio and your Du Pont are different, you have an error somewhere in either your ratio or your equation.

Third,  here is a major hint on how to calculate the industry Du Pont in 4-23(b):

To get the EM for the industry, recognize that ROE/ROA = (NI/E)/(NI/A) = NI/E × A/NI = A/E = Equity multiplier = 2.5.

 

I hope all this helps!

 

Thanks

 

RATIO ANALYSIS

 

Data for Barry Computer Co. and its industry averages follow. The firm’s

debt is priced at par, so the market value of its debt equals its book value. Since dollars are in

thousands, number of shares are shown in thousands too.

 

a.

 

Calculate the indicated ratios for Barry.

 

b.

 

Construct the DuPont equation for both Barry and the industry.

 

c.

 

Outline Barry’s strengths and weaknesses as revealed by your analysis.

 

d.

 

Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and

common equity during 2018. How would that information affect the validity of your ratio

analysis? (Hint: Think about averages and the effects of rapid growth on ratios

 

if averages are

not used. No calculations are needed.)

 

Barry Computer Company: Balance Sheet as of December 31, 2018 (in Thousands)

 

Cash

 

$ 77,500

 

Accounts payable

 

$129,000

 

Receivables

 

336,000

 

Other current liabilities

 

117,000

 

Inventories

 

241,500

 

Notes payable to bank

 

84,000

 

 

Total current assets

 

$ 655,000

 

 

Total current liabilities

 

$330,000

 

 

 

Long

term debt

 

256,500

 

Net fixed assets

 

292,500

 

Common equity (36,100 shares)

 

361,000

 

Total assets

 

$ 947,500

 

Total liabilities and equity

 

$947,500

 

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in

Thousands)

 

Sales

 

 

$1,607,500

 

Cost of goods sold

 

 

 

 

Materials

 

$717,000

 

 

 

Labor

 

453,000

 

 

 

Heat, light, and power

 

68,000

 

 

 

Indirect labor

 

113,000

 

 

 

Depreciation

 

41,500

 

1,392,500

 

Gross profit

 

 

$ 215,000

 

Selling expenses

 

 

115,000

 

General and administrative expenses

 

 

30,000

 

 

Earnings before interest and taxes (EBIT)

 

 

$ 70,000

 

Interest expense

 

 

24,500

 

 

Earnings before taxes (EBT)

 

 

$ 45,500

 

Federal and state income taxes (40%)

 

 

18,200

 

Net income

 

 

$ 27,300

 

Earnings per share

 

 

$ 0.75623

 

RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm’s

debt is priced at par, so the market value of its debt equals its book value. Since dollars are in

thousands, number of shares are shown in thousands too.

a. Calculate the indicated ratios for Barry.

b. Construct the DuPont equation for both Barry and the industry.

c. Outline Barry’s strengths and weaknesses as revealed by your analysis.

d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and

common equity during 2018. How would that information affect the validity of your ratio

analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are

not used. No calculations are needed.)

Barry Computer Company: Balance Sheet as of December 31, 2018 (in Thousands)

Cash $ 77,500 Accounts payable $129,000

Receivables 336,000 Other current liabilities 117,000

Inventories 241,500 Notes payable to bank 84,000

Total current assets $ 655,000 Total current liabilities $330,000

 

Long-term debt 256,500

Net fixed assets 292,500 Common equity (36,100 shares) 361,000

Total assets $ 947,500 Total liabilities and equity $947,500

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in

Thousands)

Sales

 

$1,607,500

Cost of goods sold

 

Materials $717,000

 

Labor 453,000

 

Heat, light, and power 68,000

 

Indirect labor 113,000

 

Depreciation 41,500 1,392,500

Gross profit

 

$ 215,000

Selling expenses

 

115,000

General and administrative expenses

 

30,000

Earnings before interest and taxes (EBIT)

 

$ 70,000

Interest expense

 

24,500

Earnings before taxes (EBT)

 

$ 45,500

Federal and state income taxes (40%)

 

18,200

Net income

 

$ 27,300

Earnings per share

 

$ 0.75623

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"