Daily Compound Interest Calculator
Calculate interest day by day on a balance that changes, then download the workpaper.
Balance and dates
Your workpaper
Example inputs- $291.68
- $486,841.68
- $486,550.00
Daily balances and interest
Choose the Daily Accrual Convention
Daily compound accrual adds each day’s interest to the interest-bearing balance. Simple daily accrual keeps the interest separate, so later days earn or incur interest on principal alone.
Divide the entered annual rate by the selected divisor and multiply by the day’s interest-bearing balance. Choose 365 or 360 every year, or use 366 for each day in a leap year and 365 otherwise.
Included dates controls which endpoints accrue interest. When the two dates match, Include both dates counts one day and the other settings count zero. These are workpaper assumptions you can match to the terms you’re checking.
Enter Balances and Rate Changes in Order
Enter the opening balance before any included movement. Use a positive amount to increase the balance or a negative amount to reduce it. Each rate entry replaces the annual rate on its entered date.
Before accrual applies that day’s movements and rate change first. After accrual applies them once the day’s interest is calculated. The new rate then applies from the following included day.
The workpaper sorts events by date and adds same-day movements together, including identical entries. It requires one rate change per date. A reversed date range or an event outside the included dates stops the calculation and marks the entry. Each workpaper allows up to 12 balance movements and 12 rate changes over up to 3,660 calendar days.
Reconcile the Daily Workpaper
Read across each dated row from the opening balance through the applicable annual rate and daily interest to the closing interest-bearing balance. Add accrued interest to the closing principal to reconcile the closing balance with interest.
The hypothetical example starts at $485,000 for three included days at 7.3% a year. Add $1,550 before interest on day two. Use a 365-day divisor and round to cents each day in both modes.
Simple mode accrues $97.00, $97.31 and $97.31 across the three rows. Daily compound mode accrues $97.00, $97.33 and $97.35 because prior interest stays in the balance.
Download the CSV for every day, the selected assumptions and the totals. The workpaper is generated in your browser. With interval rounding, the model carries fractions of a cent until the end. The CSV retains those daily amounts and shows the adjustment to the rounded total.
Compare With the Contract or Statement
Daily calculation and interest posting can follow different schedules. For example, CommBank describes how it totals daily home loan charges each month using a 365-day divisor even in a leap year.
Compare the lender’s value dates with the dates you entered. An offset can change the interest-bearing balance, and differences in posting frequency or rounding can change the total.
This workpaper checks arithmetic for the balances and assumptions you enter. Use the loan contract and statement to establish the lender’s contractual charge.