Equivalent Periodic Return

bhar

Active Member
Hi David

On Page 58 of Study note - 2012 T4 Valuation. Could you please help with the formula for the column Equivalent Periodic Return. I am not able to get the rate that you have solved for.
Thanks
 

bhar

Active Member
Hi All
I have uploaded the file below. THis is for you to help in calculation of the Equivalent Periodic Return. Shakthi, do let me know if can provide me the formula for the column, Equivalent Periodic Return. Thanks
 

Attachments

  • Book1 for David.xls
    19 KB · Views: 3

David Harper CFA FRM

David Harper CFA FRM
Subscriber
Hi bhar,

Here is the underlying XLS https://www.dropbox.com/s/sslcqspxswacwgn/hull.04.01.xls (it is my expansion of Hull Table 4.1)
It applies the formula above the table on page 58 for the discrete return, which, unfortunatey, I can see has a typo, and should read:
R(m) = m*(exp[R(c)/m] - 1).

In the case of m=2 (ie, semiannual compounding), R(2) = 2*(exp[9.531%/2] - 1) = 9.7618%

What this means, by definition, is that 9.531% compounded semiannually is "equivalent to" (produces that same terminal value) 9.7618% compounded continuously:
100*exp(9.531%) = 100*[1+9.7618%/2]^2 = $110

(I think the table is frankly confusing: the first column, Terminal Value, is used in Hull's Table 4.1. Then I added the next two columns). Thanks,
 
Top