Question
In: Accounting
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo Company at the end of two recent fiscal years:
| Current Year | Previous Year | |||||||
| Current assets: | ||||||||
| Cash | $297,200 | $224,000 | ||||||
| Marketable securities | 344,100 | 252,000 | ||||||
| Accounts and notes receivable (net) | 140,700 | 84,000 | ||||||
| Inventories | 880,400 | 658,800 | ||||||
| Prepaid expenses | 453,600 | 421,200 | ||||||
| Total current assets | $2,116,000 | $1,640,000 | ||||||
| Current liabilities: | ||||||||
| Accounts and notes payable | ||||||||
| (short-term) | $266,800 | $280,000 | ||||||
| Accrued liabilities | 193,200 | 120,000 | ||||||
| Total current liabilities | $460,000 | $400,000 | ||||||
a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round ratios to one decimal place.
| Current Year | Previous Year | |||||
| 1. Working capital | $ | $ | ||||
| 2. Current ratio | ||||||
| 3. Quick ratio | ||||||
b. The liquidity of Nilo has from the preceding year to the current year. The working capital, current ratio, and quick ratio have all . Most of these changes are the result of an in current assets relative to current liabilities.
Solutions
Expert Solution
a.
| Current Year | Previous Year | |
| 1. Working capital | $1,656,000 | $1,240,000 |
| 2. Current ratio | 4.6 | 4.1 |
| 3. Quick ratio | 1.7 | 1.4 |
Working:
| 1 | Working capital = Current assets - Current liabilities |
| Current Year: $2116000 - $460000 = $1656000 | |
| Previous Year: $1640000 - $400000 = $1240000 | |
| 2 | Current ratio = Current assets/Current liabilities |
| Current year: $2116000/$460000 = 4.6 | |
| Previous year: $1640000/$400000 = 4.1 | |
| 3 | Quick ratio = Quick assets/Current liabilities |
| Quick assets = Cash + Marketable securities + Accounts and notes receivable | |
| Current year: | |
| Quick assets = $297200 + $344100 + $140700 = $782000 | |
| Quick ratio = $782000/$460000 = 1.7 | |
| Previous year: | |
| Quick assets = $224000 + $252000 + $84000 = $560000 | |
| Quick ratio = $560000/$400000 = 1.4 |
b. The liquidity of Nilo has increased from the preceding year to the current year. The working capital, current ratio, and quick ratio have all increased. Most of these changes are the result of an increase in current assets relative to current liabilities.
ekkarill92 answered 1 year agoRelated Solutions
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$424,100
$324,000
Marketable securities
491,000
364,500
Accounts and notes receivable
(net)
200,900
121,500
Inventories
982,100
658,800
Prepaid expenses
505,900
421,200
Total current assets
$2,604,000
$1,890,000
Current liabilities:
Accounts and notes payable
(short-term)
$359,600
$378,000
Accrued liabilities
260,400
162,000
Total current liabilities
$620,000
$540,000
a. Determine for each year (1) the working
capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$340,500
$268,800
Marketable securities
394,200
302,400
Accounts and notes receivable
(net)
161,300
100,800
Inventories
1,056,000
683,200
Prepaid expenses
544,000
436,800
Total current assets
$2,496,000
$1,792,000
Current liabilities:
Accounts and notes payable
(short-term)
$371,200
$392,000
Accrued liabilities
268,800
168,000
Total current liabilities
$640,000
$560,000
a. Determine for each year (1) the working
capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$492,500
$403,200
Marketable securities
570,200
453,600
Accounts and notes receivable
(net)
233,300
151,200
Inventories
617,800
422,700
Prepaid expenses
318,200
270,300
Total current assets
$2,232,000
$1,701,000
Current liabilities:
Accounts and notes payable
(short-term)
$417,600
$441,000
Accrued liabilities
302,400
189,000
Total current liabilities
$720,000
$630,000
a. Determine for each year (1) the working
capital, (2)...
The following data were taken from the balance sheet of Nilo Company at the end of...
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$458,700
$347,200
Marketable securities
531,100
390,600
Accounts and notes receivable
(net)
217,200
130,200
Inventories
1,546,400
1,134,600
Prepaid expenses
796,600
725,400
Total current assets
$3,550,000
$2,728,000
Current liabilities:
Accounts and notes payable
(short-term)
$411,800
$434,000
Accrued liabilities
298,200
186,000
Total current liabilities
$710,000
$620,000
a. Determine for each year (1) the working
capital, (2)...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$421,800
$307,200
Marketable securities
488,400
345,600
Accounts and notes receivable
(net)
199,800
115,200
Inventories
1,611,700
1,132,200
Prepaid expenses
830,300
723,800
Total current assets
$3,552,000
$2,624,000
Current liabilities:
Accounts and notes payable
(short-term)
$429,200
$448,000
Accrued liabilities
310,800
192,000
Total current liabilities
$740,000
$640,000
a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$535,000
$448,000
Marketable securities
619,500
504,000
Accounts and notes receivable
(net)
253,500
168,000
Inventories
887,000
614,900
Prepaid expenses
457,000
393,100
Total current assets
$2,752,000
$2,128,000
Current liabilities:
Accounts and notes payable
(short-term)
$371,200
$392,000
Accrued liabilities
268,800
168,000
Total current liabilities
$640,000
$560,000
a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis The following data were taken from the
balance sheet of Nilo Company at the end of two recent fiscal
years: Current Year Previous Year Current assets: Cash $556,300
$445,200 Marketable securities 644,200 500,900 Accounts and notes
receivable (net) 263,500 166,900 Inventories 603,900 452,600
Prepaid expenses 311,100 289,400 Total current assets $2,379,000
$1,855,000 Current liabilities: Accounts and notes payable
(short-term) $353,800 $371,000 Accrued liabilities 256,200 159,000
Total current liabilities $610,000 $530,000 a. Determine for each
year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$419,500
$312,000
Marketable securities
485,800
351,000
Accounts and notes receivable
(net)
198,700
117,000
Inventories
683,100
475,800
Prepaid expenses
351,900
304,200
Total current assets
$2,139,000
$1,560,000
Current liabilities:
Accounts and notes payable
(short-term)
$400,200
$420,000
Accrued liabilities
289,800
180,000
Total current liabilities
$690,000
$600,000
a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$425,600
$317,200
Marketable securities
492,800
356,900
Accounts and notes receivable
(net)
201,600
118,900
Inventories
646,800
372,100
Prepaid expenses
333,200
237,900
Total current assets
$2,100,000
$1,403,000
Current liabilities:
Accounts and notes payable
(short-term)
$406,000
$427,000
Accrued liabilities
294,000
183,000
Total current liabilities
$700,000
$610,000
a. Determine for each year (1) the...
Current Position Analysis The following data were taken from the balance sheet of Nilo Company at...
Current Position Analysis
The following data were taken from the balance sheet of Nilo
Company at the end of two recent fiscal years:
Current Year
Previous Year
Current assets:
Cash
$334,400
$249,600
Marketable securities
387,200
280,800
Accounts and notes receivable
(net)
158,400
93,600
Inventories
798,600
585,600
Prepaid expenses
411,400
374,400
Total current assets
$2,090,000
$1,584,000
Current liabilities:
Accounts and notes payable
(short-term)
$319,000
$336,000
Accrued liabilities
231,000
144,000
Total current liabilities
$550,000
$480,000
a. Determine for each year (1) the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT