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
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
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,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.