Question

1 Approved Answer

Posted on Sep 05, 2024

Please show work CC MPANY XYZ CONSOLIDATED BALANCE SHEET 2017 2018 2019 ASSETS Current assets: Cash and equivalents Short-term investments, at amortized cost Accounts receivable

image text in transcribed Please show work

CC MPANY XYZ CONSOLIDATED BALANCE SHEET 2017 2018 2019 ASSETS Current assets: Cash and equivalents Short-term investments, at amortized cost Accounts receivable Inventories Finished goods Raw materials and supplies $ $ $ 607,785 $ 25,450 $ 239,885 $ 700,599 $ 29,301 $ 291,570 $ 843,413 33,152 343,255 $ $ $ 75,693 $ 203,288 $ 1,152,101 $ 46,896 $ 14,846 $ 1,213,843 $ 64,676 $ 53,659 188,615 $ 173,942 1,274,761 $ 1,447,421 139,728 $ 132,560 14,226 $ 13,606 1,428,715 $ 1,593,587 Other current assets Deferred income taxes - current Total current assets $ $ $ Marketable equity securities, at fair value Deferred charges and other assets Deferred income taxes - noncurrent $ $ $ 25,300 $ 115,745 $ 26,381 $ 28,535 $ 83,713 $ 26,743 $ 31,770 51,681 27,105 Property, plant, and equipment (at cost) Land Buildings and building equipment Machinery and equipment $ $ $ $ $ $ 39,933 $ 359,109 $ 857,044 $ 1,256,086 $ (571,717) $ 684,369 $ 39,125 $ 38,317 344,457 $ 329,805 756,050 $ 655,056 1,139,632 $ 1,023,178 (532,598) $ (493,479) 607,034 $ 529,699 Less accumulated depreciation Net property, plant and equipment TOTAL ASSETS $ 2,065,638 $ 2,174,740 $ 2,233,842 $ $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses Dividends payable Income and other taxes payable Deferred income taxes - current Total current liabilities $ 91,215 $ 128,406 $ 42,711 $ 68,437 $ 1,455 $ 332,224 $ 73,041 $ 113,779 $ 39,467 $ 60,976 $ 859 $ 288,122 $ 54,867 99,152 36,223 53,515 263 244,020 $ $ $ Long-term Debt $ VF 157,127 $ 153,633 $ 150,139 TOTAL LIABILITIES $ 489,351 $ 441,755 $ 394,159 Common stock Retained earnings Total stockholders'equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ $ $ $ 1,100,450 $ 475,837 $ 1,576,287 $ 2,065,638 $ 1,200,500 $ 1,200,500 532,485 $ 639,183 1,732,985 $ 1,839,683 2,174,740 $ 2,233,842 Information: Unlevered Beta Long-Term Debt Interest Rate Income Tax Rate S&P 500 Rate T-bill Rate 0.97 7.0% 35.0% 12.0% 2.0% Company XYZ wants to calculate its WACC (Weighted Average Cost of Capital) for the 3 years. Open the attached spreadsheet Dto calculate WACC. The information needed to calculate WACC is provided in the Balance Sheet and information below the Balance Sheet. (DO NOT include % sign and use 2 decimals. For example 9.43% would be input as 9.43.) CC MPANY XYZ CONSOLIDATED BALANCE SHEET 2017 2018 2019 ASSETS Current assets: Cash and equivalents Short-term investments, at amortized cost Accounts receivable Inventories Finished goods Raw materials and supplies $ $ $ 607,785 $ 25,450 $ 239,885 $ 700,599 $ 29,301 $ 291,570 $ 843,413 33,152 343,255 $ $ $ 75,693 $ 203,288 $ 1,152,101 $ 46,896 $ 14,846 $ 1,213,843 $ 64,676 $ 53,659 188,615 $ 173,942 1,274,761 $ 1,447,421 139,728 $ 132,560 14,226 $ 13,606 1,428,715 $ 1,593,587 Other current assets Deferred income taxes - current Total current assets $ $ $ Marketable equity securities, at fair value Deferred charges and other assets Deferred income taxes - noncurrent $ $ $ 25,300 $ 115,745 $ 26,381 $ 28,535 $ 83,713 $ 26,743 $ 31,770 51,681 27,105 Property, plant, and equipment (at cost) Land Buildings and building equipment Machinery and equipment $ $ $ $ $ $ 39,933 $ 359,109 $ 857,044 $ 1,256,086 $ (571,717) $ 684,369 $ 39,125 $ 38,317 344,457 $ 329,805 756,050 $ 655,056 1,139,632 $ 1,023,178 (532,598) $ (493,479) 607,034 $ 529,699 Less accumulated depreciation Net property, plant and equipment TOTAL ASSETS $ 2,065,638 $ 2,174,740 $ 2,233,842 $ $ LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Accounts payable Accrued expenses Dividends payable Income and other taxes payable Deferred income taxes - current Total current liabilities $ 91,215 $ 128,406 $ 42,711 $ 68,437 $ 1,455 $ 332,224 $ 73,041 $ 113,779 $ 39,467 $ 60,976 $ 859 $ 288,122 $ 54,867 99,152 36,223 53,515 263 244,020 $ $ $ Long-term Debt $ VF 157,127 $ 153,633 $ 150,139 TOTAL LIABILITIES $ 489,351 $ 441,755 $ 394,159 Common stock Retained earnings Total stockholders'equity TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ $ $ $ 1,100,450 $ 475,837 $ 1,576,287 $ 2,065,638 $ 1,200,500 $ 1,200,500 532,485 $ 639,183 1,732,985 $ 1,839,683 2,174,740 $ 2,233,842 Information: Unlevered Beta Long-Term Debt Interest Rate Income Tax Rate S&P 500 Rate T-bill Rate 0.97 7.0% 35.0% 12.0% 2.0% Company XYZ wants to calculate its WACC (Weighted Average Cost of Capital) for the 3 years. Open the attached spreadsheet Dto calculate WACC. The information needed to calculate WACC is provided in the Balance Sheet and information below the Balance Sheet. (DO NOT include % sign and use 2 decimals. For example 9.43% would be input as 9.43.)