# Calculation of loan parameters

### 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.

### Fixed Principal Loans vs Standard Amortizing Loans in EXCEL

Compare two types of loan payments: annuity (the borrower regularly pays the loan in equal amounts) and differentiated (the principal amount is divided into equal parts in proportion to the term loan, interest is accrued on the remaining amount).

### 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.

### Fixed Principal Loans in EXCEL

Compose in MS EXCEL loan repayment schedule differentiated payments.

### 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.