本文介绍 Microsoft Excel 中YIELDMAT函数的公式语法和用法。 说明 返回到期付息的有价证券的年收益率。 语法 YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) 重要:应使用 DATE 函数输入日期,或者将日期作为其他公式或函数的结果输入。 例如,使用函数 DATE(2008,5,23) 输入 2008 年 5 月 23 日。
Excel YIELD FunctionYIELD is an Excel function that returns the yield to maturity of a bond given its coupon rate, current price, principal amount and coupon payment frequency per year.In the context of debt securities, yield is the return that a debt-holder earns by investing in a security...
The Excel “YIELD” function is most often used in practice to determine the yield on a bond or a related debt instrument. As part of a financing arrangement, the borrower is obligated to pay periodic interest payments to the lender until the date of maturity, in which the remaining balance...
本文介绍 Microsoft Excel 中 TBILLYIELD 函数的公式语法和用法。 说明 返回国库券的收益率。 语法 TBILLYIELD(settlement, maturity, pr) 重要: 应使用 DATE 函数输入日期,或者将日期作为其他公式或函数的结果输入。 例如,使用函数 DATE(2008,5,23) 输入 2008 年 5 月 23 日。 如果日期以文本形式输入,则会...
Excel YIELDMAT 函數 YIELDMAT 函數返回到期支付利息的證券的年收益率。 句法 YIELDMAT(settlement,maturity,issue,rate,pr,[basis]) 參數 沉降(必填):證券的結算日期。 是購買證券的發行日期之後的日期; 到期(必填):證券的到期日。 這是證券到期的日期;...
4. Calculate the number of years until maturity by subtracting the current year from the bond’s maturity year and enter that number into a cell. 5. Use Excel’s “RATE” function to calculate yield to maturity, using cells for price, face value, coupon rate, and number of years until ...
What is the yield to maturity formula in Excel? The Excel function YIELDMAT can be used to calculate the yield to maturity of a bond. The function's inputs are the settlement, maturity, and issue dates, the coupon rate, and the price paid per $100 face value. How YTM is calculated?
Where C is the annual coupon amount, F is the face value of the bond, P is the current bond price and n is the total number of years till maturity. Alternatively, we can also use Microsoft Excel YLD function to find yield to maturity. ...
函数语法：YIELD 参数含义：settlement：债券的结算日，即购买债券的日期。这是计算收益率的起始时间点。maturity：债券的到期日，即债券的最后偿还日期。这是收益率计算的终止时间点。rate：债券的票面利率。这是债券发行时规定的固定利率，用于计算每年的利息支付金额。pr：每100面值债券的当前价格。这是...
To speed this process up, you can use the SOLVER function in Excel to determine a value based on a set of conditions. This means that you can set the price (present value) for the bond and solve for the yield to maturity (the interest rate for the present value calculation). ...