Excel მოდელი: რთული პროცენტის კალკულატორი

 აღწერა:

This spreadsheet is designed to calculate compound interest for a given principal amount over a specified period. It includes sections for inputting the principal amount, interest rate, compounding frequency, years of growth, additional deposits, and payment frequency. It calculates the future value, total payments, and total interest.

• Inputs:
  • Principal Amount (P): The initial amount of money.
  • Annual Interest Rate (r): The yearly interest rate.
  • Compound Frequency (n): How often the interest is compounded per year.
  • Years of Growth (t): The number of years the money is invested or borrowed.
  • Additional Deposit (A): Extra amounts added periodically.
  • Deposit Frequency (p): How often the additional deposits are made.
    
    
• Results:
  • Rate Per Payment Period: The interest rate per compounding period.
  • Total Payments: The sum of all additional deposits.
  • Total Payments + Principal: The sum of the initial principal and total payments.
  • Total Interest: The amount of interest earned or paid.
  • Future Value (F): The value of the investment or loan at the end of the period.