Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the portfolio analysis below, address the following: How would you assess the company's market and industry performance based on its five-year revenues and earnings

Using the portfolio analysis below, address the following:

How would you assess the company's market and industry performance based on its five-year revenues and earnings results?

How does the company's five-year performance compare to its industry peers over the same time period?

What portfolio recommendations or asset allocation strategies might you consider to improve investment performance?

Apple (AAPL) Stock
Enter Current Fiscal Year in Cell B2: 2023
Historical Fiscal Year-End Data: 2018 2019 2020 2021 2022 Forecasted Fiscal Year-End Data: 2023 2024 2025 2026 2027 Projections Per Year
Revenues 265,595 260,174 274,515 365,817 394,328 Revenues 354,895 319,406 287,465 258,719 232,847 90%
Cost of Goods Sold 163,756 161,782 169,559 212,981 223,546 Cost of Goods Sold 190,014 161,512 137,285 116,692 99,189 85%
Selling, General & Administrative Expenses 16,705 18,245 19,916 21,981 25,094 Selling, General & Administrative Expenses 21,330 18,130 15,411 13,099 11,134 85%
Research and development 14,236 16,217 18,752 21,914 26,251 Research and development 22,313 18,966 16,121 13,703 11,648 85%
Operating Income 70,898 63,930 66,288 108,941 119,437 Operating Income 121,238 120,797 118,648 115,224 110,876
Net Interest Expenditure 2,446 1,385 890 198 106 Net Interest Expenditure 90 77 65 55 47 85%
Pre-Tax Income 73,344 65,315 67,178 109,139 119,543 Pre-Tax Income 121,148 120,720 118,583 115,168 110,829
Taxes 22,003 19,595 20,153 32,744 35,863 Taxes 30,484 25,911 22,024 18,721 15,913 85%
Net Income 51,341 45,720 47,025 76,395 83,680 Net Income 90,664 94,809 96,558 96,448 94,917
Earnings Per Share 2.5901 2.4752 2.7101 4.57428 5.1603 Earnings Per Share 6.577687 8.0923 9.6959 11.394 13.192 90%
Shares Outstanding 19,822 18,471 17,352 16,701 16,216 Shares Outstanding 13,784 11,716 9,959 8,465 7,195 85%

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

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

Behavioral Finance And Investor Types

Authors: Michael M. Pompian

1st Edition

1118011503, 978-1118011508

More Books

Students also viewed these Finance questions

Question

8. Explain the difference between translation and interpretation.

Answered: 1 week ago

Question

10. Discuss the complexities of language policies.

Answered: 1 week ago

Question

1. Understand how verbal and nonverbal communication differ.

Answered: 1 week ago