نموذج Excel: حاسبة تأثير سعر الفائدة المالية

 وصف:

This spreadsheet is designed to analyze the impact of varying interest rates on loans and investments. It includes sections for setting up the calculation parameters, recording loan details, and summarizing the impact of interest rate changes.

• يثبت: Initial configuration of the spreadsheet to define frequency and periods per year.
• سجل القروض: Detailed recording of each loan’s ID, borrower name, loan date, amount, interest rate, years to pay, frequency, number of periods, and number of payments made.
• Interest Rate Impact Summary: A summary view of how different interest rates affect total payments and overall loan costs.