can someone help me and let me know how i can explain this
Part 4: Throughout the project, you have been asked a number of questions relating to the Balance Sheet of ABC Company. Using the Balance Sheet found below. performa horizontal analysis. Once complete, use your new version of the Balance Sheet to present and discuss the Balance Sheet of ABC Company using voice-over PowerPoint or YouTube. 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. ABC Company Balance Sheet.xls ABC COMPANY BALANCE SHEET At December 31, 20x2 and December 31, 20X1 20X2 20x1 Dollar Change * Change 182.225 48,000 28,000 (5,000) 23,000 2,450 200 17,750 296,625 149,010 39.600 19.500 2.900) 16,600 3,600 750 14,005 234,165 304,550 300 601475 299,050 300 533515 Current Assets Cash and cash equivalents $ * Trading Securities - Accounts receivable 10 Allowance for doubthail accounts 11 Accounts receivable, net 12 Inventores 13 Prepaid expenses and other receivables 74 Available for sale securities 15 Total current assets $ 16 17 Property, plant and equipment, net 18 Intangible Assets 19 Total assets 20 21 Liabilities and Shareholders' Equity 22 Current Liabilities 23 Salaries Payable 24 FICA-Social Security Taxes Payable 25 FICA Medicare Taxes Payable 26 Employee Federal Income Taxes Payable 27 State Unemployment Taxes Payable 28 Federal Unemployment Taxes Payable 29 Notes payable or current portion of long-term debt 30 Accounts payable 31 Total current liabilities 32 33 Long-term debt 34 Total liabilities 35 36 Shareholders' equiry 37 Common stock, 510 per value; 50,000 shares authorized: 20,000 shares issued and outstanding 38 Retained eamings 39 40 Total shareholders eruity 41 Total liabilities and shareholders' eauit Balance Sheet $5,000 10,540 2,465 8,500 756 84 24,000 14.030 145 375 61,950 7,682 1.797 6,000 540 60 24,000 17.050 119,079 104 400 249.775 128.400 247,479 200,000 151,700 200,000 86,036 351,700 601.475 286,036 533515 20X2 20x1 Dollar Change * Change 182.225 48,000 28,000 5.000) 21,000 2,450 200 17,750 296,625 143,010 39,600 19,500 (2.900 16,600 3,600 750 14,005 234,165 304,550 300 601 475 299,050 300 533,515 ABC COMPANY 2 BALANCE SHEET 3 At December 31, 20x2 and December 31, 20x1 4. 5 Assets 6 Current Assets Cash and cash equivalents s 8 Trading Securities 9 Accounts receivable 10 Allowance for doubtful accounts 11 Accounts receivable, net 12 Inventories 13 Prepaid expenses and other receivables 14 Available for sale securities 15 Total current assets 16 17 Property, plant and equipment, net 18 Intangible Assets 19 Total assets 20 21 Liabilities and Shareholders' Equity 22 Current Liabilities 3 Salaries Payable 24 FICA-Social Securty Taxes Payable 25 FICA Medicare Taxes Payable 26 Employee Federal Income Taxes Payable 27 State Unemployment Taxes Payable 28 Federal Unemployment Taxes Payable 29 Notes payable or current portion of long-term debt $ 30 Accounts payable 31 Total current liabilities 32 33 Long-term debt 34 Total liabilities $ 35 36 Shareholders' equiry 57 Common stock, $10 per value; 50,000 shares authorized: 20,000 shares issued and outstanding 38 Retained eamings 39 80 Total shareholders' equity 31 Total liabilities and shareholders' equity S Balance Sheet 85,000 10,540 2,465 8,500 756 34 24,000 14030 145 375 61,950 7,682 1.797 6,000 540 60 24,000 17.050 119,079 104,400 249,775 125.400 247.4479 200,000 151,700 200,000 $6,036 351.700 601.475 286,036 533.515
