In: Accounting
| Vockery Market Co. | ||||
| Balance Sheet | ||||
| 2018 | 2017 | |||
| Cash | 20,000 | 24,000 | ||
| ST Investments | 18,000 | 26,000 | ||
| Net Accounts Receivable | 50,000 | 78,000 | ||
| Inventory | 70,000 | 66,000 | ||
| Prepaid Expenses | 12,000 | 10,000 | ||
| Total Current Assets | 170,000 | 204,000 | ||
| PP&E | 105,000 | 85,000 | ||
| Total Assets | 275,000 | 289,000 | ||
| Prepare a horizontal and vertical analysis of Total Assets | ||||
| HORIZONTAL ANALYSIS | |||||||||
| 2018 | 2017 | Net Increase/(Decrease) | % Increasse/(Decrease) | ||||||
| Cash | 20000 | 24000 | -4000 | -16.67% | |||||
| ST investment | 18000 | 26000 | -8000 | -30.77% | |||||
| Net Accounts recivable | 50000 | 78000 | -28000 | -35.90% | |||||
| Inventory | 70000 | 66000 | 4000 | 6.06% | |||||
| Prepaid expense | 12000 | 10,000 | 2000 | 20% | |||||
| Total current Assets | 170000 | 204000 | -34000 | -16.67% | |||||
| PP &E | 105000 | 85000 | 20000 | 23.53% | |||||
| Total Assets | 275000 | 289000 | -48000 | 16.61% | |||||
| VERTICAL ANALYSIS | |||||||||
| 2018 | % OF TOTAL ASSETS | 2017 | % OF TOTAL ASSETS | ||||||
| Cash | 20000 | 7.27% | 24000 | 8.30% | |||||
| ST investment | 18000 | 6.55% | 26000 | 9.00% | |||||
| Net Accounts recivable | 50000 | 18.18% | 78000 | 26.99% | |||||
| Inventory | 70000 | 25.45% | 66000 | 22.84% | |||||
| Prepaid expense | 12000 | 4.36% | 10,000 | 3.46% | |||||
| Total current Assets | 170000 | 61.82% | 204000 | 70.59% | |||||
| PP &E | 105000 | 38.18% | 85000 | 29.41% | |||||
| Total Assets | 275000 | 100% | 289000 | 100% | |||||