Microsoft Office Tutorials and References
In Depth Information
Financial Functions
Returns a modified internal rate of return for several periodic
cash flows.
MIRR
Returns the nominal annual interest rate given an effective rate
and a number of compounding periods per year.
NOMINAL
Returns the number of periods for an investment based on periodic
constant payments and a constant interest rate.
NPER
Calculates the net present value of an investment with the
discount rate and several future payments and income.
NPV
Returns the value of a security based on a per $100 face value and
an odd first period.
ODDFPRICE
Returns the security yield with an odd first period.
ODDFYIELD
Returns the per $100 face value of a security having an odd last
coupon period.
ODDLPRICE
Returns the security yield that has an odd last coupon period.
ODDLYIELD
Calculates the loan payment for a loan based on constant
payments and constant interest rates.
PMT
Returns the principal payment for a period of an investment based
on periodic constant payments and a constant interest rate.
PPMT
Returns the value of a security based on price per $100 face value
and periodic payments.
PRICE
Returns the value of a discounted security based on a price per
$100 face value.
PRICEDISC
Returns the value of a security that pays interest at maturity and
price per $100 face value.
PRICEMAT
Returns the present value based on an investment.
PV
Returns per period the interest of an annuity.
RATE
Returns the amount received at maturity based on a fully invested
security.
RECEIVED
Returns the straight-line depreciation on an asset based on one
period.
SLN
Returns the sum-of-years-digits depreciation of an asset based on
a specified period.
SYD
Returns the bond equivalent yield for a treasur y bill.
TBILLEQ
Returns the price per $100 face value for a treasur y bill.
TBILLPRICE
Returns the yield for a treasur y bill.
TBILLYIELD
Returns the depreciation of an asset for a period you specify.
VDB
Returns the internal rate of return for a schedule of cash flows
that are not necessarily periodic.
XIRR
Search JabSto ::




Custom Search