Analyze Apple Inc. by segmentSegment disclosure by Apple Inc. (AAPL) provides sales information for its major product lines for three recent years as follows (in millions):SegmentYear 3Year 2Year 1iPhone$136,700$155,041$101,991iPad20,62823,22730,28325,471Мас22,83124,079Services18,06324,34819,909Other Products11,1328,37910,067$215,639$233,715$182,795Total salesThe Services segment includes sales from iTunes Store, App Store, Mac App Store, TV App Store, iBooks Store, Apple Music, AppleCare, and ApplePay. The Other Products segment includes sales from Apple TV, Apple Watch, Beats products, iPod, and Apple-branded accessories.a. Prepare a vertical analysis of Year 3 sales. (Round percentages to nearest whole percent.)Year 3 Sales Percent of Total SalesSegmentiPhone$136,700%iPad20,628%Мас22,831Services24,348Other Products11,132%$215,639Total sales% Which product had the greatest percentage of Year 3 sales? Which product had the least percentage of Year 3 sales?Greatest percentageLeast percentageb. Prepare a horizontal analysis of the change in sales from Year 1 to Year 3. (Round percentages to nearest whole percent. For those boxesin which you must enter subtractive or negative numbers use a minus sign.)Increase (Decrease)SegmentYear 3Year 1AmountPercentiPhone$136,700 $101,991 $%iPad30,28320,628%Мас22,83124,079%Services24,34818,063%8,379Other Products11,132%$215,639 $182,795Total salesWhich product grew the most in sales, in percentage terms, using Year 1 as the base year?

Question
Asked Nov 17, 2019
28 views
Analyze Apple Inc. by segment
Segment disclosure by Apple Inc. (AAPL) provides sales information for its major product lines for three recent years as follows (in millions):
Segment
Year 3
Year 2
Year 1
iPhone
$136,700
$155,041
$101,991
iPad
20,628
23,227
30,283
25,471
Мас
22,831
24,079
Services
18,063
24,348
19,909
Other Products
11,132
8,379
10,067
$215,639
$233,715
$182,795
Total sales
The Services segment includes sales from iTunes Store, App Store, Mac App Store, TV App Store, iBooks Store, Apple Music, AppleCare, and Apple
Pay. The Other Products segment includes sales from Apple TV, Apple Watch, Beats products, iPod, and Apple-branded accessories.
a. Prepare a vertical analysis of Year 3 sales. (Round percentages to nearest whole percent.)
Year 3 Sales Percent of Total Sales
Segment
iPhone
$136,700
%
iPad
20,628
%
Мас
22,831
Services
24,348
Other Products
11,132
%
$215,639
Total sales
%
help_outline

Image Transcriptionclose

Analyze Apple Inc. by segment Segment disclosure by Apple Inc. (AAPL) provides sales information for its major product lines for three recent years as follows (in millions): Segment Year 3 Year 2 Year 1 iPhone $136,700 $155,041 $101,991 iPad 20,628 23,227 30,283 25,471 Мас 22,831 24,079 Services 18,063 24,348 19,909 Other Products 11,132 8,379 10,067 $215,639 $233,715 $182,795 Total sales The Services segment includes sales from iTunes Store, App Store, Mac App Store, TV App Store, iBooks Store, Apple Music, AppleCare, and Apple Pay. The Other Products segment includes sales from Apple TV, Apple Watch, Beats products, iPod, and Apple-branded accessories. a. Prepare a vertical analysis of Year 3 sales. (Round percentages to nearest whole percent.) Year 3 Sales Percent of Total Sales Segment iPhone $136,700 % iPad 20,628 % Мас 22,831 Services 24,348 Other Products 11,132 % $215,639 Total sales %

fullscreen
Which product had the greatest percentage of Year 3 sales? Which product had the least percentage of Year 3 sales?
Greatest percentage
Least percentage
b. Prepare a horizontal analysis of the change in sales from Year 1 to Year 3. (Round percentages to nearest whole percent. For those boxes
in which you must enter subtractive or negative numbers use a minus sign.)
Increase (Decrease)
Segment
Year 3
Year 1
Amount
Percent
iPhone
$136,700 $101,991 $
%
iPad
30,283
20,628
%
Мас
22,831
24,079
%
Services
24,348
18,063
%
8,379
Other Products
11,132
%
$215,639 $182,795
Total sales
Which product grew the most in sales, in percentage terms, using Year 1 as the base year?
help_outline

Image Transcriptionclose

Which product had the greatest percentage of Year 3 sales? Which product had the least percentage of Year 3 sales? Greatest percentage Least percentage b. Prepare a horizontal analysis of the change in sales from Year 1 to Year 3. (Round percentages to nearest whole percent. For those boxes in which you must enter subtractive or negative numbers use a minus sign.) Increase (Decrease) Segment Year 3 Year 1 Amount Percent iPhone $136,700 $101,991 $ % iPad 30,283 20,628 % Мас 22,831 24,079 % Services 24,348 18,063 % 8,379 Other Products 11,132 % $215,639 $182,795 Total sales Which product grew the most in sales, in percentage terms, using Year 1 as the base year?

fullscreen
check_circle

Expert Answer

Step 1

Formula for percentage of sale is:

help_outline

Image Transcriptionclose

Percentage of Year 3 sales total sales Total sales

fullscreen
Step 2

a. Prepare a vertical analysis of year 3.

help_outline

Image Transcriptionclose

Percentage of total sales Segment iPhone Year 3 sales $136,700 $20,628 $22,831 $24,348 $11,132 63% iPad 10% Мас 11% 11% Services Other products 5% 100% Total sales $215,639

fullscreen
Step 3

 i phone has the greatest percentage of year 3 sales. Oth...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Accounting

Financial Accounting

Related Accounting Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Cash payback period for a Service Company Prime Financial Inc. is evaluating two capital investment ...

A: Compute cash payback period for location 1 as shown below:

question_answer

Q: Euclid Corporation processes a patented chemical, P-1, and produces two outputs, P-11 and P-12. In A...

A: In the net realizable value method, the cost of the process is allocated between different products ...

question_answer

Q: Break-Even in Sales Revenue, Changes in Variables Carmichael Corporation is in the process of prepar...

A: Break-even Sales:Break even sales is the dollar amount of revenue at which a business earns a profit...

question_answer

Q: During 2018, Baird Corporation reported after-tax net income of $3,620,000. During the year, the num...

A: 1.  Determine the earnings per share:

question_answer

Q: Using T accounts for Cash, Accounts Payable, Purchases, Purchases Returns and Allowances, Purchases ...

A: T-account: The condensed form of a ledger is referred to as T-account. The left-hand side of this ac...

question_answer

Q: E8-28 Computing Depreciation and Accounting for a Change of Estimate In January 2016, Rankine Compan...

A: Requirement a)Calculate the annual depreciation expense using the straight line depreciation.

question_answer

Q: Raffie’s Kids, a nonprofit organization that provides aid to victims of domestic violence, low-incom...

A: Ethical Issue in the situation:The ethical issue in the situation is whether organization RK’s bookk...

question_answer

Q: Use the financial statement effects template to record the accounts and amounts for the following fo...

A: Income statement is a statement that helps in calculating the income or the profit and loss of a fir...

question_answer

Q: Explain what the difference is between Data flow Diagrams and the System Flowcharts.

A: Data flow diagrams: A Data flow diagram shows what kind of information will be input to and output f...