نموذج Excel: جدول استهلاك الرهن العقاري

 وصف:

This spreadsheet is designed to help homeowners track and manage their mortgage payments over the life of the loan. It includes sections for loan details, a detailed payment schedule, and a summary of the loan’s progress.

• Loan Details: Enter key information about the loan, such as loan amount, interest rate, loan term, start date, and monthly payment amount.
• جدول الاستهلاك: A comprehensive table that breaks down each payment into principal and interest components and tracks the remaining loan balance over time.
• ملخص: Provides an overview of total payments, total interest paid, and remaining balance.