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
Call 800-968-0600
Was this article helpful?
Thank you for the feedback!