Question

In: Finance

Given: Total current assets (CA), $14,000; accounts receivable (AR), $5,500; total cur- rent liabilities (CL), $9,000;...

Given: Total current assets (CA), $14,000; accounts receivable (AR), $5,500; total cur- rent liabilities (CL), $9,000; inventory (Inv), $3,900; net sales, $36,500; total assets, $32,000; net income (NI), $8,000. Calculate:

a. Current ratio.

b. Acid test.

c. Average day’s collection.

d. Profit margin on sales (round to the nearest hundredth percent).

Solutions

Expert Solution

(a) Current ratio = Current assets / Current liabilities

Current assets = $14000, Current liabilities = $9000

Current ratio = $14000 / $9000 = 1.55

(b) Acid test ratio = Current assets – Inventories – Prepaid expenses / Current liabilities

Current assets = $14000, Current liabilities = $9000, Inventories = $3900

Acid test ratio = ($14000 - $3900) / $9000

Acid test ratio = $10100 / $9000 = 1.12

(c) For average day's collection, we need to calculate receivables turnover ratio as below:

Receivable turnover ratio = Sales / Accounts receivables

Sales = $36500, Accounts receivables = $5500

Putting these values in the receivable turnover ratio formula, we get,

Receivables turnover ratio = $36500 / $5500 = 6.64

Now, we will calculate Average day's collection as below:

Avearge day's collection = 365 / Accounts receivable turnover ratio

Receivable turnover ratio = 6.64 times ( as computed above)

Putting these values in the Avearge day's collection formula, we get,

Average day's collection = 365 / 6.64 = 54.97 days

(d) Profit margin on sales = Net income / Sales * 100

Net income = $8000, Sales = $36500

Net Profit margin = $8000 / $36500 * 100 = 21.92%


Related Solutions

1.) Given the following: Current Assets $ 18,000 Accounts Receivable $ 3,000 Current Liabilities $ 16,000...
1.) Given the following: Current Assets $ 18,000 Accounts Receivable $ 3,000 Current Liabilities $ 16,000 Inventory $ 2,000 Net Sales $ 41,000 Total Assets $ 29,000 Net Income $ 6,000 Find the following (round to the nearest hundredth if needed): A. Current ratio ? B. Acid test ? C. Average day's collection ? days D. Asset Turnover ? E. Profit margin on sales ? 2.) Complete using trend analyses for sales. Round to nearest percent and use 2014 as...
For each transaction below, write the net effect on Current Assets (CA), Current Liabilities (CL), Gross...
For each transaction below, write the net effect on Current Assets (CA), Current Liabilities (CL), Gross Profit (GP), Net Income Before Taxes (NIBT), and Cash flows from operating activities (CFO). Write 0 for no effect and use negative numbers to indicate reductions in accounts or cash outflows. Assume warranty expenses are recognized in COGS and bad debt expenses are recognized in SG&A. Transaction CA CL GP NI (pretax) CFO Recognize bad debt expense of $85 Write off $22 of Accounts...
Current assets Current liabilities Cash $72,000 Accounts payable $12,000 Accounts receivable 18,000 Interest payable 12,000 Interest...
Current assets Current liabilities Cash $72,000 Accounts payable $12,000 Accounts receivable 18,000 Interest payable 12,000 Interest receivable 1,000 Inventory 60,000 Total current assets $151,000 Total current liabilities $24,000 Long-term assets Long-term liabilities Equipment (net of depreciation) $128,000 Note payable 100,000 Total long-term assets $128,000 Total long-term liabilities $100,000 Equity Common stock 10,000 Paid-in capital 50,000 Retained earnings 95,000 Total equity $155,000 Total assets 279,000 Total liabilities and equity $279,000 Yes the difference between account payable and accounts receivable is required....
Duffert Industries has total assets of $1,050,000 and total current liabilities (consisting only of accounts payable...
Duffert Industries has total assets of $1,050,000 and total current liabilities (consisting only of accounts payable and accruals) of $150,000. Duffert finances using only long-term debt and common equity. The interest rate on its debt is 9% and its tax rate is 40%. The firm's basic earning power ratio is 15% and its debt-to capital rate is 40%. What are Duffert's ROE and ROIC? Do not round your intermediate calculations. a. 9.04%; 8.93% b. 16.12%; 11.66% c. 13.90%; 10.50% d....
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable...
You are given the following information. Calculate Total Liabilities. Cash and equivalents is $85 accounts receivable are $87 inventory is $66 net fixed assets is $199 accounts payable is $92 accruals are $99 notes payable are $81 long term debt is $82
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities...
($ in millions) Current assets 115 Fixed and other assets 165 Total assets 280 Current liabilities 81 Long-term debt 48 Stockholders' equity 151 Total liabilities and equity 280 Common shares outstanding (millions) 14 Total revenues 436 Total operating costs and expenses 350 Interest expense 15 Income taxes 23 Net profits 48 Dividends paid to common stockholders 13 On the basis of this​ information, calculate as many​ liquidity, activity,​ leverage, profitability, and common stock measures as you can. ​(​Note: Assume the...
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...
A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets...
A firm has Current Assets of $500,000, Inventory of $200,000, Current Liabilities of $700,000, Total Assets of $3,000,000 and Total Liabilities of $3,500,000. Which of the following statements is correct: a. this firm is bankrupt b. this firm has a Quick Ratio that is greater than one c. this firm has positive equity d. this firm is technically insolvent
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...
year 2016 current assets cash 8814 accounts receivable 22053 inventory 38422 total 69289 fixed assets net...
year 2016 current assets cash 8814 accounts receivable 22053 inventory 38422 total 69289 fixed assets net plant equipment 216790 total asset 286259 liabilities and owners equity current liability accounts payable 42498 not payable 19064 total 61562 long term debt 25600 owners equity common stock and paid in surplus 39600 accumulated retain earnings 159497 total 199097 total liability and owners equity 286259 finding common size
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT