# YouTubeT5-05: Value (VaR) Mapping a fixed-income portfolio

#### Nicole Seaman

##### Director of FRM Operations
Staff member
Subscriber
In this video, we walk through an actual case study of Value at Risk (VaR) mapping, specifically as it is illustrated by Phillip Jorion in Chapter 11 of his book, Value at Risk. We will take a two-bond fixed income portfolio. It's going to have a value of 200 million, and we're going to look at VaR mapping under three different approaches. That mapping means that we'll take the value of the portfolio and we'll map it to one primitive risk factor or, in the more sophisticated case, five primitive risk factors. This will be a simplification exercise so that we can take in theory what is a complex portfolio and replace it, or map it to, a limited set of simple risk factors. Then we can shock or stress the risk factors as a means of estimating the risk of the portfolio.

#### BDonn

##### New Member
Hi David,

Is it possible to post the excel file from the video? I'd like to explore this further and I've ordered the book mentioned in the description, but while waiting for it to arrive, I would love the chance to play with the excel file if possible.

Thank you so much!
Brian

#### BDonn

##### New Member
Good morning, just checking in, is it possible to post the excel for this one? Still curious about it, thank you!

#### David Harper CFA FRM

##### David Harper CFA FRM
Staff member
Subscriber
Hi @BDonn Sure thing (sorry i missed your earlier request), thank you for liking the video. Here is the XLS I created/used for it:

Thank you! : )

#### jan molina

##### New Member
Is this an historical simulation aproach ?

#### David Harper CFA FRM

##### David Harper CFA FRM
Staff member
Subscriber
Hi @jan molina No, this is VaR mapping; aka, risk factor VaR mapping. It is compatible with any of the three major VaR approaches (analytical/parametric, historical simulation, or Monte Carlo simulation).

#### jan molina

##### New Member
thanks, can you make a historical var for fixed income portfolio?