Publication date: 11/10/2021

# Finance Functions

Lets you create formulas to calculate principal payments, interest rate, rate of return, and so on.

#### Double Declining Balance

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.

#### Future Value

Returns the future value of an investment that is based on periodic, constant payments and a constant interest rate.

#### Interest Payment

Returns the interest payment for a given period for an investment that is based on periodic, constant payments and a constant interest rate.

#### Interest Rate

Returns the interest rate per period of an annuity.

#### Internal Rate of Return

Returns the internal rate of return for a series of cash flows in the values argument.

#### Modified Internal Rate of Return

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.

#### Net Present Value

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).

#### Number of Periods

Returns the number of periods for an investment that is based on periodic, constant payments and a constant interest rate.

#### Payment

Returns the payment for a loan that is based on constant payments and a constant interest rate.

#### Present Value

Returns the present value of an investment.

#### Principal Payment

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.

#### Straight Line Depreciation

Returns the straight-line depreciation of an asset for one period.

#### Sum Of Years Digits Depreciation

Returns the sum-of-yearsâ€™ digits depreciation of an asset for a specified period.