Sunday, July 4, 2021

Discuss the limitations of ratio analysis.

 Which of the following is NOT a reason why financial analysts use ratio analysis?

A) Ratios help to pinpoint a firm's strengths.
B) Ratios restate accounting data in relative terms.
C) Ratios are ideal for smoothing out the differences that may exist when comparing firms that use different accounting practices.
D) Some of a firm's weaknesses can be identified through the usage of ratios.

Which of the following is NOT a limitation related to the usage of ratios when reviewing a firm's performance?
A) Many firms experience seasonality in their operations.
B) Ratios cannot be used to compare firms that are in the same industry if one firm's sales are higher than another firm's.
C) Some firms operate in a variety of business lines, which makes it difficult to make comparisons.
D) Accounting practices differ widely among firms.



Which of the following statements is FALSE?
A) The calculation of the accounts receivable average collection period (ACP) would generally produce a more realistic assessment of how a firm is managing its accounts receivable if the analyst were to calculate the ACP for each month and average the results, than if the analyst were to solely use the fiscal year-end accounts receivable value.
B) If an analyst were to compare the inventory turnover of one firm to that of another, the comparison can be distorted if the two firms use different methods of valuing ending inventory.
C) Assume that two firms are in the same industry and one reports a higher debt ratio than the other. We can safely say that the firm that has the highest debt ratio is the riskier of the two firms.
D) A firm that has a current ratio that is significantly above the industry norm will, as a direct consequence, also have a significantly better return on assets than if its current ratio was below the industry norm.
E) All of the above statements are true.

Which of the following is a limitation related to the usage of ratios when reviewing a firm's performance?
A) Ratios reveal differences in policy and performance between years.
B) Ratios can be used to compare firms that are in the same industry if one firm's sales are higher than another firm's.
C) Financial ratios are designed for the use of creditors, not for managers.
D) Different accounting practices between firms can distort comparisons.

A serious pitfall in the interpretation of financial ratios arises when a company, whose business is seasonal, ends its accounting year on March 31, while most companies in the same industry end their accounting period on December 31.


Differences in accounting practices limit the use of ratio analysis.
Answer:  TRUE

Discuss the limitations of ratio analysis.
Answer:  It is often difficult to find adequate benchmarks to use, as companies in the same industry can be structured quite differently. Conglomerates are difficult to classify, as they are involved in many different businesses. Firms in different countries use different accounting methods, so ratio analysis can be difficult when trying to compare multinational firms. Many firms have seasonal business, which can skew results, and one-time restructurings are difficult to account for.

Which of the following industries has the highest average inventory turnover ratio?

Which of the following industries has the highest average inventory turnover ratio?

A) Retail clothing stores
B) Jewelry stores
C) Automobile dealerships
D) Supermarkets

Which of the following would be most responsible for a company's average collection period being higher than the industry average?
A) If a company's growth in sales is greater than the growth of sales in the industry.
B) Being more aggressive in collecting its accounts receivable than its competitors.
C) Having credit policy standards that are more restrictive than its competitors.
D) Being more lenient in extending credit to its customers than its competitors.

When the present financial ratios of a firm are compared with similar ratios for another firm in the same industry, it is called trend analysis.
Answer:  FALSE

Firms that engage in multiple lines of business make it difficult to assign them to an industry category for ratio analysis.
Answer:  TRUE


A small start-up company should choose an industry leader in the same industry as a benchmark.
Answer:  FALSE

 Companies chosen for benchmmarks should be of similar size and in the same or a similar industry.
Answer:  TRUE

Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities

Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities. To evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. The following are the financial statements given to Trust Us Bank:


Balance Sheet                                           12/31/13                12/31/14
Cash                                                             $305                         270
Accounts receivable                                  275                         290
Inventory                                                      600                         580
Current assets                                          1,180                      1,140
Plant and equipment                             1,700                      1,940
Less: acc depr                                           (500)                       (600)
Net plant and equipment                     1,200                      1,340
Total assets                                             $2,380                    $2,480
Liabilities and Owners' Equity
Accounts payable                                    $150                       $200
Notes payable                                             125                              0
Current liabilities                                       275                         200
Bonds                                                             500                         500
Owners' equity
Common stock                                            165                         305
Paid-in-capital                                            775                         775
Retained earnings                                      665                         700
Total owners' equity                              1,605                      1,780
Total liabilities and owners' equity $2,380                   $2,480
Income Statement
Sales (100% credit)                               $1,100                    $1,330
Cost of goods sold                                      600                         760
Gross profit                                                  500                         570
Operating expenses                                     20                            30
Depreciation                                                160                         200
Net operating income                               320                         340
Interest expense                                            64                            57
Net income before taxes                           256                         283
Taxes                                                                87                            96
Net income                                                $169                       $187

