How to do a Linear interpolation in excel?

I

Ines

I need to find a function that permites me to create a rule for linear
interpolation for virtually any point given an array of dates and discount
factors. For a given date how can I calculate the aproximate discount factor?
 
D

David Billigmeier

Assuming the discount factors follow a linear pattern relative to the dates
you can use:

=FORECAST(<new date>,<range of discount factors>,<range of corresponding
dates>)
 
Top