How to Calculate an Interest Payment Using Microsoft Excel

Set up your spreadsheet for the interest payment calculation. ... Divide your annual interest rate by 12 if you want to calculate interest on a monthly basis; divide ...

www.google.com.tw