No video

Interest Rate Swaps Explained | Example Calculation

  Рет қаралды 35,925

Ryan O'Connell, CFA, FRM

Ryan O'Connell, CFA, FRM

Күн бұрын

Пікірлер: 65
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available ► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/ 💾 Download Free Excel File: ► Grab the file from this video here: ryanoconnellfinance.com/product/interest-rate-swaps-excel-model/
@gregsLyrics
@gregsLyrics 9 күн бұрын
Wow! Eyeopening. I constantly hear about swap rates and how the economy is in a melt down. Appreciate the hard work you put into making great content.
@mradjamesable
@mradjamesable 26 күн бұрын
Great Video Ryan - as they say if you can't explain a complex topic simply, you don't understand it. Thanks for making the easy for the layman to understand (layman = me)
@RyanOConnellCFA
@RyanOConnellCFA 26 күн бұрын
Thank you Adrian, I really appreciate that! You may be less of a layman than you think if this video was easy to understand 💪
@b-reel
@b-reel 2 жыл бұрын
I can't believe there is just 4.3K subscribers... this channel will grow! Excellent content!
@RyanOConnellCFA
@RyanOConnellCFA 2 жыл бұрын
Thank you Bryan, I really appreciate it!
@wajihchtiba34
@wajihchtiba34 2 жыл бұрын
I love the content !! just one remark in 5:45 you said " we djust the floating rate" instead of the fixed rate (you mentioned the cell name correctly)
@RyanOConnellCFA
@RyanOConnellCFA 2 жыл бұрын
Thank you for the heads up Wajih!
@shrayanduari9119
@shrayanduari9119 21 күн бұрын
Excellent explanation
@RyanOConnellCFA
@RyanOConnellCFA 21 күн бұрын
Glad it was helpful!
@ganeshmalpani6839
@ganeshmalpani6839 2 жыл бұрын
Found your channel through reddit's CFA page, love all your content. Short and to the point.
@RyanOConnellCFA
@RyanOConnellCFA 2 жыл бұрын
Thank you Ganesh! Has someone shared a video of mine over on that page recently?
@ganeshmalpani6839
@ganeshmalpani6839 2 жыл бұрын
@@RyanOConnellCFA not recently, it was a while ago. Got the time to check your videos now.
@RyanOConnellCFA
@RyanOConnellCFA 2 жыл бұрын
@@ganeshmalpani6839 Awesome, I appreciate you checking them out now
@ashwinjanyani
@ashwinjanyani Жыл бұрын
This is excellent! thanks for sharing the file as well. Really appreciate your efforts.
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
Glad it was helpful Ashwin!
@kavitabatra4537
@kavitabatra4537 2 жыл бұрын
Informative video like always. Want to understand more about currency and equity swap via numerical examples.
@RyanOConnellCFA
@RyanOConnellCFA 2 жыл бұрын
Glad you enjoyed it Kavita! I may make videos on those topics in the future
@nerazzurro1234
@nerazzurro1234 4 ай бұрын
OMG that was so clear!!!
@mphys5370
@mphys5370 10 ай бұрын
Great video Ryan! Can do a real worl example using SOFR please?
@RyanOConnellCFA
@RyanOConnellCFA 10 ай бұрын
This is a good idea for a future video! I can look into it, I'll warn you that I have a pretty large backlog right now so it won't be for a while
@Sisyphus2310
@Sisyphus2310 Жыл бұрын
Great content, Ryan! And thanks for sharing the excel file. :-)
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
My pleasure Mohan!
@user-kp5du5xi2v
@user-kp5du5xi2v 9 ай бұрын
thank you so much! you are great!!!
@RyanOConnellCFA
@RyanOConnellCFA 9 ай бұрын
I appreciate it, and thank you!
@vivekraunak
@vivekraunak 24 күн бұрын
Thanks @ryan for the explanation. Could you please help me understand why in floating rate bond notional principle got added in 1st cashflow? In my understanding, Principle is paid to the bondholder at the end. Also, why is the remaining cashflow 0?
@ashwiiniinandesshwar3062
@ashwiiniinandesshwar3062 17 күн бұрын
I have a question on the floating side. You just took one floating rate for 0.5 years. What about other rates?
@devinaarastogi2420
@devinaarastogi2420 Жыл бұрын
hi Ryan, can you please make a video on how to calculate VAR for IRS and CDS.
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
Hello Devina, I can look into this topic in the future
@elyahonarchian
@elyahonarchian 3 ай бұрын
I got counter offer it says "strike from contract loan interest rate not to exceed 7%" What does it means?
@RyanOConnellCFA
@RyanOConnellCFA 3 ай бұрын
Could you explain what you mean by "counter offer"?
@MrAyushguptaful
@MrAyushguptaful 3 ай бұрын
I have a doubt. In floating rate calculation, we are taking only 3% rate. But what about other rates for 1 year, 1.5 years and 2 years. Should we not adjust swap for every term(floating rate bond side). If not What's the logic
@asvlogs2288
@asvlogs2288 Жыл бұрын
Amazing
@YenNguyen-he4nt
@YenNguyen-he4nt 3 ай бұрын
how about valuing the remaining floating cashflow, can we use the boostraping for pricing them?
@RyanOConnellCFA
@RyanOConnellCFA 3 ай бұрын
The beauty is that you do not need to value the remaining floating cashflow!
@nickpapasavvas8133
@nickpapasavvas8133 5 ай бұрын
Thanks a lot for the video. With what tools can such an interest rate swap for the euro be set up?
@RyanOConnellCFA
@RyanOConnellCFA 4 ай бұрын
Hi @nickpapasavvas8133, I'm glad you found the video helpful! Setting up an interest rate swap for the euro typically involves a few key tools: you'll need access to financial derivatives platforms like Bloomberg or Reuters to analyze rates and terms
@Harry-tc3sn
@Harry-tc3sn 5 ай бұрын
In solver you have used fixed rate despite saying floating rate. What is the correct way?
@RyanOConnellCFA
@RyanOConnellCFA 4 ай бұрын
Sorry about that, I said it backwards! I should have said that we were solving for the fixed rate, not the floating rate
@philliphochman1654
@philliphochman1654 Жыл бұрын
"Received whole cash flow .5 years in the future. No cash flows beyond that bc it's a floating rate bond that reprices itself itself back to par at every coupon date." Sorry, I'm not clear on this, if it's semiannual payments and it's a 2 year instrument, why aren't there more payments?
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
The interest payments on floating rate bonds adjust periodically to match prevailing market rates. Since these adjustments ensure that the bond's yield remains in line with market rates, the bond's price does not deviate significantly from its face value. As a result, one needs only to consider the first cash flow, which includes the initial payment and the principal repayment at the end, to calculate the bond's present value. Other future cash flows are automatically adjusted for, thereby eliminating the need to individually discount them.
@lzra8111
@lzra8111 Жыл бұрын
Hi Ryan, great stuff thank you very much. One thing i always wondered how it worked in practice as opposed to in theory is the yield curve and interest rates to use. How a swap works in theory is completely clear to me (i got my CFA charter in February so that helps haha). I work in real estate and i was given the task to value a swap that is hedging a variable rate loan on a property. the floating payer pays 3M EURIBOR, while the fixed payer pays 0,208% with a maturity to 30th Sept 2024. And that is where it gets unclear to me. EURIBOR curve does not extend until that maturity, since max maturity is 12M. so i got 1M, 3M, 6M and 12M EURIBOR. So the EURIBOR forward curve determines the future floating payments, so far so good. but what rate do i use to discount those future payments? i cant use forward rates to discount and i have no spot rates above 12M. pls help and sorry for the long message! cheers all the best L.
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
This is a really interesting problem. I'm sorry to say that I don't know how you would discount it without having any spot rates or forward rates that go beyond 12 months. Is there another curve you could possibly use? You could try to find a similar curve as the EURIBOR curve to use but it is a weird situation to be sure
@vergil62
@vergil62 Жыл бұрын
The Euribor futures curve on Eurex goes out to 5 years, providing a forward curve.
@swapskillsacademy575
@swapskillsacademy575 Жыл бұрын
@@vergil62 To be precise we use the forward Euribor curve to generate zero coupon discount factors for each maturity. This is a more accurate discounting rate. MMake sure to note the day count and frequency of the fixed rate,
@SalK-3S3K
@SalK-3S3K Жыл бұрын
1-is it appropriate to use risk free rates (treasuries in this example) to value swaps? 2-@5:06, why the rate change to 4.5%, changes value of fixed swap bond, as fixed swap bond has rate fixed at 3.5%?
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
1. You can use the treasury curve to value swaps but I believe, in practice, the LIBOR curve is used more frequently. 2. You can see @2:25 when we determine the value of each side of the swap, the pay fixed side is price sensitive to changes in all rates because the present value of each payment is determined by the market rates.
@SalK-3S3K
@SalK-3S3K Жыл бұрын
@@RyanOConnellCFA thank you!
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
@@SalK-3S3K My pleasure!
@alessandrodoimo8146
@alessandrodoimo8146 Жыл бұрын
Hi Ryan, were the covariance right? The diagonal of the covariance, not close to zero Many thanks for the video
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
Hello, did you mean to comment this on a different video? I did not create a covariance matrix in this swap video
@user-wr4yl7tx3w
@user-wr4yl7tx3w Жыл бұрын
Can you elaborate on your point about the float side? Why only a single cash flow?
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
Hello, this is because the floating rate side of the swap reprices to par after the next cash flow, so we really only need to value you the next cash flow as all future cashflows beyond that would assumed to be equal to par. Does that make sense?
@user-wr4yl7tx3w
@user-wr4yl7tx3w Жыл бұрын
Sorry not quite. Not sure why that helps. May be it might take a video to explain why the math works.
@mphys5370
@mphys5370 10 ай бұрын
I didn't understand either
@oliviaboija7259
@oliviaboija7259 Жыл бұрын
Should the price difference be zero?
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
At day 1 it should be because value on both sides of the swap is 0 upon initiation. This satisfies the arbitrage free condition. However, overtime as market interest rates change, one side wins by the same amount that the other side losses. It is a zero sum game
@mahmoudkadrynafei
@mahmoudkadrynafei Жыл бұрын
Please can you clarify can we value the floating part based on the tbill yield curve for each period (6 month fixed) thus we bring the pv and summed like fixed rate. Thanks a lot
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
Hi there! Absolutely, you can value the floating part of an interest rate swap by using the T-bill yield curve for each period (e.g., 6 months). To do this, you would calculate the present value (PV) of each expected floating payment, using the corresponding T-bill yield as the discount rate. Then, you would sum up the present values of all the floating payments to obtain the total present value of the floating leg. This approach essentially treats each floating payment as if it were fixed at the current yield curve, allowing you to compare and value both legs of the swap. I hope this helps! Let me know if you have any more questions.
@jinjin2061
@jinjin2061 Жыл бұрын
Hey Ryan, don't really understand why is there only 1 cashflow for Floating rate bond? How does the floating rate bond resets at par every coupon date relate to the cashflow stream?
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
This is because at that point, the bond would reprice to par essentially as the floating rate updates to the market rate. I know it is quite confusing but just know that this method provides you with the correct answer
@stevenintexas6947
@stevenintexas6947 Жыл бұрын
@@RyanOConnellCFA Hey Ryan, excellent video. I'd like to see an example where the floating rate bond has a Cap. Bonds with Caps will not reprice to par as they get close to their coupon or interest rate Cap.
@RyanOConnellCFA
@RyanOConnellCFA Жыл бұрын
I can definitely look into working on an example like this in the future!
@little.rascal.
@little.rascal. 6 ай бұрын
Hi Ryan, I am confused about the float side only having 1 cash flow. Would you be able to provide a clarification? Thanks Ryan.
@RyanOConnellCFA
@RyanOConnellCFA 5 ай бұрын
Hello. The floating side has only 1 cash flow because at that point, the bond would reprice to par essentially as the floating rate updates to the market rate and we thus have no need to price in any future cash flows
Bond Duration and Bond Convexity Explained
9:18
Ryan O'Connell, CFA, FRM
Рет қаралды 103 М.
What is a swap? - MoneyWeek Investment Tutorials
14:54
MoneyWeek
Рет қаралды 911 М.
Comfortable 🤣 #comedy #funny
00:34
Micky Makeover
Рет қаралды 16 МЛН
Bony Just Wants To Take A Shower #animation
00:10
GREEN MAX
Рет қаралды 7 МЛН
Magic trick 🪄😁
00:13
Andrey Grechka
Рет қаралды 42 МЛН
I'm Excited To see If Kelly Can Meet This Challenge!
00:16
Mini Katana
Рет қаралды 35 МЛН
Swaps (FRM Part 1 2023 - Book 3 - Chapter 10)
29:56
AnalystPrep
Рет қаралды 18 М.
Put-Call Parity in Options Trading Explained Using Excel
9:23
Ryan O'Connell, CFA, FRM
Рет қаралды 6 М.
SOFR Futures Explained: 3-Month & 1-Month Pricing in Excel
10:12
Ryan O'Connell, CFA, FRM
Рет қаралды 3,8 М.
Valuation of plain-vanilla interest rate swap (T3-32)
19:02
Bionic Turtle
Рет қаралды 34 М.
FRM: You will never be scared of SWAPS after watching this!
58:05
Monte Carlo Method: Value at Risk (VaR) In Excel
10:13
Ryan O'Connell, CFA, FRM
Рет қаралды 46 М.
Calculate Bond Convexity and Duration in Excel | Interest Rate Risk
11:03
Ryan O'Connell, CFA, FRM
Рет қаралды 10 М.
Forward Rate Agreements Explained | How to Calculate an FRAs Value
9:07
Ryan O'Connell, CFA, FRM
Рет қаралды 7 М.
Pricing Interest Rate Swaps
12:12
Patrick Boyle
Рет қаралды 15 М.
Comfortable 🤣 #comedy #funny
00:34
Micky Makeover
Рет қаралды 16 МЛН