Please help me with this practice task on AMAZON . STEP 1 Download financial statements of your
Fantastic news! We've Found the answer you've been seeking!
Question:
Please help me with this practice task on AMAZON.
STEP 1
- Download financial statements of your company for five years: 2015-2019.
- Income statement
- Balance sheet
- Statement of cashflow
- Open them in excel spreadsheet (1) Income statement first, (2) balance sheet below, and (3) statement of cashflow below
- 1stcolumn is the item name
- Column 2----6are for data from each year.
- Code the statements based on statements. For example: In balance sheet TCA consists of Cash+A/R+Inventory. TA = TCA+NFA. So, use excel finction to write TCA equation and to solve it.
- Color the code cells in purple. So that you can recognize numbers as black and calculated value as purple.
Source of financial statements:Company's website, SEC, EDGAR, Yahoo Finance, Bloomberg.
You search them in the Internetfor sources and collect five years data 2015-2019. Annual Data.
For the step, I attach a sample data for a company for you to observe, and follow.
Onceyou review them, let me know if you have any question, we can discuss this in our next class. (Attached the sample income picture
Posted Date: