Please help me with this practice task on AMAZON.

STEP 1

1. Download financial statements of your company for five years: 2015-2019.
2. Income statement
3. Balance sheet
4. Statement of cashflow
5. Open them in excel spreadsheet (1) Income statement first, (2) balance sheet below, and (3) statement of cashflow below
6. 1^stcolumn is the item name
7. Column 2----6are for data from each year.
8. 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.
9. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Q:

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

Q:

You will be asked to select a company that is publicly traded. You must research and secure the SEC 10-K Annual Report for the most recent year. This is often available at the company web site. Look...

Q:

Due April 23 before 5pm - You must submit your completed excel file to the submission link on Canvas. Your file must be named correctly - "Your name (first and last) Project 3 part 3. Failure to name...

Q:

BE SURE TO CHECK AFTER THE LAST SUGGESTED STEP TO COMPLETE FOR INFORMATION REGARDING POTENTIAL EXTRA CREDIT ON THIS PROJECT. YOU MUST USE FORMULAS AND CELL REFERENCES ON THE RATIOS PAGE FOR THE...

Q:

ACC 3010 PROJECT 3 PART 3 Fall 2020 Due December 15th before 5pm - You must submit your completed excel file to the submission link on Canvas. Your file must be named correctly - "Your name (first...

Q:

Chapter 16 Developing a sustainable business plan Objectives 1. To define a sustainable business plan and demonstrate its value 2. To describe the benefits of a business plan 3. To set forth the...

Q:

Making Long Term FM Decisions - Integrative Case Title: Analyzing Long Term Financial Decision Making in the Firm (Learning Demonstration 3) Initial Steps to Completion: 1. Organize your team, choose...

Q:

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

Q:

I need to forecast the income statement, balance sheet, and freecash flows generated by the company over a five year period on the attached company. Annual report 2015 Virgin Atlantic annual report...

Q:

A company is planning to invest in three investment ventures. These are condominium (COND), land (LAND) or house and lot (HAL). All of these investment ventures will be used by the business but will...

Q:

Steam at a pressure of 2 MPa and 400oC flows through a pipe of diameter 10 cm with a velocity of 50 m/s. Determine the flow rates of (a) Mass (m). (b) Energy (J). (c) Entropy (S).

Q:

An offer can be conditioned upon each of the following EXCEPT: Question 7 Select one: a . Silence. b . An act. c . Return promise. d . Forbearance.

Q:

Consider liquid water at 1 atm. At 25C, the density of water is 0.997044 g cm 3 . The coefficient of thermal expansion, , is well fitted by = e + ft + gt 2 where t is in celsius and e = 1.00871 10...

Q:

Raspberry Corporation has 4 million ordinary shares outstanding that are currently priced at $8.50 each and have a beta of 1.4. The company has 500,000 preference shares trading at $6 each. The...

Q:

A plane n passes through the point (1,1,1). If b,c, a are the dr's of a normal to the plane, whe a, b, c (a

Q:

Consider three planes P=x-y+z= 1, P- x+y-z=-1 and P;: x- 3y + 3z = 2. La and L be the lines of intersection of the planes P, and P3, P, and P, and P, and P2 respecitvely Statement -1: At least two of...

Q:

The accounting records of Water's Appliances included the following balances at the end of the period: Accrued Warranty Payable Sales Revenue Warranty Expense Beg bal 2,500 114.000 In the past,...

Q:

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

Q:

4. Which is the strongest correlation from the following DBP variable? a) Girls DBP and weight b) Boys DBP and height c) Girls DBP and height d) Boys DPB and weight

Q:

2. If you wish to test the relationship between coping and quality of life, with depression controlled for (co-varied out) you would use: a) Cronbachs alpha b) Cohens kappa c) Partial correlation d)...

Q:

Gheissari et al. (2010) investigated the carotid intima-media thickness in children with end-stage renal disease on dialysis. As part of that study, they performed partial correlations. Look at the...

Previous Question Next Question