AF7004 MSc International Finance Assignment Sample

Financial Econometrics and Forecasting I

Get Assignment Help from Industry Expert Writers (1)

 Section A

 Analysis

 On the capital markets, financial service providers are doing well. A high demand for loans has caused the performance to increase due to increased financial literacy among insurers. This trend is a result of the technological change. The stocks of these companies are more popular with investors than those of other sectors.

However, despite this, investors still need to diversify their investments. This process is called portfolio management. Due to the omission of certain variables like market size, momentum, and size in Sharpe’s CAPM model, two other models were introduced.

Carhart and Fama French are examples of these models. Basically, the goal of this report is to develop a stock portfolio by selecting several companies and then calculating the return on it. Also, we are also going to discuss the parameters and factors of the Fama French model and the dependent factors of the model as well as why they are critical.

Bloomberg.com is making use of 10 stocks from the United States in order to analyze them. These stocks include:

  • S. Steel Corporation
  • bioRad Lab Inc.
  • The Qurate Retail Corporation.
  • Lyondell Basel Industries, Inc.
  • Nucor Corporation
  • Metal Dynamics Inc.
  • PLC Nielsen Holdings
  • westlake Chemical Corporation
  • Alaska Airlines, Inc.
  • Xerox Holdings Corporation

Get Assignment Help from Industry Expert Writers (1)

 

Furthermore, we have examined the data for the last 10 years of each of these 10 listed US companies for the purpose of estimating the Price-to-Earnings ratio; Price-to-Book Value ratio and Dividend Yield ratio for each of the companies.

 

 

  P/E
Companies 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020  
JPM US Equity

 

 

-41.91

 

-11.10

 

-3.10

 

32.40

 

-6.00

 

-4.90

 

51.10

 

3.70

 

4.10

 

-1.00

 
BAC US Equity

 

7.14 17.80 11.52 11.43 8.80 4.47 2.40 4.44 0.00 7.81  
GS US Equity

 

 

13.27

 

13.17

 

46.95

 

37.53

 

38.37

 

208.14

 

58.65

 

19.20

 

7.35

 

6.62

 
MS US Equity

 

 

4.72

 

6.70

 

7.27

 

6.27

 

5.92

 

6.39

 

6.38

 

5.09

 

8.95

 

20.73

 
WFC US Equity

 

12.01 23.05 24.90 18.01 134.54 22.94 12.88 7.41 13.86 23.14  
C US Equity

 

8.38 15.04 20.38 22.84 0.01 21.22 13.58 4.16 10.61 13.94  
PNC US Equity

 

100.38 32.91 18.88 36.46 25.27 25.80 26.85 0.00 0.00 0.00  
BK US Equity

 

 

9.80

 

11.34

 

13.12

 

11.96

 

10.29

 

17.11

 

10.07

 

8.29

 

20.93

 

31.48

 
STT US Equity

 

11.14 7.81 11.27 22.37 11.35 13.03 9.05 25.27 25.80 26.85  
NTRS US Equity

 

5.39 5.94 17.03 19.19 14.47 9.40 34.67 13.60 7.76 27.42  

 

 

 

 

  P/BV
Companies 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020  
JPM US Equity

 

 

1.87

 

0.91

 

2.42

 

0.98

 

0.43

 

2.42

 

3.14

 

1.85

 

1.48

 

1.08

 
BAC US Equity

 

1.23 1.25 1.92 1.36 2.25 1.87 2.21 1.54 0.73 1.25  
GS US Equity

 

 

1.59

 

1.54

 

2.63

 

2.60

 

3.66

 

1.99

 

2.49

 

1.52

 

2.15

 

1.94

 
MS US Equity

 

 

1.20

 

2.63

 

2.70

 

3.12

 

6.33

 

1.54

 

2.63

 

2.60

 

3.66

 

1.54

 
WFC US Equity

 

1.70 1.82 4.23 4.04 4.71 2.56 2.17 1.67 1.67 1.66  
C US Equity

 

1.20 1.32 4.63 5.58 2.41 3.09  

