Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, Here I show both income statement and balance sheet for 2015 and 2016. I want to forecast income statement and balance sheet for 2017,
Hi,
Here I show both income statement and balance sheet for 2015 and 2016. I want to forecast income statement and balance sheet for 2017, 2018 and 2019, according to the assumptions shown below... Thank you
Consolidated Income Statement For the year ended December 31, | ||
(In millions) | 2016 | 2015 |
Net sales | ||
Products | 35,691 | 37,817 |
Services | 9,667 | 9,365 |
Total net sales | 45,358 | 47,182 |
Cost of sales | ||
Products | 31,346 | 33,495 |
Services | 8,588 | 8,383 |
Goodwill impairment charge | 195 | 0 |
Severance and other charges | 201 | 48 |
Other unallocated corporate costs | 841 | 1,060 |
Total cost of sales | 41,171 | 42,986 |
Gross profit | 4,187 | 4,196 |
Other operating income | 318 | 238 |
Operating profit | 4,505 | 4,434 |
Interest expense | 350 | 383 |
Other nonoperating income | 0 | 21 |
Earnings before income taxes | 4,155 | 4,072 |
Income tax expense | 1,205 | 13,329 |
Net earnings from continuing operations | 2,950 | 2,745 |
Net earnings (loss) from discontinued operations | 31 | 0 |
Net earnings | 2,981 | 2,745 |
Consolidated Balance Sheet At December 31, | ||
(In millions) | ||
| 2016 | 2015 |
Cash and equivalents | 2,617 | 1,898 |
Receivables, net | 5,834 | 6,563 |
Inventories, net | 2,977 | 2,937 |
Deferred income taxes | 1,088 | 1,269 |
Other current assets | 813 | 1,188 |
Total current assets | 13,329 | 13,855 |
Property, plant and equipment, net | 4,706 | 4,675 |
Goodwill | 10,348 | 10,370 |
Deferred income taxes | 2,850 | 4,809 |
Other noncurrent assets | 4,955 | 4,948 |
Total assets | 36,188 | 38,657 |
Accounts payable | 1,397 | 2,038 |
Customer advances and amounts in excess of costs | 6,349 | 6,503 |
Salaries, benefits and payroll taxes | 1,809 | 1,649 |
Current portion of long-term debt | 0 | 150 |
Other current liabilities | 1,565 | 1,815 |
Total current liabilities | 11,120 | 12,155 |
Long-term debt, net | 6,152 | 6,158 |
Accrued pension liabilities | 9,361 | 15,278 |
Other postretirement benefit liabilities | 902 | 1,220 |
Other noncurrent liabilities | 3,735 | 3,807 |
Total liabilities | 31,270 | 38,618 |
Common stock | 319 | 321 |
Retained earnings | 14,200 | 13,211 |
Accumulated other comprehensive (loss) | -9,601 | -13,493 |
Total stockholders equity | 4,918 | 39 |
Total liabilities and stockholders equity | 36,188 | 38,657 |
Assumptions: To forecast the financial statements, make the following assumptions. For accounts that are not included in the list below, assume that the amount will not change for the forecasted year. | |
Growth in Net sales: Products | 2.0% |
Growth in Net sales: Services | 3.05% |
Cost of sales margin - Products | Estimate |
Cost of sales margin Service | Estimate |
Goodwill impairment charges ($) | 0 |
Severances and other charges ($) | 0 |
Other nonoperating income ($) | 0 |
Interest expense @ 6% of beginning-of-year long-term debt | |
Income tax expense to earnings before tax | 25.0% |
Earnings from discontinued operations ($) | 0 |
A/R to total net sales | 12.9% |
Inventories to Net sales: Products | 8.3% |
Depreciation expense to start of year PPE, net | 21.2% |
CAPEX to total net sales | 2.8% |
Additions to CAPEX to be funded by new Long-term Debt | |
A/P to total net sales | 3.1% |
Customer advances to total net sales | 14.0% |
Salaries, benefits and payroll taxes to non-product cost-of-sales | 19.0% |
Growth in accrued pension liabilities to non-product cost-of-sales | 2% |
Other postretirement benefit liabilities to balance of accrued pensions | 10.0% |
Dividends to net earnings with an additional $5,000 special dividend in 2019 | 55% |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started