Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

CAGR (複合年度成長率) 測量投資期間內,例如共同基金或債券等投資的報酬率,例如 5 或 10 年。 CAGR 也稱為「平滑」的報酬率,因為它會測量投資的成長,就好像它以每年複合基礎穩定地成長一樣。 若要計算 CAGR,請使用 XIRR 函數。

範例

XIRR 函數範例

附註: 當您比較不同投資的 CAGR 時,請確定每個利率都是在相同的投資期間內計算。

另請參閱

XIRR 函數

Need more help?

Want more options?

探索訂閱權益、瀏覽訓練課程、瞭解如何保護您的裝置等等。

社群可協助您詢問並回答問題、提供意見反應,以及聆聽來自具有豐富知識的專家意見。

Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×