Page 405 - Excel 2013 All-in-One For Dummies

Function
EFFECT(nominal_rate,npery) INTRATE(settlement,maturity,
investment,redemption,[basis]) MDURATION(settlement,maturity,
coupon,yld,frequency,[basis]) NOMINAL(effect_rate,npery)
ODDFPRICE(settlement,maturity, issue,first_coupon,rate,yld,redemption, frequency,[basis])
ODDFYIELD(settlement,maturity, issue,first_coupon,rate,pr,redemption, frequency,[basis])
ODDLPRICE(settlement,maturity, last_interest,rate,yld,redemption, frequency,[basis])
ODDLYIELD(settlement,maturity, last_interest,rate,pr,redemption, frequency,[basis])
PRICE(settlement,maturity,rate,yld, redemption,frequency,[basis])
PRICEDISC(settlement,maturity, discount,redemption,[basis])
PRICEMAT(settlement,maturity,issue, rate,yld,[basis])
RECEIVED(settlement,maturity, investment,discount,[basis])
TBILLEQ(settlement,maturity, discount)
TBILLPRICE(settlement,maturity, discount)
TBILLYIELD(settlement,maturity,pr)
What It Calculates
Calculates the effective annual interest rate given the nominal interest rate and the number of compounding periods per year.
Calculates the interest rate for a fully invested security.
Calculates the modified Macauley dura- tion for a security with an assumed part value of $100.
Calculates the nominal annual interest rate given the effect rate and the number of compounding periods per year.
Calculates the price per $100 face value of a security having an odd (short or long) first period.
Calculates the yield of a security that has an odd (short or long) first period.
Calculates the price per $100 face value of a security having an odd (short or long) last coupon period.
Calculates the yield of a security that has an odd (short or long) last period.
Calculates the price per $100 face value of a security that pays periodic interest.
Calculates the price per $100 face value of a discounted security.
Calculates the price per $100 face value of a security that pays interest at matu- rity.
Calculates the amount received at matu- rity for a fully invested security.
Calculates the bond-equivalent yield for a Treasury bill.
Calculates the price per $100 face value for a Treasury bill.
Calculates the yield for a Treasury bill.
(continued)
Analysis ToolPak Financial Functions 387
Book III Chapter 4
Financial Formulas