# Calculate Interest

so say youve saved and parked it in a savings account with an ongoing interest rate of you want to leave it there for years

for purposes of calculation the active formula below may be used by entering the relevant data and then clicking on the quantity you wish to calculate

in order to calculate the nominal function we will need to input the following formula nominalcc where c is the effective interest rate and c is

you will enter this data into the pmt function to calculate your monthly payment since this loan is paid in monthly the interest rate

using software like excel or numbers how to calculate equal payments based on different interest rates

use the ppmt function to calculate the principal part of the payment the second argument specifies the payment number

excel interest calculator compounding interest calculator excel interest rate excel image titled calculate credit card interest