Model a loan repayment plan in Excel by entering the financing terms and reviewing how each scheduled payment is divided between principal and interest.
The workbook is built for practical debt analysis: enter the loan amount, annual interest rate, first payment date, payment frequency, loan term, and an optional balloon payment. It then presents summary outputs, a dated amortization schedule, and a dashboard view of payment and outstanding-balance trends.
See the payment breakdown
Review principal payable, interest payable, and the total installment for each scheduled payment date.
Track the remaining balance
Follow the loan outstanding balance through the schedule instead of relying on a single payment estimate.
Structure repayment timing
Set monthly, quarterly, semi-annual, or annual payment frequency and include a balloon amount when the financing structure requires one.
What this template helps you analyze
A loan decision depends on more than the headline interest rate. This workbook connects the financing assumptions to the timing and composition of the repayments so you can see the cash commitment and balance reduction over the life of the schedule.
Scheduled debt service: view the payment amount and the total number of payments generated from the entered terms.
Principal versus interest: see how each installment is allocated between repayment of principal and interest expense.
Outstanding principal: follow the remaining loan balance after each dated payment.
Total financing cost: review total interest paid and total principal plus interest paid in the summary outputs.
Balloon repayment structure: enter a balloon payment and see it reflected as the final repayment line in the schedule.
What is inside the workbook?
The workbook separates assumptions from calculated results. The input area contains the financing terms, while the output area and amortization table show the resulting payment totals, payment dates, principal and interest components, and remaining balance. A dashboard summarizes key figures and charts the repayment path.
Editable financing assumptions
Input cells cover loan amount, annual interest rate, first payment date, payment frequency, loan term in months, and balloon payment.
Calculated loan outputs
The summary view shows the payment amount, total interest paid, total principal plus interest paid, and total number of payments.
Dated amortization schedule
Each row shows the due date, principal payable, interest payable, total installment payable, and loan outstanding balance.
The calculator view pairs editable loan assumptions with summary outputs and a payment-by-payment amortization table, including a separate balloon repayment line.
Build the schedule from the financing terms
The assumptions panel keeps the key debt inputs in one place. Once the terms are entered, the schedule lays out when payments fall due and how much of each installment reduces principal versus covers interest, making it easier to assess the repayment profile rather than only the initial payment amount.
The dashboard highlights the loan amount, interest rate, payment, and total paid, then charts principal payable, interest payable, and the outstanding loan balance across the schedule.
Review the repayment path visually
The dashboard condenses the schedule into headline figures and a time-series chart. This view helps finance teams and decision-makers see how the outstanding balance declines while the principal and interest components change across the repayment period.
How do you use the template?
Enter the core loan terms
Input the loan amount and annual interest rate used for the financing arrangement.
Set the repayment timing
Add the first payment date, choose the payment frequency, and enter the loan term in months.
Add a balloon amount if applicable
Use the balloon payment field when part of the principal is intended to remain for a final lump-sum repayment.
Review the outputs and schedule
Check the calculated payment totals, dated principal and interest lines, remaining balance, and dashboard chart before using the results in a financing review or cash-planning discussion.
Who is this template for?
This loan amortization workbook is suited to founders, analysts, lenders, investors, and finance teams that need a transparent repayment schedule for a debt assumption. It can support financing comparisons, debt-service planning, borrower or lender discussions, and broader models where the timing of principal and interest affects cash flow. It is especially useful when you want to inspect the full schedule rather than work from a single payment figure.
For adjacent financing work, use the Excel Loan Payment Template when you need another payment-focused tool, the Financial Debt Ratios Calculator to examine leverage and debt-related metrics, or the DCF Calculator when debt assumptions need to be considered alongside a broader valuation analysis.
Choosing a selection results in a full page refresh.
