Question

In: Accounting

Shown below are selected data from the financial statements of planet Company, a retain lighting store

Shown below are selected data from the financial statements of planet Company, a retain lighting store.

From the Balance Sheet:

Cash................................................................................................... $ 40,000

Accounts receivable........................................................................... 165,000

Inventory............................................................................................ 215,000

Plant assets (net of accumulated depreciation).................................. 600,000

Current liabilities............................................................................... 185,000

Total stockholders’ equity................................................................. 400,000

Total assets........................................................................................ 1,200,000

From the Income Statement:

Net sales............................................................................................. $2,000,000

Cost of goods sold............................................................................. 1,600,000

Operating expenses............................................................................ 300,000

Interest expense................................................................................. 75,000

Income taxes expense........................................................................ 5,000

Net income......................................................................................... 20,000

From the Statement of Cash Flows:

Net cash provided by operating activities

(including interest paid of $68,000)............................................... $ 42,000

Net cash used in investing activities.................................................. (49,000)

Financing activities:

Amounts borrowed................................................. $ 60,000

Repayment of amounts borrowed........................... (20,000)

Dividends paid........................................................ (25,000)

Net cash provided by financing activities................................... 15,000

Net increase in cash during the year.................................................. $ 8,000

Required:

  1. Explain how the interest expense shown in the income statement could be $75,000, when the interest payment appearing in the statement of cash flows is only $68,000.
  2. Work out the following (round to one decimal place):
    1. Current ratio
    2. Quick ratio
    3. Working capital
    4. Debt ratio
  3. Comment on these measurements and evaluate Planet’s short-term debit-paying ability.
  4. Compute the following ratios (assume that the year-end amounts of total assets and total stockholders’ equity also represent the average amounts throughout the year):
    1. Return on assets
    2. Return on equity
  5. Comment on the company’s performance under these measurements. Sufficiently explain why the return on assets and return on equity are so different.
  6. Discuss (i) the apparent safety of long-term creditors’ claims and (ii) the prospects for Planet Co. continuing its dividend payments at the present level.

Solutions

Expert Solution

The detailed answer for the above question is provided below:

 

a.   Interest expense is based on the accrual concept whereas the cash flow statement records the expenses based on cash expense only. 

 

b.   Current ratio= Current assets/current liabilities

                          = 420000/185000   = 2.270

      Quick ratio= current assets-inventory/current liabilities

                       = 1.108

      Working capital= Current assets- current liabilities

                              = 420000-185000  = 235000

      Debt ratio= Total debts/Total assets

                     = 185000/1200000= 0.154

 

c. Higher current ratio or quick ratio indicates better liquidity for the company. 

 

d. Return on assets= Net income /Total assets  

                               = 20000/1200000   =  1.667

   Return on equity= Net income /Shareholder's Equity

                             = 20000/400000   = 5

 


Related Solutions

