Number of Periods Annuity Formula PV

This number of periods annuity formula PV calculates the number (n) of annuity payments required to provide a given value today PV (present value). The annuity formula assumes payments (Pmt) are made at the end of each period, and a discount rate i is applied.

Last modified February 16th, 2023 by Michael Brown
Read more

Excel SYD Function

The Excel SYD function is used to calculate the sum of the years digits depreciation for a given accounting period. It is based on an assets cost. salvage value, and useful life.

Last modified January 19th, 2023 by Michael Brown
Read more

Bond Amortization Calculator

This free bond premium or discount amortization calculator with can be used for any bond up to a maximum term of 200 interest payment periods.

The calculator will calculate the straight line method bond amortization, and will also produce an effective interest method amortization schedule setting out the premium or discount amortization for each interest payment period.

Last modified July 16th, 2019 by Michael Brown
Read more

Excel NOMINAL Function

The Excel NOMINAL function is used to calculate the nominal annual rate (i) required to give an effective annual rate (r), allowing for a given number of compounding periods each year (m). The effective rate allows for compounding, whereas the nominal rate does not allow for compounding.

Last modified January 12th, 2023 by Michael Brown
Read more

Nominal Interest Rate Formula

The nominal rate formula calculates the nominal rate of interest for a year based on an effective rate (r), with compounding taking place a number of times a year (m).

Last modified October 17th, 2022 by Michael Brown
Read more

Effective Interest Rate Formula

The effective interest rate formula calculates the rate of interest for a number of compounding periods (n) based on a nominal rate (i) compounded a number of times a year (n).

Last modified January 16th, 2023 by Michael Brown
Read more

Future Value of a Growing Annuity Formula

The future value of a growing annuity formula is used to calculate the value at the end of period n of a series of periodic payments which increase or decrease at a constant rate each period. The payments made at the end of each period, and a discount rate i% is applied.

Last modified January 17th, 2020 by Michael Brown
Read more

Present Value of a Growing Annuity Formula

The present value of a growing annuity formula is used to calculate the present value of a series of periodic payments which increase at a constant rate each period. The payments made at the end of each period, and a discount rate i% is applied.

Last modified February 24th, 2023 by Michael Brown
Read more

Present Value of Annuity Due Formula

The present value of an annuity due formula is used to calculate the present value of a series of periodic payments. The payments are for the same amount, made at the start of each period, and a discount rate i% is applied.

Last modified February 22nd, 2023 by Michael Brown
Read more

MIRR Formula

The MIRR formula is used to calculate the rate of return for a project taking into account the finance cost (f) of the cash used to fund the project (negative cash flows), and the rate of return (r) on cash from the project (positive cash flows) reinvested elsewhere.

Last modified September 19th, 2019 by Michael Brown
Read more

You May Also Like