Calculation of loan parameters

Расчет кредитов и вкладов в Excel

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.

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

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.

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.

Compose in MS EXCEL loan repayment schedule differentiated payments.

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.

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.

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.