Question

In: Accounting

Assets 2019 2018 Cash 175,000 88,000 Acc Receivable 130,000 102,000 INventory 127,600 173,000 Prepaid Expenses 8,800...

Assets 2019 2018

Cash 175,000 88,000

Acc Receivable 130,000 102,000

INventory 127,600 173,000

Prepaid Expenses 8,800 10,800

Total Current Assets 441,400 373,800

Plant and Equipment 248,000 130,000

Acc Dep.- Plant and Equip (54,000) (18,000)

Total Assets 635,400 585,800

Liabilities and equity

Accounts Payable 50,000 60,000

Wages Payable 12,000 30,000

Income Tax Payable 6,800 7,600

Total Current Liabilities 68,800 97,600

Notes Payable (Long Term) 60,000 120,000

Total Liabilities 128,800 217,600

Equity

Common Stock $2 per value 440,000 320,000

Retained Earnings 66,600 48,200

Total Liabilities and Equity 635,700 585,800

Income Statement

Sales 1,356,000

COGS 822,000

Gross Profit 534,000

operating expenses

depreciation expenses 117,200

other expense 134,000

Total operating expenses 251,200

282,800

other gains (losses)

gain on sale of car 4,000

income before taxes 286,000

income tax expense 87,780

NI 199,020

Question: calculate

1. working capital

2. current ratio

3. quick ratio

4. account receivable ratio

5. inventory turnover

6. days of sale inventory

7. eps of common stock

8. equity ratio

9.profit margin

10. gross margin

11. gross margin

12. return on total assets

13. return on common stock holders equity,

Solutions

Expert Solution

Answer :

Working Capital = Current Assets - Current Liabilities.

Current assets $ 441,400.

Current Liabilities $ 68,800.

$441,400 -$68,800

, working Capital =$372,600.

Current Ratio= Current Assets / Current Liabilities.

$441,400 / $$68,800

Current Ratio = 6.42

Quick ratio = Quick assets / current liabilities.

Quick assets = Cash + Marketable securities + Accounts Receivable

$ 175,000 Cash + $ 130,000 Accounts Receivable + $0 ( no Marketable securities )

$ 305,000.

Current liabilities $ 68,800.

Quick ratio = $305,000 /$68,800.

Quick ratio = 4.43

Accounts receivable turnover Ratio = Net Credit Sales / Avarage Accounts Receivable.

Net Credit Sales :$ 1,356,000 ( in absence of information all sale is considered as credit sales ).

Avarage Accounts receivable = $ 130,000 + $ 102,000 = $ 116,000

$ 1,356,000 / $ 116,000

Accounts Receivable turnover ratio = 11.69

Inventory Turnover = COGS / Average inventory.

COGS = $ 822,000

Avarage Inventory = $ 127,600 + $ 173,000 / 2

$ 150,300.

Inventory Turnover = $822,000 / $150,300.

5.47..

Days of sale inventory = Number of total days in year 365 /inventory Turnover ratio.

365 / 5.47 ( calculated in 5.)

Days of sale inventory = 66.73 days

Earning per share for common stock = Net income - preferred Dividend / Weighted Average number of common shares outstanding.

Net income = $ 199,020 -$0 =$ 199,020.

Weighted average number of common shares = 220,000 ( $440,000 total share value / $2 per share ).

Earning per share = $199,020 / 220,000.

$ 0.90 per share.

Equity Ratio = shareholders equity / total assets.

Shareholder Equity = $ 440,000 + $ 66,600 = $ 506,600.

Total assets = $ 635,400.

Equity Ratio = $506,600/ $ 635400

0.80

Profit margin = Net profit / Net Sales.

Net Profit = $ 199,020.

Net sales = $ 1,356,000.

Profit margin = $ 199,020 / $ 1,356,000.

14.68%.

10.

Gross margin = gross Profit / net sales

Gross Profit = $ 534,000

Net sales = $ 1,356,000.

Gross margin = $ 534,000 / $ 1,356,000

39.38%

11. Gross margin same as 10.

12.

Return on total assets = Net income / total assets.

Net income = $ 199,020.

Total assets = $ 635,400.

Return on total assets = $ 199,020 / $ 635,400.

31.32%

13.

Return on common stock holders Equity = Net income / average common stock holders Equity

Net income = $ 199,020.

Avarage common stock holders Equity = $ 506,600* + $ 368,200** /2

$437,400.

Return on common stock holders Equity = Net income / average common stock holders Equity.

$ 199,020 / $ 437,400

45.50%

* Total of stocks holders Equity 2019 $ 440,000 + $ 66,600 = $ 506,600.

** Total of stocks holders Equity 2018 $ 320,000 + $ 48,200 = $ 368,200.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Assets Cash $ 57,400 $ 78,500 Accounts receivable 73,320 55,625 Inventory 283,156 256,800 Prepaid expenses 1,260...

Assets Cash $ 57,400 $ 78,500 Accounts receivable 73,320 55,625 Inventory 283,156 256,800 Prepaid expenses 1,260 1,995 Total current assets 415,136 392,920 Equipment 152,500 113,000 Accum. depreciation—Equipment (39,125 ) (48,500 ) Total assets $ 528,511 $ 457,420 Liabilities and Equity Accounts payable $ 58,141 $ 122,175 Short-term notes payable 11,500 7,000 Total current liabilities 69,641 129,175 Long-term notes payable 62,500 53,750 Total liabilities 132,141 182,925 Equity Common stock, $5 par value 172,750 155,250 Paid-in capital in excess of par, common...

Balance Sheet ASSETS Cash $96,000 Accounts receivable 31,000 Inventory 41,000 Prepaid expenses 18,000 Total current assets...

Balance Sheet ASSETS Cash $96,000 Accounts receivable 31,000 Inventory 41,000 Prepaid expenses 18,000 Total current assets $186,000 Gross plant and equipment 403,000 Accumulated depreciation (69,000) Total assets $520,000 LIABILITIES AND OWNERS' EQUITY Accounts payable $89,000 Accrued liabilities 62,000 Total current liabilities $151,000 Long-term debt 130,000 Common stock 206,000 Retained earnings 33,000 Total liabilities and equity $520,000 Income Statement Sales* $211,000 Cost of goods sold (85,000) Gross profit $126,000 Selling, general, and administrative expenses (27,000) Depreciation expenses (28,000) Operating income $71,000...

Balance Sheet Assets: 12/31/19 Current Assets: Cash $3,000.00 Accounts Receivable 1,250.00 Prepaid Expenses $100.00 Total Current...

Balance Sheet Assets: 12/31/19 Current Assets: Cash $3,000.00 Accounts Receivable 1,250.00 Prepaid Expenses $100.00 Total Current Assets $4,350.00 Non-Current Assets: Property, Plant, and Equipment Land $10,000.00 Buildings 25,000.00 Equipment 15,000.00 Accumulated Depreciation $(12,000.00) Total Property, Plant, and Equipment $38,000.00 Total Assets $42,350.00 Liabilities: Current Liabilities Accounts Payable $100.00 Accrued Expense 150.00 Salary and Wages Payable - Notes Payable - Unearned Revenue $1,500.00 Total Liabilities $1,750.00 Shareholder's Equity Common Stock - $1 par (See Note Below) $15,000.00 Retained Earnings $25,600.00 Total...

Data TABLE: 2016 2015 Current Assets: Cash $93,200 $24,000 Accounts Receivable 64,200 69,100 Merchandise Inventory 88,000...

Data TABLE: 2016 2015 Current Assets: Cash $93,200 $24,000 Accounts Receivable 64,200 69,100 Merchandise Inventory 88,000 82,000 Current Liabilities: Accounts Payable $57,700 $55,500 Income Tax Payable 14,100 16,400 Transaction Data for 2016: Issuance of common stock for cash $44,000 Payment of notes payable $48,100 Depreciation expense 19,000 Payment of cash dividends 51,000 Purchase of equipment with cash 80,000 Issuance of notes payable to borrow cash 58,000 Acquisition of land by issuing long-term notes payable 119,000 Gain on sale of building...

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts...