a. What are the firm's financial strengths and weaknesses?
b. Should the bank make the loan? Why or why not?


Answer: 
a. The firm's liquidity has improved significantly, as indicated by the current ratio and the acid test ratio. However, the current ratio is a bit deceiving since it relies on inventory in part for liquidity. Since the inventory is not particularly liquid (low inventory turnover), the quick ratio is a better measure of liquidity, which is still below the industry norm. Management has done a less-than-average job of generating operating profits on its assets (low operating income return on investment). The cause for the low OIROI is the inefficient use of assets (low asset turnover), especially inventory (low inventory turnover). However, this ineffectiveness is countered by efficiencies in keeping operating expenses low (high operating profit margin). From a balance sheet perspective, the company has less financial risk than the average firm in the industry (slightly lower debt ratio). However, owing to the firm's lower profitability, it is not covering its interest charges as well as the average firm in the industry (low times interest earned). Owing to the low return on investment, the firm's return on assets and return on equity are low relative to its competition.

b. The answer is not an easy one. The firm has improved its liquidity, but it is still having problems at effectively managing its inventory. It may be that the loan is not needed to the extent thought, but rather management should work at reducing its investment in inventories. The bank would also want to know why the operating profit margin, which is still high, is falling. Nevertheless, the loan decision could go either way.

Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities. To evaluate the firm as a potential debtor

Baker & Co. has applied for a loan from the Trust Us Bank to invest in several potential opportunities. To evaluate the firm as a potential debtor, the bank would like to compare Baker & Co. to the industry. The following are the financial statements given to Trust Us Bank:


Balance Sheet                                           12/31/13               12/31/14
Cash                                                             $305                         270
Accounts receivable                                  275                         290
Inventory                                                      600                         580
Current assets                                          1,180                      1,140
Plant and equipment                             1,700                      1,940
Less: acc depr                                           (500)                       (600)
Net plant and equipment                     1,200                      1,340
Total assets                                             $2,380                    $2,480
Liabilities and Owners' Equity
Accounts payable                                    $150                       $200
Notes payable                                             125                              0
Current liabilities                                       275                         200
Bonds                                                             500                         500
Owners' equity
Common stock                                            165                         305
Paid-in-capital                                            775                         775
Retained earnings                                      665                         700
Total owners' equity                              1,605                      1,780
Total liabilities and owners' equity $2,380                   $2,480
Income Statement
Sales (100% credit)                               $1,100                    $1,330
Cost of goods sold                                      600                         760
Gross profit                                                  500                         570
Operating expenses                                     20                            30
Depreciation                                                160                         200
Net operating income                               320                         340
Interest expense                                            64                            57
Net income before taxes                           256                         283
Taxes                                                                87                            96
Net income                                                $169                       $187



Compute the following ratios:
                                                                                2013       2014       Industry Norms
Current ratio                                                                                               5.0
Acid test ratio                                                                                             3.0
Inventory turnover                                                                                    2.2
Average collection period                                                                       90 days
Debt ratio                                                                                                     .33
Times interest earned                                                                              7.0
Total asset turnover                                                                                  .75
Fixed asset turnover                                                                                 1.0
Operating profit margin                                                                         20%
Net profit margin                                                                                      12%
Return on total assets                                                                              9.00%
Return on equity                                                                                        10.43%
Answer:                                                                                     Industry
                                                        2013               2014               Norm        Evaluation
Current ratio                               4.3x                5.7x                5.0x            Satisfactory
Acid test (quick) ratio               2.1x                2.8x                3.0x            Improving
Inventory turnover                    1.0x                1.31x              2.2x            Poor
Average collection period       90 days         78.5 days      90 days     Satisfactory
Debt ratio                                     33%                28%                33%            Satisfactory
Times interest earned              5.0x                6.0x                7.0x            Poor
Total asset turnover                  .46x                .54x                .75x            Poor
Fixed asset turnover                 .92x                .99x                1.00x          Satisfactory
Operating Profit Margin         29.1%            25.6%            20%            Satisfactory
Net profit margin                      15.36%          14.06%          12.00%      Poor
Return on total assets              7.1%               7.54%            9.00%        Poor
Operating income return
        on investments                   13.45%          13.71%          15.00%      Poor
Return on equity                        10.6%            10.47%          13.43%      Poor


S.M., Inc. had total sales of $400,000 in 2014 (70 percent of its sales are credit). The company's gross profit margin is 10%

McKinny Enterprises must raise $580,000 to pay off a bank loan at the end of the year. The firm expects sales of $5,200,000 for the year. Depreciation for the year is $315,000. The company's net profit margin is 5%. Can the company pay off its loan through the retention of earnings?

