Help with VaR

Hi everybody. First, sorry about my english.

I have a doubt about calculating VaR. Hope you can help me.

I´m trying to calculate VaR based on a document that i´ve read at J.P.Morgan´s website. The URL is bellow:

http://www.jpmorgan.com/tss/General/Risk_Management/1159360877242

I´m using the follow VaR formula: VaR=PortfolioValue*StandardDeviation*Z

Where:

Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147

My final result is -5.393.013,27

But in the document the final result is 4.993.012,77

So, i think it´s because i´m calculating the Relative VaR and the document uses Absolute VaR, but when I try an Absolute VaR formula my final result is 4.993.013.27.

I´m using the follow formula of Absolute VaR:

VaR=-(PortfolioExpectedReturn+Z*StandardDeviation)*PortfolioValue

Where:
Portfolio Value = 100.000.000
Standard Deviation = 0,03278719262151
Z = -1,64485362695147
ExpectedReturn = 0,40%

I know that it´s a insignificant difference, but I would like to know if everything is correct and if the document is really using Absolute VaR instead of Relative VaR.

I´m a beginner, so please be patience! lol

Thanks a lot in advance.
 
Top