Assets 2019 2018 Amount Cash & equivalents $20,000.00 Cash & equivalents $10,000.00 Accounts Receivable $15,000.00 Accounts Receivable $25,000.00 Inventory $10,000.00 Inventory $15,000.00 Total current assets $45,000.00 Total current assets $50,000.00 Net Plant and equipment $50,000.00 Net Plant and equipment $60,000.00 Total assets $95,000.00 Total assets $110,000.00 Liabilities and equity Liabilities and equity Accounts payable $5,000.00 Accounts payable $7,000.00 Accruals $2,000.00 Accruals $3,000.00 Notes payable $10,000.00 Notes payable $5,000.00 Total current liabilities $17,000.00 Total current liabilities $15,000.00 Long term debts $25,000.00...

Balance Sheet Current assets Cash 1,050,000 Acc receivable not given Inventories 1,500,000 Fixed assets 4,280,000 TOTAL...

Balance Sheet Current assets Cash 1,050,000 Acc receivable not given Inventories 1,500,000 Fixed assets 4,280,000 TOTAL ASSETS 7,500,000 Current liabilities Acc payable not given Long-term debt 2,300,000 Common stock 600,000 Retained earnings 3,960,000 TOTAL LIAB and EQUITY 7,500,000 Income Statement Sales 22,500,000 Operating expense 18,680,000 EBIT 3,820,000 Interest expense 230,000 EBT 3,590,000 Taxes 1,436,000 Net income 2,154,000 What is the firm's quick ratio?

Balance Sheet Current assets Cash 870,000 Acc receivable not given Inventories 1,050,000 Fixed assets 3,220,000 TOTAL...

Balance Sheet Current assets Cash 870,000 Acc receivable not given Inventories 1,050,000 Fixed assets 3,220,000 TOTAL ASSETS 6,200,000 Current liabilities Acc payable not given Long-term debt 1,900,000 Common stock 680,000 Retained earnings 3,190,000 TOTAL LIAB and EQUITY 6,200,000 Income Statement Sales 18,600,000 Operating expense 14,320,000 EBIT 4,280,000 Interest expense 266,000 EBT 4,014,000 Taxes 1,606,000 Net income 2,408,000 What is the firm's debt ratio? 30.65% 37.58% 62.42% 93.06% 89.03%

Balance Sheet Current assets Cash 870,000 Acc receivable not given Inventories 1,050,000 Fixed assets 3,220,000 TOTAL...

Balance Sheet for J & P Industries 2018 Current assets Cash 215 Accounts receivable 310 Inventory...

Balance Sheet for J & P Industries 2018 Current assets Cash 215 Accounts receivable 310 Inventory 328 Total current assets 853 Fixed assets Net plant and equipment 6,527 Total assets 7,380 Current liabilities Accounts payable 298 Notes payable 1,427 Total currrent liabilities 1,725 Long-term debt 2,308 Owners' equity Common stock and paid in surplus 1,000 Retained earnings 2,347 Total owners' equity 3,347 Total liabilities and owners' equity 7,380 Income Statement for J & P Sales 4,053.00 Cost of goods sold...

Balance Sheets Assets 2019 2018 Cash and equivalents $100 $85 Accounts receivable 275 300 Inventories 375 ...

Balance Sheets Assets 2019 2018 Cash and equivalents $100 $85 Accounts receivable 275 300 Inventories 375 250 Total current assets $750 $635 Net plant and equipment 2,300 1,490 Total assets $3,050 $2,125 Liabilities and Equity Accounts payable $150 $85 Accruals 75 50 Notes payable 150 75 Total current liabilities $375 $210 Long-term debt 450 290 Total liabilities 825 500 Common stock 1,225 1,225 Retained earnings 1,000 400 Common equity 2,225 1,625 Total liabilities and equity $3,050 $2,125 Income Statements 2019...

Subjects