Question

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 $433,200 $353,600
  Marketable securities 501,600 397,800
  Accounts and notes receivable (net) 205,200 132,600
  Inventories 831,600 539,200
  Prepaid expenses 428,400 344,800
  Total current assets $2,400,000 $1,768,000
Current liabilities:
  Accounts and notes payable
  (short-term) $348,000 $364,000
  Accrued liabilities 252,000 156,000
  Total current liabilities $600,000 $520,000

a. Determine for each year (1) the The excess of the current assets of a business over its current liabilities.working capital, (2) the A financial ratio that is computed by dividing current assets by current liabilities.current ratio, and (3) the A financial ratio that measures the ability to pay current liabilities with quick assets (cash, temporary investments, accounts receivable), computed as quick assets divided by current liabilities.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.

Homework Answers

Answer #1
Answer to Q a.
Current year Previous year
1) Working capital = Total Current assets Minus Total Current liabilities
24,00,000 - 6,00,000 17,68,000 - 5,20,000
18,00,000 12,48,000
2) Current ratio = Current assets/Current Liabilities
2400000/600000 1768000/520000
4.0 times 3.4 times
3) Quick ratio = Total current assets - Inventory - Prepaid expense / Total current Liabilities
Quick assets = (24,00,000 - 8,31,600 - 4,28,400 )/600000 (1768000 - 539200 - 344800 )/ 520000
1.9 times 1.7 times

Answer to Q b.

The liquidity of Nilo has increases from the preceding year to the current year. The working capital, current ratio, and quick ratio have all increases . Most of these changes are the result of an increase in current assets relative to current liabilities.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
17-3 17-06 Current Position Analysis The following data were taken from the balance sheet of Nilo...
17-3 17-06 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 $387,600 $291,200   Marketable securities 448,800 327,600   Accounts and notes receivable (net) 183,600 109,200   Inventories 950,400 729,600   Prepaid expenses 489,600 466,400   Total current assets $2,460,000 $1,924,000 Current liabilities:   Accounts and notes payable   (short-term) $348,000 $364,000   Accrued liabilities 252,000 156,000   Total current liabilities $600,000 $520,000 a. Determine for each year...
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 $483,400 $386,400   Marketable securities 559,700 434,700   Accounts and notes receivable (net) 228,900 144,900   Inventories 664,600 477,000   Prepaid expenses 342,400 305,000   Total current assets $2,279,000 $1,748,000 Current liabilities:   Accounts and notes payable   (short-term) $307,400 $322,000   Accrued liabilities 222,600 138,000   Total current liabilities $530,000 $460,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 $446,900 $361,200   Marketable securities 517,400 406,400   Accounts and notes receivable (net) 211,700 135,400   Inventories 161,700 104,900   Prepaid expenses 83,300 67,100   Total current assets $1,421,000 $1,075,000 Current liabilities:   Accounts and notes payable   (short-term) $284,200 $301,000   Accrued liabilities 205,800 129,000   Total current liabilities $490,000 $430,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 $335,200 $275,200   Marketable securities 388,100 309,600   Accounts and notes receivable (net) 158,700 103,200   Inventories 776,200 498,400   Prepaid expenses 399,800 318,600   Total current assets $2,058,000 $1,505,000 Current liabilities:   Accounts and notes payable   (short-term) $284,200 $301,000   Accrued liabilities 205,800 129,000   Total current liabilities $490,000 $430,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 $646,800 $537,600   Marketable securities 748,900 604,800   Accounts and notes receivable (net) 306,300 201,600   Inventories 732,600 429,400   Prepaid expenses 377,400 274,600   Total current assets $2,812,000 $2,048,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 $399,000 $317,200   Marketable securities 462,000 356,900   Accounts and notes receivable (net) 189,000 118,900   Inventories 693,000 483,700   Prepaid expenses 357,000 309,300   Total current assets $2,100,000 $1,586,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 $492,500 $403,200   Marketable securities 570,200 453,600   Accounts and notes receivable (net) 233,300 151,200   Inventories 1,188,000 768,600   Prepaid expenses 612,000 491,400   Total current assets $3,096,000 $2,268,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...
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 $303,600 $229,600   Marketable securities 351,600 258,300   Accounts and notes receivable (net) 143,800 86,100   Inventories 868,600 650,300   Prepaid expenses 447,400 415,700   Total current assets $2,115,000 $1,640,000 Current liabilities:   Accounts and notes payable   (short-term) $272,600 $287,000   Accrued liabilities 197,400 123,000   Total current liabilities $470,000 $410,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 $330,600 $260,000   Marketable securities 382,800 292,500   Accounts and notes receivable (net) 156,600 97,500   Inventories 957,000 701,500   Prepaid expenses 493,000 448,500   Total current assets $2,320,000 $1,800,000 Current liabilities:   Accounts and notes payable   (short-term) $336,400 $350,000   Accrued liabilities 243,600 150,000   Total current liabilities $580,000 $500,000 a. Determine for each year (1) the working capital, (2)...
Current Position Analysis The following data were taken from the balance sheet of Bock Suppliers Company:...
Current Position Analysis The following data were taken from the balance sheet of Bock Suppliers Company: Current Year Previous Year Cash $359,100 $264,000 Temporary investments 415,800 297,000 Accounts and notes receivable (net) 170,100 99,000 Inventories 1,205,800 872,300 Prepaid expenses 621,200 557,700 Total current assets $2,772,000 $2,090,000 Accounts and notes payable (short-term) $365,400 $385,000 Accrued liabilities 264,600 165,000 Total current liabilities $630,000 $550,000 a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio....