Free calculators

Per diem interest calculator

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.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Per diem interest24.3704
Accrued interest414.30
Payoff amount123,161.68

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

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.

How it works

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.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How do you calculate per diem interest on a loan?

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.

How do you calculate a payoff amount?

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.

Does a 360-day year cost more?

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.

The book behind this calculator

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.

Get the book on Amazon →

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 →

All free calculators → · Free Excel templates →