Excel: Rentes Rente Formel

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)

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? rentes rente formel excel

=RRI(6, 5000, 5500)

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 = (End Value / Start Value)^(1/Periods) -

| 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? =RRI(6, 5000, 5500) In Danish finance, "rentes rente"

=RRI(5, 10000, 15000)