Microsoft Office Tutorials and References
In Depth Information
Returns a modified internal rate of return for several periodic
Returns the nominal annual interest rate given an effective rate
and a number of compounding periods per year.
Returns the number of periods for an investment based on periodic
constant payments and a constant interest rate.
Calculates the net present value of an investment with the
discount rate and several future payments and income.
Returns the value of a security based on a per $100 face value and
an odd first period.
Returns the security yield with an odd first period.
Returns the per $100 face value of a security having an odd last
Returns the security yield that has an odd last coupon period.
Calculates the loan payment for a loan based on constant
payments and constant interest rates.
Returns the principal payment for a period of an investment based
on periodic constant payments and a constant interest rate.
Returns the value of a security based on price per $100 face value
and periodic payments.
Returns the value of a discounted security based on a price per
$100 face value.
Returns the value of a security that pays interest at maturity and
price per $100 face value.
Returns the present value based on an investment.
Returns per period the interest of an annuity.
Returns the amount received at maturity based on a fully invested
Returns the straight-line depreciation on an asset based on one
Returns the sum-of-years-digits depreciation of an asset based on
a specified period.
Returns the bond equivalent yield for a treasur y bill.
Returns the price per $100 face value for a treasur y bill.
Returns the yield for a treasur y bill.
Returns the depreciation of an asset for a period you specify.
Returns the internal rate of return for a schedule of cash flows
that are not necessarily periodic.