Microsoft Office Tutorials and References
In Depth Information
Returns the price per $100 face value of a security with an odd last period.
Returns the yield of a security with an odd last period.
Returns the number of periods required by an investment to reach a speci-
Returns the periodic payment for an annuity.
Returns the payment on the principal for an investment for a given period.
Returns the price per $100 face value of a security that pays periodic in-
Returns the price per $100 face value of a discounted security.
Returns the price per $100 face value of a security that pays interest at
Returns the present value of an investment.
Returns the interest rate per period of an annuity.
Returns the amount received at maturity for a fully invested security.
Returns an equivalent interest rate for the growth of an investment.
Returns the straight-line depreciation of an asset for one period.
Returns the sum-of-years' digits depreciation of an asset for a specified
Returns the bond-equivalent yield for a Treasury bill.
Returns the price per $100 face value for a Treasury bill.
Returns the yield for a Treasury bill.
Returns the depreciation of an asset for a specified or partial period using a
double declining-balance method.
Returns the internal rate of return for a schedule of cash flows that is not
Returns the net present value for a schedule of cash flows that is not ne-