Excel: Rentes Rente Formel

=RRI(4, 200000, 120000)

=RRI(Nper, Pv, Fv)

=RRI(5, 10000, 15000)

| Argument | Explanation | | :--- | :--- | | | Number of periods (years, months, quarters, etc.) | | Pv | Present Value (start value) | | Fv | Future Value (end value) | Note: RRI always returns the rate per period . If Nper is in years, the result is the annual compound interest rate. Practical Examples Example 1: Annual Compound Interest You invest 10,000 DKK in a fund. After 5 years , it is worth 15,000 DKK . What was the average annual compound growth rate? rentes rente formel excel

In Excel, you don't need to memorize the complex mathematical equation. Microsoft provides a dedicated function: . The Mathematical Formula For reference, the classic compound interest formula is: =RRI(4, 200000, 120000) =RRI(Nper, Pv, Fv) =RRI(5, 10000,