70.2K

Verified Solution

Link Copied!

Part 4 Needed.

Part 4: Throughout the project, you have been asked a number of questions relating to the Balance Sheet of ABC Compary. 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 Sheat of ABC Company using voice-over PowerPoint. Based on the inderences you make from your horizontal analysis, discuss any improvements andlor changes that may have occurred since the prior year: Consider addressing the items that the Board of Directors requested infocmation on throughout the project: (1) Accounts Receivabies and the process for uncollectible accounts; (2) Payroll Liabilties as well as other Current or Long-Term liabilities; and (3) the fypes of investments held by ABC Company. Keep in mind the intended audience of your presentation A 12 SBC COMPANY 2 B.L.ACE SHE.T 3 Nr Decenber 31, 20K2 and Decenber 31, 20XI 202 20x1. Dollar Change *hange 5 Assets 6 Cument Arsets. 7 Casta and casb cyuivalents 8 Tradieg Secunties 9 Accounts recenvable 10 Allowince for doobtful acoounts 11 Accounts rocecivable, net 12. Invertotes 13 Propad exponies and other mocivables 14 Avalable forsile socuritios 15 Total current aiset 16 17 Property, plant and esupment, net 18 lotangible Assets. 19 Tatal assets \begin{tabular}{|r|r|r|} \hline 5 & 247,225 & 165,010 \\ \hline 5 & 48,000 & 39,600 \\ \hline 5 & 28,000 & 19,500 \\ \hline & (5,000) & (2,900) \\ \hline 5 & 23,000 & 16,600 \\ \hline 5 & 2,450 & 3,600 \\ \hline 5 & 1,200 & 750 \\ \hline 5 & 17,750 & 14,005 \\ \hline 5 & 339,625 & 242,565 \\ \hline 5 & & \\ \hline 5 & 404,550 & 299,050 \\ \hline 5 & 300 & 300 \\ \hline \end{tabular} 21. Liabilitios abd Sharcbelden' Equity 22 Curcht Liabelities 23 Salaries Payable 24 FICA-Social Secunty Tanes Payable 25 FICA-Medicare Taxes Payblie. 26 Employee Federal lnoome Tuxer Payable 27 State Unemployment Trxes Payble 28 Foderal Unemployment Taxes Payable 29. Notes payable or cument portion of long-tern debt 30 Acoounts pyyable 31 Total curret liabilides Losk-tertin deh. Tetal Ilabilities Starcholder' eguity Conmon stock, $10 per valoe, 50,000 shares authonsod; 20,000 shares ispeed and cutstanding Reainod camings \begin{tabular}{|l|l|r|} \hline 5 & 275,000 & 220,000 \\ \hline 5 & 128,700 & 69,436 \\ \hline \end{tabular} Iotal sharcholden' equify Tetal liabilities and sharcholders' equity \begin{tabular}{|lll} \hline S & 403,700 & 289,436 \\ \hline s & 744,475 & 541,915 \\ \hline \end{tabular} Part 4: Throughout the project, you have been asked a number of questions relating to the Balance Sheet of ABC Compary. 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 Sheat of ABC Company using voice-over PowerPoint. Based on the inderences you make from your horizontal analysis, discuss any improvements andlor changes that may have occurred since the prior year: Consider addressing the items that the Board of Directors requested infocmation on throughout the project: (1) Accounts Receivabies and the process for uncollectible accounts; (2) Payroll Liabilties as well as other Current or Long-Term liabilities; and (3) the fypes of investments held by ABC Company. Keep in mind the intended audience of your presentation A 12 SBC COMPANY 2 B.L.ACE SHE.T 3 Nr Decenber 31, 20K2 and Decenber 31, 20XI 202 20x1. Dollar Change *hange 5 Assets 6 Cument Arsets. 7 Casta and casb cyuivalents 8 Tradieg Secunties 9 Accounts recenvable 10 Allowince for doobtful acoounts 11 Accounts rocecivable, net 12. Invertotes 13 Propad exponies and other mocivables 14 Avalable forsile socuritios 15 Total current aiset 16 17 Property, plant and esupment, net 18 lotangible Assets. 19 Tatal assets \begin{tabular}{|r|r|r|} \hline 5 & 247,225 & 165,010 \\ \hline 5 & 48,000 & 39,600 \\ \hline 5 & 28,000 & 19,500 \\ \hline & (5,000) & (2,900) \\ \hline 5 & 23,000 & 16,600 \\ \hline 5 & 2,450 & 3,600 \\ \hline 5 & 1,200 & 750 \\ \hline 5 & 17,750 & 14,005 \\ \hline 5 & 339,625 & 242,565 \\ \hline 5 & & \\ \hline 5 & 404,550 & 299,050 \\ \hline 5 & 300 & 300 \\ \hline \end{tabular} 21. Liabilitios abd Sharcbelden' Equity 22 Curcht Liabelities 23 Salaries Payable 24 FICA-Social Secunty Tanes Payable 25 FICA-Medicare Taxes Payblie. 26 Employee Federal lnoome Tuxer Payable 27 State Unemployment Trxes Payble 28 Foderal Unemployment Taxes Payable 29. Notes payable or cument portion of long-tern debt 30 Acoounts pyyable 31 Total curret liabilides Losk-tertin deh. Tetal Ilabilities Starcholder' eguity Conmon stock, $10 per valoe, 50,000 shares authonsod; 20,000 shares ispeed and cutstanding Reainod camings \begin{tabular}{|l|l|r|} \hline 5 & 275,000 & 220,000 \\ \hline 5 & 128,700 & 69,436 \\ \hline \end{tabular} Iotal sharcholden' equify Tetal liabilities and sharcholders' equity \begin{tabular}{|lll} \hline S & 403,700 & 289,436 \\ \hline s & 744,475 & 541,915 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer