1
$\begingroup$

I'm a newbie to the world of swaps.

If I have a Total Return Inflation Swap (Receive CPI, Pay Fixed Zero Coupon)

Based on CPI Index starting level = 236 Notional = 100,000 Term = 5 Years

How can I calculate the final payoff at maturity using a hypothetical future CPI level e.g. 300 ? Are there any excel and/or R examples?

$\endgroup$
1
$\begingroup$

For ZC inflation swaps, the fixed side cash flow is $$ N \big((1 + r)^T - 1\big), $$ where $N$ is the national amount, $r$ is the agreed upon ZC swap rate, and $T$ is the tenor of the swap.

The floating side cash flow is $$ N\left( \frac{I(T)}{I_\text{base}} - 1 \right), $$ where $I_\text{base}$ is the base index level (reference index as of the effective date) and $I(T)$ is the reference index as of the termination date.

$\endgroup$
  • $\begingroup$ thanks for the answer. Is there a source / link to these formulas for all types of swaps? $\endgroup$ – Guenther Jun 10 '15 at 21:42
  • $\begingroup$ This open gamma one is the first thing that popped into my head... developers.opengamma.com/quantitative-research/… I think they have a bunch of references for other instruments too. Specifically for inflation swaps, there are a lot of really good sell-side research papers. Search for Lehman Brothers, Inflation Derivatives Explained, as an example. $\endgroup$ – Helin Jun 10 '15 at 21:48
0
$\begingroup$

The trick to swap calculations is understanding what your profit is. Profit is (what you receive - what you pay). You can use this to calculate swaps on interest rates, equity swaps, and so on.

What will you receive? You are receiving: CPI appreciation x Notional. (300/236 - 1) * 100,000 = 27,118.

What are you paying? You are paying the zero coupon rate. Let's say it is 10%, which is 10,000.

Final payoff to swap long at maturity = 27,118 - 10,000 = 17,118. You said "you have" the swap, so I assume you are the fixed rate payer.

In Excel, you could do something like this: http://www.fincad.com/resources/resource-library/article/how-build-workbook-value-total-return-swap-floating-rate-loan

Modify for you specific swap.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.