I-Excel PMT Umsebenzi: Bala Ukukhokha Kwesikweletu noma Izinhlelo Zokulondoloza

Umsebenzi we-PMT, omunye wemisebenzi yezimali ka-Excel, ingasetshenziswa ukubala:

1. Ukukhokha njalo kwesikhathi esidingekayo ukukhokha (noma ukukhokhela kancane) umboleko
2. Uhlelo lokulondoloza oluzoholela ekusindiseni inani elibekiwe esikhathini esithile

Kuzo zombili izimo, isilinganiso senzalo esinqunyiwe kanye nesimiso sokukhokha okufanayo kufakwa.

01 ka 05

I-PMT Yesebenzayo i-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi , amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax yomsebenzi we-PMT yile:

= I-PMT (Rate, Nper, Pv, Fv, Uhlobo)

Kuphi:

Linganisa (elidingekayo) = inani lentengo yonyaka yenzalo. Uma izinkokhelo zenziwa ngenyanga, hlukanisa le nombolo ngo-12.

I-Nper (edingekayo) = inani eliphelele lezinkokhelo zemalimboleko. Futhi, ukuze uthole izinkokhelo zenyanga, wandisa lokhu ngo-12.

I-Pv (edingekayo) = inani lamanje noma lamanje noma inani elibolekiwe.

Fv (okukhethwa kukho) = inani elizayo. Uma kukhishiwe, i-Excel iqala ibhalansi izoba ngu- $ 0.00 ekupheleni kwesikhathi. Ngemalimboleko, le mpikiswano ingavunyelwa ngokujwayelekile.

Thayipha (okukhethwa kukho) = kubonisa ukuthi izinkokhelo ziyadingeka yini:

• "0" (noma ishiyiwe) - ekupheleni kwesikhathi sokukhokha (ekupheleni kwenyanga);
• "1" - ekuqaleni kwesikhathi sokukhokha (ukuqala kwenyanga).

02 ka 05

Izibonelo ze-Excel PMT

Isithombe esingenhla sihlanganisa izibonelo eziningi zokusebenzisa umsebenzi we-PMT ukubala izinkokhelo zemali kanye nezinhlelo zokulondoloza.

1. Isibonelo sokuqala (iselula D2) sibuyisela inkokhelo yenyanga yonke ye-$ 50,000 mboleko ngenani lesenzalo ka-5% ukukhokhelwa ngaphezu kweminyaka emihlanu
2. Isibonelo sesibili (iselula D3) sibuyisela inkokhelo yenyanga yonke ye-$ 15,000, isikweletu seminyaka emithathu, isilinganiso senzalo se-6% ne-balance balance ye-$ 1,000.
3. Isibonelo sesithathu (iseli D4) sinquma izinkokhelo zonyaka ngecebo lokulondoloza ngenhloso ye $ 5,000 emva kweminyaka emibili ngenani lesithakazelo se-2%.

Ngezansi kubalwe izinyathelo ezisetshenziselwa ukungena emsebenzini we-PMT esitokisini se-D2

03 ka 05

Izinyathelo zokufaka umsebenzi we-PMT

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo kwiseli lokusebenzela lihlanganisa:

1. Ukuthayipha umsebenzi ophelele, njenge: = PMT (B2 / 12, B3, B4) ibe yiseli D2;
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lebhokisi lengxoxo ye-PMT.

Yize kungenzeka ukuthi uthayiphe umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo njengoba kunakekela ukungena kwe-syntax yomsebenzi - njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.

Izinyathelo ezingezansi kwekhava ezifaka isibonelo somsebenzi we-PMT usebenzisa ibhokisi lengxoxo lomsebenzi.

1. Chofoza kuseli D2 ukuze wenze iseli elisebenzayo ;
2. Chofoza kuthebhu yefomu yebhebhoni;
3. Khetha imisebenzi yezezimali ukuvula uhlu lwehla lokusebenza;
4. Chofoza ku-PMT kuhlu ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
5. Chofoza kulayini Wokulinganisela ebhokisini lengxoxo;
6. Chofoza kuseli B2 ukungena kulolu chungechunge lweseli ;
7. Thayipha i-slash phambili "/" ilandelwe inombolo engu-12 emgqeni wokulinganisa webhokisi lengxoxo ukuze uthole inzalo yenzalo ngenyanga;
8. Chofoza ku- Nper line ebhokisini lengxoxo;
9. Chofoza kuseli B3 ukungena kuleli referensi yeseli;
10. Chofoza kumgqa we- Pv ebhokisini lengxoxo;
11. Chofoza kuseli B4 kuspredishithi;
12. Chofoza OK ukuvala ibhokisi lengxoxo bese uqedela umsebenzi;
13. Impendulo ($ 943.56) ivela kuseli D2;
14. Uma uchofoza ku-cell D2 umsebenzi ophelele = i-PMT (B2 / 12, B3, B4) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela .

04 ka 05

Ukubuyiswa kwemali mboleko Inani

Ukuthola inani lemali elikhokhwa ngesikhathi sokuboleka imali kufezeka ngokuphindaphinda inani le-PMT (iseli D2) ngokubaluleka kokuphikisana kukaNper (inani lokukhokha).

$ 943.56 x 60 = $ 56,613.70

05 ka 05

Ukufometha Izinombolo Ezingalungile ku-Excel

Kulesi sithombe, impendulo engu-$ 943.56 e-cell D2 izungezwe ngabazali futhi inebala lombala obomvu ukukhombisa ukuthi kuyinani elibi - ngoba kuyinkokhelo.

Ukubonakala kwezinombolo ezingalungile kwiphepha lokusebenzela kungashintshwa ngokusebenzisa ibhokisi le-dialog cells .