:"How to use the PRICEMAT function to calculate the value of a coupon-paying bond at maturity"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "How to use the PRICEMAT function to calculate the value of a coupon-paying bond at maturity"

"How to use the PRICEMAT function to calculate the value of a coupon-paying bond at maturity"

Author: daogeziyuan • • Table skills • Views 820
  • Graphic and text skills

The PRICEMAT function is a financial function used to calculate the price of a bond that pays interest at maturity.

方法步骤.png

The steps are as follows:

1. Click the "Insert Function" button in the "Formulas" tab.

2. In the pop-up dialog box, select the PRICEMAT function.

3. Set parameters: Enter B2 for the transaction date, B3 for the maturity date, B4 for the issuance date, B5 for the annual coupon rate, and B6 for the annual yield.

4. Click OK to calculate the price of a marketable bond with a face value of RMB 100.

1.gif

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ru-he-shi-yong-PRICEMAT-han-shu-ji-suan-dao-qi-fu-xi-zhai-quan-de-jia-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu pengfeng Columnist
48 196
single-end

Related Suggestion