Answer:  Net profit = sales × net profit margin = $5,200,000 × .05 = $260,000
Internal funds generated by the firm = net profit + depreciation = $260,000 + $315,000 = $575,000
McKinny cannot pay off its loan by using only internally generated funds.

S.M., Inc. had total sales of $400,000 in 2014 (70 percent of its sales are credit). The company's gross profit margin is 10%, its ending inventory is $80,000, and its accounts receivable is $25,000. What amount of funds can be generated by the company if it increases its inventory turnover ratio to 10.0 and reduces its average collection period to 20 days?
Answer:  Average collection period = (accounts receivable)/(annual credit sales/360 days)
20 days = (accounts receivable)/[(400,000)(.70)/360 days]
Accounts receivable = (20 × $280,000)/(360) = $15,556
Funds generated by reducing accounts receivable = $25,000 - $15,556 = $9,444
Inventory turnover = (cost of goods sold)/(ending inventory)
10.0 = [($400,000)(1 - .10)]/(ending inventory)
Ending inventory = ($360,000)/(10.0) = $36,000
Funds generated by reducing inventory = $80,000 - $36,000 = $44,000
Total funds generated = $9,444 + $44,000 = $53,444

Financial Data for Dooley Sportswear December 31, 2013


                                          Table 3
Financial Data for Dooley Sportswear December 31, 2013
Inventory                                                    $206,250
Long-term debt                                           300,000
Interest expense                                               5,000
Accumulated depreciation                     442,500
Cash                                                               180,000
Net sales (all credit)                               1,500,000
Common stock                                            800,000
Accounts receivable                                  225,000
Operating expenses                                   525,000
Notes payable-current                              187,500
Cost of goods sold                                      937,500
Plant and equipment                             1,312,500
Accounts payable                                      168,750
Marketable securities                                  95,000
Prepaid insurance                                        80,000
Accrued wages                                              65,000
Retained earnings-current-year                          ?
Federal income taxes                                     5,750

95) From the information presented in Table 3, calculate the following financial ratios for the Dooley Sportswear Company.
                current ratio                                        operating profit margin
                acid test ratio                                      net profit margin
                average collection period               total tangible asset turnover
                inventory turnover                           times interest earned
                gross profit margin
Answer: 
Current ratio = ($180,000 + $95,000 + $225,000 + $206,250 + $80,000)/($168,750 + $187,500 + $65,000) = ($786,250/$421,250) = 1.87
Acid test ratio = ($180,000 + $95,000 + $225,000 + $80,000)/($168,750 + $187,500 + $65,000) = ($580,000/$421,250) = 1.38
Average collection period = ($225,000)/($1,500,000/360 days) = 54 days
Inventory turnover = ($937,500/$206,250) = 4.55
Gross profit margin = ($562,500/$1,500,000) = 0.375
Operating profit margin = ($37,500/$1,500,000) = 0.025
Net profit margin = ($26,750/$1,500,000) = 0.0178
Total asset turnover = ($1,500,000/$1,656,250) = 0.906
Times interest earned = ($37,500/$5,000) = 7.5 times



                                                  Table 4
           Hokie Corporation Comparative Balance Sheet
           For the Years Ending March 31, 2013 and 2014
                                      (Millions of Dollars)
Assets                                                          2013                       2014
Current assets:
Cash                                                                 $2                         $10
Accounts receivable                                     16                           10
Inventory                                                         22                           26
Total current assets                                   $40                         $46
Gross fixed assets:                                   $120                       $124
Less accumulated depreciation               60                           64
Net fixed assets                                             60                           60
Total assets                                                $100                       $106
Liabilities and Owners' Equity
Current liabilities:
Accounts payable                                      $16                         $18
Notes payable                                                10                           10
Total current liabilities                             $26                         $28
Long-term debt                                              20                           18
Owners' equity:
Common stock                                              40                           40
Retained earnings                                        14                           20
Total liabilities and owners' equity    $100                       $106

Hokie had net income of $26 million for 1996 and paid total cash dividends of $20 million to their common stockholders.

Calculate the following financial ratios for the Hokie Corporation using the information given in Table 4 and 2014 information.
                current ratio
                acid test ratio
                debt ratio
                long-term debt to total capitalization
                return on total assets
                return on common equity
Answer: 
Current ratio = ($46/$28) = 1.64
Acid test ratio = ($20/$28) = 0.71
Debt ratio = ($46/$106) = 0.43
Long-term debt to total capitalization = ($18/$78) = 0.23
Return on total assets = ($26/$106) = 0.25
Return on common equity = ($26/$60) = 0.43

Bull Gator Industries is considering a new assembly line costing $6,000,000. The assembly line will be fully depreciated

Bull Gator Industries is considering a new assembly line costing $6,000,000. The assembly line will be fully depreciated by the simplified s...