Ntchito zachuma mu Microsoft Excel

Microsoft Excel imapereka ntchito zosiyanasiyana zomwe zimakupatsani mwayi wothana ndi masamu, zachuma, zachuma ndi ntchito zina. Pulogalamuyi ndi imodzi mwa zida zazikulu zomwe zimagwiritsidwa ntchito m'mabungwe ang'onoang'ono, apakati ndi akuluakulu kuti asunge mitundu yosiyanasiyana yowerengera ndalama, kuchita mawerengedwe, ndi zina zotero. Pansipa tiwona ntchito zachuma zomwe zimafunidwa kwambiri ku Excel.

Kuyika ntchito

Choyamba, tiyeni tikumbukire momwe mungayikitsire ntchito mu cell ya tebulo. Mutha kuchita izi m'njira zosiyanasiyana:

1. Mukasankha foni yomwe mukufuna, dinani chizindikirocho "fx (Ikani ntchito)" kumanzere kwa formula bar.
2. Kapena sinthani ku tabu "Mitundu" ndikudina batani lofanana lomwe lili kumanzere kwa riboni ya pulogalamuyo.

Mosasamala kanthu zomwe zasankhidwa, zenera la ntchito yoyika lidzatsegulidwa, momwe muyenera kusankha gulu "Ndalama", sankhani wogwiritsa ntchito yemwe mukufuna (mwachitsanzo, ZOTHANDIZA), kenako dinani batani OK.

Zenera lidzawonekera pazenera ndi mfundo za ntchito yomwe muyenera kudzaza, kenako dinani OK batani kuti muwonjezere ku selo yosankhidwa ndikupeza zotsatira.

Mutha kufotokoza zambiri pamanja pogwiritsa ntchito makiyi a kiyibodi (makhalidwe enieni kapena maumboni a cell), kapena poyika m'munda moyang'anizana ndi mkangano womwe mukufuna, sankhani zomwe zikugwirizana patebulo lokha (maselo, magulu osiyanasiyana) pogwiritsa ntchito batani lakumanzere ( ngati aloledwa).

Chonde dziwani kuti zotsutsana zina sizingawonetsedwe ndipo muyenera kutsika pansi kuti muzitha kuzipeza (pogwiritsa ntchito zotsetsereka zoyimirira kumanja).

Njira ina

Kukhala mu tabu "Mitundu" mukhoza kukanikiza batani "Ndalama" pagulu "Function Library". Mndandanda wa zosankha zomwe zilipo zidzatsegulidwa, zomwe mwangodinanso zomwe mukufuna.

Pambuyo pake, zenera lomwe lili ndi zifukwa zogwirira ntchito kuti mudzaze lidzatsegulidwa nthawi yomweyo.

Ntchito zodziwika bwino zachuma

Tsopano popeza tazindikira momwe ntchito imayikidwira mu selo mu Excel spreadsheet, tiyeni tipite ku mndandanda wa ogwira ntchito zachuma (operekedwa motsatira zilembo).

BS

Wogwiritsa ntchitoyu amagwiritsidwa ntchito kuwerengetsera mtengo wamtsogolo wandalama potengera malipiro ofanana nthawi ndi nthawi (nthawi zonse) ndi chiwongola dzanja (nthawi zonse).

Zofunika Zokambirana (magawo) oti mudzaze ndi:

• uliwonse - chiwongola dzanja pa nthawiyo;
• Kper - chiwerengero cha nthawi zolipira;
• Plt - kulipira kosalekeza kwa nthawi iliyonse.

Zotsutsa zosafunikira:

• Ps ndi mtengo wapano (panopa). Ngati sichinalembedwe, mtengo wofanana ndi "0";
• Mtundu - akuti apa:
  • 0 - malipiro kumapeto kwa nthawi;
  • 1 - malipiro kumayambiriro kwa nthawi
  • ngati gawolo lisiyidwa popanda kanthu, limakhala lokhazikika mpaka zero.

Ndikothekanso kulowetsa pamanja chilinganizo chantchito nthawi yomweyo mu selo yosankhidwa, ndikudutsa ntchito ndi mazenera oyika mkangano.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