2.49

 

1.52

 

2.15

 

1.94

 
PNC US Equity

 

29.24 30.16 35.89 15.29 27.34 41.95  

1.54

 

2.63

 

2.60

 

3.66

 
BK US Equity

 

 

20.38

 

19.83

 

29.15

 

21.73

 

25.66

 

57.66

 

105.51

 

66.17

69.0

1

 

79.86

 
STT US Equity

 

18.37 11.55 46.69 29.76 10.51 88.73  

1.54

 

2.63

 

2.60

 

3.66

 
NTRS US Equity

 

20.17 17.97 12.06 56.52 18.01 23.00 29.15 19.76 36.8

7

23.19  

 

 

 

  Dividend Yield
Companies 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020  
JPM US Equity

 

 

 

0.71

 

 

0.94

 

 

0.72

 

 

0.54

 

 

2.84

 

 

0.95

 

 

1.74

 

 

0.70

 

 

1.45

 

 

1.40

 
BAC US Equity

 

0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00  
GS US Equity

 

 

0.00

 

0.01

 

0.00

 

0.00

 

0.00

 

0.00

 

0.00

 

0.00

 

0.00

 

0.00

 
MS US Equity

 

 

0.00

 

9.08

 

2.55

 

1.21

 

2.64

 

2.72

 

3.13

 

6.31

 

1.55

 

4.64

 
WFC US Equity

 

3.62 3.38 2.92 2.93 3.65 2.45 2.35 2.92 2.83 3.01  
C US Equity

 

3.03 2.95 2.21 2.41 3.07 1.54 1.46 2.53 2.80 2.71  
PNC US Equity

 

0.00 0.00 0.00 2.27 2.28 2.82 3.67 5.48 5.43 1.48  
BK US Equity

 

 

0.66

 

5.79

 

0.74

 

0.83

 

1.19

 

1.35

 

0.84

 

1.32

 

1.44

 

1.38

 
STT US Equity

 

0.31 0.32 0.32 0.92 1.05 1.49 1.81 1.90 1.70 2.10  
NTRS US Equity

 

2.03 2.34 1.96 1.64 2.58 3.40 3.32 5.01 2.68 4.29  

 

 

 

An EView using the Fama-French model and Carhart’s model:

 

Dependent Variable-  RP Method: Least Squares

Date: 14/5/2022 Time: 1 pm Sample: 2012MDH1536

Included observations: 121

Variable Coefficient Std. Error t-Statistic Prob.
C -0.048325 0.006418 -7.126787 0.0000
MKT_RF 1.008323 0.001676 597.7674 0.0000
HML 0.004833 0.002631 1.734293 0.0867
SMB 0.002678 0.006701 0. 676213 0.3670
MOM 0.002171 0.002144 1.012313 0.3135
R Squared 0.999757 Mean Dependent variance 1.103523
Adjusted R Squared 0.996749 S.D dependent variance 4.135210
SE. of regression 0.067526 Akanke info criterion -2.571523
Sum squared reside 0.493767 Schwartz criterion -2.455818
Log likelihood 159. 6778 Hannah-Quinn criter. -2.525296
F Statistic 1183674.7 Durbin-Watson stat 0.112162
Prob (F-statistic) 0.000000    

 

Command Estimation:

=========================

LS Rp_ C MKT_RF hML SMB MOM

 

Equation Estimation:

=========================

RP_ = C(1) + C(2)*MKT_RF + C(3)*HML + C(4)*SMB + C(5)*MOM

 

Coefficients Substitution

=========================

 

RP_        =    -0.048325   +    1.008323*MKT_RF    +    0.004833*HML   +               0.002678*SMB      + 0.002171*MOM

Econometric issues for the Estimation Process:

 

