Growing Annuity Payment Formula FV

This growing annuity payment formula FV calculates the initial annuity payment required to provide a given future value FV using a growing annuity. The growing annuity payment formula assumes payments are made at the end of each period for n periods and are growing or declining at a constant rate (g), and a discount rate i is applied.

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

Growing Annuity Payment Formula PV

This growing annuity payment formula PV calculates the initial annuity payment required to provide a given value today PV (present value) using a growing annuity. The growing annuity payment formula assumes payments are made at the end of each period for n periods and are growing or declining at a constant rate (g), 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

Auto Loan Payment Example

A car is financed using a three-year loan. The loan has a 8% nominal annual interest rate, compounded monthly. The price of the car is 7,000, and a deposit of 2,000 is paid in cash. Calculate the monthly auto loan payments, assuming that the payments start one month after the purchase.

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

Annuity Payment Formula FV

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

Read more

Annuity Payment Formula PV

This annuity 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 end of each period for n periods, and a discount rate i is applied.

Read more

How to Calculate a Lease Payment

A lease is a method of financing the use of an asset, and is an agreement between a lessee (who rents the asset), and a lessor (who owns the asset). The lessor is usually a lease company or finance company.

The lessee rents the asset from the lessor in return for a periodic rental payment. The lessee never owns the asset, and at the end of the term it is returned to the lessor or a secondary period of rental is entered into.

Read more

Loan Constant Tables

The loan constant tables can be used to carry out annuity calculations without the use of a financial calculator. In particular, the tables can be used to calculate the repayments and the outstanding balance on a fixed interest loan.

Read more

How to Calculate a Debt Constant

The debt constant sometimes referred to as the loan constant or mortgage loan constant is the ratio of the constant periodic payment on a loan to the original loan.

The debt service constant is only relevant to loans that have a fixed interest rate over the term of the loan, and is used to make quick calculations of the amount needed to repay a loan over its term, and the balance outstanding on the loan at any point in time.

Read more