نموذج Excel: جدول استهلاك الدفعة الثابتة

 وصف:

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.