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