Simo yekushandisa

Pamhepo IRR karukureta inogona kukurumidza kuverenga kukosha kweIRR kweseti yedata, mutsara mumwe we data rega rega, uye chigumisiro chekuverenga chinopindirana neExcel.

Chishandiso cheIRR chishandiso chakakosha uye chiratidzo chemari inowanikwa muindasitiri yezvemari. Muzviitiko zvakawanda, zvinofanirwa kuverenga iyo IRR yemukati mwero wekudzoka kwedata kuti uongorore mwero wekudyara wekudzoka uye chiyero chechokwadi chegore negore chekukwereta.

Kuverengera kwechishandiso ichi kunoenderana nekuverenga mhedzisiro yeIRR formula muExcel, inogona kuverenga kukosha kweIRR yedata rakapihwa zviri nyore.

Mashandisiro e

Pinda data ichaverengwa, data imwe pamutsara, tinya bhatani kuti utange kuverenga, iyo data inofanira kunge iine imwe yakanaka kukosha uye imwe yakaipa kukosha. .

Unogona kudzvanya bhatani remuenzaniso kuti uone data remuenzaniso kuti uwane nekukurumidza kushanda kwechishandiso ichi.

Nezve IRR

Partial rate of return, zita rechirungu: Internal Rate of Return, yakapfupikiswa IRR. Zvinoreva chiyero chekudzoka icho chirongwa chekudyara chinogona kunyatso zadzisa. Ndiwo chiyero chekudzikisira kana huwandu hwazvino hwemari inowanikwa yakaenzana nehuwandu hwazvino hwehuwandu hwemari inoyerera, uye mambure azvino kukosha kwakaenzana ne zero. Kana ukasashandisa komputa, muyero wemukati wekudzoka uchaverengerwa uchishandisa mareti akati wandei kusvika wawana mutero wemutengo une mambure eukoshi hwakaenzana kana pedyo ne zero. Muyero wemukati wekudzoka ndiwo mwero wekudzoka uyo mari inoshuvira kuwana, uye chiyero chekuderedzwa chinogona kuita kuti mambure anowanikwa kukosha kweprojekti yekudyara yakaenzana ne zero.