Excel ((better)) - 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)

=RRI(6, 5000, 5500)

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