Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Vockery Market Co. Balance Sheet 2018 2017 Cash 20,000 24,000 ST Investments 18,

ID: 2545211 • Letter: V

Question

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

Explanation / Answer

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%