Nrog tsab xov xwm no, koj tuaj yeem kawm paub yuav xam CAGR, Qhov Sib Sau Txhua Xyoo Kev Loj Hlob, hauv Excel. Kev Sib Koom Txhua Xyoo Kev Loj Hlob yog qhov kev loj hlob ntawm ib xyoos dhau ib xyoo ntawm kev nqis peev nyob rau lub sijhawm tshwj xeeb. Nws tau suav los ntawm kev siv lub hauv paus nth ntawm tag nrho feem pua kev loj hlob, qhov twg n yog tus lej xyoo nyob rau lub sijhawm raug txiav txim siab. Cov mis rau CAGR yog [(Xaus Tus Nqi/Pib Tus Nqi)^(1/(# xyoo))]-1.
CAGR tsis yog qhov rov qab los tiag tiag. Nws yog tus lej xav tau uas piav qhia tus nqi uas kev nqis peev yuav tau loj hlob yog tias nws loj hlob ntawm qhov tsis tu ncua. Koj tuaj yeem xav txog CAGR raws li txoj hauv kev kom ua tiav qhov rov qab los.
Cov kauj ruam
Kauj Ruam 1. Qhib Microsoft Excel
Xwb nyem rau ntawm lub cim ntsuab X ntawm qhov khoom lossis qhib nws los ntawm daim ntawv thov nplaub tshev hauv Microsoft Office.
Kauj Ruam 2. Qhib Phau Ntawv Tshiab
Kauj Ruam 3. Nkag Mus Rau Lub Hauv Paus/Cov Piv Txwv:
- Nkag mus rau cell A1 daim ntawv lo, CAGR
- Nkag mus rau cell B1 daim ntawv lo, Xaus_Value
- Nkag mus rau cell C1 daim ntawv lo, Pib_Value
- Nkag mus rau cell D1 daim ntawv lo, _1_OverYears
- Nkag mus rau cell E1 daim ntawv lo, Xyoo
- Nkag mus rau cell F1 daim ntawv lo, _1
Kauj Ruam 4. Tshaj tawm kab ntawv B: F thiab xaiv Insert los ntawm cov ntawv qhia zaub mov saum toj kawg nkaus
Nyem Cov Npe> Tsim thiab xaiv Kab Sab saum toj
Kauj Ruam 5. Sau cov qauv thiab cov txiaj ntsig:
- Nkag mus rau cell A2 ib = thiab tom qab ntawd cov mis ((Xaus_Value/Pib_Value)^(_ 1_OverYears)) -_ 1
- Nkag mus rau cell B2 Tus Xaus Tus Nqi ntawm kev nqis peev, piv txwv. 23, 512 ib
- Nkag mus rau cell C2 Pib Tus Nqi ntawm kev nqis peev, piv txwv. 14, 500
- Nkag mus rau cell E3 tus naj npawb ntawm Xyoo Kev nqis peev tau zoo txog rau qhov xaus tus nqi, piv txwv li 3
- Nkag mus rau cell D3 ib = thiab tom qab ntawd cov mis, 1/Xyoo.
- Nkag mus rau cell F3 tus nqi, 1
Kauj Ruam 6. Format koj cov cell:
- Highlight kab A: F thiab xaiv Hom los ntawm cov ntawv qhia zaub mov saum toj kawg nkaus. Nyem Kab ntawv thiab tom qab ntawd xaiv qhov haum rau tus kheej, thiab Chaw Kho Kom Zoo.
- Qhib kab ntawv A thiab xaiv Hom Ntawv, tom qab ntawv Cells. Hauv qab Tus lej ntawv qhia zaub mov, thiab Feem pua, xaiv 2 qhov chaw sib luag.
- Tshaj tawm kab ntawv B: C thiab xaiv Hom Ntawv, tom qab ntawv Cells. Hauv qab Tus Naj Npawb Tus Kheej, sau $#, ## 0
- Nyeem kab ntawv D thiab xaiv Hom Ntawv, tom qab ntawv Cells. Hauv qab Tus lej ntawv qhia zaub mov hauv Number Number, nkag mus.0000
Kauj Ruam 7. Txheeb xyuas tus nqi hauv cell A2
Rau cov piv txwv tus lej muab, koj yuav tsum pom CAGR qhov tshwm sim ntawm 24.93% Yog li, koj li CAGR rau koj li peb xyoos kev nqis peev yog sib npaug rau 24.93%, sawv cev rau kev ua haujlwm tau zoo txhua xyoo uas koj khwv tau los ntawm koj lub sijhawm nqis peev.
