Question

In: Accounting

Please review the following six ratios for Simpson Company and ABC Inc. for the year ended...

Please review the following six ratios for Simpson Company and ABC Inc. for the year ended 2014, then address the two questions below.

Ratio Name Simpson Company ABC Inc.
(a) Days’ Sales Outstanding 36 30
(b) Inventory Turnover 5.6 4.9
(c) Asset Turnover 2.02 3.03
(d) Earnings per Share $1.50 $1.25
(e) Times Interest Earned 6.1 5.2
(f) Return on Common Stockholders’ Equity 15.6% 12.2%

Instructions: This is a two-part question. (1) Explain the meaning of each of the Simpson Company ratios above. (18 points) (2) State which company performed better for each ratio. (18 points)

Solutions

Expert Solution

Simpson Company and ABC Inc.
a.Days’ Sales Outstanding
Days sales outstanding is calculated as = 365 days / (Sales / Avg. Accounts Receivable)
The figure arrived shows how efficiently or inefficiently the companies are converting
Receivables into cash .It is the average number of days the company takes to convert
debtors into cash.The faster the better for liquidity.The company which converts
debtors into cash faster are more efficient.
Simpson Company takes 36 days to convert debtor into cash whereas ABC inc. takes
30 days which shows Abc Inc. is more efficient in converting debtors into cash.
b.Inventory Turnover
Inventory Turnover is calculated as = Cost of goods sold / (Avg. inventory)
The Inventory needs to be moved quickly to remove obsoletion and reduce storage
costs.The longer the inventory lies idle the higher the cost.This ratio shows how many
times Inventory has been replaced and sold.Th esame figure can be used by dividing
by days in the period to calculate the days it takes to sell the inventory on hand.
The lower the ratio higher the number of days to sell the inventory on hand.
Simpson Co. seems to sell their inventory faster than ABC inc.
(c) Asset Turnover
Asset Turnover is calculated as = Sales / Avg. Total assets
Assets are used to generate sales revenue.The asset turnover ratio measures the
efficiency of a company's use of assets in genrating sale revenue.
Lower the asset turnover ratio higher the profit margin.Higher the Asset turnover
ratio lower the profit margin.
ABC Inc. with high asset turnover is using its assets efficiently to generate maximum sales
(d) Earnings per Share
Earning per share is calculated as = Net income / Total no. of shares outstanding
Higher EPS indicates significant dividends for investors .It gives a good return to
the shareholders
Simpson Co. has higher EPS indicating good return to shareholders than ABC Inc.
(e) Times Interest Earned
Times Interest earned is calculated as = Earnings before interest & Tax / Interest Expense
This ratio shows the company's ability to meet its debt obligation.The higher the ratio
higher the ability to meet its debt obligation.
(f) Return on Common Stockholders’ Equity
Return on Common Stockholders’ Equity is calculated as = Net Income / common stockholders' equity
The ratio measures ability of company in generating income for its common stock holders.Higher
the ratio better the performance.

Related Solutions

The following information relates to a company ABC Ltd for the year ended 30 June 2020:...
The following information relates to a company ABC Ltd for the year ended 30 June 2020: Transaction totals for the year ended 30 June 2020 R Credit purchases of raw materials 503750 Freight on raw materiasl purchased (on credit) 99833 Sales of finished producgts 11440000 Direct Labour: Factory wages 828600 Pension fund contributions paid by employer 172500 Medical aid paid by employer 227200 UIF Contributions paid by employer 8144 Indirect Labour 500250 Electricity Factory 211450 Administration offices 127900 Rent Expenses...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March $41,000 June $47,000 April 50,000 July 58,000 May 32,000 August 62,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare...
Simpson Glove Company has made the following sales projections for the next six months. All sales...
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales.    March $52,000 June $58,000 April 61,000 July 69,000 May 43,000 August 73,000    Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 35 percent are collected in the month of sale, 25 percent are collected in the following month, and 30 percent are collected two months after...
Question 1: The following information and ratios of XYZ Ltd related to the year ended December...
Question 1: The following information and ratios of XYZ Ltd related to the year ended December 31, 2019. 1. Accounting Information Gross Profit 15% of Sales Net profit 8% of Sales Inventory to sales 5% Average collection Period 60days All Sales on Credit 2. Financial Ratios Fixed Assets to Sales 33.3% Fixed Assets to Current Assets 118% Current ratio 2x Long-term loans to current liabilities 67% Capital to Retained earnings 25% If the value of fixed assets as of December...
The following information relates to ABC Ltd., for the year ended 31st December, 2019.
The following information relates to ABC Ltd., for the year ended 31st December, 2019.             Sales……………………………………………………………….. Rs.2,000,000.             EBID ………………………………………………………………. 40% of sales.             Ordinary Shares capital of par value Rs.10/each……………… Rs.800,000.             8% Preference shares Capital of par value Rs.100/ each………. Rs.500,000.             10% Bonds payable of par value Rs.1000/each…………………. Rs.400,000.             Reserves and surplus………………………………………………Rs.250,000.             Current liabilities…………………………………………………..Rs.250,000. Tax rate is 30%.             Market price of share is Rs.20 each.             Dividend payout ratio is 60%. Required; Compute and comments on each of the following ratios a)Earning per...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008:                                        Actual results Budgeted results Previous year Industry average current ratio 1.97 1.92 1.87 1.92 Quick asset ratio 1.06 1.06 1.06 1.11 Inventory turnover 4.21 4.91 4.86 4.76 Net profit ratio 0.05 0.03 0.03 0.03 Gross margin 0.65 0.59 0.61 0.61 Required: Provide four (4) possible explanations for the results for the various ratios for Nova Ltd and outline their implications...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008: Ratio Actual results Budgeted results Previous year Industry Average Current ratio 1.97 1.92 1.87 1.92 Quick asset ratio 1.06 1.06 1.06 1.11 Inventory turnover 4.21 4.91 4.86 4.76 Net profit ratio 0.05 0.03 0.03 0.03 Gross margin 0.65 0.59 0.61 0.61 Required: Provide four (4) possible explanations for the results of the various ratios for Nova Ltd and explain their implications for the...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008:                         Actual results      Budgeted results    Previous year      Industry average current ratio 1.97                    1.92                       1.87 1.92 quickasset ratio 1.06                    1.06                        1.06 1.11 Inventory turnover    4.21    4.91                       4.86    4.76 Net profit ratio 0.05    0.03                       0.03                      0.03 Gross margin           0.65                    0.59                       0.61                       0.61 Required: Provide four (4) possible explanations for the results for the various ratios for Nova Ltd and outline...
The following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1,...
The following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1, $500,000. • On 31 March 20X1, the directors decided to pay an interim cash dividend of $100,000. • On 7 April 20X1, the interim dividend was paid. • For final dividends, the company’s constitution provides that the directors can recommend a dividend to be subsequently declared by a resolution of the members in a general meeting. • The directors recommended a final dividend of...
ABC Company has the following sales budget for the last six months of 2020:
  Note: Not all sales are always collected. Remember Bad Debt Expense. So don’t worry if the problems do not add up to 100%.   1. ABC Company has the following sales budget for the last six months of 2020:                   July                             $9,000                                          August                      $8,000                                          September                 $11,000                   October                      $9,000                        Historically, the cash collection of sales has been as follows:                                     35% of sales collected in the month of sale,                                     45% of sales collected in the month...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT