Question: how to calculate monthly compound interest on loan in excel?
Answer: P = the principal amount (the initial savings or the starting loan amount)
r = the nominal annual interest rate in decimal form. ... 
n = the number of compound periods per year (e.g. for monthly, n=12)
t = the time in years.