Munthu aliyense amene akuchita bizinesi yazachuma kapena kusamalira akatswiri, amakumana ndi chisonyezo monga mtengo wanthawi zonse kapena NPV. Chizindikirochi chikuwonetsa kugwirira ntchito bwino pantchito yomwe mwaphunzira. Excel ili ndi zida zokuthandizani kuwerengera mtengowu. Tiyeni tiwone momwe angagwiritsidwire ntchito pochita.
Kuwerengera phindu lazaposachedwa
Mtengo wapano (NPV) m'Chingerezi amatchedwa phindu la Net, chifukwa chake nthawi zambiri limafupikitsidwa kuti amalitchule NPV. Palinso dzina lina - Mtundu wa pakali pano wa Net.
NPV chimawerengera kuchuluka kwa mitengo yotsika yomwe idatsitsidwa kufikira lero, ndiwo kusiyana pakati pakubwera ndi kutuluka. M'mawu osavuta, chizindikirochi chimatsimikizira kuchuluka kwa ndalama zomwe bizinesi imafuna kulandira, kuchotsera zonse m'mene ndalama zoyambirira zingaperekedwe.
Excel ili ndi ntchito yomwe imapangidwa mwachindunji kuwerengera NPV. Ndi gawo la ndalama la ogwiritsira ntchito ndipo limatchedwa NPV. Syntax yantchitoyi ndi motere:
= NPV (mtengo; mtengo1; mtengo2; ...)
Kukangana Pikisano chikuyimira mtengo wokhazikitsidwa ndi kuchotsera kwa nthawi imodzi.
Kukangana "Mtengo" ikuwonetsa kuchuluka kwa zolipira kapena ma risiti. Poyamba, ili ndi chizindikiro chosalimbikitsa, ndipo chachiwiri - cholimbikitsa. Mtundu uwu wotsutsa mu ntchito ukhoza kukhala kuchokera 1 kale 254. Zitha kuwoneka, ngati ma manambala, kapena kuyimira maulalo omwe manambala amapezeka manambala, komabe, monga kutsutsana Pikisano.
Vuto ndilakuti ntchitoyo, ngakhale idayitanidwa NPVkoma kuwerengera NPV Samachita bwino. Izi ndichifukwa choti sizitenga nawo gawo poyambira, zomwe malinga ndi malamulowa sizikugwira ntchito pakalipano, koma nthawi ya zero. Chifukwa chake, mu Excel, njira yowerengera NPV Chingakhale chanzeru kwambiri kulemba izi:
= Initial_investment + NPV (bid; value1; value2; ...)
Mwachilengedwe, ndalama zoyambirira, ngati mtundu wina uliwonse wabizinesi, zidzakhala ndi chizindikiro "-".
Kuwerengera kwa NPV
Tiyeni tiwone momwe ntchitoyo ithandizire kudziwa phindu NPV pa chitsanzo cha konkriti.
- Sankhani khungu lomwe mawerengero akuwonetsedwa. NPV. Dinani pachizindikiro "Ikani ntchito"itayikidwa pafupi ndi baramu yodula
- Zenera limayamba Ogwira Ntchito. Pitani ku gulu "Zachuma" kapena "Mndandanda wathunthu wa zilembo". Sankhani chojambulachi "NPV" ndipo dinani batani "Zabwino".
- Pambuyo pake, zenera zotsutsa za wothandizira uyu zitsegulidwa. Ili ndi magawo angapo ofanana ndi kuchuluka kwa zotsutsana za ntchito. Izi ndizofunikira Pikisano ndi umodzi wa minda "Mtengo".
M'munda Pikisano Muyenera kufotokozera za kuchotsera komwe kulipo. Mtengo wake umatha kuyendetsedwa pamanja, koma kwa ife mtengo wake umayikidwa mu khungu papepala, ndiye tikuwonetsa adilesi ya foni iyi.
M'munda "Mtengo1" muyenera kufotokozera magwirizanidwe a magulu omwe ali ndi ndalama zomwe zikuyembekezeredwa mtsogolo komanso zoyerekeza zam'tsogolo, kupatula kulipira koyambirira. Izi zitha kuchitika pamanja, koma ndizosavuta kuyika pomwepo pomwe pali cholowera ndipo batani lakumanzere ndikanikizidwa kusankha mndandanda wolingana papepala.
Popeza kwa ife ndalama zotuluka zimayikidwa pa pepala lonse, simusowa kuyika zambiri m'minda yotsalira. Ingodinani batani "Zabwino".
- Kuwerengera kwa ntchitoyi kukuwonetsedwa mu khungu lomwe tidawunikira m'gawo loyambirira la malangizowo. Koma, monga momwe tikukumbukira, ndalama zathu zoyambilira sizidapezeke. Pofuna kumaliza kuwerengera NPV, sankhani khungu lomwe lili ndi ntchitoyo NPV. Mtengo umawonekera mu baramu yamu form.
- Pambuyo chizindikiro "=" onjezani kuchuluka kwa malipiro oyamba ndi chikwangwani "-", ndipo pambuyo pake tidayika chizindikiro "+"zomwe ziyenera kukhala patsogolo pa wothandizira NPV.
Mutha kuthandizanso m'malo mwa nambala yomwe mukuwonetsera adilesi ya foniyo pa pepalalo lomwe mulipira.
- Kuti muwerengere ndikuwonetsa zotsatira mu foni, dinani batani Lowani.
Zotsatira zake zimachotsedwa, ndipo kwa ife, mtengo womwe ulipo ndi ma ruble 41160.77. Ndizachuma kuti amene amafesa, atachotsa ndalama zonse, komanso kuti agwirizane ndi kuchotsera mtengo, akuyembekeza kulandiranso phindu. Tsopano, podziwa chizindikiro ichi, akhoza kusankha ngati akuyenera kuyikirapo polojekiti kapena ayi.
Phunziro: Ntchito Zachuma ku Excel
Monga mukuwonera, pamaso pa deta yonse yomwe ikubwera, werengani NPV kugwiritsa ntchito zida za Excel ndikosavuta. Zomwe zimangowopsa ndizakuti ntchito yopangidwira kuthana ndi vutoli silingalire malipiro oyamba. Koma vutoli silovuta kuthetsa mwa kungolemba phindu lolingana pakuwerengera komaliza.
