Current position analysis The following data were taken from the balance sheet of Nilo Company at...

Transcribed Image Text:

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 $332,700 $252,800 Marketable securities 438,200 298,300 Accounts and notes receivable (net) 539,500 358,900 Inventories 840,300 574,100 Prepaid expenses 415,500 356,900 Total current assets $2,566,200 $1,841,000 Current liabilities: Accounts and notes payable (short-term) $565,500 $466,700 Accrued liabilities 214,500 Total current liabilities $780,000 233,300 $700,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round the ratios to one decimal place and the working capital to the nearest dollar. Current Year Previous Year 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has improved ratio have all increased liabilities. from the preceding year to the current year. The working capital, current ratio, and quick Most of these changes are the result of a(n) increase in current assets relative to current 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 $332,700 $252,800 Marketable securities 438,200 298,300 Accounts and notes receivable (net) 539,500 358,900 Inventories 840,300 574,100 Prepaid expenses 415,500 356,900 Total current assets $2,566,200 $1,841,000 Current liabilities: Accounts and notes payable (short-term) $565,500 $466,700 Accrued liabilities 214,500 Total current liabilities $780,000 233,300 $700,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine for each year (1) the working capital, (2) the current ratio, and (3) the quick ratio. Round the ratios to one decimal place and the working capital to the nearest dollar. Current Year Previous Year 1. Working capital 2. Current ratio 3. Quick ratio b. The liquidity of Nilo has improved ratio have all increased liabilities. from the preceding year to the current year. The working capital, current ratio, and quick Most of these changes are the result of a(n) increase in current assets relative to current