In: Accounting
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:
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