Annualized ROR & Standard Deviation

Panayiotis

New Member
Joined
Mar 22, 2005
Messages
38
I have a certain number of yearly quarterly data and I would like to Annualize each year's ROR & Standard Deviation as well as Annualize the overall ROR and standard deviation. For example:
1. Years are listed in column A1:A5
2. Quarterly ROR are listed next to each yr so for example in yr 1 all 4 quarterly ROR's are listed in B1:E1

In F1 can I simply enter =product(1+B1:E1)-1 to find the annualized ROR?
Do I multiply the standard deviation of the 4 qtrly returns by sqrt(4) to annualize the yr 1 standard deviation?

Second, what if I want the annualized ror and standard deviation for all 20 quarters?

Many thanks.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,222,103
Messages
6,163,948
Members
451,867
Latest member
csktwyr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top