To solve for the (the compound interest rate), the formula is:
=RRI(6, 5000, 5500)
0.0161 → 1.61% per month
-0.116 → -11.6% per year Comparing RRI to Other Excel Functions | Function | Purpose | | :--- | :--- | | RRI | Find the compound interest rate from start and end values. | | FV | Find the future value given a fixed rate. | | PV | Find the present value given a fixed rate. | | RATE | More flexible version of RRI (handles periodic payments). | rentes rente formel excel
This gives you the average annual (or per-period) compound interest rate, essential for evaluating investments, savings, or loan costs in Danish finance. To solve for the (the compound interest rate),
In Danish finance, "rentes rente" (compound interest) is the principle where interest earned on an investment is reinvested, so you earn interest on your interest. The formal formula for calculating the average annual growth rate is known as the "rentes rente formel" . | | RATE | More flexible version of