SmartModels Stage I

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