In the above equation, it can be concluded that variables such as the Risk-free rate and the Headline Margin Level are significant in terms of their correlations, intercepts, as well as probability values as long as they fall below the 5% level. In the case of SMB, even though it has an intercept of below 5%, its probability is 35.10% which also not significant because it is over 5% and 10%. Additionally, the market return is not very significant from a probability standpoint because it is below 5%, but it is significant from a coefficient standpoint as it exceeds the 10% mark. As with the momentum factor, one can see that its coefficient is significantly little below 5% in this case. Therefore, the increase in momentum should not be taken seriously at this point. Although, it does not meet even the 10% significance level when measured in terms of probability, as it is at 31.35%. In this example, the independent variables do not seem to be significant. Furthermore, we can state from the data that model is appropriate and valid in that the Probability (F-Statistics) value is below the significance level of 5% and that this model is valid and appropriate.

 

 

 

 

Estimation Results:

 

Based on our Fama French & Carhart model, we have divided the data annually along with coefficients and significance levels as shown below:

 

  C MKT_RF HML SMB MOM
2011 -0.11191 -0.01652 0.08049 0.04580 -0.07744
2012 -0.02196 -0.03529 -0.05046 0.00804 0.07412
2013 0.04269 0.15205 0.05287 0.02045 0.07449
2014 -0.14198 -0.15214 0.01804 0.07803 -0.07430
2015 -0.02688 -0.00999 0.02253 0.00815 -0.07498
2016 -0.00266 -0.00399 -0.00458 -0.00802 0.00742
2017 -0.02369 -0.03899 0.02047 0.08005 -0.00744
2018 0.19826 -0.09699 -0.18299 -0.04391 0.18079

 

2020 0.16092 0.34309 -0.10098 -0.05766 -0.05404

 

 

As can be seen from the table above, the coefficient fluctuates a lot on an annual basis in all the 10 years included in the study. Observing the market return, we can observe that the significance level is not reached for a period of four times, and for small and medium businesses it is reached merely once. It is evident from these calculations that both the SMB and the market return of the investment portfolio are significant. There is no significant momentum for 1 of the 10 times, more so for HML where it is not significant for 3 of the 10 times. Thus, it is evident that the significance level is maintained most of the time out of every ten years. Thus, it is evident that the significance level is maintained most of the time out of every ten years. The constant (alpha) displayed in the picture indicates a security that has a better performance than the market. F-F models are designed to incorporate independent variables such as Rm- Rf, SML, and HML. Based on our analysis of the following review, we can conclude that when an investor invests in small-sized companies, his/her portfolio return will increase, and when his/her book-to-market ratios are increasing, his/her portfolio return will decrease. Based on the F-F-model and the Carhart functions applied to the entire data, we can conclude that the alpha value for the stock is positive, meaning that it is performing better than the market. Hence, the betas of the curve determine the coefficients of the regression line. According to the subsamples, we can observe an increase of beta coefficients in the first year compared to later in the study. In other words, between 2009 and 2011, the beta coefficients have increased. Carhart’s data analysis shows that the values of the security are changing but the security is performing well, as we can see from the data derived from the model. Considering the results of the study, I believe that small size companies tend to operate more effectively than large companies. There are two reasons for this: first, small businesses can grow faster than large companies since they have a high growth rate. Furthermore, firms with a high ratio between book value and market value will be able to improve their profitability better than companies with low ratios. Normally, companies with a high book-to-market ratio will have a high investment ratio and a high Return on investment as a result of this.

 

 

 

 

 

Section B: Intervalling Effect

Calculation of Beta using CAPM in EViews:

 

 

 

 

Companies

Beta Monthly The daily beta  

 

Relevance

 

 

Differences

Boeing inc 6.72 1.21 0.00 2.50
Chevron Group 1.86 3.29 0.00 1.57
Salesforce 3.21 1.27 0.00 1.94
Apple inc 1.89 2.68 0.00 1.22
Dow 1.78 2.34 0.00 -0.57
Procter & Gamble -1.86 -3.16 0.00 -0.79
Intel Corporation 5.70 2.27 0.00 -0.52
Visa 3.41 2.14 0.00 1.24
Boots Alliance Inc. 1.60 2.12 0.00 -0.53
Goldman Sachs group Inc. 2.88 1.97 0.00 2.94
IBM Inc. -3.16 -2.60 0.00 -0.52
Johnson & Johnson -2.84 -2.06 0.00 -0.74
McDonald’s Corpo. -2.29 -1.87 0.00 -1.43
Merck & Co Inc. -1.70 -1.85 0.00 0.12
Honeywell Inc. 1.85 2.34 0.00 1.52
         

 

 

During this part of the analysis, it was noted that a typical volume for the Boeing Company was 9,759,187, while its market cap was 126.955 billion. As for the Beta, for the 5 years that the company has been in business, it is 1.51. This means that the ESG score risk of our company for the five years has been calculated at 36.1, which has the significance of a high risk for our company. The Visa Company, in contrast, has a stock volume of 575,482 and a market capitalization of 425.021B. Additionally, this company has a Beta value of 0.97 over the past five years. As opposed to Johnson & Johnson Company whose stock has a volume of 7,961,033 shares and a market cap of 450.833 billion dollars, the Johnson & Johnson Company has a stock volume of 7,364033 shares and a market cap of 42.833 billion dollars.

 

Econometric Issues

 

Autocorrelation – Regression models that perform well won’t show autocorrelation. We assume that residual terms are auto correlative, otherwise, residual variables are not auto correlative. We will assess the assumptions of both models by applying the Durbin- Watson statistic. Eviews determines the significance of the statistic.

 

  1. Autocorrelation:

I took the Durbin-Watson statistic Test to check the autocorrelation for daily and monthly frequency and these were the results

 

Durbin-Watson statistics- Test for Autocorrelation-CAPM Model
Market cap size Ticker name Daily Frequency Monthly Frequency
Large Cap AAPL US Equity 1.81782 2.346444
FB US Equity 1.977565 2.065962
JPM US Equity 1.987926 1.643169
PG US Equity 1.950438 1.576191
UNH US Equity 2.043524 2.265119
Medium Cap COP US Equity 1.978905 2.134323
CZR US Equity 1.65796 2.287933
PXD US Equity 2.052081 2.245921
IFF US Equity 2.037543 2.207603
NRG US Equity 1.886221 1.671999
Small Cap MKTX US Equity 1.986005 2.312385
NLSN US Equity 1.95357 2.155309
IPGP US Equity 2.051118 2.38618
FFIV US Equity 2.004866 1.733443
JNPR US Equity 2.187305 2.219928

 

The value 0 indicates the positive correlation and the value 4 indicates the negative correlation but The values of all the companies were lies between 1.5 to 2.5 in both daily and monthly frequency. Hence there are no signs of autocorrelation in these stocks

 

Heteroscedasticity- When the predicted variable in a standard deviation as compared to a value of an independent variable, or with respect to the standard deviations of a previous time period, are not constant, then this is a skewed distribution in the prediction

 

To test the heteroskedasticity I perform whites tests in all the 15 stocks both monthly and daily and these were the results.

 

White test – Test for Heteroskedasticity-CAPM Modle
Market cap size Ticker Name Daily Frequency Monthly Frequency
Obs*R-Squared Prob Chi-square Obs*R-Squared Prob Chi-square
Large Cap AAPL US Equity 5.083131 0.079 0.287226 0.866
FB US Equity 0.057809 0.972 3.710243 0.156
JPM US Equity 37.67357 0 4.713201 0.095
PG US Equity 78.50388 0 0.721154 0.697
UNH US Equity 78.41739 0 0.01012 0.995
Medium Cap COP US Equity 105.6406 0 11.51283 0.003
CZR US Equity 202.301 0 25.83419 0
PXD US Equity 105.7084 0 14.23327 0.001
IFF US Equity 3.270429 0.195 0.013264 0.993
NRG US Equity 4.06002 0.131 0.320205 0.852
Small Cap MKTX US Equity 13.28614 0.001 4.335036 0.115
NLSN US Equity 13.52086 0.001 0.141234 0.932
IPGP US Equity 6.423702 0.040 0.182082 0.913
FFIV US Equity 3.191065 0.203 3.847757 0.146
JNPR US Equity 2.9996864 0.224 0.771334 0.724
 

