BALANCE SHEET At December 31, 2032 and December 31, 20X1 20X2 20X1 Dollar Change * | 49 3 15 $ Axels Ciment Assets Cash and cash equivalent Trading Securities Accounts receivable Allowance for doubtful con Accounts receivable nel Inventories Prepaid expenses and other receivables Available for sale securities Total current sets 5 $ S s 5 247,225 48.000 30 5.000 23,000 2.450 1.200 17.750 3:39,625 168,010 39,600 19.500 2.900 16,000 3,600 750 14.00 242,565 Property, plant and equipment, net Intangible Assets Total anses S 5 5 404550 MO 744.475 199,050 100 541.915 Liabilities and Shareholders' Equity Current Libilities Salaries Payable FICA Social Security Teses Payable FICA-Medicare Taxes Payable Employee Federal Income Taxes Payable State Unemployment The Payable Federal Unemployment Taxes Payable Notes payable or current portion of long-term dicht Accounts payable Total current liabilities S 5 5 $ 5 5 $ S S 75.000 10.540 2.465 3.500 756 $4 34,000 15.00 136.175 66,950 7.682 1.793 6. 540 60 24,000 17,050 124.079 S S 204,400 340,775 138,400 252.479 Long-term debet Total libilities 220.000 Shareholders' equity Common stock, S10 per valut: 50,000 chans authorized 20.000 sharessed and outstanding Retained earnings S $ 275.000 125.700 403.700 T44A75 219.436 41.915 Total shareholderslegity Total liabilities and shareholders equity 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, perform a 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 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 BALANCE SHEET At December 31, 2032 and December 31, 20X1 20X2 20X1 Dollar Change * | 49 3 15 $ Axels Ciment Assets Cash and cash equivalent Trading Securities Accounts receivable Allowance for doubtful con Accounts receivable nel Inventories Prepaid expenses and other receivables Available for sale securities Total current sets 5 $ S s 5 247,225 48.000 30 5.000 23,000 2.450 1.200 17.750 3:39,625 168,010 39,600 19.500 2.900 16,000 3,600 750 14.00 242,565 Property, plant and equipment, net Intangible Assets Total anses S 5 5 404550 MO 744.475 199,050 100 541.915 Liabilities and Shareholders' Equity Current Libilities Salaries Payable FICA Social Security Teses Payable FICA-Medicare Taxes Payable Employee Federal Income Taxes Payable State Unemployment The Payable Federal Unemployment Taxes Payable Notes payable or current portion of long-term dicht Accounts payable Total current liabilities S 5 5 $ 5 5 $ S S 75.000 10.540 2.465 3.500 756 $4 34,000 15.00 136.175 66,950 7.682 1.793 6. 540 60 24,000 17,050 124.079 S S 204,400 340,775 138,400 252.479 Long-term debet Total libilities 220.000 Shareholders' equity Common stock, S10 per valut: 50,000 chans authorized 20.000 sharessed and outstanding Retained earnings S $ 275.000 125.700 403.700 T44A75 219.436 41.915 Total shareholderslegity Total liabilities and shareholders equity 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, perform a 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 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