=RRI(Nper, Pv, Fv)
Rate = (End Value / Start Value)^(1/Periods) - 1 Excel’s RRI function calculates the equivalent interest rate needed for an investment to grow from a present value to a future value over a specified number of periods. Syntax =RRI(Nper, Pv, Fv)
=RRI(4, 200000, 120000)
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:
0.0161 → 1.61% per month
=RRI(5, 10000, 15000)
To convert to annual rate: =(1+0.0161)^12 - 1 → Example 3: Negative Growth You buy a car for 200,000 DKK . After 4 years , its value is 120,000 DKK . What is the average annual compound depreciation? rentes rente formel excel
-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). |
=RRI(Nper, Pv, Fv)
Rate = (End Value / Start Value)^(1/Periods) - 1 Excel’s RRI function calculates the equivalent interest rate needed for an investment to grow from a present value to a future value over a specified number of periods. Syntax =RRI(Nper, Pv, Fv)
=RRI(4, 200000, 120000)
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:
0.0161 → 1.61% per month
=RRI(5, 10000, 15000)
To convert to annual rate: =(1+0.0161)^12 - 1 → Example 3: Negative Growth You buy a car for 200,000 DKK . After 4 years , its value is 120,000 DKK . What is the average annual compound depreciation?
-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). |