Preview

Business Economics - Regression Analysis

Good Essays
Open Document
Open Document
660 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Business Economics - Regression Analysis
Effect of Ratio Profitability: Return on Asset (ROA) and Return of Equity (ROE) to Stock Price of PT Bank Central Asia (BCA) Tbk.

Ratio profitability, Return on Asset (ROA) and Return of Equity (ROE), of a firm is used as one of parameters for investor to decide whether they want to invest or not. The following table consists of ROA and ROE as well as the stock price of PT Bank Central Asia (BCA) Tbk., as one of the largest bank in Indonesia, from year of 2002 up to 2011.
Table 1. ROA, ROE and stock price of PT Bank Central Asia Tbk. tahun 2002-2011 Year | Stock Price(Y) | ROA(X2) | ROE(X2) | 2002 | 2500 | 2.17 | 22.08 | 2003 | 3325 | 2.36 | 24.87 | 2004 | 2975 | 3.04 | 32.52 | 2005 | 3400 | 3.41 | 32.33 | 2006 | 5200 | 3.43 | 33.58 | 2007 | 7300 | 1.68 | 16.47 | 2008 | 5778 | 3.14 | 33.16 | 2009 | 5645 | 3.17 | 32.11 | 2010 | 4284 | 3.28 | 31.23 | 2011 | 3674 | 2.65 | 24.16 |

Using regression analysis we want to determine the relationship between ROA, ROE and stock price of PT BCA Tbk. In this case, ROA and ROE are the independent or explanatory variable (X), while stock price is the dependent variable that we want to explain (Y).

Regression Analysis

SUMMARY OUTPUT | | | Regression Statistics | Multiple R | 0.13028475 | R Square | 0.016974116 | Adjusted R Square | -0.263890422 | Standard Error | 1710.529517 | Observations | 10 |

ANOVA | | | | | | | df | SS | MS | F | Significance F | Regression | 2 | 353656.3 | 176828.15 | 0.060435241 | 0.941840446 | Residual | 7 | 20481378.6 | 2925911.229 | | | Total | 9 | 20835034.9 | | | |

| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | Intercept | 5361.609293 | 2796.526605 | 1.917238793 | 0.096721961 | -1251.125335 | 11974.34392 | -1251.125335 | 11974.34392 | X Variable 1 | -142.3275587 | 3749.125063 | -0.037962873 | 0.970777259 | -9007.599603 | 8722.944486 | -9007.599603 |

