Kubara NPV muri Excel

Buri muntu ukora cyane mubikorwa byubukungu cyangwa ishoramari ryumwuga byahuye nigipimo nkicyo cyinjiza cyangwa NPV. Iki kimenyetso kigaragaza imikorere yishoramari yumushinga wiga. Gahunda ya Excel ifite ibikoresho bifasha kubara agaciro. Reka tumenye uburyo zishobora gukoreshwa mubikorwa.

Kubara inyongera ya net yagabanijwe

Ikimenyetso cyamafaranga yagabanijwe (CDD) mucyongereza yitwa Net Net Agaciro, muri rusange byemewe guhamagara guhamagara NPV. Haracyariho ubundi buryo - urushundura.

NPV isobanura umubare windangagaciro zo kugata zatanzwe kumunsi wubu, ni irihe tandukaniro riri hagati yirubyo no hejuru. Niba tuvuga mu rurimi rworoshye, iki kimenyetso kigena uburyo inyungu zo kwakira umushoramari ukuyemo isohoka nyuma yintererano yambere yishyurwa.

Gahunda ya Excel ifite imikorere igenewe kubara NPV. Yerekeza ku cyiciro cy'imari cy'abakora kandi yitwa CHPS. Syntax yiyi miterere ni izi zikurikira:

= Chps (igipimo; agaciro1; agaciro2; ...)

Impaka "Igipimo" ni umubare washyizweho mugihe kimwe.

Impaka "Agaciro" zerekana umubare wishyuwe cyangwa amafaranga yinjira. Kubwa mbere, ifite ikimenyetso kibi, kandi mubya kabiri nibyiza. Ubu bwoko bw'impaka muri imikorere burashobora kuva kuri 1 kugeza kuri 254. Barashobora gukora nko muburyo bwimibare, hanyuma bakemerwe nimibare iyi mibare irimo, ariko, nkimpaka ".

Ikibazo nuko imikorere ari, nubwo CPS yitwa, ariko kubara NPV ntabwo aribyo rwose. Ibi biterwa nuko itazirikana ishoramari ryambere, rikaba rikurikije amategeko ridakoreshwa nubu, ariko kugeza mugihe cya zeru. Kubwibyo, muri Excel, formulale yo kubara NPV yaba ikwiye kwandika ubu buryo:

= Intangiriro_Igice + chps (igipimo; agaciro1; agaciro2; ...)

Mubisanzwe, ishoramari ryambere, nkubwoko ubwo aribwo bwose bwishoramari, buzaba hamwe nikimenyetso "-".

Urugero rwo kubara NPV.

Reka dusuzume gukoresha iyi mikorere kugirango tumenye agaciro ka NPV kurugero runaka.

1. Hitamo Akagari aho ibisubizo byo kubara NPV bizerekanwa. Kanda kuri "Shyiramo imikorere" ishusho hafi ya formula.



2. Ikirangantego Wizard Idirishya ritangira. Jya mucyiciro "Amafaranga" cyangwa "Urutonde rwuzuye. Hitamo "chps" muri yo hanyuma ukande kuri buto "OK".



3. Nyuma yibyo, idirishya ryimpaka zuyu mukoresha rizafungurwa. Ifite umubare wimirima ingana numubare wimikorere. Yiyemeje kuzuza umurima "igipimo" kandi byibuze kimwe mumirima "agaciro".

   Mu murima "igipimo", ugomba kwerekana igipimo cyo kugabanywa ubu. Agaciro karyo karashobora kuyoborwa nintoki, ariko mugihe cyacu gishyizwe muri kasho kurupapuro, kugirango ugaragaze aderesi yiyi selile.

   Muri ikibuga cya "Agaciro1", ugomba kwerekana guhuza intera zirimo amafaranga nyayo kandi agereranijwe, ukuyemo ubwishyu bwambere. Ibi birashobora kandi gukorwa intoki, ariko biroroshye cyane kwishyiriraho indanga kumurima ukwiye kandi hamwe na buto yimbeba yibumoso kugirango ugaragaze urwego rukwiye kurupapuro.

   Kuva muri twe, amafaranga yashizwe ku rupapuro hamwe na array ikomeye, noneho ntukeneye gukora amakuru mubindi bice. Kanda buto ya "OK".



4. Kubara imikorere byagaragaye mu Kagari, ibyo twahaye ingingo yambere yamabwiriza. Ariko, nkuko twibuka, ishoramari ryambere ryagumye ridakozwe. Kugirango urangize kubara NPV, hitamo selile ikubiyemo imikorere ya CPS. Muri formula kumurongo, agaciro kayo kagaragara.



5. Nyuma yikimenyetso "=" Ongeraho umubare wubwishyu bwambere hamwe nikimenyetso "-", hanyuma nyuma yo gushyira imbere "+" igomba kuba imbere ya CPS ikoresha.

   

   Urashobora kandi, aho kuba umubare, vuga aderesi ya selire kurupapuro, irimo umusanzu wambere.



6. Kugirango ubare kubara kandi usohoke ibisubizo muri selire, kanda kuri buto yintonde.

Igisubizo gikomoka kandi muricyo cyinjiza yagabanijwe ni 41160.77. Aya mafaranga niho umushoramari nyuma yo gukuramo ibishoramari byose, kimwe no kuzirikana igipimo cyo kugabanyirizwa, birashobora kwitega kwakira muburyo bwinyungu. Noneho, kumenya iki kimenyetso, arashobora guhitamo niba bikwiye gushora mumushinga cyangwa utabimenye.

Isomo: Imikorere yimari muri Excel

Nkuko mubibona, niba hari amakuru yose yinjira, kora kubara NPV ukoresheje ibikoresho byoroshye biroroshye. Gusa ibintu bitari byo ni uko imikorere igamije gukemura iki gikorwa ntabwo yizirika ku bwishyu bwa mbere. Ariko iki kibazo biroroshye gukemura, gusa gusimbuza agaciro kajyanye no kubara kwa nyuma.