Financing
Enter your loan amount, APR, and term. Get a year-by-year breakdown of interest, principal, and remaining balance, plus a full month-by-month CSV export.
How it works
Step 1
Use your actual loan figures for the most useful schedule. The loan payment calculator can help you settle on these first if you're still comparing options, and the loan term comparison tool shows several terms side by side.
Step 2
The on-screen table shows how the interest and principal split shifts across every year of the loan, along with the remaining balance at each year's end.
Step 3
The CSV export includes every single month of the loan, useful for spreadsheet planning or comparing against your lender's official schedule.
Every payment on a standard fixed-rate loan is split into interest and principal, calculated fresh each month based on the remaining balance. This schedule lays out that split for every year of the loan, along with how much balance remains, so you can see exactly how the loan pays down over time rather than just knowing the monthly payment amount. The CFPB's explainer on how loan amortization works covers the same mechanics in plain language if you want the underlying math spelled out further.
Interest is always calculated on whatever balance remains, so it's highest when the balance is highest, meaning early in the loan. As the balance declines with each payment, the interest portion shrinks and the principal portion grows, which is why the final few years of a loan pay down the balance much faster than the first few years, even with an identical monthly payment throughout. The IRS instructions for Form 5695 set out which costs qualify and how to claim them.
If you're planning to make extra principal payments at some point, the month-by-month schedule shows exactly what your balance would be at that time under the original schedule, which is the starting point for calculating how much an extra payment actually saves. The early payoff savings calculator uses this same balance logic to estimate that savings directly.
Generating a schedule for a few different term lengths side by side shows not just the total interest difference, covered in the total interest paid calculator, but exactly how much faster the balance declines under a shorter term. That can be a useful factor if you're weighing how quickly you'd build full ownership versus keeping payments low. For a business installation, the MACRS depreciation schedule tool covers a related, separate schedule worth checking alongside this one.
Most solar loans are standard fixed-rate, fully amortizing loans, so this schedule should closely match your lender's official one. Small differences can arise from exact day-count conventions, a first payment date that isn't exactly one month after origination, or any fees rolled into the loan balance, so treat your lender's statement as the authoritative source. The total cost including financing fees calculator can help confirm whether a fee is part of your quote, and the total cost of ownership calculator covers related cost picture. If your loan includes a credit-related paydown, the IRS Form 5695 instructions confirm the current eligibility rules.
Questions
An amortization schedule breaks down every payment of a loan into how much goes toward interest versus principal, and shows the remaining balance after each payment. It's the same math lenders use to calculate your monthly payment and shows exactly how the loan pays down over its full term.
Interest is calculated on the remaining balance, so as the balance shrinks each month, the interest portion of the payment shrinks too, while the principal portion grows since the total payment stays fixed. Early in the loan, most of the payment is interest, and by the final years, most is principal.
Yes, the CSV export includes every single month of the loan, not just the year-end summaries shown on screen. Use the export bar after generating your schedule to download the complete file.
It should match closely if the loan is a standard fixed-rate, fully amortizing loan with monthly payments, which describes most solar loans. Minor differences can occur due to exact day-count conventions or a loan that isn't perfectly standard, so treat your lender's official schedule as the final word.
Related tools