Question: Create a common size balance sheet using information provided. Please show work and excel equations for each line item. What missing information do i need
Create a common size balance sheet using information provided. Please show work and excel equations for each line item. What missing information do i need to complete
| Consolidated Balance Sheets - USD ($) $ in Thousands | Dec. 31, 2019 | Dec. 31, 2018 |
| Current assets | ||
| Cash and cash equivalents | $ 788,072 | $ 557,403 |
| Accounts receivable, net | 708,714 | 652,546 |
| Inventories | 892,258 | 1,019,496 |
| Prepaid expenses and other current assets | 313,165 | 364,183 |
| Total current assets | 2,702,209 | 2,593,628 |
| Property and equipment, net | 792,148 | 826,868 |
| Operating lease right-of-use assets | 591,931 | |
| Goodwill | 550,178 | 546,494 |
| Intangible assets, net | 36,345 | 41,793 |
| Deferred income taxes | 82,379 | 112,420 |
| Other long term assets | 88,341 | 123,819 |
| Total assets | 4,843,531 | 4,245,022 |
| Current liabilities | ||
| Accounts payable | 618,194 | 560,884 |
| Accrued expenses | 374,694 | 340,415 |
| Customer refund liabilities | 219,424 | 301,421 |
| Operating lease liabilities | 125,900 | |
| Current maturities of long term debt | 0 | 25,000 |
| Other current liabilities | 83,797 | 88,257 |
| Total current liabilities | 1,422,009 | 1,315,977 |
| Long term debt, net of current maturities | 592,687 | 703,834 |
| Operating lease liabilities, non-current | 580,635 | |
| Other long term liabilities | 98,113 | 208,340 |
| Total liabilities | 2,693,444 | 2,228,151 |
| Commitments and contingencies (see Note 8) | ||
| Stockholders equity | ||
| Additional paid-in capital | 973,717 | 916,628 |
| Retained earnings | 1,226,986 | 1,139,082 |
| Accumulated other comprehensive loss | (50,765) | (38,987) |
| Total stockholders equity | 2,150,087 | 2,016,871 |
| Total liabilities and stockholders equity | 4,843,531 | 4,245,022 |
| Class A Common Stock | ||
| Stockholders equity | ||
| Common stock issued | 62 | 62 |
| Class B Convertible Common Stock | ||
| Stockholders equity | ||
| Common stock issued | 11 | 11 |
| Class C Common Stock | ||
| Stockholders equity | ||
| Common stock issued | $ 76 | $ 75 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
