SmartModels Utilities: Interpolate
As cash flow consultants we work with yield curves quite a bit, often incomplete ones. How do you generate a 30 year, annual scale starting from 5 to 8 points? Sure, you can build a bunch of interpolation formulas in Excel but this is slow and error-prone.
Interpolate in SmartModels Utilities makes this a snap:
- Highlight your 2 column input range of dates and amounts
- Select your output range
- Select from 'Linear' or 'Cubic Spline' interpolation
- Click the Interpolate button
BENEFITS
- Speed - in seconds you can interpolate data points only limited by the number of rows in Excel.
- Accuracy - no messy formulas required which are prone to error
- Simple - clean user interface with flyover help for each input
- More Speed - Data persists in the interface until the user changes it, saving additional time when recalculating