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. |