Ayyukan kudi a cikin Microsoft Excel

Microsoft Excel yana ba da ayyuka iri-iri masu yawa waɗanda ke ba ku damar jure wa ilimin lissafi, tattalin arziki, kuɗi da sauran ayyuka. Shirin yana ɗaya daga cikin manyan kayan aikin da ake amfani da su a cikin ƙananan, matsakaita da kuma manyan kungiyoyi don kula da nau'o'in lissafin kuɗi, yin lissafin kuɗi, da dai sauransu. A ƙasa za mu dubi ayyukan kudi da suka fi dacewa a cikin Excel.

Saka aiki

Da farko, bari mu tuna yadda ake saka aiki a cikin tantanin halitta. Kuna iya yin haka ta hanyoyi daban-daban:

1. Bayan zaɓar tantanin halitta da ake so, danna gunkin "fx (Saka aikin)" zuwa hagu na mashayin dabara.
2. Ko canza zuwa shafin "Formulas" sannan danna maballin makamancin haka dake gefen hagu na ribbon shirin.

Ko da kuwa zaɓin da aka zaɓa, taga aikin sakawa zai buɗe, wanda a ciki kake buƙatar zaɓar nau'i "Kudi", yanke shawara akan ma'aikacin da ake so (misali, KUDI), sannan danna maballin OK.

Wani taga zai bayyana akan allon tare da gardama na aikin da kuke buƙatar cikawa, sannan danna maɓallin OK don ƙara shi a cikin tantanin halitta da aka zaɓa sannan ku sami sakamakon.

Kuna iya ƙididdige bayanai da hannu ta amfani da maɓallan maɓalli (takamaiman ƙima ko nassoshi tantanin halitta), ko ta hanyar sakawa a cikin filin sabanin hujjar da ake so, zaɓi abubuwan da suka dace a cikin tebur ɗin kanta (kwayoyin, kewayon sel) ta amfani da maɓallin linzamin kwamfuta na hagu ( idan an yarda).

Lura cewa ba za a iya nuna wasu gardama ba kuma dole ne ka gungura ƙasa don samun damar su (ta amfani da madaidaicin madaidaicin dama).

Hanyar madadin

Kasancewa a cikin shafin "Formulas" zaka iya danna maballin "Kudi" cikin rukuni "Labarun Ayyuka". Za a buɗe jerin zaɓuɓɓukan da ake da su, waɗanda kawai danna kan wanda kuke buƙata.

Bayan haka, taga mai gardama don cikawa zai buɗe nan da nan.

Shahararrun ayyuka na kuɗi

Yanzu da muka gano yadda ake shigar da aiki a cikin tantanin halitta a cikin ma'auni na Excel, bari mu matsa zuwa jerin masu gudanar da kuɗi (wanda aka gabatar a cikin jerin haruffa).

BS

Ana amfani da wannan ma'aikacin don ƙididdige ƙimar saka hannun jari na gaba bisa la'akari da daidaitattun biya na lokaci-lokaci (m) da ƙimar riba (m).

Hujjar da ake buƙata (parameters) don cika sune:

• Bet - yawan riba na lokaci;
• Kper - jimlar adadin lokutan biyan kuɗi;
• Plt – biya akai-akai ga kowane lokaci.

Hujjoji na zaɓi:

• Ps shine darajar yanzu (a halin yanzu). Idan an bar komai a fili, ƙima daidai da "0";
• Wani nau'in - yana cewa a nan:
  • 0 - biya a ƙarshen lokacin;
  • 1 – biya a farkon lokacin
  • idan an bar filin babu komai, zai zama sifili.

Hakanan yana yiwuwa a shigar da tsarin aikin da hannu kai tsaye a cikin tantanin halitta da aka zaɓa, ƙetare aikin da shigar windows.

Tsarin aiki:

=БС(ставка;кпер;плт;[пс];[тип])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

VOD

Ayyukan yana ba ku damar ƙididdige ƙimar dawowar ciki don jerin tsabar kuɗi da aka bayyana a cikin lambobi.

