50.1K

Verified Solution

Link Copied!

In excel, perform horizontal analysis of the balance sheet.

Summarize the balance sheet results of the horizontal analysis. Simply select some of the higher or lower %s to discuss. Focus on items you feel are more relevant and telling of the company operations. For example, you could write one paragraph on each section of the balance sheet i.e. assets, liabilities, equity.

December 2020 $ 3,160 $ 1,978 9,545 3,545 1,150 19,378 7,213 10,806 3,012 3,475 6,826 $ 50,710 $ Assets Current assets Cash and cash equivalents Receivables, net Contract assets Inventories Other current assets Total current assets Property, plant and equipment, net Goodwill Intangible assets, net Deferred income taxes Other noncurrent assets Total assets Liabilities and equity Current liabilities Accounts payable Contract liabilities Salaries, benefits and payroll taxes Current maturities of long-term debt Other current liabilities Total current liabilities Long-term debt, net Accrued pension liabilities Other noncurrent liabilities Total liabilities Stockholders' equity Common stock, $1 par value per share $ 880 $ 7,545 3,163 500 1,845 13,933 11,669 12,874 6,196 44,672 279 Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total stockholders' equity Noncontrolling interests in subsidiary Total equity Total liabilities and equity 221 21,636 (16,121) 6,015 23 6,038 $ 50,710 $ December 2020 $ 3,160 $ 1,978 9,545 3,545 1,150 19,378 7,213 10,806 3,012 3,475 6,826 $ 50,710 $ Assets Current assets Cash and cash equivalents Receivables, net Contract assets Inventories Other current assets Total current assets Property, plant and equipment, net Goodwill Intangible assets, net Deferred income taxes Other noncurrent assets Total assets Liabilities and equity Current liabilities Accounts payable Contract liabilities Salaries, benefits and payroll taxes Current maturities of long-term debt Other current liabilities Total current liabilities Long-term debt, net Accrued pension liabilities Other noncurrent liabilities Total liabilities Stockholders' equity Common stock, $1 par value per share $ 880 $ 7,545 3,163 500 1,845 13,933 11,669 12,874 6,196 44,672 279 Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total stockholders' equity Noncontrolling interests in subsidiary Total equity Total liabilities and equity 221 21,636 (16,121) 6,015 23 6,038 $ 50,710 $

Answer & Explanation Solved by verified expert

See Answer