# Financial functions

CUMIPMT | Returns the total interest paid on a loan in specified periodic payments. |

CUMPRINC | Returns the total capital repaid on a loan in specified periodic payments. |

DB | Returns the depreciation of an asset for a given year using the fixed rate declining-balance method. |

DDB | Returns the depreciation of an asset for a given year using the double declining-balance method (or any other factor). |

DOLLARDE | Converts a fractional number representation of a number into a decimal number. |

DOLLARFR | Converts a decimal number into a fractional representation of that number. |

EFFECT | Returns the effective compounded interest rate given a nominal interest rate. |

FV | Returns the future value of an initial sum with a subsequent stream of payments. |

FVSCHEDULE | Returns the future value of a lump sum, with changing future interest rates. |

IPMT | Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity. |

IRR | Calculates the internal rate of return of a series of cash flows. |

ISPMT | Returns the interest paid in a period for a fixed-rate loan. |

MIRR | Returns the modified internal rate of return of a series of cash flows. |

NOMINAL | Returns a nominal interest rate given the effective compounded interest rate. |

NPER | Returns the number of payment periods for an annuity. |

NPV | Returns the net present value of an investment with regular cash payments. |

PDURATION | Returns the number of periods required by an investment to realize a desired value. |

PMT | Returns the payment per period for a fixed-rate loan. |

PPMT | Returns the portion of the periodic payment which is repaid capital for a fixed-rate loan or annuity. |

PV | Returns the present value of a stream of future payments with a final lump sum. |

RATE | Returns the interest rate of an annuity. |

RRI | Returns an equivalent interest rate when an investment increases in value. |

SLN | Returns the depreciation of an asset in a single period using the straight-line depreciation method. |

SYD | Returns the depreciation of an asset for a given year using the sum of the years' digits method. |

TBILLEQ | Returns the bond-equivalent-yield (BEY) for a US Treasury bill. |

TBILLPRICE | Returns the issue price for a US Treasury bill, per $100 face value, given a discount rate. |

TBILLYIELD | Returns the yield for a US Treasury bill. |

XIRR | Calculates the internal rate of return of a series of irregular cash flows. |

XNPV | Returns the net present value of an investment with irregular cash payments. |