Significant

 

 

 

 

CAPM Model -Beta estimation with S&P 500
Market cap size Ticker name Beta Daily P-Value Monthly P-Value
Large Cap AAPL US Equity 0.070175 0.0478 1.488473 0.1027
FB US Equity 0.024568 0.5914 0.159078 0.8401
JPM US Equity -0.00624 0.8536 -0.09782 0.8738
PG US Equity 0.014637 0.6102 0.456843 0.3731
UNH US Equity 0.035928 0.3154 1.080463 0.1106
Medium Cap COP US Equity -0.08215 0.1728 -2.03813 0.0691
CZR US Equity 0.059165 0.5564 -0.74762 0.7421
PXD US Equity -0.07899 0.247 -2.52777 0.0245
IFF US Equity -0.04941 0.2293 -1.21754 0.2098
NRG US Equity 0.04143 0.4892 1.053643 0.4189
Small Cap MKTX US Equity 0.096029 0.0539 2.293223 0.0566
NLSN US Equity -0.11423 0.043 -3.07833 0.0032
IPGP US Equity 0.019257 0.7694 0.073456 0.9566
FFIV US Equity 0.00377 0.9298 -0.15139 0.86
JNPR US Equity -0.05866 0.16 -1.02262 0.1829
 

Significant

As seen in the table the beta estimation of parameters was not significant in most areas hence deriving the direct relation between the index and stocks would be not meaningful. But there were 3 parts in daily beta value that show that negative relationship between the stock and index with a 10% significance level.

 

In the large-cap estimates, the average sum of daily beta is higher than the average sum of monthly betas indicating the frequency of the trading is higher when coming to the daily beta and the relation with index is also closer compared to the monthly data.

 

As same as the large-cap, the mid-cap stocks the average sum of daily beta is higher than the average sum of monthly betas but the values were positive here stating the direct relation between the index movement and the stock movement

 

In the small-cap, the average sum of beta value is daily higher than the monthly. And also, the difference is huge between the average sum of daily beta and monthly beta indicating the market moves more forward or vice versa in the monthly period of time not on daily basis

 

Multicorrilation- Assuming heterogeneity in independent variables is an assumption of linear regression. Endogenous variables will not result in linear regression. In equations in which the independent variable is defined, multicollinearity occurs. Multicorrelation will be tested using a variance factor test in our analysis

 

  1. The beta coefficient measures how volatile a particular stock is in relation to the market-wide systematic risk. Simply put, betas tend to tilt lines back to the right direction. All of the information in finance is aimed at making a profit on stock in comparison to others in the market. When it comes to volatility (Lin, 2018), the beta model accurately captures the profit margin movement. By changing the market interest rate over a predetermined period of time, we can determine the collateral beta by dividing the covariance effect of both collateral profit and market gain.

Assuming the stock has a beta of 1, it indicates strong correlation between its price and the market. Such stocks are accurate risks. A beta statistic, however, cannot measure random risk. Portfolio risk does not increase with the addition of stock to beta 1.0, but it does not increase its chances of providing additional benefits. In order to buy a protection contract with a beta less than 1.0, the investor has to assume that the protection is not as mental as the market. If we remember this portfolio stock, we are far safer than if we had the same portfolio without it. The beta of service stocks is typically low since they move freely than market capitalization stocks. Security costs are not substantially higher than the market because beta is more prominent than 1.0. Stocks that are new or small have a higher beta than market benchmarks. Accordingly, adding stocks to a portfolio will increase the risk of the portfolio, while increasing its normal return. However, there are some stocks with a negative beta. Stocks with negative beta equal negative market benchmarks. With complete representation of marking patterns, this stock can be considered counterintuitive. A counter ETF provides protection against bad beta. Negative beta is also common in several industrial circles, like gold mines.

 

 

 

Section C: Determinants of Capital Structure

 

In the following case, we will use the Pooled Regression Method according to the Redundant Fixed Effect to evaluate whether the Method is appropriate for the following data.

 

Tests of Redundant Fixed Effects Equation: Untitled

