writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 22:
Line 22: − +
→Description
N= Number of days from settlement date to redemption date
N= Number of days from settlement date to redemption date
:<math>YIELD = \frac{(\frac{redemption}{100}+\frac{rate}{frequency})-(\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency}))}{\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency})}*\frac{frequency*C}{N}</math>
:<math>YIELD = \dfrac{(\dfrac{redemption}{100}+\frac{rate}{frequency})-(\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency}))}{\frac{par}{100}+(\frac{B}{C}*\frac{rate}{frequency})}*\frac{frequency*C}{N}</math>
*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*<math>settlement</math> and <math>maturity</math> dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.