Question

In: Accounting

Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio The following account balances are...

Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio

The following account balances are taken from the records of Liquiform Inc.:

Cash $ 70,000
Short-term investments 60,000
Accounts receivable 80,000
Inventory 100,000
Prepaid insurance 10,000
Accounts payable 75,000
Taxes payable 25,000
Salaries and wages payable 40,000
Short-term loans payable 60,000

Required:

1. Use the information provided to compute the amount of working capital and Liquiform's current and quick ratios (round to two decimal points).

Working capital $
Current ratio to 1
Quick ratio to 1

2. Determine the effect that each of the following transactions will have on Liquiform's working capital, current ratio, and quick ratio by recalculating each and then indicating whether the measure is increased, decreased, or not affected by the transaction. Consider each transaction independently; that is, assume that it is the only transaction that takes place.

Enter all amounts as positive numbers. For the ratios, round to three decimal places.


Transaction
Working Capital Effect on
Working Capital

Current Ratio
Effect on
Current Ratio

Quick Ratio
Effect on
Quick Ratio
a. Purchased inventory on account, $20,000 $ none to 1 to 1
b. Purchased inventory for cash, $15,000 $ none to 1 to 1
c. Paid suppliers on account, $30,000 $ none to 1 to 1
d. Received cash on account, $40,000 $ none to 1 to 1
e. Paid insurance for next year, $20,000 $ none to 1 to 1
f. Made sales on account, $60,000 $ increase to 1 to 1
g. Repaid short-term loans at bank, $25,000 $ none to 1 to 1
h. Borrowed $40,000 at bank for 90 days $ none to 1 to 1
i. Declared and paid $45,000 cash dividend $ decrease to 1 to 1
j. Purchased $20,000 of short-term investments $ none to 1 to 1
k. Paid $30,000 in salaries $ decrease to 1 to 1
l. Accrued additional $15,000 in taxes $ decrease to 1 to 1

Feedback

Working capital and the current ratio both involve current assets and current liabilities. A transaction that causes an equal change in current assets and current liabilities will have no impact on working capital.

Solutions

Expert Solution

Cash $70,000 Accounts payable 75,000
Short-term investments 60,000 Taxes payable 25,000
Accounts receivable 80,000 Salaries and wages payable 40,000
Inventory 100,000 Short-term loans payable 60,000
Prepaid insurance 10,000 Total Current Liabilities 200,000 C
Total Current Assets 320,000 A
Cash $70,000
Short-term investments 60,000
Accounts receivable 80,000
Total Quick Assets $210,000 B
1 Working capital 120,000 A-C
Current ratio           1.60 to 1 A÷C
Quick ratio           1.05 to 1 B÷C
2 Working Capital Effect on Effect on Effect on
Transaction Working Capital Current Ratio Current Ratio Quick Ratio Quick Ratio
a. Purchased inventory on account, $20,000 120000 none 1.55 to 1 decrease 0.95 to 1 decrease
b. Purchased inventory for cash, $15,000 120000 none 1.60 to 1 none 0.98 to 1 decrease
c. Paid suppliers on account, $30,000 120000 none 1.71 to 1 increase 1.06 to 1 increase
d. Received cash on account, $40,000 120000 none 1.60 to 1 none 1.05 to 1 none
e. Paid insurance for next year, $20,000 120000 none 1.60 to 1 none 0.95 to 1 decrease
f. Made sales on account, $60,000 180000 increase 1.90 to 1 increase 1.35 to 1 increase
g. Repaid short-term loans at bank, $25,000 120000 none 1.69 to 1 increase 1.06 to 1 increase
h. Borrowed $40,000 at bank for 90 days 120000 none 1.50 to 1 decrease 1.04 to 1 decrease
i. Declared and paid $45,000 cash dividend 75000 decrease 1.38 to 1 decrease 0.83 to 1 decrease
j. Purchased $20,000 of short-term investments 120000 none 1.60 to 1 none 1.05 to 1 none
k. Paid $30,000 in salaries 90000 decrease 1.45 to 1 decrease 0.90 to 1 decrease
l. Accrued additional $15,000 in taxes 105000 decrease 1.49 to 1 decrease 0.98 to 1 decrease
Note: I have tried my best for correct solution still you need further help please ask in comment, Thanks.

