Computation of portfolio VAR The provided yields data file (yields.xls)

Hello I need help with the following questions. Description isMay 13, 20221. Given a directed graph, described with the set ofMay 13, 2022

Computation of portfolio VAR 
The provided yields data file (yields.xls) contains 5-year yields from 1953 to 1994. Using this information and the duration approximation, compute the portfolio VAR as of December 1994. Risk should be measured over a month at the 95% level. Report the distribution and compute the VAR:
· using a normal distribution for yield changes (Delta-Normal method) and a 12-month moving average model for the volatility of yield changes 
· using the actual distribution for yield changes (Historical-Simulation method using all the available past data) 
· Compare and discuss the differences between the VAR obtained using the two methods 
Hint: Consider yield changes as if they were log-returns

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”