writer
2,661
edits
Changes
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 ..."
<div style="font-size:30px">'''CAGR(StartAmount,EndAmount,NumberOfYearsToEnd,NumberOfYearsToStart)'''</div><br/>
*<math>StartAmount</math> is the initial amount of investment
*<math>EndAmount</math> is the end amount of investment
*<math>NumberOfYearsToEnd</math> number of years of investment
*<math>NumberOfYearsToStart </math> 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.1544 <br/>
Over the course of 3 years/months your investment grew from 1000.0 to 10000.0. Its compound annual growth rate (CAGR) is 115.44 %.
2. =CAGR(1000,5000,10,5) = 0.3797 <br/>
Over the course of 10 years/months your investment grew from 1000.0 to 5000.0. Its compound annual growth rate (CAGR) calculated from 5th year is 37.97 %.
==Related Videos==
{{#ev:youtube|f0KUuHVscaI|280|center|XIRR}}
==See Also==
*[[Manuals/calci/IRR | IRR ]]
*[[Manuals/calci/XIRR |XIRR ]]
*[[Manuals/calci/MIRR | MIRR ]]
==References==
*[https://en.wikipedia.org/wiki/Compound_annual_growth_rate CAGR]
[[Z_API_Functions | List of Main Z Functions]]
[[ Z3 | Z3 home ]]
*<math>StartAmount</math> is the initial amount of investment
*<math>EndAmount</math> is the end amount of investment
*<math>NumberOfYearsToEnd</math> number of years of investment
*<math>NumberOfYearsToStart </math> 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.1544 <br/>
Over the course of 3 years/months your investment grew from 1000.0 to 10000.0. Its compound annual growth rate (CAGR) is 115.44 %.
2. =CAGR(1000,5000,10,5) = 0.3797 <br/>
Over the course of 10 years/months your investment grew from 1000.0 to 5000.0. Its compound annual growth rate (CAGR) calculated from 5th year is 37.97 %.
==Related Videos==
{{#ev:youtube|f0KUuHVscaI|280|center|XIRR}}
==See Also==
*[[Manuals/calci/IRR | IRR ]]
*[[Manuals/calci/XIRR |XIRR ]]
*[[Manuals/calci/MIRR | MIRR ]]
==References==
*[https://en.wikipedia.org/wiki/Compound_annual_growth_rate CAGR]
[[Z_API_Functions | List of Main Z Functions]]
[[ Z3 | Z3 home ]]