Element |
Description |
---|---|

DDB function |
Returns double-declining balance depreciation of an asset for a specific period |

FV function |
Calculates the future value of an annuity |

IPmt function |
Computes the interest payment for a given period of an annuity |

IRR function |
Calculates the internal rate of return for a series of periodic cash flows |

MIRR function |
Calculates the modified internal rate of return |

NPer function |
Determines the number of payment periods for an annuity, based on fixed periodic payments and a fixed interest rate |

NPV function |
Calculates the net present value of an investment |

Pmt function |
Calculates the payment for an annuity |

PPmt function |
Computes the payment of principal for a given period of an annuity |

PV function |
Calculates the present value of an annuity |

Rate function |
Returns the interest rate per period for an annuity |

SLN method |
Computes the straight-line depreciation of an asset |

SYD function |
Computes the sum-of-years’ digits depreciation of an asset for a specified period |

Start Free Trial

No credit card required