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

DW Simpson
Actuarial Jobs

Visit our site for the most up to date jobs for actuaries.

Actuarial Salary Surveys
Property & Casualty, Health, Life, Pension and Non-Tradtional Jobs.

Actuarial Meeting Schedule
Browse this year's meetings and which recruiters will attend.

Contact DW Simpson
Have a question?
Let's talk.
You'll be glad you did.

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

Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old 03-13-2018, 03:15 PM
Freebird's Avatar
Freebird Freebird is offline
Join Date: Dec 2001
Location: Topeka, Kansas
College: Graduated from Ohio State too many years ago to remember
Favorite beer: Newcastle
Posts: 824
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 12:06 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, 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.16427 seconds with 10 queries