Daily Loan Math — planning worksheet Simple interest loan calculator with payment schedule 1. Enter the principal and its balance date, then the contractual note rate. 2. Set the first monthly payment date, payment and optional extra. 3. Review any unpaid interest and export the dated schedule. Method: Use elapsed UTC calendar days between payment dates. Interest accrues on remaining principal at annual note rate divided by 365. Apply payments to accrued interest first, then principal. Carry unpaid interest separately without charging interest on it. Formula: New interest = principal × annual note rate ÷ 100 × elapsed days ÷ 365. Payment is capped at principal + accrued interest. Example: For $12,000 at a hypothetical 7.3%, daily interest starts at $2.40. Over 30 days it is $72. A $400 payment covers that interest and reduces principal by $328 to $11,672. Underpaying the interest leaves it separately visible. My inputs and source of each number: ________________________________________________ ________________________________________________ ________________________________________________ My result and questions to verify: ________________________________________________ ________________________________________________ Limitations: Your contract may use a different day-count convention, payment order or rounding. This tool excludes fees, insurance, penalties and interest capitalization. It is not a lender payoff quote. Recurring dates stay anchored to the first payment’s day, clamping to month end when necessary. Keep private records in a secure place. Do not send account numbers, addresses or identity documents to this site.