- Picture and text skills
The PRICEMAT function is a financial function that can calculate the price of a marketable bond with a face value of RMB 100 that pays interest at maturity.
▪Click the "Formula" tab-"Insert Function" button.
In the pop-up "Insert Function" dialog box, select the PRICEMAT function.
Enter B2 in "Transaction Date", which is November 8, 2018;
Enter B3 in "Expiration Date", which is November 8, 2021;
Enter B4 in "Release Date", which is December 6, 2017;
Enter B5 in "Interest Rate", that is, the annual coupon rate of the bond is 0.15%;
Enter B6 in "Annual Yield", the annual yield of the bond is 1.22%.
Click OK to calculate the price of a marketable bond with a face value of RMB 100 that will pay interest at maturity.
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/PRICEMAT-han-shu-ji-suan-dao-qi-fu-xi-zhai-quan-jia-ge.html
支付宝扫一扫 
评论列表（196条）
测试