Lets you create formulas to calculate principal payments, interest rate, rate of return, and so on.
Returns the depreciation of an asset for a specified period of time. The function uses the double-declining balance method or some other depreciation factor.
Returns the future value of an investment that is based on periodic, constant payments and a constant interest rate.
Returns the interest payment for a given period for an investment that is based on periodic, constant payments and a constant interest rate.
Returns the interest rate per period of an annuity.
Returns the internal rate of return for a series of cash flows in the values argument.
Returns the modified internal rate of return for a series of periodic cash flows. The cost of investment and the interest received on reinvested cash is included.
Returns the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
Returns the number of periods for an investment that is based on periodic, constant payments and a constant interest rate.
Returns the payment for a loan that is based on constant payments and a constant interest rate.
Returns the present value of an investment.
Returns the payment on the principal for a given period for an investment that is based on periodic, constant payments and a constant interest rate.
Returns the straight-line depreciation of an asset for one period.
Returns the sum-of-years’ digits depreciation of an asset for a specified period.