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