Use Segment Disclosures to Forecast Income Statement

Following are revenue and cost of revenue numbers for Thermo Fisher Scientific.

Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.

THERMO FISHER SCIENTIFIC INC.

Consolidated Statement of Income

For Year Ended December $31($$ millions$)20182017$

Revenues

Product revenues $$18,868$ $$17,374$

Service revenues $5,4903,544$

Total revenues $24,35820,918$

Costs and operating expenses

Product cost of revenues $9,6828,975$

Service cost of revenues $3,8192,495$

Total cost of revenues $13,50111,470$

Selling, general and administrative expenses $6,0575,504$

Research and development expenses $967887$

Restructuring and other costs, net $5097$

Total costs and operating expenses $20,57517,958$

Operating income $3,7832,960$

Other expense, net $(521)(531)$

Income from continuing operations before income taxes $3,2622,429$

Income tax expense $324201$

Income from continuing operations $2,9382,228$

Loss from discontinued operations $0(3)$

Net income $$2,938$ $$2,225$

Assumptions

Selling, general and administrative expenses $24\mathrm{.}9\%$ of total revenues

Research and development expenses $4\%$ of total revenues

Restructuring and other costs, net $$0$

Other expense, net No change

Income tax expense $23\%$ of pretax income

part a$.$

part b$.$

part c$.$

a$.$ Use the historic growth in total revenues $($from $2017$ to $2018)$ to forecast total revenue for $2019.$ Use the historic rate of total cost of revenues to total revenues to forecast total cost of revenues. Other forecast assumptions follow:

Note: Complete the entire question in Excel $($template provided above$).$ Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with $\_$two decimal places$\_.$

Note: Use negative signs with answers, when appropriate.

Thermo Fisher Scientific

Forecasted Income Statement

Dec. $31,2019$

Forecast

Revenues

Product Revenues

Service Revenues

Total Revenues Answer $1$

$28,374\mathrm{.}38$

Cost and Operating Expenses

Product Cost of revenues

Service Cost of revenues

Total cost of revenue Answer $2$

$19,811\mathrm{.}4$

Selling, general and administrative expenses Answer $3$

$7,069\mathrm{.}77$

Research and development expenses Answer $4$

$1,134\mathrm{.}78$

Restructuring and other costs, net Answer $5$

$0$

Total costs and operating expenses Answer $6$

$23,906\mathrm{.}37$

Operating Income Answer $7$

$4,462\mathrm{.}51$

Other Expense, Net Answer $8$

$(521)$

Income from Continuing Operations Before Income Taxes Answer $9$

$2,941\mathrm{.}51$

Income tax expense Answer $10$

$907\mathrm{.}89$

Net Income Answer $11$

$3,033\mathrm{.}62$