In this chapter student will understand how VaR measures the risk of a portfolio; compute static portfolio VaR using formulas and normal distribution functions, a Monte Carlo simulation of a random walk model of asset returns, and @Risk; write VBA Macros using “For Loops” and the “Cells” objects. | Lecture Financial modeling - Topic 6: Computing portfolio value-at-risk (VaR), random walk simulations, macros and @Risk simulations