Question

In: Finance

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 the base year.

2017 2016 2015 2014
Sales $ 158,000 $ 615,000 $ 280,000 $ 500,000
% % % %

3.) From the following information, could you help Bill calculate his cost of merchandise sold?

Beginning inventory $ 2,500
Purchases $ 3,000
Purchase returns $ 400
Purchase discounts $ 100
Ending inventory $ 2,100
Cost of Merchandise Sold ???

4.) Al Flynn has gathered the following information. Could you help Al calculate his gross profit?

Gross sales $ 25,000
Sales discounts $ 3,000
Beg inventory $ 2,000
Net purchases $ 4,000
Ending inventory $ 2,800
Operating expense $ 1,800
Gross Profit ????


Solutions

Expert Solution

1) Ratios

a) Current Ratio = Current Assets/Current Liabilities
= 18000/16000
Current Ratio = 1.125

b) Acid Test Ratio = (Current Assets - Inventory) / Current Liabilities
= (18000 - 2000)/16000
= 16000/16000
Acid Test Ratio = 1.00

c) Average Day's Collection = Accounts Receivables/ Net Sales * 365
= 3000/41000 * 365
Average Day's Collection = 26.707 days ~ 27 days

d) Asset Turnover = Net Sales / Total Assets
= 41000/29000
Asset Turnover = 1.4138 ~ 1.41

e) Profit Margin on Sales = Net Income / Total Sales
= 6000/41000
Profit Margin on Sales = 0.146341 or 14.63%

2) Trend Analysis = (Net Sales in next year / Net Sales in current year) - 1

Year 2014 2015 2016 2017
Net Sales 500,000 280,000 615,000 158,000
Trend Analysis -44.00% 119.64% -74.31%

3) Net Purchase = Purchase - Purchase Returns - Purchase discount
= 3000 - 400 - 100
Net Purchase = 2500

Cost of Merchandise Sold = Opening Inventory + Net Purchase - Closing Inventory
= 2500 + 2500 - 2100
Cost of Merchandise Sold = $2,900

4) Net Sales = Gross Sales - Sales Discount
= 25000 - 3000
  Net Sales = 22000

Cost of Goods Sold = Opening Inventory + Net Purchase - Closing Inventory
= 2000 + 4000 - 2800
Cost of Goods Sold = $3,200

Gross Profit = Net Sales - Cost of Goods Sold
= 22000 - 3200
Gross Profit = $18,800


Related Solutions

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....
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...
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).
Indicate which of the following current assets and current liabilities are operating accounts (O) and thus...
Indicate which of the following current assets and current liabilities are operating accounts (O) and thus included in the adjustment of net income to cash flow from operating activities and which are cash (C), investing (I), or financing (F) accounts. (a) Accounts payable (b) Accounts receivable (c) Notes payable (to bank) (d) Marketable securities (e) Accrued expenses (f) Inventory (g) Prepaid expenses (h) Current portion of long-term debt (i) Dividends payable (j) Income taxes payable (k) Interest payable (l) Certificates...
11. The following accounts are listed in order of liquidity... A. Current Assets B. Current Liabilities...
11. The following accounts are listed in order of liquidity... A. Current Assets B. Current Liabilities C. Both A and B D. Long-term assets E. none of the above 13. Retained earnings are found on the... A. Balance Sheet B. Income Statement C. Neither A nor B D. Noth A and B 15. A credit entry has the following effect on a liability account.. A. Increases B. Decreases C. No effect 17. Goldstone LLC purchases a machine on credit a...
CAPTAIN JET INC. BALANCE SHEET DECEMBER 31, 2017 Current Assets Cash 41,200 Notes Receivable 16,000 Accounts...
CAPTAIN JET INC. BALANCE SHEET DECEMBER 31, 2017 Current Assets Cash 41,200 Notes Receivable 16,000 Accounts Receivable 38,800 Inventories 40,000 Prepaid Insurance 540 Prepaid Rent 500                Total Current Assets 137,040 Non-Current Assets Long-term Investments      Investments in held-for-maturity securities 51,000      Land held for future development 45,500 Property, Plant, and Equipment      Land 85,000      Buildings 291,000      Less: Accumulated Depreciation (187,500) Intangible Assets      Capitalized Development Costs 8,000      Goodwill 76,000      Other Identifiable Intangible Assets 48,000                ...
Mustang Motors. has the following assets, liabilities, revenues and expenses for the current year. The accounts...
Mustang Motors. has the following assets, liabilities, revenues and expenses for the current year. The accounts are listed below in alphabetical order. The company has a December 31st year end. Accounts receivable $27,000 Office equipment $59,500 Accounts payable 38,500 Office supplies 5,000 Building 45,000 Service revenue 102,000 Cash 60,000 Supplies expense 8,000 Commission expense 24,500 Utilities expense 18,500 Common stock 42,500 Wage expense 65,500 Interest payable 10,800 Deferred revenue 8,200 Land 40,000 Beginning retained earnings was $154,000 and dividends were...
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
Assets Liabilities and Equity Cash $ 51,000 Accounts Payable $ 23,000 Accounts Receivable 43,000 Common Stock...
Assets Liabilities and Equity Cash $ 51,000 Accounts Payable $ 23,000 Accounts Receivable 43,000 Common Stock 84,000 Land 27,000 Retained Earnings 14,000 Total $ 121,000 Total $ 121,000 The following accounting events apply to Waddell Company's Year 2 fiscal year: Jan. 1 Acquired $46,000 cash from the issue of common stock. Feb. 1 Paid $5,100 cash in advance for a one-year lease for office space. Mar. 1 Paid a $1,900 cash dividend to the stockholders. Apr. 1 Purchased additional land...
Bing, Incorporated, has current assets of $4,750, net fixed assets of $23,900, current liabilities of $3,000, and long-term debt of $13,400.
Bing, Incorporated, has current assets of $4,750, net fixed assets of $23,900, current liabilities of $3,000, and long-term debt of $13,400.a. What is the value of the shareholders' equity account for this firm? (Do not round intermediate calculations.)b. How much is net working capital? (Do not round intermediate calculations.)a. Shareholders' equity _____b. NWC ______
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT