# Annuity in EXCEL

### Annuity in EXCEL. Calculating the Interest rate

Let you know the amount and term of the loan and the value of the regular annuity payment. will Calculate in MS EXCEL what interest rate you need to take this loan to completely pay off over a given period of time. The article also will examine the case of accumulation of the Deposit.

### Annuity in EXCEL. A Guide to the PMT, FV, IPMT, PPMT and other Functions

the article considers the financial function PMT(), OPLT(), IPMT(), NPER(), RATE(), PS(), BS() and OBTAHED() and ABSPATH(), which are used for the calculations of the annuity scheme.

### Annuity in EXCEL. Calculating the Periodic payment for a loan

Calculate MS EXCEL the amount of the regular annuity payment at maturity of the loan. Do it using the function PMT(), and directly by the formula of annuities. Also set up a table of monthly payments with a breakdown of the remaining part of the debt and accrued interest.

### Annuity in EXCEL. Calculating the Periodic payment for an investment

Calculate in MS EXCEL the amount of regular payment in case of accumulation of a certain amount. Do it using the function PMT(), and directly by the formula of annuities. Also set up a table of regular payments with a breakdown of accumulated amount and accrued interest.

### Annuity in EXCEL. Number of periods for loan or investment

Calculate in MS EXCEL how long will it take to repay the loan in equal monthly payments (annuity scheme). The interest rate and the amount of payment is known, the accrual of interest on the loan monthly. The article also will examine the case of accumulation of the Deposit.

### Annuity in EXCEL. Сumulative principal paid on a loan

Calculate in MS EXCEL outstanding principal amount of the debt you want to repay after a specified number of periods. Loan repayment is made in equal monthly installments (annuity). The interest rate and the amount of payment is known, the calculation of interest on loan monthly.

### Annuity in EXCEL. Сumulative interest paid on a loan

Calculate in MS EXCEL the amount of interest that you want to pay for a certain number of periods of the loan. Loan repayment is made in equal monthly installments (annuity). The interest rate and the amount of payment is known, the calculation of interest on loan monthly.

### Annuity in EXCEL. Calculating the future value

Determine the Future value of an investment in the case of an annuity. An investment will understand how regular contributions and initial payment. For this, we use the function BS(). Also derive an alternative formula for calculating Future value.

### Annuity in EXCEL. Calculating the Present value

Define Given (current) value of future incomes (or costs) in the case of an annuity. For this, we use the function PS(). Also derive an alternative formula for the calculation of fair value.