Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Finance - Investments
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Finance - Investments Sub-forum: Non-Actuarial Personal Finance/Investing

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-08-2018, 11:01 AM
Freebird's Avatar
Freebird Freebird is offline
Member
SOA AAA
 
Join Date: Dec 2001
Location: Topeka, Kansas
College: Graduated from Ohio State too many years ago to remember
Favorite beer: Newcastle
Posts: 822
Default Bootstrapping to get LIBOR forward rates

It's been a really long time since I have dealt with the bootstrapping technique for LIBOR forward rates. A Google search didn't get me anything I could use off the rack, so I thought I would try here.

I have a set of LIBOR spot rates in the table below. I think the first one is a 2-day rate, with the rest going up to 12 months. These are rates as of 2/28/2018. I was hoping someone had a spreadsheet to share, or could point me somewhere. I would like a formula to calculate the forward rates from these spot rates.

Anyone?

LIBOR Rates (A/360)
O/N 1.390%
LIB01m 1.670%
LIB02m 1.814%
LIB03m 2.017%
LIB06m 2.224%
LIB12m 2.502%
Reply With Quote
  #2  
Old 03-08-2018, 04:26 PM
Numbers Nerd's Avatar
Numbers Nerd Numbers Nerd is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Midwest
College: University of Wisconsin
Favorite beer: Ale, Lager, you name it
Posts: 1,608
Default

Year Spot Forward
0 0.00% 0.50%
0.25 0.40% 0.59%
0.5 0.43% 0.70%
0.75 0.47% 0.82%
1 0.50% 0.94%

This is something from a spreadsheet we use, with actual rates from 2/28. Basically you get the tabular rates for specific durations, interpolate for the desired duration, raise to the power to get the zero coupon rate, then back out the forward rate, using a formula something like this:

Forward Rate=((1+Spot Rate)^(Duration+1)/(1+Spot Rate)^Duration))-1

Here are the original source rates from Bloomberg.
GBP
02/28/2018
3 months 0.4009%
6 months 0.4321%
12 months 0.4989%
24 months 0.7917%
Reply With Quote
  #3  
Old 03-08-2018, 04:55 PM
Freebird's Avatar
Freebird Freebird is offline
Member
SOA AAA
 
Join Date: Dec 2001
Location: Topeka, Kansas
College: Graduated from Ohio State too many years ago to remember
Favorite beer: Newcastle
Posts: 822
Default

Thanks, Mr. Nerd!

I will give your approach a try and let you know if i have any questions.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 09:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.31006 seconds with 9 queries