Question
This course contains a Course Project, where you will be required to submit one draft of the project at the end of Week 6, and
This course contains a Course Project, where you will be required to submit one draft of the project at the end of Week 6, and the final completed project at the end of Week 8. Using the financial statements for Apple Inc. and Alphabet Inc., respectively, you will calculate and compare the financial ratios listed further down this document and prepare your comments about the two companies' performances based on your ratio calculations. The entire project will be graded by the instructor at the end of the final submission in Week 8, and one grade will be assigned for the entire project.
Financial Statements----
Below is the link for the financial statements for Apple Inc. for the fiscal year ending 2020.
https://investor.apple.com/investor-relations/default.aspx (Links to an external site.)
When you arrive at this website, please do the following.
First, select SEC Filings, next select Annual Filings using the drop-down arrow labeled All Filings and then select 2020, using the drop-down arrow labeled Year,
You should select the 10-K dated 10/30/20 and choose to download in PDF, HTML, or Excel format. The PDF format is the best format for searching.
Below is the link for the financial statements for Alphabet, Inc. for the fiscal year ending 2020.
https://abc.xyz/investor/previous/#numbersLink (Links to an external site.)
First, scroll down to the "2020" heading on the page and click on the PDF link under the "10-K" sub-heading. This will open the company's 10-K in a format that will be searchable.
Required Ratios for Final Project Submission
- Earnings per Share of Common Stock
- Current Ratio
- Gross Profit Rate
- Profit Margin
- Inventory Turnover
- Days in Inventory
- Accounts Receivable Turnover
- Average Collection Period
- Asset Turnover
- Return on Assets (ROA)
- Debt to assets Ratio
- Times Interest Earned Ratio
- Dividend Yield [For the purposes of this ratio, use Yahoo Finance to look up current dividend per share and stock price; be sure to use the balance sheet date, or last business day prior to the balance sheet date. .]
- Return on Common Stockholders' Equity (ROE)
- Free cash flow
- Price-Earnings Ratio [For the purpose of this ratio, look up the market price per share as of the balance sheet date, or last business day prior to the balance sheet date for each company.]
Note: The Excel files uploaded as the assignment submission should not include any unnecessary numbers or information (such as previous years' ratios, ratios that were not specifically asked for in the project, etc.).
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