=RRI(Nper, Pv, Fv)
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
0.0845 → 8.45% per year Example 2: Monthly Growth (Convert to Annual) Your savings account grows from 5,000 DKK to 5,500 DKK over 6 months . What is the monthly compound interest rate? =RRI(Nper, Pv, Fv) 0
This gives you the average annual (or per-period) compound interest rate, essential for evaluating investments, savings, or loan costs in Danish finance. | | RATE | More flexible version of
=RRI(6, 5000, 5500)
=RRI(4, 200000, 120000)