The Nelson and Siegel (1987) model is a very practical model to capture the term structure of interest rates with a non-linear model with just three parameters. In the youtube video we explain how you can use Excel and the solver to derive these parameters from a set of observed yields.

You can also download the Excel spreadsheet that is used in this video.