Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. Earnings per Share of Common Stock
  2. Current Ratio
  3. Gross Profit Rate
  4. Profit Margin
  5. Inventory Turnover
  6. Days in Inventory
  7. Accounts Receivable Turnover
  8. Average Collection Period
  9. Asset Turnover
  10. Return on Assets (ROA)
  11. Debt to assets Ratio
  12. Times Interest Earned Ratio
  13. 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. .]
  14. Return on Common Stockholders' Equity (ROE)
  15. Free cash flow
  16. 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

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

Deadly Audit A Buckeye Barrister Mystery

Authors: David M Selcer

1st Edition

0988194368, 978-0988194366

More Books

Students also viewed these Accounting questions