ExcelBanter - Return on a bond

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return on a bond (https://www.excelbanter.com/excel-worksheet-functions/185237-return-bond.html)

Gilbert DE CEULAER

Return on a bond

Has somebody a formula to calculate the exact real return on a bond.
With time to go not just in years, but with exact dates, including
purchasing-costs,...
Thanks in advance.
Gilbert

Fred Smith[_4_]

Return on a bond

Excel has such a function. It's called YIELD. Just look up bond yield in
Help.

Regards,
Fred,

"Gilbert DE CEULAER" wrote in message
...
Has somebody a formula to calculate the exact real return on a bond.
With time to go not just in years, but with exact dates, including
purchasing-costs,...
Thanks in advance.
Gilbert

All times are GMT +1. The time now is 06:15 AM.