In: Accounting
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 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.
| Current year |
| Working Capital=(Current Assets - Current Liabilities) |
| Working capital= 2139000-690000=$1449000 |
| Current Ratio:- Current Asset/ Current Liability |
| =(2139000/690000)= 3.1 |
| Quick Ratio:- (Current Asset- Inventory- Prepaid Expense)/ Current Liability |
| =(2139000-683100-351900)/690000=1.6 |
| Previous year |
| Working Capital=(Current Assets - Current Liabilities) |
| Working capital= 1560000-600000=$960000 |
| Current Ratio:- Current Asset/ Current Liability |
| =(1560000/600000)= 2.6 |
| Quick Ratio:- (Current Asset- Inventory- Prepaid Expense)/ Current Liability |
| =(1560000-475800-304200)/600000=1.3 |
| b. The Liquidity of Nilo has increase from the preceeding year to the current year . The Wrking capitotal , current ratio, and quick ratio all incresed. Most of these changes are resut of an increased in Current Asset relative to current liabilities. |