The financial statements of Hainz Company appear below:
HAINZ COMPANY
Comparative Balance Sheet
December 31
Assets 2017 2016
Cash $20,000 $40,000
Short-term investments 20,000 60,000
Accounts receivable (net) 40,000 30,000
Inventory 60,000 70,000
Property, plant and equipment (net) 260,000 300,000
Total assets $400,000 $500,000
Liabilities and stockholders' equity
Accounts payable $20,000 $30,000
Short-term notes payable 40,000 90,000
Bonds payable 80,000 160,000
Common stock 150,000 150,000
Retained earnings 110,000 70,000
Total liabilities and stockholders' equity $400,000 $500,000
HAINZ COMPANY
Income Statement
For the Year Ended December 31, 2017
Net sales $400,000
Cost of goods sold 250,000
Gross profit 150,000
Expenses
Operating expenses $42,000
Interest expense 18,000
Total expenses 60,000
Income before income taxes 90,000
Income tax expense 27,000
Net income $63,000
Additional information:
a. Cash dividends of $23,000 were declared and paid in 2017.
b. Weighted-average number of shares of common stock outstanding during 2017 was 30,000 shares.
c. Market value of common stock on December 31, 2017, was $21 per share.
Required:
(A) Using the financial statements and additional information, compute the following ratios for Hainz Company for 2017. (Use 365 days for calculation. Round answers to 1 decimal place, e.g. 52.7.)
1. Current ratio
2. Return on common stockholders' equity %
3. Price-earnings ratio times
4. Acid-test ratio
5. Accounts receivable turnover times
6. Times interest earned times
7. Profit margin %
8. Days in inventory days
9. Payout ratio %
10. Return on assets %

Respuesta :

Answer:

(1) 2.33 (2)11.42857 times (3) 31.9375 days (4) 3.846154 times (5) 87.6 days (6) 6.00 times (7) 15.75% (8) 1 times (9) 0.35 (10) 14%

Explanation:

Solution

(1) Current ratio:

Current Ratio = Current Asset / Current Liability = =140000/60000 = 2.33

(2) The return of common equity of stockholders:

Accounts receivable turnover ratio = the net credit sales/ average accounts receivable = $400000/$35000      

11.42857 times

(3) Accounts collection period = 365/Accounts receivable turnover ratio   =365/11.42857    

31.9375 days

(4) Test acid ratio:

The Inventory Ratio Turnover  = Cost of Goods Sold/Average Inventory  

= $2,50,000/$65000      

3.846154 times

(5)  Average day to sell inventory = Inventory/Cost of Sales *365    

=60000/250000*365    

87.6 days

(6) The interest earned times:

Times Interest Earned = (Income before taxes and interest)/interest expense  

= ($90000+18000)/18000    

= 6.00 times

(7)The   Profit Margin = Net Income / Sales      

= 63000/400000      

=15.75%

(8) The asset Turnover = Sales or Revenues / Total Assets    

= $400000/400000 = 1 times

(9) Debt to asset ration = Total Liability / Total asset    

= $140000/$400000      

=0.35

(10)The return on asset ratio = Net Income/Average total asset    

= 63000/450000 =14%

Now,

The total current assets = total assets - Net property, plant, equipment = $400000-$260000 = $140000  

The Total current liabilities = [accounts payable + notes payable] $20000 + 40000 = $60000  

The Average Account Receivable = (Opening Debtors+Closing Debtors)/2 = ($30000+$40000)/2 = $35000

The Average Inventory = (Opening Inventory+Closing Inventory)/2 = ($70000+$60000)/2 = $65000  

Long-term debt + Equity = Total liabilities and equity – Total current liabilities = $275.00 – 65 = $201.00  

The Total liability = Accounts Payable+ Notes Payable+Bonds Payable = $20000+40000+80000 = 140000

The Average Total asset = (Total opening asset+ total closing asset)/2 = ($400000+$500000)/2 = $4,50,000