Calculating the cumulative abnormal return

In the main table tab we will need your help to fill out the column CAR. The CAR can be obtained using Part 1 and Part 2 and by following these steps.

1. Calculate the return

2. Calculate the intercept, slope and std using the 21st return till the 60th return

3. Using the previously calculated intercept and slope, calculate the ER

4. Using the ER and and the Return, calculate the AR

5. Summing up the first 20 AR and you get the CAR

We already did the first 3 companys Symeria, Ironwood and Terreno Reality as a sample, so you can see how to do it using the sample.

If you have further questions please do not hesitate to contact us.

Færdigheder: Excel

Se mere: Return, calculating, summing, slope, cumulative return vba, cumulative return excel monthly return streams, cumulative abnormal returns regression spss, cumulative abnormal return regression spss, cummulative abnormal return excel, calculation tool cumulative abnormal returns excel, calculating drawdown investment return series, calculate cumulative abnormal return excel, calculate abnormal return excel, cumulative return calculation vba

Om arbejdsgiveren:
( 0 bedømmelser ) Hamburg, Netherlands

Projekt-ID: #6027059