Based on these data, calculate the following for 2021 and 2020: i. Days' sales in receivables...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Based on these data, calculate the following for 2021 and 2020: i. Days' sales in receivables (use trade receivables) ii. Accounts receivables turnover (use gross trade receivables at year end) iii. Days' sales in inventory iv. Inventory turnover (use year-end inventory) v. Working capital vi. Current ratio vii. Acid test ratio Analyse the performance of the company based on the ratios calculated above. WESTMAN DIGITAL COMPANY CONSOLIDATED STATEMENT OF FINANCIAL POSITION (In millions, except per share data) ASSETS Current assets Cash and cash equivalents Receivables, net Inventories, net Other current assets Total current assets Property, plant, and equipment, net Goodwill Other long-term assets Total assets (In millions, except per share data) LIABILITIES AND SHAREHOLDERS' EQUITY Current liabiilties Accounts payable and other current liabilities Short-term borrowings and current portion of long-term debt Accrued income and other taxes Total current liabilities Long-term debt, net of current portion Pension and other postretirement liabilities Other long-term liabilities Total liabilities Commitments and Contingencies (Note 10) SHAREHOLDERS' EQUITY Common stock, $2.50 par value, 950,000,000 shares authorized 391,292,760 shares issued as of December 31, 2021 and 2020; 268,169,055 and 287,999,830 shares outstanding as of December 31, 2021 and 2020 Additional paid in capital Retained earnings Accumulated other comprehensive (loss) income Treasury stock, at cost; 123,123,705 shares as of December 31, 2021 and 103,292,930 shares as of December 31, 2020 Total shareholders' equity Total liabilities and shareholders' equity 2021 2021 At December 31 $ 2,145 1,716 948 195 5,004 1,551 896 1,728 $9,179 At December 31 $ 3,267 51 144 3,462 1,252 2,382 1,122 8,218 978 901 5,879 (749) 7,009 (6,048) 961 $9,179 2020 $ 2,947 1,939 943 224 6,053 1,811 1,657 4,138 $13,659 2020 $ 3,794 308 344 4,446 1,289 3,444 1,451 10,630 978 889 6,474 452 8,793 (5,764) 3,029 $13,659 NOTE 2: RECEIVABLES, NET (In millions) Trade receivables WESTMAN DIGITAL COMPANY Notes to Financial Statements (In Part) Miscellaneous receivables Total (net of allowances of $113 and $114 as of December 31, 2021 and 2020, respectively) NOTE 7: ACCOUNTS PAYABLE AND OTHER CURRENT LIABILITIES $1,716 Of the total trade receivables amounts of $1,330 million and $1,697 million as of December 31, 2021 and 2020, respectively, approximately $218 million and $266 million, respectively, are expected to be settled through customer deductions in lieu of cash payments. Such deductions represent rebates owed to the customer and are included in accounts payable and other current liabilities in the accompanying Consolidated Statement of Financial Position at each respective balance sheet date The increase in miscellaneous receivables is primarily due to an amendment to an intellectual property licensing agreement with an existing license executed during the third quarter of 2021. Under the terms of this amendment, cash consideration is to be received in 2022. Refer to Note 9, "Other Long-Term Liabilities." (In millions) Accounts payable, trade Accrued employment-related liabilities Accrued advertising and promotional expenses Deferred revenue Accrued restructuring liabilities Other Total As of December 31 2021 $1,330 386 As of December 31 2021 $1,288 520 416 217 129 697 $3,267 $1,233 727 541 414 164 715 $3,794 The other component above consists of other miscellaneous current liabilities that, individually, are less than 5% of the total current liabilities component within the Consolidated Statement of Financial Position 2020 $1,697 242 2020 $1,939 Based on these data, calculate the following for 2021 and 2020: i. Days' sales in receivables (use trade receivables) ii. Accounts receivables turnover (use gross trade receivables at year end) iii. Days' sales in inventory iv. Inventory turnover (use year-end inventory) v. Working capital vi. Current ratio vii. Acid test ratio Analyse the performance of the company based on the ratios calculated above. WESTMAN DIGITAL COMPANY CONSOLIDATED STATEMENT OF FINANCIAL POSITION (In millions, except per share data) ASSETS Current assets Cash and cash equivalents Receivables, net Inventories, net Other current assets Total current assets Property, plant, and equipment, net Goodwill Other long-term assets Total assets (In millions, except per share data) LIABILITIES AND SHAREHOLDERS' EQUITY Current liabiilties Accounts payable and other current liabilities Short-term borrowings and current portion of long-term debt Accrued income and other taxes Total current liabilities Long-term debt, net of current portion Pension and other postretirement liabilities Other long-term liabilities Total liabilities Commitments and Contingencies (Note 10) SHAREHOLDERS' EQUITY Common stock, $2.50 par value, 950,000,000 shares authorized 391,292,760 shares issued as of December 31, 2021 and 2020; 268,169,055 and 287,999,830 shares outstanding as of December 31, 2021 and 2020 Additional paid in capital Retained earnings Accumulated other comprehensive (loss) income Treasury stock, at cost; 123,123,705 shares as of December 31, 2021 and 103,292,930 shares as of December 31, 2020 Total shareholders' equity Total liabilities and shareholders' equity 2021 2021 At December 31 $ 2,145 1,716 948 195 5,004 1,551 896 1,728 $9,179 At December 31 $ 3,267 51 144 3,462 1,252 2,382 1,122 8,218 978 901 5,879 (749) 7,009 (6,048) 961 $9,179 2020 $ 2,947 1,939 943 224 6,053 1,811 1,657 4,138 $13,659 2020 $ 3,794 308 344 4,446 1,289 3,444 1,451 10,630 978 889 6,474 452 8,793 (5,764) 3,029 $13,659 NOTE 2: RECEIVABLES, NET (In millions) Trade receivables WESTMAN DIGITAL COMPANY Notes to Financial Statements (In Part) Miscellaneous receivables Total (net of allowances of $113 and $114 as of December 31, 2021 and 2020, respectively) NOTE 7: ACCOUNTS PAYABLE AND OTHER CURRENT LIABILITIES $1,716 Of the total trade receivables amounts of $1,330 million and $1,697 million as of December 31, 2021 and 2020, respectively, approximately $218 million and $266 million, respectively, are expected to be settled through customer deductions in lieu of cash payments. Such deductions represent rebates owed to the customer and are included in accounts payable and other current liabilities in the accompanying Consolidated Statement of Financial Position at each respective balance sheet date The increase in miscellaneous receivables is primarily due to an amendment to an intellectual property licensing agreement with an existing license executed during the third quarter of 2021. Under the terms of this amendment, cash consideration is to be received in 2022. Refer to Note 9, "Other Long-Term Liabilities." (In millions) Accounts payable, trade Accrued employment-related liabilities Accrued advertising and promotional expenses Deferred revenue Accrued restructuring liabilities Other Total As of December 31 2021 $1,330 386 As of December 31 2021 $1,288 520 416 217 129 697 $3,267 $1,233 727 541 414 164 715 $3,794 The other component above consists of other miscellaneous current liabilities that, individually, are less than 5% of the total current liabilities component within the Consolidated Statement of Financial Position 2020 $1,697 242 2020 $1,939
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations for the ratios requested i Days sales in receivables 2021 Trade receivable... View the full answer
Related Book For
Financial Reporting and Analysis Using Financial Accounting Information
ISBN: 978-1133188797
13th edition
Authors: Charles H. Gibson
Posted Date:
Students also viewed these finance questions
-
Determine how much needs to be invested if you want to end up with $5000 in interest after 7 years of simple interest at 1.8% APR. Starting investment= 39682.54 dollars. Your answer must be accurate...
-
a. Based on these data, calculate the following for 2010 and 2009: 1. Days sales in receivables (use trade receivables) 2. Accounts receivable turnover (use gross trade receivables at year- end) 3....
-
Sithabiso's Wraps is an all-organic restaurant located near State University. It is managed by Eunice Ndlovu, and Eunice is preparing her first-quarter cash budget for this year. It is important to...
-
At year-end 2010, 28,879 million represents: A. the funded status of the plan. B. the defined benefit obligation. C. the fair value of the plans assets. Kensington plc, a hypothetical company based...
-
As seen from above, a playground carousel is rotating counterclockwise about its center on frictionless bearings. A person standing still on the ground grabs onto one of the bars on the carousel very...
-
The following questions relate to audit procedures for property and equipment. Select the best response. a. In the examination of property, plant, and equipment, the auditor tries to determine all of...
-
Wdiat is the net income for the year as a percentage of total operating revenue?
-
Based on the manager identified in Question 3, in what ways did that person exhibit or fail to exhibit each of the components of leadermember exchange (LMX)? Did you have a high or low LMX with that...
-
2 What is the focus of the parabola y = -4x - 1? Simplify any fractions. DO Submit
-
Kaitlin Carlton, a CPA sole practitioner, prepares tax returns each year for approximately 100 clients. Items 1 through 8 each represent an independent factual situation in which Kaitlin has prepared...
-
Explore the impacts of the Coronavirus, the war in Ukraine, and other recent events and policies on supply and demand dynamics. Find articles using the sources listed below to identify fluctuations...
-
What are some of the key issues and questions that need to be addressed during mergers and acquisitions? How do firms handle the business valuation of an acquisition? Include your own experience as...
-
How does the organizational culture facilitate or hinder the adoption of new technologies and digital transformation, and what practices encourage a culture of continuous learning and adaptation ?
-
How long will it take to save $2601.00 by making deposits of $178.00 at the end of every month into an account earning interest at 4% compounded monthly?
-
What are the primary barriers to successful organizational change, and how can transformational leaders proactively address these obstacles to ensure a smooth transition and sustainable outcomes ?
-
2. A U-shaped vessel contains water (pw-1000. kg/m) and oil (po-810. kg/m). The fluids do not mix. Answer these questions explaining why your answer makes sense given the equation P = Po+pgAh (a)...
-
John Stantus is 32 years old and single. John has no dependentsand is the sole owner of Stantus Accounting Services, Co. Hestarted the company, which is organized as a sole proprietorship,on Februa 1...
-
[a] Two foam blocks, each with a charge of 19 micro coulombs (1 C = 10-6 C), are both held in place 19 cm apart in the east-west direction. A foam ball with a charge 49 C is placed 55 cm north of the...
-
The Boyer Company manufactures snow blowers. It has been a warm fall and sales have declined materially. This has resulted in a buildup of inventory. Required a. In early December the Boyer Company...
-
Lucas County, Ohio presented the following table in its comprehensive annual financial report for the fiscal year ended December 31, 2010: Required a. Complete a horizontal common- size analysis. Use...
-
Whole Foods Market, Inc. included these statements in its 2010 annual report.* Required a. Compute the following for 2010 and 2009: 1. Net profit margin 2. Total asset turnover (use year- end assets)...
-
In early January 2005, a company acquires equipment for $3,800.The company estimates this equipment to have a useful life of three years and a salvage value of $200. Early in 2007, the company...
-
A company acquires equipment on January 10, 2005, at a cost of $42,000. Straight-line depreciation is used with a five-year life and $7,000 salvage value. On June 27, 2006, the company sells this...
-
hsteban Co. owns a machine that costs $38,400 with accumulated depreciation of $20,400. Esteban exchanges the machine for a similar but newer model that has a market value of $48,000. Record the...
Study smarter with the SolutionInn App