ODDFYIELD
Returns the yield of a security with an odd first period.
FinancialFinance & Accounting
What it does
Calculates yield for odd first period.
Syntax
ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
Arguments
settlement(date) — Settlement date.
Examples
Odd Period Yield
Calculate yield.
FORMULA
=ODDFYIELD(A2, B2, C2, D2, 0.05, 99.8, 100, 2)
RESULT
0.06
SAMPLE DATA
| A | |
|---|---|
| 1 | Dates |
| 2 | (See Args) |