#### 08

2020## Forward Rate Agreement Excel

The term interest rate is the interest rate that an investor should guarantee between the first maturity of the investment and the second maturity to be indifferent between choosing the shorter or longer term (at least in terms of returns). The important underlying assumption in this definition is that the contract is fair, which means that A and B are satisfied with the terms of the contract and do not require additional compensation. This is necessarily the case at the time the contract is signed, but it usually does not last a second later, because the market interest rates are changing! FRA is indicated with the FRA course. For example, if a U.S. dollar FRA is listed at 1.50% and a future borrower expects the 6-month libor rate to be above 1.50% in two months, they should buy an FRA. Let`s calculate the 30-day credit rate and the 120-day credit rate to deduct the corresponding advance rate, which makes the FRA value zero at the time of creation: there are two parties who participate in a advance rate agreement, namely buyers and sellers. The buyer of such a contract sets the loan price at the beginning of the contract and the seller sets the interest rate of the credit. At the beginning of an FRA, both parties have no profit/loss. With this article, I want to show you how to create a yield curve in Excel using the QuantLib open source analytics library, when input market data are transfer rates. Suppose you were looking at a $100 investment over two years with an annual interest rate of 7%. The one-year interest rate is only 4%. In any case, it is easy to calculate the final value in Excel.

Step one. Determine the year`s cash rate, two-year s2-spotrate and one-year 1f1 advance rate for one year from now. A company learns that it will have to borrow $1,000,000 in six months for a period of six months. The rate at which it can now afford is the 6-month LIBOR plus 50 basis points. Let`s also assume that the 6-month LIBOR is currently 0.89465%, but the company`s treasurer thinks it could even increase by 1.30% in the coming months. To determine advance rates, we must respect the non-arbitration condition, where no investor should win arbitrators between interest rate periods. Suppose an investor is interested in investing their funds for two years. It has two options: Forward Rate Agreement has bespoke interest rate contracts, which are bilateral in nature and do not involve centralized counterparty and are often used by banks and companies.

On the date of fixing (October 10, 2016), the 6-month LIBOR sets 1.26222, the settlement rate applicable to the company`s FRA. Over time, however, the buyer of the FRA benefits when interest rates rise like the interest rate set at the time of creation, and the seller benefits when interest rates fall as the interest rate set at the beginning. In short, the advance rate agreement is a zero-sum game where the gain of one is a loss for the other. Suppose one-year interest rates in USD and Pakistan are 2% and 10%, respectively. The spot price is usd 1 – PKR 90.77. The one-year term exchange rate will be as follows: the overall structure is similar to that of a yield curve based on deposit rates, as explained in my corresponding article.