# Durchschnittliche Wachstumsrate berechnen In 5 Jahren, ja. So wichtig und sinnvoll diese Statistiken auch sind, ihre Berechnung ist nicht schwierig.

## CAGR Rechner - Wachstumsrechner Zerfall und wie rechnet man damit? Diese Frage wurde automatisch geschlossen, da der Fragesteller kein Interesse mehr an der Frage gezeigt hat. Hallo ich hätte eine Frage zu folgender Aufgabe: Für alle, die mir helfen möchten automatisch von OnlineMathe generiert: Hierzu passend bei OnlineMathe: Du könntest zu Beginn mit fiktiven Personen beginnen.

Dann vergleichst du den Endwert mit den anfänglichen Um was zu erhalten? Use the following formula: Enter data in the spreadsheet.

Create rows and columns in the spreadsheet to display the year and the investment's value that year. Once you have the data entered, create a row where you will enter the formula for the CAGR. Once you enter the formula, Excel will perform the calculations for you. Then you would enter the years , and in cells C1, D1 and E1. In cell C3, under the information for , you would enter the number 1.

Then enter the number 2 in cell D3 and the number 3 in cell E3. Enter the basic formula to calculate the CAGR. Cell E3 is the number of years in the time period, 3. The calculated CAGR for the time period is It will result in the same answer, but some Excel users prefer to use functions instead of entering manual formulas. The POWER function returns the result of the ending value divided by the beginning value, raised to the power of 1 divided by the number of years. The answer is the same, The RATE function returns the interest rate over the time period in question.

This function looks a bit complicated. But once you understand the elements, then you can quickly create this function on the spreadsheet. Some people like this method because it expresses the result as a percentage instead of as a decimal. The next element of the function is pmt. Just leave that space blank. The next element is the pv, which stands for present value. But it refers to the beginning value of the investment, which is in cell B2. The last element is fv, which is the future value.

This refers to the ending value of the investment, which is in cell E2. You need to enter the beginning value, cell B2, as a negative number. Otherwise you will get a NUM! Using this formula, you will get the same answer, Compare different types of investments with each other. Suppose you have money in a savings account with a fixed annual interest rate and you also stock in a portfolio with a varying return.

Use the CAGR to compare the growth rate of the portfolio investment over time with the growth rate of the savings account. This can help you to decide which investment is has the higher rate of return over time. Compare the CAGR of the portfolio to the savings account. Even though the market was so volatile, a CAGR of 2. Compare the performance of multiple business measures within a company.

But suppose in the same time period, their customer satisfaction CAGR was This discrepancy highlights areas in which the company could improve. Understand that growth of an investment is never steady. The CAGR artificially smooths the rate of growth of an investment.

Forum Get forum support. User Testimonials Customers say. And we can easily apply this formula as following: Create a new table with the start value and end value as the following first screen shot shown: You can do as follows: Combine and Consolidate Multiple Sheets and Workbooks. You are guest Sign Up? The comment will be refreshed after To post as a guest, your comment is unpublished. Hi - I'm trying to work backwards to find the highest price I can buy a share at when I have a total expected return.

Are you able to please help me by reverse engineering the formula to work this out. Using your example - I'm trying to work out what the "3" should be 2. Hi, I have 7 fiscal years of foot traffic data for a retail store: Is the growth slowing? The part I don't understand is that, what about the values in the middle?

How does only taking the end and beginning value determine the growth rate accurately? Is there another method where it takes all the fiscal year values into account? Can someone help with this problem using excel?