Umlinganiselo wangaphakathi wenzuzo (IRR): Inkcazo kunye nomzekelo

Umyinge waNgaphakathi wokuBuyisa (IRR) sisixhobo esisisiseko kwihlabathi lezemali, esisetyenziselwa ukuvavanya ukusebenza kunye nenzuzo yeeprojekthi zotyalo-mali. Yimetric eyimfuneko kubatyali-mali, iinkampani kunye neengcali ngezemali, njengoko ibonelela ngengqiqo ebalulekileyo kwinzuzo yeprojekthi ekuhambeni kwexesha. Kweli nqaku, siza kuphonononga ngokweenkcukacha ukuba yintoni na i-IRR, yintoni na, injani na ifomyula yayo yokubala kunye nendlela esinokuyibala ngayo ngokulula usebenzisa iMicrosoft Excel/Spreadsheets.

Yintoni umlinganiselo wangaphakathi wenzuzo (IRR)?

Umlinganiselo wangaphakathi wenzuzo (IRR) yimetric esetyenziswa kuhlalutyo lwemali ukuqikelela inzuzo yotyalo-mali olunokwenzeka. I-IRR lixabiso lesaphulelo elenza ixabiso langoku elishiyekileyo (NPV) layo yonke imiqukuqelo yemali ilingane no-zero kucazululo lokuhamba kwemali oluthotyiweyo. Ubalo lwe-IRR lusekelwe kwifomula efanayo neNPV. Kufuneka kuthathelwe ingqalelo ukuba i-IRR ayilona ixabiso ledola leprojekthi. Yinzuzo yonyaka eyenza iNPV ilingane no-zero. Ngokubanzi, okukhona isantya sangaphakathi sembuyekezo siphezulu, kokukhona kunqweneleka ukwenza utyalo-mali. I-IRR iyafana kutyalo-mali lweentlobo ezahlukeneyo kwaye, ngenxa yoko, inokusetyenziselwa ukuhlela utyalo-mali olunokubakho oluninzi okanye iiprojekthi ngendlela efanayo. Ngokubanzi, xa kuthelekiswa ukhetho lotyalo-mali nezinye iimpawu ezifanayo, utyalo-mali olune-IRR ephezulu lunokubonwa njengolona lungcono.

igrafu yebha

Uphuhliso lwe-IRR yenkampani. Umthombo: Corporate Finance Institute.

Yenzelwe ntoni i-IRR?

Eyona njongo iphambili ye-IRR kukuchonga isantya sesaphulelo esenza ixabiso langoku lesambuku semali engenayo yonyaka ilingane nesambuku sokuqala sotyalo-mali. Iindlela ezahlukeneyo zinokusetyenziswa xa kufunwa ukuchonga inzuzo elindelekileyo, kodwa i-IRR isoloko ilungele ukuhlalutya ingeniso enokubakho yeprojekthi entsha ecingwa ukwenziwa yinkampani. Kufuneka kuqatshelwe ukuba i-IRR lizinga lokukhula ekulindeleke ukuba utyalo-mali luvelise ngonyaka. Ke ngoko, inokufana kakhulu nenqanaba lokukhula lonyaka elihlanganisiweyo (CAGR). Enyanisweni, utyalo-mali aludli ngokuba nomlinganiselo ofanayo wembuyekezo ngonyaka. Ngokubanzi, elona zinga lembuyekezo oluthi utyalo-mali olunikiweyo lugqibele ngokuvelisa luya kwahluka kuqikelelo lwe-IRR.

Indlela yokubala i-IRR

Sineendlela ezahlukeneyo zokubala i-IRR, ukusuka:

  • Ukusebenzisa ifomyula, sibeka i-NPV ukuba ilingane no-zero kwaye iya kusonjululwa kwireyithi yesaphulelo, eyi-IRR.
  • Utyalo-mali lokuqala luhlala lungalunganga kuba lubonisa ukuphuma.
  • Ukuqukuqela kwemali nganye okulandelayo kunokuba kuhle okanye kubi, kuxhomekeke kuqikelelo lwento eza kubonelelwa yiprojekthi okanye ifune njengenaliti enkulu kwixesha elizayo.
  • Ngenxa yobume befomula, i-IRR ayinakubalwa ngokulula ngokuhlalutya kwaye endaweni yoko kufuneka ibalwe ngokuphindaphindiweyo ngokusebenzisa uvavanyo kunye nephutha okanye ukusebenzisa isoftware ecwangcisiweyo ukubala i-IRR (umzekelo, usebenzisa i-Excel).
ifomula

Ifomula yokubala ye-IRR. Umthombo: Sage.

Bala i-IRR kwi-Excel

Konke okufuneka ukwenze kukudibanisa ukuhamba kwemali, kubandakanywa nokuphuma kokuqala kunye nokungena okulandelayo, kunye nomsebenzi we-IRR. Umsebenzi we-IRR ufunyanwa ngokunqakraza i Faka iiFomula (fx) icon. Apha ngezantsi unomzekelo olula wohlalutyo lwe-IRR kunye nokuhamba kwemali okwaziwayo kunye namaxesha athile ngonyaka (unyaka omnye ngaphandle). Masithi inkampani ivavanya inzuzo yeProjekthi Kule meko, i-IRR yi-250.000%, ephezulu kakhulu.

ibhodi

Umzekelo wokubala i-IRR yotyalo-mali.


Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.