Compute the Forecast Inventory for the 2021 Balance Sheet.
Present your result to the second decimal point
Don't round until the end of the problem.
Actual Financial Results 2016 2017 31-Dec 2014 2015 2018 2019 2020 2021 Current Assets Cash and cash equivalents Receivables (net) Inventories Other current assets Total current assets Property, plant and equipment, net Goodwill Other intangible assets, net Deferred income taxes Other assets Total non-current assets Total assets 1,089 1,552 1,382 840 4.863 4,080 2.307 1,413 76 720 8,596 13.459 970 1,427 1,180 807 4.384 3,796 2,103 1,346 67 262 7,574 11.958 1,315 1,411 1,171 441 4.338 3,840 2.107 1,313 301 224 7,785 12.123 1,535 1,480 1,221 403 4,639 4,072 2.218 1,341 188 218 8,037 12,676 726 1,400 1,250 417 3.793 3,881 2,530 1,637 152 168 8.368 12,161 883 1,440 1,400 456 4,179 3,750 3,508 2,667 177 753 10,855 15,034 13 11 12 Liabilities and Shareholders' Equity Current Liabilities Notes and loans payable Current portion of long-term debt Accounts payable Accrued income taxes Other accruals Total current liabilities Long-term debt Deferred income taxes Other liabilities Total Non-Current Liabilities Total liabilities 16 488 1,231 294 1.917 3,946 5,644 261 2.223 8,128 12,074 4 298 1,110 277 1,845 3,534 6,269 233 1,966 8,468 12,002 1.124 441 1.727 3.305 6,520 246 2,035 8,801 12.106 1,212 354 1,831 3,408 6,566 204 2.255 9,025 12,433 1.222 411 1.696 3,341 6,354 235 2,034 8,623 11,964 260 254 1,237 370 1,917 4,038 7,333 507 2,598 10,438 14,476 Shareholders' Equity Common stock, $1 par value Additional paid-in capital Retained earnings Accumulated other comprehensive income (loss) Unearned compensation Treasury stock, at cost Total Company shareholders' equity Plus Non-controlling interests Total equity Total liabilities and equity 1,466 1.236 18,832 (3,507) (20) (16,862) 1,145 240 1,385 13,459 1,466 1,438 18,861 (3,950) (12) (18,102) (299) 255 (44) 11,958 1,466 1.691 19.922 (4.180) (7) (19,135) (243) 260 17 12,123 1,466 1,984 20,531 (3,855) (5) (20,181) (60) 303 243 12,676 1,466 2,204 21,615 (4,188) (3) (21,196) (102) 299 197 12,161 1,466 2,488 22.501 (4,273) (2) (22,063) 117 441 558 15,034 Actual Financial Results 2016 2017 31-Dec 2014 2015 2018 2019 2020 2021 Current Assets Cash and cash equivalents Receivables (net) Inventories Other current assets Total current assets Property, plant and equipment, net Goodwill Other intangible assets, net Deferred income taxes Other assets Total non-current assets Total assets 1,089 1,552 1,382 840 4.863 4,080 2.307 1,413 76 720 8,596 13.459 970 1,427 1,180 807 4.384 3,796 2,103 1,346 67 262 7,574 11.958 1,315 1,411 1,171 441 4.338 3,840 2.107 1,313 301 224 7,785 12.123 1,535 1,480 1,221 403 4,639 4,072 2.218 1,341 188 218 8,037 12,676 726 1,400 1,250 417 3.793 3,881 2,530 1,637 152 168 8.368 12,161 883 1,440 1,400 456 4,179 3,750 3,508 2,667 177 753 10,855 15,034 13 11 12 Liabilities and Shareholders' Equity Current Liabilities Notes and loans payable Current portion of long-term debt Accounts payable Accrued income taxes Other accruals Total current liabilities Long-term debt Deferred income taxes Other liabilities Total Non-Current Liabilities Total liabilities 16 488 1,231 294 1.917 3,946 5,644 261 2.223 8,128 12,074 4 298 1,110 277 1,845 3,534 6,269 233 1,966 8,468 12,002 1.124 441 1.727 3.305 6,520 246 2,035 8,801 12.106 1,212 354 1,831 3,408 6,566 204 2.255 9,025 12,433 1.222 411 1.696 3,341 6,354 235 2,034 8,623 11,964 260 254 1,237 370 1,917 4,038 7,333 507 2,598 10,438 14,476 Shareholders' Equity Common stock, $1 par value Additional paid-in capital Retained earnings Accumulated other comprehensive income (loss) Unearned compensation Treasury stock, at cost Total Company shareholders' equity Plus Non-controlling interests Total equity Total liabilities and equity 1,466 1.236 18,832 (3,507) (20) (16,862) 1,145 240 1,385 13,459 1,466 1,438 18,861 (3,950) (12) (18,102) (299) 255 (44) 11,958 1,466 1.691 19.922 (4.180) (7) (19,135) (243) 260 17 12,123 1,466 1,984 20,531 (3,855) (5) (20,181) (60) 303 243 12,676 1,466 2,204 21,615 (4,188) (3) (21,196) (102) 299 197 12,161 1,466 2,488 22.501 (4,273) (2) (22,063) 117 441 558 15,034
