how to calculate compound interest on loan in excel?
['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.']