Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started