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.