Kowane mutumin da yake da hannu cikin ayyukan kudi ko zuba jarurruka na sana'a, yana fuskantar irin wannan alamar ta zama darajar tamanin NPV. Wannan alamar yana nuna yadda ya dace da aikin binciken. Excel yana da kayan aikin da zai taimake ka ka kirga wannan darajar. Bari mu gano yadda za mu yi amfani da su a cikin aiki.
Ƙididdigar darajar da aka samu yanzu
Matsayin da aka samar a yanzu (NPV) a cikin harshen Ingilishi an kira Nemi darajar Net, sabili da haka an ƙuntata shi kamar sunansa NPV. Akwai wani sunan madadin - Matsayi mai nuni na yanzu.
NPV Ya ƙayyade kwatankwacin dabi'u na yau da kullum na kudaden kuɗi, wanda shine bambanci a tsakanin inflows da outflows. A cikin sauƙi, wannan alamar ya ƙayyade yawan mai zuba jari da shirin ya karbi, ya rage duk fitarwa, bayan an biya bashin farko.
Excel yana da aikin da aka tsara musamman don ƙididdigewa NPV. Yana da nau'i na nau'i na masu aiki kuma an kira shi NPV. Haɗin aikin don wannan aiki shine kamar haka:
= NPV (Rate; value1; value2; ...)
Magana "Bet" wakiltar darajar kuɗin kuɗin kuɗin na tsawon lokaci.
Magana "Darajar" ya nuna adadin biyan kuɗi ko karɓa. A cikin akwati na farko, yana da alamar kuskure, kuma a na biyu - mai tabbatacce. Irin wannan hujja a cikin aiki na iya zama daga 1 har zuwa 254. Za su iya aiki a matsayin lambobi, ko kuma zasu iya zama nassoshi ga kwayoyin da waɗannan lambobi ke ƙunshe, duk da haka, da kuma gardama "Bet".
Matsalar ita ce aikin, ko da yake ana kira NPVamma lissafi NPV ba ta ciyarwa ba daidai ba. Wannan shi ne saboda gaskiyar cewa ba la'akari da ƙaddamarwa na farko, wanda bisa ga ka'idodin yana nufin ba ga halin yanzu ba, amma ga lokacin baƙi. Sabili da haka, a cikin Excel, ƙira don ƙidayawa NPV zai fi kyau rubuta wannan:
= Initial_investment + NPV (kudi; value1; value2; ...)
A dabi'a, ƙaddamarwa ta farko, kamar kowane irin zuba jari, za a sanya hannu "-".
NPV misali misali
Bari muyi la'akari da yin amfani da wannan aikin don sanin ƙimar NPV a kan wani misali.
- Zaɓi tantanin halitta wanda za'a nuna sakamakon lissafi. NPV. Danna kan gunkin "Saka aiki"sanya a kusa da wannan tsari bar.
- Wurin ya fara. Ma'aikata masu aiki. Je zuwa category "Financial" ko "Jerin jerin jerin sunayen". Zaɓi rikodin a ciki "CHPS" kuma danna maballin "Ok".
- Bayan haka, taga na muhawarar wannan afaretan zai buɗe. Ya na da yawan filayen daidai da yawan aikin muhawara. Wurin da ake nema "Bet" kuma akalla ɗaya daga cikin filayen "Darajar".
A cikin filin "Bet" Dole ne ku ƙayyade yawan rangwame na yanzu. Ana iya fitar da darajarsa ta hannun hannu, amma a cikin yanayinmu an saka darajarta a cikin tantanin halitta a kan takardar, saboda haka muna nuna adireshin wannan cell.
A cikin filin "Value1" kana buƙatar ƙayyade ƙayyadaddun kewayon da ke dauke da ainihin kudaden tsabar kuɗin da ake tsammani, ba tare da biyan bashin ba. Hakanan za'a iya yin haka tare da hannu, amma yana da sauƙin saka matsayin siginan kwamfuta a filin daidai kuma, tare da maɓallin linzamin kwamfuta na hagu da aka ajiye a ƙasa, zaɓi hanyar da aka dace akan takardar.
Tun da, a cikin yanayinmu, ana saka kudade a kan takarda a cikin tsararru, bazai buƙatar shigar da bayanai a wasu wurare ba. Kawai danna kan maballin "Ok".
- Ana lissafin lissafin aikin a cikin tantanin halitta da muka zaba a sakin farko na umarnin. Amma, kamar yadda muke tunawa, asusun na asali bai kasance ba. Don kammala lissafi NPVzaɓi tantanin halitta dauke da aikin NPV. Ƙimarta tana bayyana a cikin tsari.
- Bayan halin "=" Ƙara yawan adadin farko tare da alamar "-"kuma bayan shi mun sanya alama "+"wanda dole ne a gaban mai aiki NPV.
Hakanan zaka iya maye gurbin lambar tare da adreshin tantanin salula akan takardar da ke dauke da biyan kuɗi.
- Domin yin lissafi kuma nuna sakamakon a cikin tantanin halitta, danna kan maballin Shigar.
An samo sakamakon kuma a cikin yanayinmu farashin tamanin daidai yake da 41160,77 rubles. Wannan lamari ne cewa mai saka jari, bayan da ya rabu da duk zuba jari, da kuma la'akari da rangwame, zai iya sa ran samun karbar riba. Yanzu, sanin wannan alamar, zai iya yanke shawara ko ya zuba kudi a cikin aikin ko a'a.
Darasi: Ayyukan Gida a Excel
Kamar yadda kake gani, a gaban dukkanin bayanai mai shigowa, yi lissafi NPV Yin amfani da kayan aikin Excel yana da sauki. Abincin kawai shi ne aikin da aka tsara don magance wannan matsala ba ya la'akari da biyan bashin. Amma wannan matsala ma sauƙin warwarewa, ta hanyar canza matakan da ya dace a lissafin ƙarshe.
