The security's issue date.

The security's first interest date.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's annual coupon rate.

The security's par value. If you omit par, ACCRINT uses $1,000.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use. The default is 0.

The security's issue date.

The security's maturity date.

The security's annual coupon rate.

The security's par value. If you omit par, ACCRINTM uses $1,000.

Optional. The type of day count basis to use.

The cost of the asset.

The date of the purchase of the asset.

The date of the end of the first period.

The salvage value at the end of the life of the asset.

The period.

The rate of depreciation.

Optional. The year basis to be used.

The cost of the asset.

The date of the purchase of the asset.

The date of the end of the first period.

The salvage value at the end of the life of the asset.

The period.

The rate of depreciation.

Optional. The year basis to be used.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use. Default is 0.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The interest rate.

The total number of payment periods.

The present value.

The first period in the calculation. Payment periods are numbered beginning with 1.

The last period in the calculation.

The timing of the payment.

The interest rate.

The total number of payment periods.

The present value.

The first period in the calculation. Payment periods are numbered beginning with 1.

The last period in the calculation.

The timing of the payment.

The initial cost of the asset.

The value at the end of the depreciation (sometimes called the salvage value of the asset).

The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

The period for which you want to calculate the depreciation. Period must use the same units as life.

Optional. The number of months in the first year. If month is omitted, it is assumed to be 12.

The initial cost of the asset.

The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

The period for which you want to calculate the depreciation. Period must use the same units as life.

Optional. The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method).

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's price per $100 face value.

The security's redemption value per $100 face value.

Optional. The type of day count basis to use. Default is 0.

A number expressed as an integer part and a fraction part, separated by a decimal symbol.

The integer to use in the denominator of the fraction.

A decimal number.

The integer to use in the denominator of a fraction.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's annual coupon rate.

The security's annual yield.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The nominal interest rate.

The number of compounding periods per year.

The interest rate per period.

The total number of payment periods in an annuity.

The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.

Optional. The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument.

Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.

The present value.

An array of interest rates to apply.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The amount invested in the security.

The amount to be received at maturity.

Optional. The type of day count basis to use.

The interest rate per period.

The period for which you want to find the interest and must be in the range 1 to nper.

The total number of payment periods in an annuity.

The present value, or the lump-sum amount that a series of future payments is worth right now.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).

Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.

An array or a reference to values that contain numbers for which you want to calculate the internal rate of return.

• Values must contain at least one positive value and one negative value to calculate the internal rate of return.
• IRR uses the order of values to interpret the order of cash flows. Be sure to enter your payment and income values in the sequence you want.
• If an array or reference argument contains text, logical values, or empty values, those values are ignored.

Optional. A number that you guess is close to the result of IRR.

• Microsoft Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent. If IRR can't find a result that works after 20 tries, the #NUM! error value is returned.
• In most cases you do not need to provide guess for the IRR calculation. If guess is omitted, it is assumed to be 0.1 (10 percent).
• If IRR gives the #NUM! error value, or if the result is not close to what you expected, try again with a different value for guess.

The interest rate for the investment.

The period for which you want to find the interest, and must be between 1 and Nper.

The total number of payment periods for the investment.

The present value of the investment. For a loan, Pv is the loan amount.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's annual coupon rate.

The security's annual yield.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

An array or a reference to values that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.

• Values must contain at least one positive value and one negative value to calculate the modified internal rate of return. Otherwise, MIRR returns the #DIV/0! error value.
• If an array or reference argument contains text, logical values, or empty values, those values are ignored; however, values with the value zero are included.

The interest rate you pay on the money used in the cash flows.

The interest rate you receive on the cash flows as you reinvest them.

The effective interest rate.

The number of compounding periods per year.

The interest rate per period.

The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes.

The present value, or the lump-sum amount that a series of future payments is worth right now.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).

Optional. The number 0 or 1 and indicates when payments are due.

The rate of discount over the length of one period.

value1, value2, ... Value1 is required, subsequent values are optional. 1 to 254 arguments representing the payments and income.

• value1, value2, ... must be equally spaced in time and occur at the end of each period.
• NPV uses the order of value1, value2, ... to interpret the order of cash flows. Be sure to enter your payment and income values in the correct sequence.
• Arguments that are empty values, logical values, or text representations of numbers, error values, or text that cannot be translated into numbers are ignored.
• If an argument is an array or reference, only numbers in that array or reference are counted. Empty values, logical values, text, or error values in the array or reference are ignored.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's issue date.

The security's first coupon date.

The security's interest rate.

The security's annual yield.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's issue date.

The security's first coupon date.

The security's interest rate.

The security's price.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's last coupon date.

The security's interest rate.

The security's annual yield.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's last coupon date.

The security's interest rate

The security's price.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

Rate is the interest rate per period.

Pv is the present value of the investment.

Fv is the desired future value of the investment.

The interest rate for the loan.

The total number of payments for the loan.

The present value, or the total amount that a series of future payments is worth now; also known as the principal.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Optional. The number 0 (zero) or 1 and indicates when payments are due.

The interest rate per period.

Specifies the period and must be in the range 1 to nper.

The total number of payment periods in an annuity.

The present value — the total amount that a series of future payments is worth now.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Optional. The number 0 or 1 and indicates when payments are due.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's annual coupon rate.

The security's annual yield.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's discount rate.

The security's redemption value per $100 face value.

Optional. The type of day count basis to use. The default is 0.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's issue date, expressed as a serial date number.

The security's interest rate at date of issue.

The security's annual yield.

Optional. The type of day count basis to use.

The interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate.

The total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper.

The payment made each period and cannot change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. For example, the monthly payments on a $10,000, four-year car loan at 12 percent are $263.33. You would enter -263.33 into the formula as the pmt. If pmt is omitted, you must include the fv argument.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). For example, if you want to save $50,000 to pay for a special project in 18 years, then $50,000 is the future value. You could then make a conservative guess at an interest rate and determine how much you must save each month. If fv is omitted, you must include the pmt argument.

Optional. The number 0 or 1 and indicates when payments are due.

The total number of payment periods in an annuity.

The payment made each period and cannot change over the life of the annuity. Typically, pmt includes principal and interest but no other fees or taxes. If pmt is omitted, you must include the fv argument.

The present value — the total amount that a series of future payments is worth now.

Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0). If fv is omitted, you must include the pmt argument.

Optional. The number 0 or 1 and indicates when payments are due.

Optional. Your guess for what the rate will be. If you omit guess, it is assumed to be 10 percent. If RATE does not converge, try different values for guess. RATE usually converges if guess is between 0 and 1.

• If you omit guess, it is assumed to be 10 percent.
• If RATE does not converge, try different values for guess. RATE usually converges if guess is between 0 and 1.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The amount invested in the security.

The security's discount rate.

Optional. The type of day count basis to use.

The number of periods for the investment.

The present value of the investment.

The future value of the investment.

The initial cost of the asset.

The value at the end of the depreciation (sometimes called the salvage value of the asset).

The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

The initial cost of the asset.

The value at the end of the depreciation (sometimes called the salvage value of the asset).

The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

The period and must use the same units as life.

The Treasury bill's settlement date. The security settlement date is the date after the issue date when the Treasury bill is traded to the buyer.

The Treasury bill's maturity date. The maturity date is the date when the Treasury bill expires.

The Treasury bill's discount rate.

The Treasury bill's settlement date. The security settlement date is the date after the issue date when the Treasury bill is traded to the buyer.

The Treasury bill's maturity date. The maturity date is the date when the Treasury bill expires.

The Treasury bill's discount rate.

The Treasury bill's settlement date. The security settlement date is the date after the issue date when the Treasury bill is traded to the buyer.

The Treasury bill's maturity date. The maturity date is the date when the Treasury bill expires.

The Treasury bill's price per $100 face value.

The initial cost of the asset.

The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

The number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

The starting period for which you want to calculate the depreciation. Start_period must use the same units as life.

The ending period for which you want to calculate the depreciation. End_period must use the same units as life.

Optional. The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method). Change factor if you do not want to use the double-declining balance method. For a description of the double-declining balance method, see DDB.

Optional. A logical value specifying whether to switch to straight-line depreciation when depreciation is greater than the declining balance calculation.

• If no_switch is TRUE, Microsoft Excel does not switch to straight-line depreciation even when the depreciation is greater than the declining balance calculation.
• If no_switch is FALSE or omitted, Excel switches to straight-line depreciation when depreciation is greater than the declining balance calculation.

A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive and one negative value.

A schedule of payment dates that corresponds to the cash flow payments. Dates may occur in any order. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. .

Optional. A number that you guess is close to the result of XIRR.

The discount rate to apply to the cash flows.

A series of cash flows that corresponds to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment. If the first value is a cost or payment, it must be a negative value. All succeeding payments are discounted based on a 365-day year. The series of values must contain at least one positive value and one negative value.

A schedule of payment dates that corresponds to the cash flow payments. The first payment date indicates the beginning of the schedule of payments. All other dates must be later than this date, but they may occur in any order.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's annual coupon rate.

The security's price per $100 face value.

The security's redemption value per $100 face value.

The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's price per $100 face value.

The security's redemption value per $100 face value.

Optional. The type of day count basis to use.

The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

The security's maturity date. The maturity date is the date when the security expires.

The security's issue date, expressed as a serial date number.

The security's interest rate at date of issue.

The security's price per $100 face value.

Optional. The type of day count basis to use.