You are interested in the determinants of analyst following for publicly traded companies. You conduct a...

You are interested in the determinants of analyst following for publicly traded companies. You conduct a regression on 76 observations, specified as follows: Analystsi = b0 + b1 (D/E)i + b2 Sizei + error Where Analysts is the natural log of (1 + number of analysts), D/E is the debt to equity ratio of the company, and Size is the natural log of the company's market cap, in millions. Your regression results are as follows:

Based on this information, what would be the predicted number of analysts following a company with a debt to equity ratio of 0.33 and a market cap of 170 million dollars?

	Coefficient	Standard error
Incercept	-0.17	0.03
D/E	-0.14	0.12
Size	0.45	0.14

Correct Answer is 7.12

hint: Note that both the size and analysts variables in the regression specification are natural logs of the observed quantities. Note also that Analysts is ln(1+number of analysts), since ln(0) is undefined.

PLEASE DO IT ON EXCEL AND SHOW THE STEPS.

Solutions

Expert Solution

The correct answer is 7.12

Regression equation is:

Analystsi = b0 + b1 (D/E)i + b2 Sizei + error

Where Analysts is the natural log of (1 + number of analysts), D/E is the debt to equity ratio of the company, and Size is the natural log of the company's market cap, in millions.

Before we get into excel, let's convert the regression equation in the format of the variable:

ln(1 + number of analysts) = b0 + b1 x (D / E) + b2 x ln(Market Cap in $ mn)

Please see the screenshot of the excel below. In the column with heading as "Formula" i have displayed the formula used in applicable cell.

The correct answer is 7.12; it appears in the cell highlighted in yellow below.

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Select a successful publicly traded company that you are interested in and use the Internet to...

Select a successful publicly traded company that you are interested in and use the Internet to research its use of inventory management systems and technology. Examine the inventory management system of the selected publicly traded company. Determine the key ways that inventory management systems and technology have given the selected company a competitive advantage in the marketplace. Evaluate the efficiency of two common inventory control systems. Determine the ways in which they provide a firm with a competitive advantage in...

You are a research analyst for a publicly traded company, and you’ve been assigned to give...

You are a research analyst for a publicly traded company, and you’ve been assigned to give a presentation on how a company uses performance metrics in corporate valuation. Think about how you would present return on equity (ROE) and earnings per share (EPS) to a group of investors or senior management. Explain the use of ROE and EPS in evaluating the value of a company. Include how to calculate ROE and EPS. Why is understanding ROE and EPS important to...

You are a research analyst for a publicly traded company, and you’ve been assigned to give...

You are a research analyst for a publicly traded company, and you’ve been assigned to give a presentation on how a company uses performance metrics in corporate valuation. Respond to the following in a minimum of 175 words: Think about how you would present return on equity (ROE) and earnings per share (EPS) to a group of investors or senior management. Explain the use of ROE and EPS in evaluating the value of a company. Include how to calculate ROE...

You are a research analyst for a publicly traded company, and you’ve been assigned to give...

Write an analysis in which you address the following: • Select two publicly-traded companies within the...

Write an analysis in which you address the following: • Select two publicly-traded companies within the same industry and present the DuPont analysis for each of these companies. Explain how the debt has served to influence the ROE DuPont performance results for each, and then describe how volatility plays a role in the debt choices in the context of this DuPont analysis. • Consider each of the following capital structure theories: the tradeoff theory, the signaling theory, the debt financing...

Ratio Analysis Review and compare the following ratios for both companies: Choose two publicly traded companies...

Ratio Analysis Review and compare the following ratios for both companies: Choose two publicly traded companies in the same industry. Working capital Current ratio Debt ratio Net Profit Margin Review the most recent ear Review the Earning's call for both companies and report your findings to include, but not limited to, results and projections.

The Sarbanes-oxley Act of 2002 requires which of the following for publicly traded companies: a) management...

The Sarbanes-oxley Act of 2002 requires which of the following for publicly traded companies: a) management assessment of the effectiveness of the disclosure control structure used to determine financial results b) audit committee approval of all services provided by a company's independent auditors. c) reporting by the independent auditors on the reliability of management's assessment of internal controls. d) all of the above are required by the Act What is the correct answer ?

Research one (1) publicly traded company in which you are interested using the Internet and/or Strayer...

Research one (1) publicly traded company in which you are interested using the Internet and/or Strayer databases. Review its most recent statement of cash flows and income statement on the company's Website. Be prepared to discuss. Outline a strategy for companies to spend excess cash and maximize the value of that spend. Provide a rationale for your response. Compare and contrast the selected company's statement of cash flows to its income statement. Suggest at least two (2) items from each...

research one (1) publicly traded company in which you are interested Locate the company website and...

research one (1) publicly traded company in which you are interested Locate the company website and financial statements. Also locate information on the types of bonds the company issues. Review the Liabilities section of the company’s Balance Sheet. a)Imagine that you just read about another company in the same industry facing criminal charges for misrepresenting their liabilities. Naturally, you’re worried that the company you’re researching might be doing something similar. Hypothesize a scenario in which someone at the company could...

For this week's Discussion, research one (1) publicly traded company in which you are interested using...

For this week's Discussion, research one (1) publicly traded company in which you are interested using the Internet and/or Strayer databases. Locate the company website and financial statements. Also locate information on the types of bonds the company issues. Review the Liabilities section of the company’s Balance Sheet. Be prepared to discuss. 1. Imagine that you just read about another company in the same industry facing criminal charges for misrepresenting their liabilities. Naturally, you’re worried that the company you’re researching...

Subjects