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.
27 freelancers are bidding on average $105 for this job
Hello, my name is Cristian, I have a degree in Business and I am Financial Advisor. I also work with excel every day. and I am a methodical and meticulous person. Greetings.
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide the sample excel sheet for me to understand the calculation better. Regards Sawan
I have experience working on computation of CAR using Stata, SAS, excel. I can definitely work on the assignment as I am very comfortable with it, Could you please share the excel file with me? Thanks! Deepti