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
    I receive donation for premium financial model and website developments. Please contact me for any inquiries.
this tool only works in IE
Calculate Your Power
Your Energy
Your Age Now y.o.
Your after-tax Annual Income
Monthly Expenses
Desired Real Return %
Desired Retirement Age y.o.
Transcendence Ratio %
Your Power
Annual Saving
Power in 5 yrs
Power in 10 yrs
Power @ Retirement
Estate Planning
>> read Transcendence Power