The daily interest on a loan balance, the interest accrued to a payoff date and the payoff amount, on an actual/365 or 360-day basis. Free, in the browser, no sign-up.
Per diem interest is the unpaid balance times the note rate divided by the days in the year: interest for one day. With the defaults below, $122,692.38 at 7.25 per cent on an actual/365 basis accrues $24.37 a day; 17 days from the paid-through date add $414.30, and with $55 of fees the payoff is $123,161.68.
| Result | Value |
|---|---|
| Per diem interest | 24.3704 |
| Accrued interest | 414.30 |
| Payoff amount | 123,161.68 |
Runs in your browser: nothing you type is sent anywhere.
Per diem = balance × rate / 365 (or 360, as the note says)
Accrued interest = per diem × days from the paid-through date to the payoff date
In Excel: =ROUND(B2*B3/365*B4,2), keeping the per diem unrounded.
Mortgage interest is paid in arrears: the instalment due on the 1st pays the previous month’s interest, so on the 1st the loan is paid through the last day of the previous month and interest starts again on the new balance. Count the days from that date to the payoff date. Read the note for the day basis: a 360-day year adds about 1.4 per cent to the per diem.
Keep the per diem unrounded for the multiplication and round only the total, or say on the payoff statement that you did not. Rounding first to $24.37 gives $414.29 here, a cent the borrower will notice.
Go further with the worked example, step by step and the companion files for The Mortgage Note Investor.
Multiply the unpaid balance by the annual rate and divide by 365, or by 360 if the note uses a 360-day year. $122,692.38 at 7.25 per cent is $24.3704 a day.
Add the unpaid principal balance, per diem interest from the paid-through date to the payoff date, and the fees the note and local law allow. In the default case: $122,692.38 + $414.30 + $55.00 = $123,161.68.
Yes. Dividing by 360 instead of 365 raises the daily interest by 365/360, about 1.4 per cent: $24.71 a day instead of $24.37 on the default balance.
This calculator comes from The Mortgage Note Investor by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.
Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →