Answered step by step
Verified Expert Solution
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.govFilings & Forms
site to complete a horizontal and vertical analysis of the selected organization's income statement for a fouryear period. Finally, you will
discuss any red flags that you have found through your analyses.
Choose one of the following organizations:
Cronos Group Inc.,
American Renal Associates Holdings Inc.,
Amyris Inc.,
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 sixsheet 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.
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