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

2017 ACTUARIAL SALARY SURVEYS
Contact DW Simpson for a Personalized Salary Survey

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

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-13-2018, 02:15 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 Project Monthly LIBOR rates for 40 years

I am trying to interpolate and extrapolate the table of LIBOR spot rates below. The LIBOR spot rates are listed as overnight, 1 month, 2 month, 3 month, 6 month and 12 month. I do not list the overnight rate in the table below, because I am interested in calculating monthly rates for 40 years.

Thus, I first have to interpolate for months 4, 5, 7, 8, 9, 10, and 11.

Then I have to extrapolate for months 13 through 480. My ultimate goal is LIBOR monthly forward rates for 40 years, but I can use bootstrapping for that if I can get all the monthly LIBOR spot rates projected in a reasonable fashion. The result is the risk-free rates for use in FAS 133 reserves, which is a risk neutral (market value) calculation.

A Google search didn't get me anything useful, so I thought I would try here. Does anyone do anything like this, and would you be willing to share some formulas? Or can you point me to some documentation of this?

By the way, I do have access to a Bloomberg terminal, but I am only just starting to use it, and I have not been trained yet. I was wondering if there was some Bloomberg function to do this interpolation and extrapolation.

Anyone's thoughts on this would be very much appreciated.

Mth LIBOR spot
1 1.67007%
2 1.81399%
3 2.01719%
4 0.00000%
5 0.00000%

6 2.22375%
7 0.00000%
8 0.00000%
9 0.00000%
10 0.00000%
11 0.00000%

12 2.50219%
Reply With Quote
 

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:34 AM.


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.27447 seconds with 10 queries