I have done my horizontal line as you can see below with formula current year - previous year (20x2-20x1) I also have done the percentage change which is the dollar change divided by the previous year how ever I am having trouble understanding the improvements and/or changes that may have occurred on what she's asked for...
Based on the inferences you make from your horizontal analysis, discuss any improvements and/or changes that may have occurred since the prior year. Consider addressing the items that the Board of Directors requested information on throughout the project: (1) Accounts Receivables and the process for uncollectible accounts; (2) Payroll Liabilities as well as other Current or Long-Term liabilities; and (3) the types of investments held by ABC Company. Keep in mind the intended audience of your presentation.
before horizontal analysis
ABC COMPANY BALANCE SHEET At December 31, 20%2 and December 31, 20X1 20X2 20X1 Dollar Change % Change Assets Current Assets Cash and cash equivalents 182,225 143,010 Trading Securities 48,000 39,600 Accounts receivable 28,000 19,500 Allowance for doubtful accounts (5,000) 2,900) 11 Accounts receivable, net 23,000 16,600 12 Inventories 2,450 3,600 13 Prepaid expenses and other receivables 200 750 14 Available-for-sale securities 17,750 14,005 15 Total current assets 296,625 234,165 16 Property, plant and equipment, net 304,550 299,050 Intangible Assets 300 Total assets 601,475 533,515 21 Liabilities and Shareholders' Equity 22 Current Liabilities Salaries Payable 85,000 61,950 FICA-Social Security Taxes Payable 10.540 7.682 FICA-Medicare Taxes Payable 2,465 1,797 6 Employee Federal Income Taxes Payable 8.500 000'9 State Unemployment Taxes Payable 756 540 Federal Unemployment Taxes Payable 84 Notes payable or current portion of long-term debt $ 24,000 24,000 Accounts payable 14,030 17,050 1 Total current liabilities 45.375 19,079 12 13 Long-term debt 104,400 128, 400 Total liabilities 249,775 247,479 16 Shareholders' equity Common stock, $10 per value; 50,000 shares authorized; 20,000 shares issued and outstanding 200,000 200,000 18 Retained carings 151,700 86,036 39 10 Total shareholders' equity 351,700 286,036 1 Total liabilities and shareholders' equity 601,475 533,515A B C D E F G ABC COMPANY BALANCE SHEET At December 31, 20X2 and December 31, 20X1 20X2 20X1 Dollar Change % Change Assets 6 Current Assets Cash and cash equivalents S 182,225 143,010 39,215 27.4% 8 Trading Securities 48,000 39,600 8,400 21.2% Accounts receivable 28,000 19,500 8,500 43.0% 10 Allowance for doubtful accounts (5,000) 2,900) (2, 100) 72.4% 11 Accounts receivable, net 23,000 16,600 6,400 38.0% 12 Inventories 2,450 3,600 (1,150) 31.9% 13 Prepaid expenses and other receivables 200 750 550) 73.3% 14 Available-for-sale securities 17,750 14,005 3,745 26.7% 15 Total current assets 296,625 234,165 62,460 26.7% 16 17 Property, plant and equipment, net 304,550 299,050 5,500 1.84% 18 Intangible Assets 300 300 0.0% 19 Total assets 601,475 $33,515 67.960 12.74% 20 21 Liabilities and Shareholders' Equity 22 Current Liabilities 23 Salaries Payable 85,000 61,950 23,050 37.21% 24 FICA-Social Security Taxes Payable 10,540 7,682 2,858 37.20% 25 FICA-Medicare Taxes Payable 2,465 1,797 668 37.17% 26 Employee Federal Income Taxes Payable 8,500 6,000 2,500 41.67% State Unemployment Taxes Payable 756 540 216 40.00% 28 Federal Unemployment Taxes Payable 84 24 40.00% 29 Notes payable or current portion of long-term debt $ 24,000 24,000 0.00% 30 Accounts payable 14,030 17,050 (3,020) 17.71% 31 Total current liabilities 145,375 119,079 16,296 2.08% 3.2 33 Long-term debt 104,400 128, 40 24,000) -18.69% 34 Total liabilities 249,775 247,479 2,296 1.93% 35 36 Shareholders' equity Common stock, $10 per value; 50,000 shares authorized; 20,000 shares issued and outstanding 200,000 200,000 0.00% Retained earnings 151,700 86,036 65,664 76.32% 39 Total shareholders' equity 351,700 286,036 65,664 22.96% 41 Total liabilities and shareholders' equity 01,475 $33,515 $7,960 2.74% 42