Analyzing Apple Inc.
While this final may seem daunting, if you read through the instructions carefully, it will make it much easier to complete. There is a lot of information provided to you. Take your time and review everything within this page, and the Excel spreadsheet.
Final Financial Analysis – Apple Inc. 2021 to 2023
Apple Inc. designs, manufactures, and markets smartphones, personal computers, tablets, wearables, and accessories worldwide. It also provides AppleCare support and cloud services; and operates various platforms, including the App Store that allow customers to discover and download applications and digital content, such as books, music, video, games, and podcasts.
Your final will analyze Apple Inc. and evaluate how they are doing financially in 2023.
You will conduct a comparative analysis of Apple’s financial statements from the years 2022 to 2023 looking at ratios to determine their profitability, liquidity, solvency, and efficiency in conducting business.
You will complete a Horizontal and Vertical Analysis of the Income Statements from the years 2021, 2022, and 2023 to determine trends or changes by evaluating increases and decreases within the statement line items.
You will aid Apple in determining the best investment opportunity by analyzing the Return on Investment and Payback Periods for the purchase of a new factory.
And finally, you will help determine which factory will provide the best break-even option on the manufacturing and production of the new IPhone 14.
Along with your overview of Apple Inc. you will present your knowledge of Business Forms, the four Financial Statements and their equations. You will prepare a Balance Sheet and an Income statement for Apple Inc. and you will provide your knowledge of the profitability, liquidity, solvency, and efficiency ratios.
Complete the financial analysis of Apple Inc. using the Excel file within this page. (See: Final_Analysis_Apple_Inc_2024.xlsx File)
On the Excel file, you will be expected to calculate the following ratios and equations for Apple Inc:
Profitability Ratios
Solvency Ratio
Liquidity Ratios
Efficiency Ratios
Cash Conversion Cycle – CCC-Explained
Free Cash Flow
Horizontal Variance Analysis
Vertical Variance Analysis
Return on Investment
Payback Period
Break-Even Point: Units and Dollar Amount
The Excel workbook is color coded and includes all the data you will need to complete this part of the assignment.
(For those who have difficulty moving between the spreadsheet tabs, I have provided a PDF of the Financial Statements for Apple.)
Excel Workbook: Final_Analysis_Apple_Inc_2024.xlsxDownload Final_Analysis_Apple_Inc_2024.xlsx
You will be required to submit your completed Excel file. Be sure to save each spreadsheet tab as you work through the final. (Worth 20 Points)
PDF Version Financial Statements: Apple_Inc_Financial_Statements_2021_to_2023.pdf
DO NOT SELECT THE “Step 2 – Submit Final Results – Apple Inc.” LINK UNTIL YOU ARE READY TO SUBMIT YOUR ANSWERS!
You Only Get 1 Attempt to Submit the Final
NOTE: You can submit your answers from the spreadsheet at any time. If you would like to write your answers to the essay questions prior to submitting, that is ok. (The essay questions have been provided within the spreadsheet.)
Just make sure you have everything completed before March 13th @ 11:59 PM
(The Late Policy does not apply to the final.)
You will select the following link in the Final Assessment Module titled “Step 2 – Submit Final Results – Apple Inc.” to submit the answers from your Excel workbook.
