Throughout the project, you have been asked a number of questions relating to the Balance Sheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 1 ABC COMPANY 2 BALANCE SHEET 3 At December 31, 20X2 and December 31, 20X1 4 5 Assets 6 Current Assets 7 8 O 9 10 11 Accounts receivable, net 12 Inventories 24 25 25 43 44 Cash and cash equivalents Trading Securities Accounts receivable 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 32 WA 45 46 13 Prepaid expenses and other receivables 14 Available-for-sale securities 15 Total current assets Allowance for doubtful accounts Allo 26 Employee Federal Income Taxes Payable 27 27 State Unemployment Taxes Payable 28 28 Federal Unemployment Taxes Payable 29 Notes payable or current portion of long-term debt 30 Accounts payable 20 31 Total current liabilities S FICA-Social Security Taxes Payable FICA-Medicare Taxes Payable 33 Long-term debt 20 34 Total liabilities 35 36 Shareholders' equity 37 Common stock, $10 per value; 50,000 shares authorized; 20,000 shares issued and outstanding Retained earnings 38 39 40 Total shareholders' equity 41 Total liabilities and shareholders' equity 42 A S S S S S B S S $ S S $ 11 S S S S S S $ S S S S S S $ $ C 20X2 247,225 48,000 28,000 (5,000) 23,000 2,450 1,200 17,750 339,625 404,550 300 744,475 75,000 10,540 2,465 8,500 756 84 24,000 15,030 136,375 204,400 340,775 275,000 128,700 403,700 744,475 D 20X1 168,010 39,600 19,500 (2,900) 16,600 3,600 750 14,005 242,565 299,050 300 541,915 66,950 7,682 1,797 6,000 540 60 24,000 17,050 124,079 128,400 252,479 220,000 69,436 289,436 541,915 E Dollar Change F % Change G H 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. 1 ABC COMPANY 2 BALANCE SHEET 3 At December 31, 20X2 and December 31, 20X1 4 5 Assets 6 Current Assets 7 8 O 9 10 11 Accounts receivable, net 12 Inventories 24 25 25 43 44 Cash and cash equivalents Trading Securities Accounts receivable 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 32 WA 45 46 13 Prepaid expenses and other receivables 14 Available-for-sale securities 15 Total current assets Allowance for doubtful accounts Allo 26 Employee Federal Income Taxes Payable 27 27 State Unemployment Taxes Payable 28 28 Federal Unemployment Taxes Payable 29 Notes payable or current portion of long-term debt 30 Accounts payable 20 31 Total current liabilities S FICA-Social Security Taxes Payable FICA-Medicare Taxes Payable 33 Long-term debt 20 34 Total liabilities 35 36 Shareholders' equity 37 Common stock, $10 per value; 50,000 shares authorized; 20,000 shares issued and outstanding Retained earnings 38 39 40 Total shareholders' equity 41 Total liabilities and shareholders' equity 42 A S S S S S B S S $ S S $ 11 S S S S S S $ S S S S S S $ $ C 20X2 247,225 48,000 28,000 (5,000) 23,000 2,450 1,200 17,750 339,625 404,550 300 744,475 75,000 10,540 2,465 8,500 756 84 24,000 15,030 136,375 204,400 340,775 275,000 128,700 403,700 744,475 D 20X1 168,010 39,600 19,500 (2,900) 16,600 3,600 750 14,005 242,565 299,050 300 541,915 66,950 7,682 1,797 6,000 540 60 24,000 17,050 124,079 128,400 252,479 220,000 69,436 289,436 541,915 E Dollar Change F % Change G H
Expert Answer:
Related Book For
Statistics For Business And Economics
ISBN: 9780132745659
8th Edition
Authors: Paul Newbold, William Carlson, Betty Thorne
Posted Date:
Students also viewed these accounting questions
-
As a new project manager, you have been asked to consider using the AS4071 structure for your software development project plan. What aspects of this template would you change? Why?
-
As the CPA for Bonita Inc., you have been asked to develop some key ratios from the comparative financial statements. This information is to be used to convince creditors that the company is solvent...
-
As a consultant, you have been asked to recommend either a gainsharing plan or a profit-sharing plan for employees who work in the four regional distribution and warehousing facilities of a large...
-
Solve the inequality. Write the solution in interval notation. |-3x + 1 5
-
In his most famous novel, The Red and the Black, the French author Stendhal (1783 1842) wrote: There is no such thing as natural law: this expression is nothing but old nonsense. Prior to laws, what...
-
Create a Case Study: Recycle4Change (R4C) - Enabling a Sustainable Recycling System 1. Introduction: Recycle4Change (R4C) is a social enterprise initiative under Chance Creators, affiliated with the...
-
Briefly explain the main difference between exchange-traded funds (ETFs) and mutual funds?
-
As a manager of a department store, you must deal with a variety of business transactions. Place the letter of each of the following transactions next to the effect it has on the accounting equation....
-
Create a code (that is both effective and efficient) that asks the user to enter a sales amount. The code should calculate the effective discount based on the entered sales amount and the net payable...
-
Huimin Ltd. had the following account balances at December 2021 1 3 25 29 32 30 33 Huimin Ltd. had the following account balances at Decemb Account Name Dividends Prepaid expenses Interest...
-
Summarize HR's role in corporate strategy and the activities related to strategy formation. Use examples from the module to support your summary.
-
Prepare journal entries for the following transactions for the current year Note: Use 360 days a year. April 25 Accepted a $6,400, 90-day, 9% note from a customer in granting a time extension on its...
-
Thoughts on why if five students take a test and the scores are 95, 95, 90, 90, and 20 then the mean is 78. Even though the majority of the students scored 90 or above, the extreme outlier score of...
-
Find the product. (6+7x)2
-
Given that P(A)=0.3 , P(B)=0.6 and P(A AND B)=0.15 . Are the events A and B independent?
-
A water park offers a 5 % discount on student tickets. which value is equivalent to 5 % ?
-
Annie is collecting pledges for a walk -a-thon. Her mother donation of $40, and her grandmother has pledged $2 per walks a certain distance, the two donors will end up owin What is that distance?
-
3M Company reports the following financial statement amounts in its 10-K report: a. Compute the receivables, inventory, and PPE turnover ratios for both 2018 and 2017. (Receivables turnover and...
-
Write brief reports, including examples, explaining the use of each of the following in specifying regression models: a. Dummy variables b. Lagged dependent variables c. The logarithmic transformation
-
Test the hypothesis H0: 2x = 2y H1: 2x > 2y using the following data. a. s2x = 125, ny = 45; s2y = 51, ny = 41 b. s2x = 125, ny = 45; s2y = 235, ny = 44 c. s2x = 134, ny = 48; s2y = 51, ny = 41 d....
-
A mortgage company randomly samples accounts of their time-share customers. State whether each of the following variables is categorical or numerical. If categorical, give the level of measurement....
-
Emily Stansbury is a licensed dentist. During the first month of the operation of her business, the following events and transactions occurred. Emily uses the following chart of accounts: No. 101...
-
Indicate how a journal is used in the recording process.
-
Transactions for Thorn Consulting for the month of June are presented below. Identify the accounts to be debited and credited for each transaction. June 1 2 Oleg Thorn invests 5,000 cash in a small...
Study smarter with the SolutionInn App