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

Calculate Effective Rate. XIRR. Effective Rate. SUM (PV) using XIRR. double check. Last. Coupon. Next. Payments. ACCRINT= Based on Quotes. Payment. Dates. 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. ................
................