Kč - Kč ( ) - £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : % / / / / $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 PRICEMAT Function Result TRUE Sheet Result Description 1 TRUE Simple PRICEMAT formulas with local references and values PRICEMATSummary: Calculate the price per 100 currency units of face value of the security that pays interest on the maturity date.Syntax: PRICEMAT( DateParam Settlement ; DateParam Maturity ; DateParam Issue ; Number Rate ; Number AnnualYield [ ; Basis Basis = 0 ] )Returns: NumberConstraints: Settlement < Maturity, Rate >= 0, AnnualYield >= 0Semantics: The parameters areSettlement: the settlement/purchase date of the securityMaturity: the maturity/expire date of the securityIssue: the issue date of the securityRate: the interest rate of the securityAnnualYield: the annual yield of the securityBasis: indicates the day-count convention to use in the calculation. If both, Rate and AnnualYield, are 0, the return value is 100. Function Expected Correct FunctionString Comment Data Description 99.9845 99.984498875557 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,0) 02/15/08 Settlement date 99.984498875557 99.984498875557 TRUE =PRICEMAT(I2,I3,I4,I5,I6,I7) 04/13/08 Maturity date 99.9848608145316 99.9848608145316 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,1) 11/11/07 Issue date 99.9844 99.9844394005673 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,2) 6.10% Percent semiannual coupon 99.9849 99.9848608145316 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,3) 6.10% Percent yield 99.9845 99.984498875557 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,4) 0 30/360 basis 99.9845 99.984498875557 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,) 99.9845 99.984498875557 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061) Err:502 error TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, ,0) tDf#100759 Err:502 error TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, -0.061,0) Err:502 error TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", , 0.061,0) Err:502 error TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", -0.061, 0.061,0) 99.9845 99.984498875557 TRUE =PRICEMAT("1999-02-15","1999-04-13","1998-11-11", 0.061, 0.061,0) Err:502 error TRUE =PRICEMAT("1999-04-13","1999-02-15","1998-11-11", 0.061, 0.061,0) 4