Purchase Solution

Excel Formula for Market Capitalization

Not what you're looking for?

Ask Custom Question

The market capitalization and the salary of the chief executive officer for 20 companies are shown in the following table:

See attached file.

A. Develop the estimated regression equation that can bee used to predict the CEO salary give the market capitalization.

B. The residual analysis to determine whether any outliers and or influential observation are present. Briefly summarize your findings and conclusions.

Attachments
Purchase this Solution
Solution Summary

The expert examines excel formula for market capitalization.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • DJIA: Market Capitalization and Distribution

    Explanations are included in the Excel. The solution decides whether the market capitalization of companies in the DJIA appears to be approximately normally distributed

  • Cost of equity capital : explained

    We use the compound interest formula 2.48 = 1.39 X (1+rate)^9 We can solve manually by trial and error or use the RATE function in excel. In put NPER = 9, PV = -1.39 and FV = 2.48. The growth rate comes to 6.6%.

  • Finance questions

    Excel formulas or table) I will provide credit assuming I can tell which approach was used.

  • Market capitalization, book debt-equity ratio

    Please show in Excel. ** See ATTACHED file(s) for complete details and SOLUTION ** In March 2005, General Electric had a book value of equity of $113 billion, 10.6 billion shares outstanding, and a market price of $36 per share.

  • Finance questions - Cisco systems

    The market capitalization would be the present value of repurchases.

  • Balance Sheet and Market Value of General Mills

    Regards, DKF The attached MS Excel spreadsheet contains a detailed market value, as well as a debt and ratio analysis for the General Mills Company for its 2012 fiscal year.

  • Statistics help needed

    Prediction of market capitalization are determined.

  • Financial Ratios

    Long-term debt $65,000 A Other long-tern debt $25,000 B Shareholders Equity $80,000 C Capitalization $165,000 LTDR = Long-term Debt / (Long-term debt + Total Shareholders Equity) = 85,000 / 165,000 = 0.5151 Excel Formula Written

  • Calculate Net Operating Income for a rental property

    The capitalization rate (cap rate) formula is applied also.

View More Related Solutions