Bond Portfolio Analysis

Nov 26, 2007

Using the closed-form bond formula posted before, this bunch of spreadsheets is produced to value a bond at any point in its life time and do some analyses, as follows:
  • Portfolio valuation, duration and convexity
  • Derivatives valuation: FRA, Swap, Futures
  • Risk governance: Value-at-Risk, Stress Testing and Scenario Analysis
  • Hedging effectiveness
  • Liquidity analysis

Remark: this portfolio is a liability/debt portfolio, NOT an asset/investment portfolio.

[Sorry, it's a premium spreadsheet]

Labels: ,


Post a Comment

<< Home

Dutch Indonesian English