Related Solutions

2017 2016 Current Ratio (Working Capital )              5.78           5.18 Quick Ratio      &nbs
2017 2016 Current Ratio (Working Capital )              5.78           5.18 Quick Ratio              4.90           4.60 A/R Turnover 5.91 5.53 Inventory Turnover 104.96 92.72 Gross margin 68% 66% Return on Sales 53% 52% Return on Equity 9% 6% Return on Assets 1% 1% Compare ratio analysis to trends in financial ratios over time for illustrating their impact, providing examples to support your claims.
For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio, and net working capital-to-sales...
For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio, and net working capital-to-sales ratio) Operating performance ratio (Days of Sales in Inventory, Days of Sales in Receivables), turnovers Profitability ratios (Gross Profit Margin, Operating Profit Margin, Net Profit Margin) Return on Investment ratios: (Basic Earning Power ratio, ROA, ROE) You can find financial ratios for the company for the last 3-5 years in the Internet (www.morningstar.com) a) Present the ratios as the table(s) in your project. Create...
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital...
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital of $1200, and sales of $14,500. How much does it have in inventory? 2.      Watson Co. has net income of $235,000, a return on assets of 12.5%, and a debt-equity ratio of 0.52. What is its return on equity? 3.      Lestrade Plc. has net income of $16,000 and a profit margin of 8%. It also had costs (including depreciation) of $154,000 and a tax...
SDJ, Inc., has net working capital of $1,965, current liabilities of $5,460, and inventory of $2,170. What is the current ratio? What is the quick ratio?
Calculating Liquidity Ratios SDJ, Inc., has net working capital of $1,965, current liabilities of $5,460, and inventory of $2,170. What is the current ratio? What is the quick ratio?Net Working Capital$      1,965.00Current Liabilities$      5,460.00Inventory$      2,170.00Current RatioQuick Ratio03.04 Calculating Inventory Turnover Bobaflex Corporation has ending inventory of $527,156 and cost of goods sold for the year just ended was $8,543,132. What is the inventory turnover? The days’ sales in inventory? How long on average did a unit of inventory sit on...
What effect would the following actions have on a firm's current ratio? Assume that net working capital is positive.
What effect would the following actions have on a firm's current ratio? Assume that net working capital is positive.1) inventory is sold for a profita. not change                                      b. decrease                                 c. increase                d. there is not enough information to answer this question                         
Based on the following information, compute the Working Capital and Current Ratio for both Amazon and...
Based on the following information, compute the Working Capital and Current Ratio for both Amazon and Wal-Mart. Compare your conclusions concerning the liquidity of each company in relation to each other. WAL-MART AMAZON Current Assets $54,975 $17,490 Total Assets 193,406 25,278 Current Liabilities 62,300 14,896 Total Liabilities 117,645 17,521 WORKING CAPITAL CURRENT RATIO DEBT TO ASSET RATIO
Working capital: Mukhopadhya Network Associates has a current ratio of 1.60, where the current ratio is...
Working capital: Mukhopadhya Network Associates has a current ratio of 1.60, where the current ratio is defined as follows: Current ratio = Current assets/Current liabilities. The firm's current assets are equal to $1,233,265, its accounts payables are $419,357, and its notes payables are $351,663. Its inventory is currently at $721,599. The company plans to raise funds in the short-term debt market and invest the entire amount in additional inventory. How much can note payable increase without the current ratio falling...
Explain and provide a formula for each of the following 1 working Capital 2. Current Ratio...
Explain and provide a formula for each of the following 1 working Capital 2. Current Ratio 3. Acidic- test Ratio
?5 Which one of the following will decrease net working capital? Assume the current ratio is...
?5 Which one of the following will decrease net working capital? Assume the current ratio is greater than 1.0. Multiple Choice A.Selling inventory at cost B. Collecting payment from a customer C.Paying a dividend to shareholders D.Selling a fixed asset for less than book value E. Paying a supplier for prior purchases
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio =...
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio = 1.80; current assets = $275. a. 50 b. 60 c. 80 d. 70 e. 40
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT