Question
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
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