The following data were taken from the balance sheet of Nilo Company at the end

Question

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 Marketable securities Accounts and notes receivable (net) Inventories Prepaid expenses $472,000 546,500 223,500 500,900 258,100 $2,001,000 $384,000 432,000 144,000 256,200 163,800 $1,380,000 Total current assets Current liabilities Accounts and notes payable $400,200 289,800 $690,000 $420,000 180,000 $600,000 (short-term) Accrued liabilities Total current liabilities 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

Explanation / Answer

a) current year previous year

1) working capital

{current asset - shorterm liability} $1,311,000 $780,000

(2,001,000-690,000) (1,380,000-600,000)

2) current ratio

{current asset / current liability} 2.9 times 2.3 times

(2,001,000/690,000) (1,380,000/600,000)

3) quick ratio

{ current asset - inventory /(current liability ) } 2.17 times 1.87 times

(2,001,000-500,900/(690,000)) (1,380,000-256,200/(600,000))

ACCOUNT RECIEVABLE ANALYSIS

a) 20Y3 20Y2

1) account recievable turnover

{sales/ recievables} 6.09 times 5.44 times

(732,190/120,000) (696,420/128,000)

2) number of days

{recievables /sales *365) 60 days 67 days

(120,000/732,190*365) (128,000/696,420*365)

  

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.