Calculate the actual interest rate (APR) on a loan when you know the loan amount, payment amount, and term. This reverse calculator solves for the interest rate and generates detailed payment schedules and fiscal year-end summaries for accounting and tax purposes.

What you'll enter

• Loan proceeds amount ($)
• Regular payment amount ($)
• Interest compounding frequency (monthly, semi-annually, or annually)
• Payment frequency (monthly, semi-annually, or annually)
• Loan proceeds date
• First fiscal year-end date
• Loan term in months

What you'll get

• Calculated nominal annual interest rate (compounded as specified)
• Complete payment-by-payment amortization schedule showing date, payment amount, interest portion, principal portion, and remaining balance
• Fiscal year-end summary showing interest accrued/paid, principal repaid, and outstanding balance for each fiscal year
• Print-friendly format for client presentations and documentation
• CSV export of fiscal year summary for spreadsheet analysis
• Excel export with separate sheets for payment schedule and fiscal year summary

Notes

• This calculator uses a binary search algorithm to solve for the interest rate that produces the specified payment amount.
• The fiscal year summary automatically allocates interest across fiscal year boundaries based on the number of days in each period.
• If the payment amount is too low to amortize the loan over the specified term, the calculator will alert you to increase the payment.
• The calculator handles any combination of compounding and payment frequencies (e.g., monthly payments with semi-annual compounding).
• All calculations account for the exact number of days between payments when allocating interest to fiscal years.
• The fiscal year-end summary is particularly useful for preparing T5 slips, financial statements, and corporate tax returns.
• Results are formatted in Canadian currency (CAD) with two decimal places.

↓ Scroll down to the calculator to enter your numbers.