Description:

This spreadsheet is designed to help users understand the impact of different interest rates on their loans. It includes sections for setting up loan details, tracking loan information, and analyzing the effect of various interest rates on loan repayments.

• Setup:
  • Allows users to define the frequency of payments (e.g., annual, monthly) and the number of periods per year.
• Loan Log:
  • A detailed log of loan information, including Loan ID, Borrower Name, Loan Date, Loan Amount, Interest Rate, Years to Pay, Frequency of payments, Number of periods, and Number of payments made.