writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + − + − + Line 18:
Line 18: − + + Line 45:
Line 46: − + − − − If Yield < 0 or Rate < 0, it returns the #ERROR. − − − If Frequency other than 1 , 2 or 4 returns the #ERROR. − − If Redemption <= 0, PRICE returns the #ERROR. Line 112:
Line 105: − +
no edit summary
*where 'settlement' is the security's settlement date (a date when coupon or a bond is purchased),
*where 'settlement' is the 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 the security's maturity date (a date when coupon or a bond expires),
*'rate' is the security's rate,
*'rate' is the security's annual coupon rate,
*'yield' is the security's annual yield,
*'yield' is the security's annual yield,
*'redemption' is
*'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
*'basis' is the type of day count basis to use.
*'basis' is the type of day count basis to use.
PRICE() calculates the price per '$100' face value of security that pays periodic interest.
PRICE() calculates the price per $100 face value of security that pays periodic interest.
== Description ==
== Description ==
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*'coupon' and 'yield' values must be greater than or equal to zero.
*'rate' and 'yield' values must be greater than zero, else Calci displays #N/A error message.
*'redemption' value must be greater than or equal to zero, else Calci displays #N/A error message.
*The values for 'frequency' should be 1,2 or 4.
*The values for 'frequency' should be 1,2 or 4.
For Annual payment, frequency = 1,
For Annual payment, frequency = 1,
*If 'basis' value is other than 0 to 4, Calci displays #N/A error message.
*If 'basis' value is other than 0 to 4, Calci displays #N/A error message.
*
== Examples ==
== Examples ==
== References ==
== References ==
*[]
*[http://en.wikipedia.org/wiki/Bond_valuation Bond Valuation]