Answered step by step
Verified Expert Solution
Link Copied!

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%

(FORECASTED) Consolidated Income Statement For the year ended December 31,
2017 2018 2019
Net sales ? ? ?
Products ? ? ?
Services ? ? ?
Total net sales ? ? ?
Cost of sales ? ? ?
Products ? ? ?
Services ? ? ?
Goodwill impairment charge ? ? ?
Severance and other charges ? ? ?
Other unallocated corporate costs ? ? ?
Total cost of sales ? ? ?
Gross profit ? ? ?
Other operating income ? ? ?
Operating profit ? ? ?
Interest expense ? ? ?
Other nonoperating income ? ? ?
Earnings before income taxes ? ? ?
Income tax expense ? ? ?
Net earnings from continuing operations ? ? ?
Net earnings (loss) from discontinued operations ? ? ?
Net earnings ? ? ?
(FORECASTED) Consolidated Balance Sheet At December 31,
2017 2018 2019
Cash and equivalents ? ? ?
Receivables, net ? ? ?
Inventories, net ? ? ?
Deferred income taxes ? ? ?
Other current assets ? ? ?
Total current assets ? ? ?
Property, plant and equipment, net ? ? ?
Goodwill ? ? ?
Deferred income taxes ? ? ?
Other noncurrent assets ? ? ?
Total assets ? ? ?
Accounts payable ? ? ?
Customer advances and amounts in excess of costs ? ? ?
Salaries, benefits and payroll taxes ? ? ?
Current portion of long-term debt ? ? ?
Other current liabilities ? ? ?
Total current liabilities ? ? ?
Long-term debt, net ? ? ?
Accrued pension liabilities ? ? ?
Other postretirement benefit liabilities ? ? ?
Other noncurrent liabilities ? ? ?
Total liabilities ? ? ?
Common stock ? ? ?
Retained earnings ? ? ?
Accumulated other comprehensive (loss) ? ? ?
Total stockholders equity ? ? ?
Total liabilities and stockholders equity ? ? ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions