Wonke umuntu owayebambe iqhaza emisebenzini yezezimali noma ekutshalweni kwezemfundo, ebhekene nesibonakaliso esinjalo njengenani lamanje elisha noma I-NPV. Lesi sibonakaliso sibonisa ukusebenza kahle kokutshalwa kwemali kwephrojekthi efundisiwe. I-Excel ineamathuluzi akusiza ukubala le nani. Ake sithole ukuthi singayisebenzisa kanjani ngokusebenza.
Ukubalwa kwenani elikhona lenamanje
Isamba samanje samanje (I-NPV) ngesiNgisi kuthiwa yi-Net yamanje value, ngakho-ke ivame ukufushaniswa njengegama layo I-NPV. Kukhona elinye igama elihlukile - Inani lenamanje elikhona.
I-NPV inquma inani lamanani amanje okwehla okukhokhisiwe, okuyinto umehluko phakathi kokungena nokuphuma. Ngokwemibandela elula, le nkhomba ibonisa ukuthi umtshali-zimali uzimisele kangakanani ukuthola, ususe konke okuphumayo, ngemuva kokuthi umnikelo wokuqala ukhokhwe.
I-Excel inomsebenzi oklanyelwe ukubala I-NPV. Yingxenye yesigaba sezimali se-opharetha futhi ibizwa I-NPV. I-syntax yalo msebenzi ilandelayo:
= I-NPV (isilinganiso; inani1; inani2; ...)
Ukuphikisana "Bet" limelela inani eliqinisekisiwe lezinga lokunciphisa isikhathi esisodwa.
Ukuphikisana "Value" ikhombisa inani lokukhokha noma amarisidi. Esikhathini sokuqala, sinesignali engalungile, futhi okwesibili - enhle. Lolu hlobo lokuphikisana emsebenzini luvela kusuka 1 kuze kube 254. Bangakwazi ukwenza njengezinombolo, noma bangabhekisela kumaseli lapho lezi zinombolo ziqukethe, noma kunjalo, kanye nokuphikisana "Bet".
Inkinga yukuthi umsebenzi, nakuba ubizwa ngokuthi I-NPVkodwa ukubala I-NPV akasebenzisi kahle ngokuphelele. Lokhu kungenxa yokuthi ayikucabangi ukutshalwa kwezimali okuqala, okuyinto ngokusho kwemithetho akubhekiseli kulokho okwamanje, kodwa esikhathini esiyi-zero. Ngakho-ke, ku-Excel, ifomula yokubala I-NPV kungaba ngcono ukubhala lokhu:
= Initial_investment + NPV (isilinganiso; value1; value2; ...)
Ngokwemvelo, ukutshalwa kwezimali okuqala, njengaloluhlobo lokutshalwa kwezimali, kuzosayinwa "-".
Isibonelo sokubala se-NPV
Ake sicabangele ukusebenzisa lo msebenzi ukucacisa inani I-NPV ngesibonelo esithile.
- Khetha iseli lapho umphumela wokubala uzoboniswa khona. I-NPV. Chofoza kusithonjana "Faka umsebenzi"kufakwe eduze kwe-bar bar.
- Ifasitela iqala. Amakhosi omsebenzi. Iya kusigaba "Izezimali" noma "Uhlu oluphelele lwe-alfabhethi". Khetha irekhodi kuwo "CHPS" bese uchofoza inkinobho "Kulungile".
- Emva kwalokho, iwindi lezingxabano zalolu opharetha luzovuleka. Inombhalo wezinsimu ezilingana nenombolo yezimpikiswano zomsebenzi. Inkambu edingekayo "Bet" futhi okungenani eyodwa yamasimu "Value".
Ensimini "Bet" kufanele ucacise isilinganiso samanje sesaphulelo. Inani lalo likwazi ukuqhutshwa ngesandla, kepha kithi ukulinganisa kwalo kufakwe esitokeni kushidi, ngakho-ke sibonisa ikheli lale seli.
Ensimini "Inani1" udinga ukucacisa izixhumanisi zohlu oluqukethe ukugeleza kwemali okuzayo kanye nolindelekile, ngaphandle kokukhokha kokuqala. Lokhu kungenziwa futhi ngesandla, kodwa kulula kakhulu ukubeka isikhombisi ensimini ehambelana nayo, futhi inkinobho yegundane lesokunxele igcinwe phansi, khetha ibanga elihambelanayo eshadini.
Njengoba, kithi, ukugeleza kwemali kufakwe eshidi endaweni eqinile, akudingeki ukuthi ufake idatha kwezinye izinkambu. Vele uchofoze inkinobho "Kulungile".
- Ukubalwa komsebenzi kuboniswa esitokisini esiyikhethile esigabeni sokuqala semfundo. Kodwa, njengoba sikhumbula, ukutshalwa kwezimali kwangempela akuzange kubalwe. Ukuqedela ukubala I-NPVkhetha iseli equkethe umsebenzi I-NPV. Inani laso livela kubha yefomula.
- Ngemuva komlingiswa "=" faka inani lokukhokha kokuqala ngesibonakaliso "-"futhi ngemva kwalo sibeka uphawu "+"okumele kube phambi komqhubi I-NPV.
Ungaphinda ufake inombolo ngekheli leseli eshadini eliqukethe ukukhokha kokuqala.
- Ukuze wenze isibalo futhi ubonise umphumela esitokisini, chofoza inkinobho Ngena.
Umphumela ususelwe futhi kithi okwamanje inani le-net elilinganayo lilingana nama-ruble angu-41160,77. Yilezi zimali umtshali-zimali, emva kokunciphisa zonke izimali, futhi ekhumbula izinga lesaphulelo, angalindela ukuthola ngenzuzo. Manje, umazi le nkomba, anganquma ukuthi uzotshala imali kule phrojekthi noma cha.
Isifundo: Imisebenzi Yezezimali ku-Excel
Njengoba ungabona, phambi kwayo yonke idatha engenayo, yenza ukubala I-NPV ukusebenzisa amathuluzi we-Excel kuhle kakhulu. Okuwukuphela kokuphazamiseka ukuthi umsebenzi odizayinelwe ukuxazulula le nkinga ayicabangi ukukhokha kokuqala. Kodwa le nkinga nayo ilula ukuxazulula, ngokumane ubeke inani elilinganayo ekubalweni kokugcina.
