In the last years I got more and more interested in questions
of financial mathematics like Value at risk,
Portfolio-optimization or Option-pricing. Here are some of my
works. They are no high-end real life applications - Excel is not
the tool for such tasks - but they show the mathematical idea.
- Pricing of an
american plain Vanilla option. A little
Excel-Sheet which calculates the price of american Put
and Call-Options on a stock. I used the binomial-tree
modell, also know as the CRR-Modell
of a bond price. Another Excel-Sheet which
calculates the price of an "regular" bond from
the expected cash-flows and a given yield-curve. Nothing
special, but it gives you a feeling how cash-flows,
yield-curve and bond-prices interact.
- Monte Carlo Value at
Risk. An Excel-Sheet that calculates the VAR
for a portfolio of three risk factors. The number of
simulations is limited to 10000. The empirical
distrubutions of the portfolio values is provided. On a
second sheet the covariance matrix of rel. returns can be
estimated from historical prices. The calculation follow
the idea of RiskMetrics.
[Startpage] --- [guestbook] --- [sitemap] --- last change: 31-07-2003