| Line 1: |
Line 1: |
| | =PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)= | | =PRICE(settlement, maturity, rate, yield, redemption, frequency, basis)= |
| | | | |
| − | *where 'settlement' is the security's settlement date (a date when coupon or a bond is purchased), | + | *where 'settlement' is security's settlement date (a date when coupon or a bond is purchased), |
| − | *'maturity' is the security's maturity date (a date when coupon or a bond expires), | + | *'maturity' is security's maturity date (a date when coupon or a bond expires), |
| − | *'rate' is the security's annual coupon rate, | + | *'rate' is security's annual coupon rate, |
| − | *'yield' is the security's annual yield, | + | *'yield' is security's annual yield, |
| | *'redemption' is security's redemption value per $100 face value, | | *'redemption' is security's redemption value per $100 face value, |
| | *'frequency' is the number of coupon payments per year, and | | *'frequency' is the number of coupon payments per year, and |
| Line 93: |
Line 93: |
| | | | |
| | *[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation] | | *[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation] |
| | + | *[http://en.wikipedia.org/wiki/Day_count_convention Basis Convention] |