writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 13:
Line 13: − + − +
→Examples
==Examples==
==Examples==
1. =CAGR(1000,10000,3,0) = 1.1544 <br/>
1. =CAGR(1000,10000,3,0) = 1.1544346900318838 <br/>
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 %.
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.3797 <br/>
2. =CAGR(1000,5000,10,5) = 0.3797296614612149 <br/>
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 %.
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 %.