Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need to have some calculations for the Stock of Netflix and American Express. The Data is supposed to be from the Annual Report

Hi, I need to have some calculations for the Stock of Netflix and American Express. The Data is supposed to be from the Annual Report of 2017 for each Stock and data from yahoo finance. The following needs to be calculated in an excel sheet: Compute the following key measures for your chosen stocks:

- Market Capitalization (look up the shares outstanding online on yahoo finance)

- Market to Book Ratio (plus Indication whether Value or Growth Stock)

- Book Value of Equity

- Debt to Equity Ratio (book values)

- Daily Return

- Average daily Return

- Standard Deviation of daily return (use Excel formula)

- Net Working Capital

- Enterprise Value

- Current Ratio

- Quick Ratio

- Earnings per Share

- Operating Margin

- Net Profit Margin

- Leverage Ratio = EBIT/Interest Expenses

- Return on Asset

- Return on Equity

- P/E Ratio

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

Corporate Treasury And Cash Management

Authors: Robert Cooper

1st Edition

1349512699, 9781349512690

More Books

Students also viewed these Finance questions

Question

Prove parts (b) and (c) of Theorem 1.3.4.

Answered: 1 week ago

Question

=+2. What different types of products exist in the book industry?

Answered: 1 week ago