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.