Custom Loan Payment Schedule calculator

You can use this calculator to produce a loan payment schedule for a loan with any of these unique features: Delayed first payment; Interest-only payments; Compounding on payment date or daily; Fiscal year ends for subtotals; Balloon payment.

To open this calculator, click Calculators in the toolbar, and then click Other Loan > Custom Loan Payment Schedule in the left panel.

You can export the data as a PDF file or clear all data that you entered. For more information, see Financial calculators.

Example

A taxpayer has taken money from one business and deposited it into another. Payments were not started immediately, but now he wants to set up monthly payments. The lending business has a fiscal year and the borrowing company has a calendar year. To represent this as a proper loan, determine the amount of each payment, and then provide totals that match the accounting year of each business.

Field Input
Date of loan origination 10/07/2013
Loan amount $1,000,000
Payments per year or frequency Monthly
Date of first payment 02/02/2014
Length of loan in years 5.00
Payments Interest and Principal
Year end for subtotals June
Annual interest rate 8.00%
Compounded Payment Period
Length of year (for compounding) 365

The entries above will produce a loan payment schedule for the fiscal year business. For the calendar year business, change the Year End for Subtotals to December.


Contact us

Was this article helpful?