Hujjar da ake buƙata kai kadai - "Dabi'u", wanda a ciki kana buƙatar ƙayyade tsararru ko daidaitawa na kewayon sel tare da ƙimar lambobi (aƙalla mara kyau da lamba ɗaya mai kyau) wanda za a yi lissafin.

Hujja ta zaɓi - "Zaton". Anan, ana nuna ƙimar da ake tsammani, wanda ke kusa da sakamakon VOD. Idan an bar wannan filin babu komai, ƙimar tsoho zata zama 10% (ko 0,1).

Tsarin aiki:

=ВСД(значения;[предположение])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

KUDI

Yin amfani da wannan afaretan, zaku iya ƙididdige yawan kuɗin da aka samu na asusun da ake biyan riba na lokaci-lokaci.

Abubuwan da ake buƙata:

• date_acc - kwanan wata yarjejeniya / sasantawa akan abubuwan tsaro (nan gaba ana magana da su azaman tsaro);
• Kwanan wata - kwanan watan shigarwa cikin karfi / fansa na tsaro;
• Bet – shekara-shekara coupon kudi na Securities;
• price - farashin Securities don 100 rubles na darajar fuska;
• Maimaitawa - adadin fansa ko ƙimar fansa na tsaro. don 100 rubles darajar fuska;
• Frequency - adadin biyan kuɗi a kowace shekara.

Hujjar "Basis" is zaɓi, ya fayyace yadda ake lissafin ranar:

• 0 ko komai - Amurka (NASD) 30/360;
• 1 - ainihin / ainihin;
• 2 - ainihin/360;
• 3 - ainihin/365;
• 4 – Turai 30/360.

Tsarin aiki:

=ДОХОД(дата_согл;дата_вступл_в_силу;ставка;цена;погашение;частота;[базис])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

MVSD

Ana amfani da ma'aikacin don ƙididdige ƙimar dawowar cikin gida don adadin tsabar kuɗi na lokaci-lokaci bisa la'akari da farashin haɓaka jari, da kuma adadin kuɗin da aka sake sakawa.

Aikin yana da kawai hujjojin da ake buƙata, wanda ya hada da:

• Da dabi'u - korau (biyan kuɗi) da lambobi masu kyau (rasitu) ana nuna su, an gabatar da su azaman tsararru ko bayanan tantanin halitta. Saboda haka, dole ne a nuna aƙalla ƙima ɗaya mai kyau da mara kyau a nan;
• Rate_finance - yawan kudin ruwa da aka biya don kudaden da ke gudana;
• Rate_reinvest - ƙimar riba don sake saka hannun jari don kadarorin yanzu.

Tsarin aiki:

=МВСД(значения;ставка_финанс;ставка_реинвест)

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

INORMA

Mai aiki yana ba ku damar ƙididdige ƙimar riba don cikakken hannun jari.

Hujjojin aiki:

• date_acc - kwanan wata yarjejeniya don tsaro;
• Kwanan wata - kwanan watan fansa na tsaro;
• Investment - adadin da aka saka a cikin tsaro;
• Maimaitawa - adadin da za a karɓa a kan fansa na tsaro;
• shaida "Basis" amma ga aikin KUDI ba na tilas bane

Tsarin aiki:

=ИНОРМА(дата_согл;дата_вступл_в_силу;инвестиция;погашение;[базис])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

PLT

Wannan aikin yana ƙididdige adadin biyan kuɗi na lokaci-lokaci akan lamuni bisa la'akari da tsayin daka na biyan kuɗi da ƙimar riba.

Abubuwan da ake buƙata:

• Bet - yawan riba na lokacin lamuni;
• Kper - jimlar adadin lokutan biyan kuɗi;
• Ps shine darajar yanzu (a halin yanzu).

Hujjoji na zaɓi:

