ﬂ 6 ' | ‘K Search the web... Retake Financial Econometrics 2m 772m 8 El Insert PageLayout Formulas Data REVIEW VIEW Developer Help | DNavigationCancelled x n E KOUKA Van l1 E 1

m .a. l:|:| an i._.i A t S .

3%: Cut Callbrl . 11 . p, ' 5E. Wrap Text General . .1 Normal Bad Good (E-EI EEK j 2 u 0 urn QT p

Ea Copy ' i . m Fm.

Paste _ I u , . (.2 g c. Mergeacme, , :r V 9/ , an no Conditional Formatas Neutral Calculation m Insert Delete Format Sorta rinda

" Fo'mal Pewter ’ i g a "a Formatting . Table . . ~ 9 C'ea" Filter~ Select .

Cilpbnard r. Font rs Alignment F. Number l: styles Cells Editing A

323 v E for v

A B C i D i E i F i G i H i I i J i K i L i M i N i 0 i P i Q i R i S i T i U i v i w i A Gnal: Run 2 linear regression: in order to explain v a Cast of Equity (cos) and than v a Cast of Capital (WAcc). The following steps need to be undertaken for each dependent variable underconsideration (First for COE, and second for WACC). Step 1: Men n'fy a maximum ofs explanatory factors (lie. 5 independent variables X) for each of the 2 dependent van'able: V.

:> identify a maximum of 5 factors to explain the evolution ofthe COE across industries,

and a maximum of 5 factors to explain the evolution of WACC across industries. iaiwimi”i°‘i”‘i“i“‘k i

1) Compute the correlation matrix ofthe data. 2) Explain how you select your factors: rationale, tests used and detailed tests' outputs/resuits/interpretations.

3) Draw the cloud plot of Y with each selected X. Step 2: Run the regression of Y on in- explanatory factor: X. 1) Run the linear regression. 2) Display the goodnessVofafit statistics or tests, and comment your results. 3) Display the robustness statistics ortests, and comment your results. 4) if the regression needs to be readjusted, run the new regression.

4a) Explain why the regression needsto be readjusted (e.g. insignificant factors, heteroscedasticity issues).

4b) Do again 1), 2) and 3) of step 2. Stag 3: interpret Fhe regressien': mluftr in the lens ofa corporate finance advia-or or a ﬁnancial market adviror.

1) COE and WACC sensitivity to factors. 2) lndustries' vulnerability. 3) lstliere some missing information here? - ' ' suauesrmnsmhelnuou

i Data Description INSTRUCTIONS Raw Data i Scaled Data i Staled Data (2) i Eviews and othervideos i (.9 Ready 5 n O Taper ici pour rechercher (i. 12

11

ii

11

13

ll

13

11

an

2L

g

g

2:

2:

23

2L

A Scree n5 hot saved