Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast sales revenue for each of your segments and the expense lines up to the Operating Income line. Document the key assumptions you made in

Forecast sales revenue for each of your segments and the expense lines up to the Operating Income line. Document the key assumptions you made in forecasting the expense accounts.


INPUT EACH CELL THAT HAS A "1" IN IT EXCEPT FOR THE OPERATING INCOME LINE. ALL OTHER CELLS WILL COMPUTE









(In Millions)
2022
2023 Growth
2024 Growth
2025 Growth
2026 Growth

Latin American
$ 3,629
$ 5,006 37.9%
$ 1 -100.0%
$ 1 0.0%
$ 1 0.0%

AMEA
6,767
7,075 4.6%
1 -100.0%
1 0.0%
1 0.0%

Europe
11,420
12,857 12.6%
1 -100.0%
1 0.0%
1 0.0%

North America
9,680
11,078 14.4%
1 -100.0%
1 0.0%
1 0.0%

Net Revenues
31,496
36,016 14.4%
4 -100.0%
4 0.0%
4 0.0% Formula - will compute
Cost of sales
20,184
22,252 10.2%
1 -100.0%
1 0.0%
1 0.0%

Gross Profit
11,312
13,764 21.7%
3 -100.0%
3 0.0%
3 0.0% Formula - will compute
Selling, general, administrative expense 7,384
8,002 8.4%
1 -100.0%
1 0.0%
1 0.0%

Asset impairment
262
217 -17.2%
-

-

-


Net (gain) on acquisition and divestiture -
(108)

-

-

-


Amortization of intangibles
132
151 14.4%
1 -99.3%
1 0.0%
1 0.0%

Operating Income
$ 3,534
$ 5,502 55.7%
$ 1 -100.0%
$ 1 0.0%
$ 1 0.0% Formula - will compute

















% To Sales















Cost of sales
64.1%
61.8%

25.0%

25.0%

25.0%


Gross Profit
35.9%
38.2%

75.0%

75.0%

75.0%


Selling, general, administrative expense 23.4%
22.2%

25.0%

25.0%

25.0%


Amortization of intangibles
0.4%
0.4%

25.0%

25.0%

25.0%


Operating Income
11.2%
15.3%

25.0%

25.0%

25.0%



















Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Finance questions

Question

What are accounting and administrative controls?

Answered: 1 week ago

Question

Analyze three management skills

Answered: 1 week ago

Question

Contrast the myths with the realities of a managers job

Answered: 1 week ago

Question

Discuss the criteria used to evaluate a managers performance

Answered: 1 week ago