Sign In Sign Up Ask an AI advisor
970032036
970032036
03.06.2021 • 
Business

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 $467,400 $353,400 Marketable securities 615,600 417,000 Accounts and notes receivable (net) 757,800 501,600 Inventories 529,000 196,100 Prepaid expenses 261,600 121,900 Total current assets $2,631,400 $1,590,000 Current liabilities: Accounts and notes payable (short-term) $855,500 $706,700 Accrued liabilities 324,500 353,300 Total current liabilities $1,180,000 $1,060,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 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 $fill in the blank 2 $fill in the blank 3 2. Current ratio fill in the blank 4 fill in the blank 5 3. Quick ratio fill in the blank 6 fill in the blank 7 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 a(n) in current assets relative to current liabilities.

Solved
Show answers

Ask an AI advisor a question

I want advice