SmartModels™ Utilities: Annualize

If you've ever dealt with cash flows of different frequencies and tried to annualize their totals, you know there's no simple formula to do it in a spreadsheet.

The Annualize function in SmartModels™ Utilities tackles this chore in three simple steps:

  1. Go to the SmartModels™ Utilities add-in and select Annualize from the drop down menu. 
  2. Highlight any number of date-amount paired columns and a single column output date range.
  3. Click the Annualize button to create totals based upon the output date series. 

Benefits include

  • Speed - Faster, more accurate way to interpolate yield curve data or anything needing interpolation in Excel.
  • Accuracy - Simple user interface with flyover help for each input.
  • Speed, again - Input ranges are set and stored in the interface until the user changes it, saving additional time when data changes and recalculation is necessary.