Calculating the actual price of the security in the Wall ...

The XIRR fuction can also value cash flows that are not always received at the end. of each period. This can be helpful for cash flows that can be cound more than. once per year. The XIRR provides the effective annual rate. To make comparisons, convert your bond value to an effective annual rate. principal plus accrued interest (87. days) Page ... ................
................