Future Value of an Annuity Due

The concept of the future value of an annuity due is the starting point for many annuity calculations, and can be used to calculate the future value of mortgages, pensions, life assurance, motor vehicle lease payments, rentals, bond valuations, and many others.

Read more

Annuity Due Payment Formula FV

This annuity due payment formula FV calculates the annuity payment required to provide a given future value FV. The annuity formula assumes payments are made at the start of each period for n periods, and a discount rate i is applied.

Read more

Annuity Due Payment Formula PV

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

Read more

Excel PV Function

The Excel PV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax PV (Rate, Nper, Pmt, FV, Type).

Read more

Excel RATE Function

The Excel RATE function is used to calculate the discount rate (i) in time value of money calculations. For example, it can calculate the interest rate on a loan given the value of the loan, the term and the periodic payments, it can be used to calculate the interest rate earned on a savings account, or the interest rate needed to generate annuity payments from a lump sum investment.

Read more

Excel FV Function

The Excel FV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax FV (Rate, Nper, Pmt, PV, Type).

Read more

Excel NPER Function

The Excel NPER function is one of many Excel financial functions, and can be used to calculate the number of periods for a lump sum, annuity or annuity due to grow to a future value. In addition the function can also be used to calculate the number of periods it takes for a loan to be repaid.

Read more

Excel PMT Function

The Excel PMT function is used to calculate the payment (Pmt) in time value of money calculations. For example, it can calculate the payments needed to clear a loan balance, the deposits to a savings account to grow to a future value, or annuity and annuity due payments from a lump sum investment.

Read more