You May Also Find These Documents Helpful

  • Satisfactory Essays

    ACC 501 Case 3

    • 664 Words
    • 3 Pages

    The return on Assets is defined by Investopedia as “An indicator of how profitable a company is relative to its total assets. ROA gives an idea as to how efficient management is at using its assets to generate earnings. Calculated by dividing a company's annual earnings by its total assets, ROA is displayed as a percentage. Sometimes this is referred to as "return on investment".…

    • 664 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    • Return on Assets (ROA) Ratio shows the after tax earnings of assets and is an indicator of how profitable a company is. Return on assets ratio is the key indicator of the profitability of a company. It matches net profits after taxes with the assets used to earn such profits. A high percentage rated indicates the company is well run and has a healthy return on assets. Net Profit After Taxes ÷ Total Assets…

    • 2428 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Nordstrom

    • 1502 Words
    • 7 Pages

    b). ROE and RONA are both useful methods to determine a company’s performance. However, ROE and RONA measure a company’s performance in a different way. ROE considers entire company’s income, expenses and gain/loss of a company’s profit; RONA only consider a company’s net profit from operating activities. On the other hand, ROE calculates all returns which come from shareholder’s building of equity; RONA only calculates the operating assets and liabilities which don’t include the financing activities. The non-operating portion of ROE represents is that a company captures profit from financing activities and investing activities (both of them are not operating activities).…

    • 1502 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Miss

    • 624 Words
    • 3 Pages

    For public companies, ROA varies substantially and depends to a large extent on the type of industry. As a comparative measure, ROA for public companies is best applied by comparing it with the company’s previous ROA or with a similar company’s ROA. Since debt and equity financing are utilized to provide for the operations of such companies, ROA gives an indication to investors as to how effectively the invested money is being converted into net income. A high ROA indicates to investors that the company is successful in earning more money with less investment.…

    • 624 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    AMB 201 Market Research

    • 3990 Words
    • 16 Pages

    AMB 201 Marketing and Audience Research Marketing Research Report on environmentally friendly purchase behaviour Word Count: 3000 Words (including tables, figures, references and appendix) TABLE OF CONTENT Executive Summary 1 1. Introduction and Background 2 1.1 Importance of the research 2 1.2 Scope 2 1.3 Research problem 2 1.4 Aims and Objectives 3 2. Methodology 4 2.1 Methodological considerations and assumptions 4 2.2 Sample considerations 4 2.3 Data collection and framework, and analytical considerations 4 3. Ethical Considerations 5 4. Analysis 6 4.1 Descriptive Statistics 6 4.1.1 Gender 6 4.1.2 Age 7 4.1.3 Qualification 9 4.2 Regression Analysis 10 4.2.1 Regression of personal values on…

    • 3990 Words
    • 16 Pages
    Powerful Essays
  • Good Essays

    The analysis for 2011, the company had 1.62 times and for 2010 it had 1.66 times. This means the company is making good use of assets to generate revenue. For profit margin, the company’s profitability increased slightly from 4.30% to 4.97%. Return on assets, which measures the efficiency of a business in using its assets to generate net income increased from 7.16% to 8.05%. Return on common stockholders’ equity increased by 3.02% from 2010 to 2011 that indicates the company has enough money to pay common shares, dividends, and retain funds for business growth.Profitability Ratio is very important information for Investors, customers, managers, andgovernmental…

    • 693 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Such as metrics such as ROA which according to Duponts analysis is composed of Asset turnover multiplied by profit margin. These are a measure of how efficiently the co is able to utilise its assets to convert to sales and then how much of those sales translate to profit. A high ROA is a good indication of a company’s record of being able to convert Investments into profits.…

    • 563 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Ratio Analysis

    • 3271 Words
    • 14 Pages

    Ratio analysis is the most widely used tool since it compares risk and return relationships of firms from various aspects. Ratio analysis is the method or process by which the relationship of items or group of items in the financial statements are computed, determined and presented. It is an attempt to derive quantitative measures or guides concerning the financial health and profitability of a business enterprise. It can be used both in trend and static analysis. There are several ratios at the disposal of an analyst but the group of ratios he would prefer depends on the purpose and objectives of analysis.…

    • 3271 Words
    • 14 Pages
    Better Essays
  • Good Essays

    There is a decline in both the return in investment and return on equity. This shows that the company profit generation in relation to investments is decreasing. The industrial averages of 5.25% for return on investment is higher than that of 3.45% for the company. This shows that the utilization of assets to generate returns is low and not up to the required standards. The industrial average 0f 10.5% for the return on equity is also higher than that of the company which is 7.27%. This shows that the company is not performing up to standards in maximizing shareholders wealth who have contributed capital to the firm. The return per every shilling contributed by investors is low.…

    • 1041 Words
    • 5 Pages
    Good Essays
  • Better Essays

    Accounting Paper

    • 1897 Words
    • 8 Pages

    The first ratio that we found was Return on Assets or ROA. ROA is computed by taking net income and dividing it by average total assets. This is an indicator of how profitable a company is with regards to their assets. It gives an idea into how efficient management is using their assets to generate earnings. Over the two years that we looked into Home Depot’s ROA rose by 1.2%. This rising trend is a result of good use of their assets in 2010 and they were able to generate more revenue than in 2009. On the other hand Lowe’s ROA went down by 1.48% over the course of the two years. They were not able to generate as much revenues in fiscal year 2010 as 2009 and therefore there ROA suffered. Even though Lowe’s ROA went down, its average ROA over the…

    • 1897 Words
    • 8 Pages
    Better Essays
  • Better Essays

    Annotated Bibliography

    • 3399 Words
    • 14 Pages

    of selected profitability ratios on ROE, for this analysis data is gathered from the annual financial…

    • 3399 Words
    • 14 Pages
    Better Essays
  • Powerful Essays

    The Boeing 777 Case

    • 898 Words
    • 4 Pages

    1. We know that there are two ways to increase return on equity RoE. We either may increase the net income or decrease the total equity. Boeing’s latest project Boeing 777 is aimed to increase the company’s net income. In 1988 and 1989 it is stated that Boeing’s total equity is 5404 and 6131 million dollars. It is understood that Boeing has no intention of reducing its shareholders’ equity. Therefore Shrontz’s aim of increasing RoE simply means that increasing Boeing’s net income with Boeing 777 project. In Exhibit 6, it was shown that Boeing’s forecasted pretax profit for 1990 is -142 million dollars but in 1996 forecasted pretax profit is 1,452.46 million dollars and it is increasing until 2024. Therefore, we can deduce that Boeing’s RoE will increase between 1990 and 2024.…

    • 898 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Tero Bau

    • 1906 Words
    • 8 Pages

    1.The following table gives data on imports, GDP and the Consumer Price Index(CPI) for the United states over the period 1970-1998. You are asked to consider the following model:…

    • 1906 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    It was good opportunity to familiarize myself with the stock market i.e. the capital market & their co-relation with economical environment through “Fundamental and Technical analysis of BANK NIFTY Stocks.” The analysis of banking stock gives me the opportunity to understand thoroughly this behavioural pattern’s of different stocks in industry & overall capital market.…

    • 11685 Words
    • 47 Pages
    Powerful Essays
  • Powerful Essays

    Finance

    • 5723 Words
    • 23 Pages

    We prepared the term project which is based on financial statements of the RAK and their major competitor Shinepukur chosen from the same industry. After collecting all the annual reports, we have also access to their websites as well as various newspapers available in the library and the internet. We made several discussions to make our decision. Here, we will try our best to analyze the financial data acquired from the reports of year ended 2009, 2010 and 2011. Moreover, we have used the graphical presentation of trend analysis. In addition we compared their liquidity, productivity, leverage, profitability and market value ratio. It will inform us clearly about which company is in a better situation. Then we will conclude with a financial summary of the ratios using DuPont system of analysis which will help us to see whether the company is fully utilizing its total asset turnover, equity multiplier and profit margin all together.…

    • 5723 Words
    • 23 Pages
    Powerful Essays