Bond portfolio ATR calculator
To calculate the annualized total return for each bond in a portfolio, and for the total portfolio,
paste spreadsheet data in the following format, one record per line, with tab-separated fields.
Or enter data manually (the Tab key works).
Date format, any separator:
| ID | purchase date | maturity date | coupon rate | coupons per year | par value | purchase price |
| secondary rate: | % |
| coupon reinvestment: | |
| calculate |
Please visit russellcottrell.com | blog