Course Hero Logo

Final.Project.Part.II.docx - The company from my TDUA...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 3 out of 5 pages.

The company from my TDUA thinkorswim portfolio is Apple Inc, and its competitor isCalAmp Corp. In the workbook, each spreadsheet contains the companies three fiscal year'sfinancial statements.Apple's stock price has a three-year return rate of 208.12% (L14, Apple Stock Prices).CalAmp's stock price has a three-year return rate at -54.41% (L14, CalAmp Stock Prices). Toexplain how each company's stock is performing individually and in comparison to each other,follow the examples provided. (1st Example) Investment of $1,000 made in Apple on January 2,2018. Stock performance as on December 31st, 2020: $1,000 + (208.12% * $1,000) = $3,081.16.Stock performance on December 31, 2020, would be a portfolio gain of $2,081.16. (2ndExample) Investment of $1,000 made in CalAmp on January 2, 2018. Stock performance as onDecember 31st, 2020: $1,000 + (-54.41% * $1,000) = $455.90. Stock performance on December31, 2020, would be a portfolio loss of $544.12. Comparing Apple's three-year return of 208.12%(L14, Apple Stock Prices) to CalAmp's three-year return of -54.41% (L14, CalAmp Stock Prices)shows Apple has over 200% gain on the amount of money invested three years prior. CalAmp,on the other hand, would be a profit loss.The first spreadsheet, Apple 2020 Balance Sheet, is where the ratio calculations for Appleare located, and on the fifth spreadsheet, CalAmp 2020 Balance Sheet, is where CalAmp'scalculated ratios are located. The ratios are Current Ratio, Debt/Equity Ratio, Free Cash Flow,Earnings per Share, Price/Earnings Ratio, Return on Equity, and Net Profit Margin. Under thelast ratio, Net Profit Margin is the Stock data; Number of Shares Outstanding and Closing PricesLast Business Day of December. On both spreadsheets, this information starts with column Hrow 19 through row 28 and ends with column K row 19 through 28. The formula for each ratiowill appear in Excel's Formula Bar when the ratio's results are selected.
Industry averages are located to the right side of the ratios on the company's Balance

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
FAROOQI
Tags
Income Statement, Revenue, Financial Ratio

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture