This spreadsheet is used to create an amortization schedule for loans with fixed payments. It provides a detailed breakdown of each payment, including how much goes toward interest and principal, and tracks the remaining balance over time.
Loan Details: Enter loan amount, annual interest rate, loan term, and payment frequency.
摊销计划: A detailed table showing each payment date, payment amount, principal portion, interest portion, and remaining balance.
概括: Provides an overview of total interest paid, total payments, and loan payoff details.