I-Excel inezintandokazi eziningi phakathi kwabathengisi, abacwaningi nabathengi, hhayi okungenani ngenxa yamathuluzi ayo amakhulu okwenza izibalo ezehlukene zezimali. Ngokuyinhloko imisebenzi yalokhu kugxile inikezwa eqenjini lemisebenzi yezimali. Eziningi zazo zingabasiza hhayi kuphela ochwepheshe, kodwa nakwabasebenzi ezimbonini ezihlobene, kanye nabasebenzisi abajwayelekile ezindabeni zabo zansuku zonke. Ake sihlolisise lezi zici zohlelo lokusebenza, futhi sikhathalele ngokukhethekile opharetha abadumile kakhulu kuleli qembu.
Ukwenza izibalo usebenzisa imisebenzi yezimali
Iqembu lalaba baqhubi liqukethe amafomu angaphezu kwama-50. Thina sihlala ngokweqile kulezi eziyishumi ezifunwa kakhulu. Kodwa okokuqala, ake sibheke indlela yokuvula uhlu lwezinsimbi zezimali ukuze siqhubeke nokuqaliswa komsebenzi othile.
Ukushintshela kule setethi yamathuluzi kulula ukufeza ngeMphathi Wezenzo.
- Khetha iseli lapho imiphumela yokubala izoboniswa khona, bese uchofoza inkinobho "Faka umsebenzi"itholakala eduze kwebha yefomula.
- Iqala umsebenzi wizard. Yenza ngokuchofoza kumkhakha "Izigaba".
- Uhlu lwamacembu opharetha olutholakalayo luvuleka. Khetha igama kulo "Izezimali".
- Uhlu lwamathuluzi esiwadingayo luqalisiwe. Khetha umsebenzi othize ukwenza lo msebenzi bese uchofoza inkinobho "Kulungile". Khona-ke iwindi lezingxabano zomsebenzisi okhethiwe livuleka.
Esikhathini somsebenzi wizard, ungaphinde ungene kuthebhu "Amafomula". Uma wenze ushintsho kulo, udinga ukuchofoza inkinobho ku-tape "Faka umsebenzi"efakwe ebhodini lamathuluzi "I-Function Library". Ngokushesha ngemva kwalokhu, idijithi yomsebenzi izoqala.
Kukhona indlela yokuya ku-opharetha olungileyo wezezimali ngaphandle kokuqala iwindi lewindi lewindi. Kulezi zinhloso kuthebhu elifanayo "Amafomula" kwiqembu lezilungiselelo "I-Function Library" kwi-tape chofoza inkinobho "Izezimali". Emva kwalokho uhlu lokudonsa phansi lwazo zonke amathuluzi atholakalayo ale block lizovuleka. Khetha into oyifunayo bese uchofoze kuso. Masinyane emva kwalokho, iwindi lezingxabano zakhe lizovula.
Isifundo: I-Excel Function Wizard
INCOME
Omunye wezinkampani ezifunwa kakhulu kubathengi umsebenzi INCOME. Ikuvumela ukuthi ubale isivuno samasheya ngosuku lokuvumelanisa, usuku lokuqala ukusebenza (ukuhlengwa), intengo ngayinye inani lokuhlengwa kwe-ruble, isilinganiso senzalo yonyaka, inani lokuhlengwa kwenani lemali yokuhlengwa kwe-ruble kanye nenani lokukhokha (imvamisa). Lezi ziminganiso yizimpikiswano zalolu fomula. Ngaphezu kwalokho, kunengxabano yokuzikhethela "Isisekelo". Yonke le datha ingangenwa ngokuqondile kusuka kwikhibhodi kuya emasimini afanele efasiteleni noma igcinwe emaqenjini e-Excel amashidi. Esikhathini esilandelayo, esikhundleni sezinombolo nezinsuku, udinga ukufaka izingqikithi kulawa maseli. Ungaphinda ufaka umsebenzi kubha yefomula noma endaweni eshicilelwe ngesandla ngaphandle kokubiza iwindi lempikiswano. Kulesi simo, kufanele uhambisane nale syntax elandelayo:
= INCWADI (Dat_sog; Dat_avt_v_silu; Rate, Price, Redemption "Frequency; [Isisekelo])
BS
Umsebenzi oyinhloko umsebenzi we-BS ukucacisa ukubaluleka kwesikhathi esizayo sokutshalwa kwezimali. Ingxabano yakhe yenzalo yenzalo yesikhathi ("Bet"), inani lezinkathi (Col_per) nokukhokha njalo kwenkathi ngayinye ("Plt"). Iziphakamiso zokuzikhethela zifaka inani lamanje ("Ps") nokubeka isikhathi sokukhokha ekuqaleni noma ekupheleni kwesikhathi ("Thayipha"). Isitatimende sinesi-syntax elandelayo:
= BS (Rate; Col_per; Plt; [Ps]; [Thayipha]
I-VSD
I-Operator I-VSD ibala izinga langaphakathi lokubuyisela ukugeleza kwemali. Ukuphikisana okudingekayo kuphela kwalolu msebenzi yizindleko zokugeleza kwemali, okuyi-sheet ye-Excel engamelwa ububanzi bemininingwane emafetheni ("Amanani"). Futhi esitokisini sokuqala kobubanzi kumele kuboniswe inani lokutshalwa kwezimali nge "-", nangaphezulu kwemali engenayo. Ngaphezu kwalokho, kunengxabano yokuzikhethela "I-Assumption". Ibonisa inani elilinganisiwe lokubuya. Uma kungacacisiwe, ngokuzenzakalelayo le nzuzo ithathwa njenge-10%. I-syntax yefomula ilandelayo:
= IRR (Imilinganiselo; [Izinsolo]
I-MVSD
I-Operator I-MVSD libala izinga langaphakathi lokubuyiselwa lokubuyiswa, linikezwe iphesenti yokubuyiswa kwemali. Kulo msebenzi, ngaphezu kwebanga lokugeleza kwemali ("Amanani") Izingxabano zilinganiselwe ngezimali kanye nesilinganiso se-reinvestment. Ngakho-ke, i-syntax ilandelayo:
= I-MVSD (Imilinganiselo; i-Rate_financer; i-Rate_investir)
PRPLT
I-Operator PRPLT libala inani lezinkokhelo zenzalo esikhathini esibekiwe. Iziphakamiso zomsebenzi yizinga lesithakazelo sesikhathi ("Bet"); inombolo yesikhathi ("Isikhathi"), inani elingenakudlula inani lezinkathi; inombolo yezinkathi (Col_per); Inani lamanje ("Ps"). Ngaphezu kwalokho, kukhona impikiswano yokuzikhethela - inani elizayo ("Bs"). Le fomula ingasetshenziswa kuphela uma izinkokhelo esikhathini ngasinye zenziwa ezingxenyeni ezilinganayo. I-syntax yayo ilandelayo:
= PRPLT (Linganisa; Isikhathi; I-Call_P; I-Ps; [Bs])
I-PMT
I-Operator I-PMT ibala inani lemali yokukhokha ngezikhathi ezithile ngephesenti eliqhubekayo. Ngokungafani nomsebenzi odlule, lo awunazo izingxabano. "Isikhathi". Kodwa ingxabano yokuzikhethela ingeziwe. "Thayipha"lapho kuboniswa khona ekuqaleni noma ekugcineni kwesikhathi sokukhokha kumele kwenziwe. Amapharamitha asele ahambisana ngokuphelele nefomula langaphambilini. I-syntax ilandelayo:
= I-PMT (Linganisa; I-Col_per; I-Ps; [Bs]; [Thayipha]
PS
Ifomu PS esetshenziselwa ukubala ukubaluleka kwamanje kokutshalwa kwezimali. Lo msebenzi uphambene nomsebenzisi. I-PMT. Unezimpikiswano ezifanayo, kepha esikhundleni se-argument value yamanje ("PS"), okuyinto empeleni kubalwa, inani lokukhokha ngezikhathi ezithile ("Plt"). I-syntax ilandelayo:
= PS (Rate; Col_per; Plt; [Bs ;; [Uhlobo])
I-NPV
Isitatimende esilandelayo sisetshenziselwa ukubala isamba samanje noma inani elincishisiwe. Lo msebenzi unemibono emibili: isilinganiso sesaphulelo kanye nenani lezinkokhelo noma amarisidi. Kuyiqiniso, okwesibili kubo kungaba nama-variant angu-254 abamele ukugeleza kwemali. I-syntax yale fomula ngu:
= I-NPV (Linganisa; Inani1; Inani2; ...)
BET
Umsebenzi BET libala inani lesithakazelo ku-annuity. Iziphakamiso zalolu opharetha yinani lezinkathi (Col_per), inani lokukhokha njalo ("Plt") nenani lokukhokha ("Ps"). Ngaphezu kwalokho, kuneziphakamiso ezengeziwe zokuzikhethela: ukubaluleka kwesikhathi esizayo ("Bs") futhi isibonakaliso ekuqaleni noma ekupheleni kwesikhathi sokukhokha kuzokwenziwa ("Thayipha"). I-syntax yile:
= BET (Col_per; Plt; Ps [Bs]; [Thayipha]
EFFECT
I-Operator EFFECT libala inani langempela (noma eliphumelelayo) lesithakazelo. Lo msebenzi unemibono emibili kuphela: inani lezinkathi zonyaka lapho isithakazelo sisetshenziselwa khona, kanye nesilinganiso sokuqokwa. I-syntax yayo iwukuthi:
= EFFECT (NOM_SIDE; COL_PER)
Siye sibheka kuphela imisebenzi ethandwa kakhulu yezimali. Ngokuvamile, inani labaqhubi beli qembu liphindwe izikhathi eziningana. Kodwa ngisho nakulezi zibonelo, umuntu angabona ngokucacile ukusebenza kahle nokulula ukusetshenziswa kwamathuluzi, okuwenza kube lula ukubala kubasebenzisi.