• Bs - darajar nan gaba (ma'auni bayan biya na ƙarshe). Idan filin an bar shi babu komai, zai saba zuwa "0".
• Wani nau'in – Anan ka bayyana yadda za a biya:
  • "0" ko ba a ƙayyade ba - a ƙarshen lokacin;
  • "1" – a farkon lokacin.

Tsarin aiki:

=ПЛТ(ставка;кпер;пс;[бс];[тип])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

AN KARBI

Ana amfani da shi don nemo adadin da za a karɓa ta hanyar balaga na hannun jarin da aka saka.

Hujjojin aiki:

• date_acc - kwanan wata yarjejeniya don tsaro;
• Kwanan wata - kwanan watan fansa na tsaro;
• Investment - adadin da aka saka a cikin tsaro;
• Discount – rangwamen kudi na Securities;
• "Basis" – hujja na zaɓi (duba aiki KUDI).

Tsarin aiki:

=ПОЛУЧЕНО(дата_согл;дата_вступл_в_силу;инвестиция;дисконт;[базис])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

PS

Ana amfani da ma'aikaci don nemo halin yanzu (watau, zuwa yau) ƙimar saka hannun jari, wanda yayi daidai da jerin biyan kuɗi na gaba.

Abubuwan da ake buƙata:

• Bet - yawan riba na lokaci;
• Kper - jimlar adadin lokutan biyan kuɗi;
• Plt – biya akai-akai ga kowane lokaci.

Hujja Na Zabi - daidai da aikin "PLT":

• Bs - darajar nan gaba;
• Wani nau'in.

Tsarin aiki:

=ПС(ставка;кпер;плт;[бс];[тип])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

RANAR

Mai aiki zai taimake ka nemo ƙimar riba akan shekara (hayan kuɗi) na tsawon lokaci 1.

Abubuwan da ake buƙata:

• Kper - jimlar adadin lokutan biyan kuɗi;
• Plt - biya akai-akai ga kowane lokaci;
• Ps shine darajar yanzu.

Hujja Na Zabi:

• Bs - ƙimar gaba (duba aiki PLT);
• Wani nau'in (duba aiki PLT);
• zato - ƙimar da ake tsammani na fare. Idan ba a fayyace ba, za a yi amfani da tsohuwar ƙimar 10% (ko 0,1).

Tsarin aiki:

=СТАВКА(кпер;;плт;пс;[бс];[тип];[предположение])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

farashin

Mai aiki yana ba ku damar nemo farashin 100 rubles na ƙimar ƙima na ƙima, wanda ake biyan riba lokaci-lokaci.

Abubuwan da ake buƙata:

• date_acc - kwanan wata yarjejeniya don tsaro;
• Kwanan wata - kwanan watan fansa na tsaro;
• Bet – shekara-shekara coupon kudi na Securities;
• Income – shekara-shekara samun kudin shiga ga Securities;
• Maimaitawa – fansa darajar Securities. don 100 rubles darajar fuska;
• Frequency - adadin biyan kuɗi a kowace shekara.

Hujjar "Basis" amma ga mai aiki KUDI is zaɓi.

Tsarin aiki:

=ЦЕНА(дата_согл;дата_вступл_в_силу;ставка;доход;погашение;частота;[базис])

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

ChPS

Yin amfani da wannan aikin, zaku iya ƙayyade ƙimar hannun jari na yanzu bisa la'akari da ƙimar rangwame, da kuma adadin karɓa da biyan kuɗi na gaba.

Hujjojin aiki:

• Bet - rangwamen kuɗi na tsawon lokaci 1;
• Ma'ana1 - biyan kuɗi (daraja mara kyau) da rasit (ƙimomi masu kyau) a ƙarshen kowane lokaci ana nuna su anan. Filin na iya ƙunsar ƙima guda 254.
• Idan hujja ta iyakance "darajar 1" gaji, za ku iya ci gaba da cika waɗannan abubuwa - "Value2", "Value3" da dai sauransu.

Tsarin aiki:

=ЧПС(ставка;значение1;[значение2];...)

Sakamako a cikin tantanin halitta da magana a cikin mashaya dabara:

Kammalawa

category "Kudi" Excel yana da ayyuka daban-daban sama da 50, amma da yawa daga cikinsu suna da ƙayyadaddun bayanai kuma sun fi mayar da hankali sosai, wanda shine dalilin da ya sa ba kasafai ake amfani da su ba. Mun yi la'akari da 11 mafi mashahuri, a ra'ayinmu.