Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I really would appreciate it if someone could provide me with the Excel formulas to calculate the last five (5) columns of the spreadsheet listed

I really would appreciate it if someone could provide me with the Excel formulas to calculate the last five (5) columns of the spreadsheet listed below.

# of Trading Days Before/After Event Date DATE Closing Prices Procter&Gamble MKT-Rf Rf Returns Honeywell Expected Returns Procter&Gamble (ER) Abnormal Returns Procter&Gamble (AR) AR t-test AR Significant (Y/N) ? Cumulative Abnormal Returns Procter&Gamble (CAR)
-270 1/2/2004 49.4950 -0.17 0.003
-269 1/5/2004 49.7400 1.2 0.003 0.4950056
-268 1/6/2004 49.4900 0.2 0.003 -0.5026136
-267 1/7/2004 49.0500 0.34 0.003 -0.8890745
-266 1/8/2004 49.5650 0.45 0.003 1.0499491
-265 1/9/2004 49.8200 -0.72 0.003 0.514478
-264 1/12/2004 50.1250 0.57 0.003 0.6122039
-263 1/13/2004 49.8500 -0.51 0.003 -0.5486324
-262 1/14/2004 50.0150 0.8 0.003 0.330995
-261 1/15/2004 49.7550 0.15 0.003 -0.5198401

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions