Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Directions In this activity, you will select one of the organizations listed below. Then, you will navigate to EDGAR through the SEC.gov | Filings &

Directions
In this activity, you will select one of the organizations listed below. Then, you will navigate to EDGAR through the SEC.gov|Filings & Forms
site to complete a horizontal and vertical analysis of the selected organization's income statement for a four-year period. Finally, you will
discuss any red flags that you have found through your analyses.
Choose one of the following organizations:
Cronos Group Inc., 2018-2021
American Renal Associates Holdings Inc., 2017-2020
Amyris Inc., 2017-2020
Download the income statement for the organization you select and then copy and paste the information from that document into your Excel
spreadsheet.
Specifically, you must address the following criteria in one Excel document with six worksheets:
Income Statement: Identify the organization and copy the income statement data into an Excel sheet with a tab titled Income Statement.
Horizontal Analysis: Create a horizontal analysis from the income statement data in an Excel sheet with a tab titled Horizontal Analysis.
Excel Horizontal Analysis: Create a visualization of the horizontal analysis results and present it in an Excel sheet with a tab titled Excel
Horizontal Analysis.
Vertical Analysis: Create a vertical analysis from the income statement in an Excel sheet with a tab titled Vertical Analysis.
Excel Vertical Analysis: Create a visualization of the vertical analysis results in an Excel sheet with a tab titled Excel Vertical Analysis.
Red Flags: In an Excel sheet with a tab titled Red Flags, discuss any red flags that are found. If no red flags are found, explain why.
What to Submit
Submit your analysis as a six-sheet Excel spreadsheet with tabs named Income Statement, Horizontal Analysis, Excel Horizontal Analysis,
Vertical Analysis, Excel Vertical Analysis, and Red Flags. Any sources used should be cited according to APA style.
image text in transcribed

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

Money Banking And Financial Markets

Authors: Stephen Cecchetti, Kermit Schoenholtz

3rd Edition

007337590X, 9780073375908

More Books

Students also viewed these Finance questions

Question

Given that find f(x) = (x-3 x +2 X Answered: 1 week ago

Answered: 1 week ago