It is a date after the security is traded to the buyer that is after the issue date. Settlement required argument This is the settlement date of the security. 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.
In the example shown the formula in F5 is.
Excel Yield Function is used to calculate on a security or a bond which pays the interest periodically the yield is a type of financial function in excel which is available in the financial category and is an inbuilt function which takes settlement value maturity and rate with bonds price and redemption as an input. It is a date after the security is traded to the buyer that is after the issue date. Looking for methods to use the YIELD functio. The date should be after the issue date when the security is traded to the buyer.