---
title: Financial
slug: financial
docTags: 
createdAt: 2025-09-22T04:55:19.000Z
---

### DB

**Description: **Returns the depreciation using fixed declining balance calculation.

**Example: **

*DB(cost, salvage, life, period, month)*

### DDB

**Description: **Returns the depreciation using double declining balance calculation.

**Example: **

*DDB(cost, salvage, life, period, factor)*

### FV

**Description: **Returns future value of an investment.

**Example: **

*FV( interest\_rate, number\_payments, payment, PV, Type )*

### IPMT

**Description: **Returns interest payment.

**Example: **

### IRR

**Description: **Returns internal rate of return.

**Example: **

*IRR(values, guess)*

### ISPMT

**Description: **Returns interest payment.

**Example: **

*ISPMT(rate, per, nper, pv)*

### MIRR

**Description: **Returns internal rate of return.

**Example: **

*MIRR(values, finance\_rate, reinvest\_rate)*

### NPER

**Description: **Returns number of payment periods.

**Example: **

*NPER(rate, pmt, pv, fv, type)*

### NPV

**Description: **Returns net present value.

**Example: **

*NPV(rate, value1, value2, ...)*

### PMT

**Description: **Returns loan payment.

**Example: **

*PMT(rate, nper, pv, fv, type)*

### PPMT

**Description: **Returns principal payment.

**Example: **

*PPMT(rate, per, nper, pv, fv, type)*

### PV

**Description: **Returns present value.

**Example: **

*PV(rate, nper, pmt, fv, type)*

### RATE

**Description: **Returns interest rate per period.

**Example: **

*RATE(nper, pmt, pv, fv, type, guess)*

### SLN

**Description: **Returns straight-line depreciation.

**Example: **

*SLN(cost, salvage, life)*

### SYD

**Description: **Returns sum-of-years depreciation.

**Example: **

*SYD(cost, salvage, life, per)*

### VDB

**Description: **Returns the depreciation using double declining balance calculation.

**Example: **

*VDB(cost, salvage, life, start\_period, end\_period, factor, no\_switch)*

### Xirr

**Description: **Computes the internal rate of return for a schedule of possibly non-periodic cash flows.

**Example: **

*Xirr(cashflow, datelist, value)*