Getting a quick tax-exempt debt structure in a spreadsheet is doable, although it’s slow and easy to make mistakes if you’re starting from scratch. With a simple three-column input range of maturity dates, par bond yields, and revenue, the SmartModels™ Utilities’ Structure Bonds function gets you to a basic bond structure in no time in $5,000 denominations. 

Interpolate in SmartModels™ Utilities makes this a snap:

1. Go to SmartModels™ Utilities and select Structure Bonds from the dropdown.
2. Enter a par amount, dated/delivery dates, first interest and first and last principal dates.
3. Select from one of the six Solution Types to create the desired amortization shape.
4. Select the three-column input range of date, par bond yields, and revenue.
5. Click the Size button. 

Output is a three column range of date, principal amount, and interest.

BENEFITS

• Speed – In seconds, get a clean bond solution without messing around with any spreadsheet formulas. Enter and highlight the inputs, and you’re done.
• Accuracy – Avoid simple but ubiquitous spreadsheet mistakes by using tested Intuitive Analytics algorithms.
• 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.