Below is selected financial information from the financial statements of company A and company B. Both...
Below is selected financial information from the financial statements of company A and company B. Both company A and company B started their business on 1/1/2019. Company A Company B current assets on 12/31/2019 100 8,000 total assets on 12/31/2019 11,000 28,000 current liability on 12/31/2019 200 4,000 total liability on 12/31/2019 4,000 18,000 sales revenue on 12/31/2019 4,500 20,000 Cost of goods sold for year 2019 1,000 16,000 interest expense for year 2019 400 1,000 net income for year...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the return on assets for the year, presenting your answer in percentage terms, rounded to two decimal places. e.g. 20.00%. Sales $117,358 Gross profits $51,639 Operating profits (EBIT) $32,879 Earnings before taxes (EBT) $25,389 Net profits $24,739 Tax expense 8,000 Depreciation expense $13,207 Total assets, beg of year $80,302 Total assets, end of year $99,082 Total equity, beg of year $46,237 Total equity, end of year $53,675...
Selected financial data from the June 30 year-end statements of Safford Company are given below:   Total...
Selected financial data from the June 30 year-end statements of Safford Company are given below:   Total assets $ 5,700,000   Long-term debt (11% interest rate) $730,000   Total stockholders’ equity $ 2,400,000   Interest paid on long-term debt $80,300   Net income $470,000      Total assets at the beginning of the year were $5,500,000; total stockholders’ equity was $2,200,000. The company’s tax rate is 40%. Required: 1. Compute the return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the gross profit...
Selected data from the financial statements of KRJ Manufacturing are presented below. Calculate the gross profit margin, presenting your answer in percentage terms, rounded to two decimal places. e.g. 20.00%. Sales $107,262 Cost of goods sold $51,727 Operating profits (EBIT) $32,852 Earnings before taxes (EBT) $28,308 Net profits $18,706 Tax expense 8,310 Depreciation expense $14,562 Total assets, beg of year $89,075 Total assets, end of year $83,449 Total equity, beg of year $42,951 Total equity, end of year $40,310 Cash...
The financial statements for Linked Ltd. are shown below:
The financial statements for Linked Ltd. are shown below: During the year, the company purchased a capital asset valued at $30,000; payment was made by issuing common shares. Additional capital assets were acquired for cash. Changes in other accounts were typical transactions. Required:1. Prepare the SCF using the indirect method. Include required note disclosure of non-cash transactions. Omit the separate disclosure of cash flow for interest, investment income, and income tax.2. Explain the company’s cash transactions for the year, based...
Financial Ratios Financial statements for Paulson's Pet Store are shown. Paulson's Pet Store Income Statement For...
Financial Ratios Financial statements for Paulson's Pet Store are shown. Paulson's Pet Store Income Statement For Year Ended December 31, 20-- Revenue from sales:    Sales $326,040    Less: Sales returns and allowances 5,360       Net sales $320,680 Cost of goods sold:    Merchandise inventory, January 1, 20-- $29,300    Estimated returns inventory, January 1, 20-- 900 $30,200    Purchases $162,630    Less: Purchases returns and allowances $4,080    Less: Purchases discounts 3,200 7,280    Net purchases $155,350    Add freight-in 1,600       Cost of goods purchased 156,950    Goods available for...
The following selected data were taken from the financial statements of Aggie Company. Dec 31, 2018...
The following selected data were taken from the financial statements of Aggie Company. Dec 31, 2018 Dec 31, 2019 Accounts receivable $380,000 $360,000 Rent receivable 3,200 3,360 Inventories 180,000 176,000 Supplies 1,360 2,000 Property, plant, & equipment 400,000 480,000 Accumulated depreciation 80,000 84,000 Accounts payable 216,000 212,000 Other accrued liabilities 40,800 43,200 Retained earnings 72,000 100,160 In addition, you have learned that property, plant, and equipment with a historical cost of $16,000 was sold during the year for cash. Accumulated...
Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills,...
Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills, Inc., for its fiscal year ended May 25, 2014 ($ millions): Cash and Cash Equivalents $867.3 Net Cash from Operations 2,541.0 Sales 17,909.6 Stockholders' Equity 7,005.4 Cost of Goods Sold 11,539.8 Net Cash from Financing (1,824.1) Total Liabilities 16,140.3 Other Expenses, including income taxes 4,508.5 Noncash Assets 22,278.4 Net Cash from Investing (561.8) Net Income 1,861.3 Effect of exchange rate changes on cash (29.2)...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for its fiscal year ended July 30, 2016 ($ millions). Cash, ending year $7,631    Total liabilities $58,067 Cash from operating activities 13,570    Cash from financing activities (4,699) Sales 49,247    Noncash assets 114,021 Stockholders' equity 63,585    Cash from investing activities (8,117) Cost of goods sold 18,287    Net income 10,739 Total expense (other than cost of goods sold) 20,221    Cash, beginning...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 29, 2016 ($ millions): *Cash from financing activites includes the effects of foreign exhange rate fluctuations. Revenue $16,563.1 Cost of goods sold $10,733.6 Cash from operating activities 2,629.8 Cash, ending year 763.7 Cash, beginning year 334.2 Total liabilities 16,405.2 Stockholders' equity 5,307.1 Cash from investing activities 93.4 Noncash assets 20,948.6 Total expenses (other than cost of goods sold) 4,092.7...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT