Loan Interest Calculator in Excel – Multiple Payments / Receipts (Free)
Direct download - Free Loan Interest Calculator in Excel – Multiple Payments (Free) Did you lend money and get it back in parts? Or take a loan and repay it in instalments on different dates? Working out the interest by hand is slow and easy to get wrong. Every payment falls on a different date, leap years change the day count, and interest is usually added to the balance once a year. This Excel workbook does it for you. Enter your receipts and payments with their dates and the interest rate. It builds a bank-style statement and shows the final amount , marked TO RECEIVE or TO PAY . How it works Set the basics. On the Input sheet, enter the date up to which interest should be calculated and the yearly rate. Enter transactions in date order. Put each one in Receipt (money you received) or Payment (money you paid). Use one column per row. You can enter up to 100 transactions. The Statement sheet builds itself. It lists every transaction, every yearly interest date and the fina...