A few days ago I was asked by some reader to create an Excel template for the calculation of daily interest. I think that the following can make other interested, that’s why I have programmed an interest calculator as a template.
Click here to go directly to the download.
How to use the Interest Calculator?
Everything is very simple as usual for excel-template.net:
- Download the Excel file from the download section below, save it, and then open it with Excel or any other spreadsheet editing program.
- Now enter the start amount, the interest rate, the start date and the end date.
- That’s all you need to do.
- In a moment, Excel will calculate the interest days and the final result.
Screenshot of the Interest Calculator Excel Template
In the picture, you can see the small interface made with Excel:
Interest calculator per day
Download the daily Interest Calculator Template for free
Here you find this template in Excel file format (.xlsx).
If you like my templates, I’m looking forward to a little donation 🙂
More Interest Calculators
A little research showed that there are other good interest calculator templates to download:
Hello,
Can you create a custom auto compounding calculator (compounding every 30 minutes) for a fee or otherwise? If so, I’ll provide details. thanks.
Can you create calculator which allows loans not to be compounded
The “Exact daily interest Calculator” it works great but if I wanted to include the start and end dates to be counted what needs to be done to the formula?? Also, will the entered dates include leap years in the calculations?