This article describes the formula syntax and usage of the YIELD function in Microsoft Excel. The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. The settlement date is the date a buyer purchases a security such as a bond.
To calculate the current yield of a bond in Microsoft Excel enter the bond value the coupon rate and the bond price into adjacent cells eg A1 through A3.
Settlement required argument This is the settlement date of the security. YIELDC9 C10 C7 F5 C6 C12 C13 with these inputs the YIELD function returns 008 which or 800 when formatted with the percentage number format. In cell A4 enter the formula A1. YIELDsettlement maturity rate pr redemption frequency basis.