# Financial Functions

DDB | Returns the depreciation of an asset in a single period (double or triple declining balance method) (Double). |

FV | Returns the future value of a series of equal cash flows at regular intervals (Double). |

IPMT | Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |

IRR | Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |

MIRR | Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |

NPER | Returns the number of periods for an investment (Double). |

NPV | Returns the present value of a series of unequal cash flows at regular intervals (Double). |

PMT | Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |

PPMT | Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |

PV | Returns the present value of a series of equal cash flows at regular intervals (Double). |

RATE | Returns the interest rate for a series of equal cash flows at regular intervals (Double). |

SLN | Returns the straight-line depreciation of an asset over a single period of time (Double). |

SYD | Returns the sum-of-years' digits depreciation of an asset (Double). |

DDBReturns the depreciation of an asset in a single period (double or triple declining balance method) (Double). |

FVReturns the future value of a series of equal cash flows at regular intervals (Double). |

IPMTReturns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |

IRRReturns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |

MIRRReturns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |

NPERReturns the number of periods for an investment (Double). |

NPVReturns the present value of a series of unequal cash flows at regular intervals (Double). |

PMTReturns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |

PPMTReturns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |

PVReturns the present value of a series of equal cash flows at regular intervals (Double). |

RATEReturns the interest rate for a series of equal cash flows at regular intervals (Double). |

SLNReturns the straight-line depreciation of an asset over a single period of time (Double). |

SYDReturns the sum-of-years' digits depreciation of an asset (Double). |

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top