Simple and Compound Interest in EXCEL

Простые и сложные проценты в Excel

Consider the simple interest accrual method in which the amount of accrued interest is determined based only on the initial amount you Deposit (or debt). The interest on the accrued interest not accrued (interest is not kapitaliserede).

Consider compound interest (Compound Interest) – the interest as principal and on previously accrued interest.

Consider compound interest (Compound Interest) – the interest as principal and on previously accrued interest, in the case of a variable rate.

Calculate in MS EXCEL the effective annual interest rate and effective interest rate of the loan.

Consider continuous compounding compound interest in MS EXCEL at a constant nominal rate.