Question: how to calculate compound interest on loan in excel?
Answer: It might be easier to start with simple interest that is calculated only on the principal amount. ... 
In our example, the formula is =A2*(1+$B2) where A2 is your initial deposit and B2 is the annual interest rate.