,PriceMat(Settlement, Maturity, Issue, Rate, YieldP[, Basis])
Settlement. The security's settlement date. This date is later than the issue date (the date, when the securities were sold to the buyer).
Maturity. The security's maturity date. The maturity date is the date when the security expires.
Issue. The security's issue date. Value of this parameter must be greater or equal to zero.
Rate. Security's interest rate at date of issue. Value of this parameter must be greater or equal to zero.
YieldP. The annual income on securities. Value of this parameter must be greater or equal to zero.
Basis. The day calculation method used. It is set in the range from 0 to 4:
0. The day calculation method - American. 360 days (NSAD method). Default value.
1. Day calculation method - Actual/actual.
2. Day calculation method - Actual/360 days.
3. Day calculation method - Actual/365 days.
4. Day calculation method - European 30/360 days.
Optional parameter.
NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.
It returns the price per $100 face value of the securities that pay interest at maturity.
The Settlement parameter value should not be less than the Maturity parameter value.
This method is estimated following the formula:
,
where:
| Formula | Result | Description |
| =PriceMat("01.01.2008", "01.06.2008", "01.10.2007", 0.15, 0.2, 0) | 97,79 | The price per $100 face value of securities, for which interest is paid when the maturity date is due based on the following terms:
|
| =PriceMat(A0, B0, C0, 0.05, 0.35) | 81,92 | The price per $100 face value of securities, for which interest is paid when the maturity date is due based on the following terms:
|
See also:
Function Wizard │ Financial Functions │ PriceDisc │ Price