Test fixed effects cross-section

 
Test Effects Statistic d.f. Prob.
Cross-section F 42.327953 (63,469) 00.0000
Cross-section Chi-square 892.880204 62 00.0000

 

test equation of Cross-section fixed effects: Dependent Variable of LEV

Method: Least Squares of Panel Date: 15/5/22

Time: 10pm

Sample: 53545354

Periods included: 11

Cross-sections included: 65

Unbalanced

Total panel observations: 539

Variable Co- efficient Standard. Error T Statistic Prob
C -0.246352 0.081175 -2.757558 0.0751
Beta -0.025295 0.017571 -2.117544 0.0751
Dividend 0.052774 0.027568 1.375156 0.1590
nwc -0.184352 0.047566 -3.927531 0.0003
roa -0.355209 0.077521 -4.687568 0.0004
 

 

 

 

 

 

       

 

SIZE                                  0.035021     0.005437     6.440899      0.0000

 

R Squared 0.224658 Mean dependent var 0.224641
Adjusted R Squared 0.214615 S.D. dependent var 0.146460
SE. of Regression 0.124680 Akaike info criterion -1.211757
Sum Squared reside 8.974683 Schwarz criterion -1.183179
Log likelihood 336.7468 Hannan-Quinn criter. -1.211124
F Statistic 29.94683 Durbin-Watson stat 0.111703
Prob F-statistic 0.000000    

 

 

With the Likelihood Ratio and the redundancy fixed effects, we see that the probability value is 0%, which is less than 5%. The pooled regression model is perfect according to the Null Hypothesis model. In addition, the fixed effect model is appropriate according to the alternative hypothesis. Thus, the Fixed Effect Model can be demonstrated to be a perfect model according to the Redundant Fixed Effect Model.

 

 

 

 

 

Regression Equation of Random Effects:

 

Using the EViews panel data, we ran random effect regression and obtained the following results:

Variable Dependent –  LEV

Method: Cross-section random effects- Panel EGLS

Date: 14/5/22

Time: 2.00

Sample: 382473847

Periods included: 13

Cross-sections included: 35

Total unbalanced panel observations: 524

Arora and Swamy estimator of component variances

Variable                              Co- Efficient Stand. Error                      T Statistic                          Prob. C           -0.335807   0.105665      -2.798634                        0.3554

Beta                      -0.023539     0.010136    -2.796374      0.0055

Divodend             -0.032356     0.016686    -2.165630     0. 5508

Nwc                -0.135747     0.036685    -2.863090      0.0025

Roa                 -0.193565     0.042664    -4.519635      0.0020

Size                 0.043580     0.006629     5.828635      0.0000

Specification Effects

S.D.                                                                                                  Rho.

random Cross-section                                               0.113658      0.7942

RSquared 0.123514 Mean var dependent 0.038788
Adjusted RSquared 0.151197 S.D. var dependent 0.067836
S.Eof regression 0.061517 Sum resid squared 2.078508
F-Statistic 15.50517 Durbin Watson stat 0.754792
Prob(F-statistic) 0.000000    
Un weighted Statistics
RSquared 0.194655 Mean var dependent 0.223041
Sum squared reside 9.313571 Durbin Watson stat 0.163571

 

Idiosyncratic random                                                                                     0.063562                                                                                  0.2354 Statistics Weighted

 

 

 

 

 

 

 

 

Test for Normality:

EViews can be used to calculate the normality histogram as follows:

The Histogram – Normality Test can be viewed under Residual Diagnostics: View > Residual Diagnostics > Histogram Normality Test

The panel data analysis has been conducted using three models.

  • Regression models by pooled datasets
  • Hausman Model or Fixed Effect Model
  • Random Effect Model

Step 1 In order to obtain and maintain the appropriateness of the outcomes, we need to determine first whether the panel data should be analyzed with the Fixed Effects Model or the Random Effects Model.

Step2: Selection of the Panel Options > Under Period, select ‘Random’.

Step 3: Click on OK

Step 4: Correlated Random Effects (also known as the Hausman Test) can be found under View > Fixed/Random Effects Testing

 

