Difference between revisions of "Manuals/calci/CAGR"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''CAGR(StartAmount,EndAmount,NumberOfYearsToEnd,NumberOfYearsToStart)'''</div><br/> *<math>StartAmount</math> is the initial amount of investment ...") |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 8: | Line 8: | ||
==Description== | ==Description== | ||
| − | A compound annual growth rate (CAGR) measures the rate of return for an investment — such as a mutual fund or bond — over an investment period, such as 5 or 10 years. The CAGR is also called a "smoothed" rate of return because it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis. | + | *A compound annual growth rate (CAGR) measures the rate of return for an investment — such as a mutual fund or bond — over an investment period, such as 5 or 10 years. |
| − | + | *The CAGR is also called a "smoothed" rate of return because it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis. | |
==Examples== | ==Examples== | ||
| − | 1. =CAGR(1000,10000,3,0) = 1. | + | 1. =CAGR(1000,10000,3,0) = 1.1544346900318838 <br/> |
| − | Over the course of 3 years | + | Over the course of 3 years, your investment grew from 1000.0 to 10000.0. Its compound annual growth rate (CAGR) calculated from the start is 115.44 %. |
| − | 2. =CAGR(1000,5000,10,5) = 0. | + | 2. =CAGR(1000,5000,10,5) = 0.3797296614612149 <br/> |
| − | Over the course of 10 years | + | Over the course of 10 years, your investment grew from 1000.0 to 5000.0. Its compound annual growth rate (CAGR) calculated from 5th year is 37.97 %. |
==Related Videos== | ==Related Videos== | ||
| − | {{#ev:youtube| | + | {{#ev:youtube|ammvgrJAu-U|280|center|CAGR}} |
==See Also== | ==See Also== | ||
| Line 35: | Line 35: | ||
| − | |||
| − | [[ Z3 | Z3 home ]] | + | |
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 03:55, 18 November 2020
CAGR(StartAmount,EndAmount,NumberOfYearsToEnd,NumberOfYearsToStart)
- is the initial amount of investment
- is the end amount of investment
- number of years of investment
- is the number of years to start
is the initial amount of investment
is the end amount of investment
number of years of investment
is the number of years to start
Description
- A compound annual growth rate (CAGR) measures the rate of return for an investment — such as a mutual fund or bond — over an investment period, such as 5 or 10 years.
- The CAGR is also called a "smoothed" rate of return because it measures the growth of an investment as if it had grown at a steady rate on an annually compounded basis.
Examples
1. =CAGR(1000,10000,3,0) = 1.1544346900318838
Over the course of 3 years, your investment grew from 1000.0 to 10000.0. Its compound annual growth rate (CAGR) calculated from the start is 115.44 %.
2. =CAGR(1000,5000,10,5) = 0.3797296614612149
Over the course of 10 years, your investment grew from 1000.0 to 5000.0. Its compound annual growth rate (CAGR) calculated from 5th year is 37.97 %.
Related Videos
See Also
References