Financial
This page presents procedures from class WorksheetFunction related to the theme Financial
Ispmt - Calculates the interest paid during a specific period of an investment. This function is provided for compatibility with Lotus 1-2-3.
AccrInt - Returns the accrued interest for a security that pays periodic interest.
AccrIntM - Returns the accrued interest for a security that pays interest at maturity.
AmorDegrc - Returns the depreciation for each accounting period. This function is provided for the French accounting system.
AmorLinc - Returns the depreciation for each accounting period. This function is provided for the French accounting system.
CoupDayBs - Returns the number of days from the beginning of the coupon period to the settlement date.
CoupDays - Returns the number of days in the coupon period that contain the settlement date.
CoupDaysNc - Returns the number of days from the settlement date to the next coupon date.
CoupNcd - Returns a number that represents the next coupon date after the settlement date.
CoupNum - Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
CoupPcd - expression.CoupPcd (Arg1, Arg2, Arg3, Arg4)
CumIPmt - Returns the cumulative interest paid on a loan between start_period and end_period.
CumPrinc - Returns the cumulative principal paid on a loan between start_period and end_period.
Db - Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
Ddb - Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
Disc - Returns the discount rate for a security.
DollarDe - Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. Use DollarDe to convert fractional dollar numbers, such as securities prices, to decimal numbers.
DollarFr - Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction. Use DollarFr to convert decimal numbers to fractional dollar numbers, such as securities prices.
Duration - Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of the cash flows and is used as a measure of a bond price's response to changes in yield.
Effect - Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
Fv - Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
FVSchedule - Returns the future value of an initial principal after applying a series of compound interest rates. Use FVSchedule to calculate the future value of an investment with a variable or adjustable rate.
IntRate - Returns the interest rate for a fully invested security.
Ipmt - Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
Irr - Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods.
MDuration - Returns the modified Macauley duration for a security with an assumed par value of $100.
MIrr - Returns the modified internal rate of return for a series of periodic cash flows. MIrr considers both the cost of the investment and the interest received on reinvestment of cash.
Nominal - Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year.
NPer - Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
Npv - Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
OddFPrice - Returns the price per $100 face value of a security having an odd (short or long) first period.
OddFYield - Returns the yield of a security that has an odd (short or long) first period.
OddLPrice - Returns the price per $100 face value of a security having an odd (short or long) last coupon period.
OddLYield - Returns the yield of a security that has an odd (short or long) last period.
PDuration - Returns the number of periods required by an investment to reach a specified value.
Pmt - Calculates the payment for a loan based on constant payments and a constant interest rate.
Ppmt - Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
Price - Returns the price per $100 face value of a security that pays periodic interest.
PriceDisc - Returns the price per $100 face value of a discounted security.
PriceMat - Returns the price per $100 face value of a security that pays interest at maturity.
Pv - Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow money, the loan amount is the present value to the lender.
Rate - Returns the interest rate per period of an annuity. Rate is calculated by iteration and can have zero or more solutions. If the successive results of Rate do not converge to within 0.0000001 after 20 iterations, Rate returns the #NUM! error value.
Received - Returns the amount received at maturity for a fully invested security.
Rri - Returns an equivalent interest rate for the growth of an investment.
Sln - Returns the straight-line depreciation of an asset for one period.
Syd - Returns the sum-of-years' digits depreciation of an asset for a specified period.
TBillEq - Returns the bond-equivalent yield for a Treasury bill.
TBillPrice - Returns the price per $100 face value for a Treasury bill.
TBillYield - Returns the yield for a Treasury bill.
Vdb - Returns the depreciation of an asset for any period that you specify, including partial periods, by using the double-declining balance method or some other method that you specify. Vdb stands for variable declining balance.
Xirr - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. To calculate the internal rate of return for a series of periodic cash flows, use the Irr function.
Xnpv - Returns the net present value for a schedule of cash flows that is not necessarily periodic.
YieldDisc - Returns the annual yield for a discounted security.
YieldMat - Returns the annual yield of a security that pays interest at maturity.