Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what excel formal or code be used? 31. FILE Stocks, Investors usually consider a variety of information to make investment decisions. The accompanying data file
what excel formal or code be used?
31. FILE Stocks, Investors usually consider a variety of information to make investment decisions. The accompanying data file contains a sample of large publicly traded corporations and their financial information. Relevant information includes stock price (Price), dividend as a percentage of share price (Dividend), price to earnings ratio (PE), earnings per share (EPS), book value, lowest and highest share prices within the past 52 weeks ( 52 wk low and 52 wk high), market value of the company's shares (Market cap), and earnings before interest, taxes, depreciation, and amortization (EBITDA in \$ billions). As the price to earnings ratio is often considered a better assessment of stock valuation than stock price or earnings per share alone, the financial analyst would like to remove Price and EPS from the data set. Remove these variables from the data set. a. The financial analyst is most interested in companies with a higher book value than market cap. Remove all observations that have a lower book value than market cap. How many observations are left in the data set? b. The financial analyst also wants to remove companies with price to earnings ratios that are higher than 25 . How many observations are left in the data set after those companies are removed? Ready if Accessibility: Good to go 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