Ayyukan PMT, ɗaya daga cikin ayyukan kudi na Excel, ana iya amfani dashi don lissafta:
- Adadin biyan kuɗin da ake buƙata ya biya (ko biya wani fansa) rance
- Shirin tanadi wanda zai haifar da adana adadi a wani tsawon lokaci
A duk lokuta biyu, ana tsammanin yawan kuɗi mai tsabta da kuma ma'auni na biyan kuɗi.
01 na 05
PMT Function Syntax da Arguments
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin aikin aikin PMT shine:
= PMT (Rate, Nper, Pv, Fv, Type)
Inda:
Yawanci (buƙata) = yawan kuɗi na shekara-shekara don bashi. Idan an biya biyan kuɗi kowane wata, raba wannan lambar ta 12.
Nper (da ake buƙata) = yawan adadin biyan bashin. Bugu da ƙari, don biyan kuɗi ɗaya, ninka wannan ta 12.
Pv (da ake buƙata) = halin yanzu ko halin yanzu ko adadin ya karɓa.
Fv (zaɓi) = ƙimar gaba. Idan aka cire shi, Excel ta kiyasta cewa ma'auni zai kasance $ 0.00 a ƙarshen lokacin. Don bashi, wannan hujja za a iya cirewa gaba daya.
Rubuta (na zaɓi) = yana nuna lokacin da biyan kuɗi ya zama:
- "0" (ko watsi) - a ƙarshen lokacin biya (karshen watan);
- "1" - a farkon lokacin biya (farkon watan).
02 na 05
Ayyukan SMT na Excel
Hoton da ke sama ya haɗa da misalai na yin amfani da aikin PMT don ƙididdige biyan bashin kuɗi da tsare-tsaren kuɗi.
- Misali na farko (cell D2) ya dawo da biyan kuɗin kuɗin wata rance na $ 50,000 tare da farashi mai amfani na 5% da za'a biya a shekaru biyar
- Misali na biyu (tantanin halitta D3) ya dawo da biyan kuɗi na wata shekara don adadin $ 15,000, shekaru 3, kashi 6% tare da daidaitattun $ 1,000.
- Misali na uku (tantanin halitta D4) yana lissafin biyan kuɗi na kwata zuwa shirin bashin da burin $ 5,000 bayan shekaru 2 a wata kudi mai amfani na 2%.
Da ke ƙasa an jera matakan da ake amfani dashi don shigar da aikin PMT zuwa cikin cell D2
03 na 05
Matakai don Shigar da aikin PMT
Zaɓuɓɓuka don shigar da aikin da ƙididdigarsa a cikin ɗakunan ayyukan aiki sun hada da:
- Rubuta cikakken aikin, kamar: = PMT (B2 / 12, B3, B4) zuwa cikin cell D2;
- Zaɓin aikin da muhawarar ta ta amfani da akwatin maganganu na PMT.
Kodayake yana iya yiwuwa a aiwatar da cikakken aikin tare da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu kamar yadda yake kula da shigar da haɗin gwargwadon aikin - irin su sakonni da rabuwa tsakanin ɓangarori.
Matakan da ke ƙasa suna rufe shigar da aikin PMT ta amfani da akwatin maganganun aikin.
- Danna kan tantanin halitta D2 don sa shi tantanin halitta ;
- Danna kan Rubutun hanyoyin shafin rubutun;
- Zaɓi Ayyukan Gudanar da ayyukan don buɗe jerin ayyukan saukewa;
- Danna PMT a jerin don kawo akwatin maganganu na aikin;
- Danna kan Rate a cikin akwatin maganganu;
- Danna kan tantanin halitta B2 don shigar da wannan tantanin halitta ;
- Rubuta slash " sashi " / " sannan biye da lamba 12 a cikin Rukunin Rate na akwatin maganganu don samun yawan sha'awa a kowane wata;
- Danna maɓallin Nper a cikin akwatin maganganu;
- Danna kan tantanin halitta B3 don shigar da wannan tantanin halitta;
- Danna maɓallin Pv cikin akwatin maganganu;
- Danna kan b2 B a cikin maƙallan rubutu;
- Danna Ya yi don rufe akwatin maganganu kuma kammala aikin;
- Amsar ($ 943.56) ya bayyana a cell D2;
- Lokacin da ka danna kan tantanin halitta D2 cikakkiyar aikin = PMT (B2 / 12, B3, B4) ya bayyana a cikin maɓallin tsari a sama da aikin aiki .
04 na 05
Kudin bashin kuɗi
Gano yawan kuɗin da aka biya a kan tsawon lokacin bashi yana iya cikawa ta hanyar ninka darajar PMT (tantanin halitta D2) ta wurin darajan N argument (yawan biya).
$ 943.56 x 60 = $ 56,613.70
05 na 05
Tsarin Nassin Lissafi a Excel
A cikin hoton, amsar $ 943.56 a cikin cell D2 yana kewaye da parenthesis kuma yana da launin launi ja don nuna cewa yana da mummunan adadin - saboda yana da biyan kuɗi.
Za'a iya canza alamar ƙirar lambobi a cikin takarda-aiki ta amfani da akwatin maganin Siffofin Siffar.