In EViews, the Hausman test is carried out as follows:

You may load the panel data in EViews, select Equation Estimation from the drop-down menu, then Specifications, and invert each variable’s order of input from the first variable to the last variable.

Null Hypothesis of the Hausman Test:

It can be seen that this test is likely to be appropriate for the random effects model, considering its result of the null hypothesis test of Hausman Test.

Hypotheses alternative to the Hausman Test: In addition, the alternative hypothesis of Hausman test can also be applied to the Fixed effect model.

 

 

Result of Test:

In terms of the Hausman Test, we are able to see that the probability value is at 18.09% and this is substantially higher than the standard 5%. In other words, this indicates that the results are both acceptable and significant. When such a case occurs, it is obvious that the null hypothesis will be retained and that the Random Effect model is most appropriate. It can also be stated that the Random Effect Model has also been run after confirmation of the results obtained from the Hausman Test and its effects have also been taken into consideration.

Model of Random Effects:

 

Following are the steps that have been followed in order to run the Random Effect Model in EViews:

Step 1: In EViews, click on Panel Data, then click Equation Estimation, then click Specifications, then arrange the variables according to dependent first, then independent.

 

Step 2: In step 1, select the Panel Option, then Select the ‘Random’ under Cross-section.

Step 3: click on ok

 

Output Analysis:

 

The following table is derived from the Random Effects Model. The extracts from the data panel indicate that the independent variable is quite statistically significant, and that can be seen clearly from the data. Furthermore, based on this model, the probability value is below 5%

 

Variable Co- efficient Standard. Error TStatistic Prob.
C -0.300207 0.107465 -2.765334 0.0474
BE-TA -0.028209 0.016536 -2.796574 0.0473
DIVI-DEND -0.020016 0.016586 -2.166540 0.4708
Nwc -0.120747 0.036585 -2.816590 0.0475
Roa -0.192065 0.048654 -4.519755 0.0000
Size 0.043200 0.007659 5.828655 0.0000

 

Also, we can find out from the F-statistics calculations that the probability of the Random Effects Model being significant is zero, which indicates that the model is quite significant in terms of accuracy. With respect to the capital structure of the company, all the independent variables have negative impacts. Therefore, the size alone of the company has a positive effect on its capital structure. In essence, this means that if Beta increases, dividend payments rise and the net working capital increases, and return on capital assets increases then the company capital structure will be negatively affected.

Conclusion

By using the EViews software, the financial data can be evaluated precisely. As well as that, EViews provided econometric tools. Additionally, it can be noted that there are some limitations in analyzing the panel data with EViews. A pivotal aspect of this analysis involves the selection of five large, five medium, and five small cap stocks. It is likely that the stock analysis and outcomes would differ if different stocks were chosen, as the model for selection was the Fama- French and Carhart Model. Second, we selected the stocks of the company using the same process. Furthermore, if the stocks chosen had been different, the beta would have been different. In addition, S&P500 was used to calculate beta in the US. The result of the beta analysis would have been different had we chosen a different stock exchange.

 

References

Anon. 2022. [online] Available at: <https://www.investopedia.com/ask/answers/010915/what-considered-good-price-book- ratio.asp> [Accessed 14 May 2022].

Equitymaster.com. 2022. [online] Available at: <https://www.equitymaster.com/glossary/price-book-value-ratio/> [Accessed 14 May 2022].

Investopedia. 2022. Dividend Yield; Formula and Calculation. [online] Available at: <https://www.investopedia.com/terms/d/dividendyield.asp> [Accessed 14 May 2022].

Investopedia. 2022. Price-to-Earnings (P/E) Ratio. [online] Available at: <https://www.investopedia.com/terms/p/price-earningsratio.asp> [Accessed 14 May 2022].

Investopedia. 2022. What Is the Fama and French Three Factor Model?. [online] Available at: <https://www.investopedia.com/terms/f/famaandfrenchthreefactormodel.asp> [Accessed 14 May 2022].

 

 

Leave a Comment