VSD

Ntchitoyi imakupatsani mwayi wowerengera kuchuluka kwa ndalama zomwe zimachokera kumagulu osiyanasiyana.

Mtsutso wofunikira chimodzi chokha - "Values", m'mene muyenera kufotokoza mndandanda kapena zogwirizanitsa zamagulu osiyanasiyana omwe ali ndi nambala (osachepera nambala imodzi yolakwika ndi nambala imodzi) pomwe kuwerengera kudzachitidwa.

Mtsutso wosankha - "Assumption". Apa, mtengo woyembekezeredwa ukuwonetsedwa, womwe uli pafupi ndi zotsatira VSD. Ngati gawoli lisiyidwa, mtengo wokhazikika udzakhala 10% (kapena 0,1).

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

ZOTHANDIZA

Pogwiritsa ntchito woyendetsa uyu, mutha kuwerengera zokolola zachitetezo chomwe chiwongola dzanja chimalipidwa nthawi ndi nthawi.

Zofunikira:

• tsiku_acc - tsiku la mgwirizano / kukhazikitsidwa kwa zitetezo (zomwe zimatchedwa zitetezo);
• Tsiku_loyamba - tsiku loyambira / kuwomboledwa kwa zotetezedwa;
• uliwonse - kuchuluka kwa makuponi apachaka achitetezo;
• Price - mtengo wachitetezo cha ma ruble 100 amtengo wapatali;
• Kubwezera - ndalama zowombola kapena mtengo wowombola wachitetezo. mtengo wa ma ruble 100;
• pafupipafupi - chiwerengero cha malipiro pachaka.

Kutsutsana "Basis" is zosankha, imafotokoza momwe tsikulo liwerengedwera:

• 0 kapena opanda kanthu - American (NASD) 30/360;
• 1 - zenizeni / zenizeni;
• 2 - zenizeni/360;
• 3 - zenizeni/365;
• 4 - European 30/360.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

MVSD

Wogwiritsa ntchitoyo amagwiritsidwa ntchito kuwerengera kuchuluka kwa ndalama zomwe zabwezedwa pakanthawi kochepa kutengera mtengo wokweza mabizinesi, komanso kuchuluka kwa ndalama zomwe zidabwezedwa.

Ntchito ili ndi zokha mfundo zofunika, zomwe zimaphatikizapo:

• Makhalidwe - zolakwika (malipiro) ndi manambala abwino (ma risiti) amasonyezedwa, operekedwa ngati mndandanda kapena maumboni a selo. Chifukwa chake, nambala imodzi yotsimikizika ndi yolakwika iyenera kuwonetsedwa apa;
• Rate_ndalama - chiwongola dzanja cholipira ndalama zomwe zikuyenda;
• Rate _ reinvest - chiwongola dzanja pakubwezeretsanso zinthu zomwe zilipo panopa.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

INORMA

Wothandizira amakulolani kuti muwerengere chiwongoladzanja cha zotetezedwa zomwe zasungidwa mokwanira.

Zotsutsana za ntchito:

• tsiku_acc - tsiku lomaliza lachitetezo;
• Tsiku_loyamba - tsiku lachiwombolo chachitetezo;
• Investment - kuchuluka kwa ndalama zomwe zasungidwa muchitetezo;
• Kubwezera - ndalama zomwe ziyenera kulandiridwa pakuwomboledwa kwa zotetezedwa;
• mtsutso "Basis" za ntchito ZOTHANDIZA ndizosankha.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

PLT

Ntchitoyi imawerengera kuchuluka kwa zolipirira nthawi ndi nthawi pangongole kutengera kuchuluka kwa zolipirira komanso chiwongola dzanja.

Zofunikira:

• uliwonse - chiwongola dzanja pa nthawi ya ngongole;
• Kper - chiwerengero cha nthawi zolipira;
• Ps ndi mtengo wapano (panopa).

Zotsutsa zosafunikira:

• Bs - mtengo wamtsogolo (chotsala pambuyo pa malipiro omaliza). Ngati gawolo lasiyidwa lopanda kanthu, lidzasintha "0".
• Mtundu - apa mumafotokoza momwe malipiro angapangidwire:
  • "0" kapena osatchulidwa - kumapeto kwa nthawi;
  • "1" - kumayambiriro kwa nthawi.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

KULANDIRA

Amagwiritsidwa ntchito kuti apeze ndalama zomwe zidzalandidwe ndi kukhwima kwa zotetezedwa zomwe zayikidwa.

Zotsutsana za ntchito:

• tsiku_acc - tsiku lomaliza lachitetezo;
• Tsiku_loyamba - tsiku lachiwombolo chachitetezo;
• Investment - ndalama zomwe zimayikidwa muchitetezo;
• kuchotsera - kuchotsera kwa zitetezo;
• "Basis" - kukangana kosankha (onani ntchito ZOTHANDIZA).

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

PS

Wogwiritsa ntchitoyo amagwiritsidwa ntchito kuti apeze mtengo waposachedwa (ie mpaka pano) wandalama, zomwe zimagwirizana ndi zolipira zamtsogolo.

Zofunikira:

• uliwonse - chiwongola dzanja pa nthawiyo;
• Kper - chiwerengero cha nthawi zolipira;
• Plt - kulipira kosalekeza kwa nthawi iliyonse.

Zosankha Zosankha - chimodzimodzi ndi ntchito "PLT":

• Bs - mtengo wamtsogolo;
• Mtundu.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

RATE

Wothandizira adzakuthandizani kupeza chiwongoladzanja pa annuity (renti yandalama) kwa nthawi imodzi.

Zofunikira:

• Kper - chiwerengero cha nthawi zolipira;
• Plt - kulipira kosalekeza kwa nthawi iliyonse;
• Ps ndi mtengo wapano.

Zosankha Zosankha:

• Bs - mtengo wamtsogolo (onani ntchito PLT);
• Mtundu (onani ntchito PLT);
• Kulingalira - mtengo womwe ukuyembekezeredwa kubetcha. Ngati sizinatchulidwe, mtengo wokhazikika wa 10% (kapena 0,1) udzagwiritsidwa ntchito.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

PRICE

Wothandizira amakulolani kuti mupeze mtengo wa ma ruble 100 a mtengo wamtengo wapatali wa zitetezo, zomwe chiwongola dzanja chanthawi ndi nthawi chimalipidwa.

Zofunikira:

• tsiku_acc - tsiku lomaliza lachitetezo;
• Tsiku_loyamba - tsiku lachiwombolo chachitetezo;
• uliwonse - kuchuluka kwa makuponi apachaka achitetezo;
• ndalama - ndalama zapachaka zachitetezo;
• Kubwezera - mtengo wowomboledwa wa zotetezedwa. mtengo wa ma ruble 100;
• pafupipafupi - chiwerengero cha malipiro pachaka.

Kutsutsana "Basis" kwa woyendetsa ZOTHANDIZA is zosankha.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

ChPS

Pogwiritsa ntchito ntchitoyi, mutha kudziwa kuchuluka kwa ndalama zomwe mwagulitsa panopa potengera kuchotsera, komanso kuchuluka kwa malisiti ndi malipiro amtsogolo.

Zotsutsana za ntchito:

• uliwonse - kuchotsera kwa nthawi imodzi;
• Kutanthauza1 - malipiro (makhalidwe oipa) ndi ma risiti (makhalidwe abwino) kumapeto kwa nthawi iliyonse akuwonetsedwa apa. Mundawu ukhoza kukhala ndi zinthu 254.
• Ngati mkangano malire "Mtengo 1" mutatopa, mutha kupitiriza kulemba zotsatirazi − "Value2", "Value3" etc.

Kalembedwe ka ntchito:

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

Zotsatira mu selo ndi mawu omwe ali mu bar formula:

Kutsiliza

Category "Ndalama" Excel ili ndi ntchito zopitilira 50, koma zambiri ndizokhazikika komanso zolunjika, ndichifukwa chake sagwiritsidwa ntchito kawirikawiri. Takambirana 11 otchuka kwambiri, m'malingaliro athu.