Basa re PMT, rimwe remabasa eEccel, rekushandisa, rinogona kushandiswa kuverenga:
- Chibharo chenguva dzose chinotarisirwa kubhadhara (kana kuti chikwereti chikwereti) chikwereti
- Urongwa hwekuchengetedza huchaguma nekuponesa chiyero chakatarwa munguva yakatarwa yenguva
Pamusoro pemamiriro ose aya, chikwata chakatarisirwa chikwata uye purogiramu yekubhadhara yakafanana inofungidzirwa.
01 ye 05
PMT Function Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa , mabheji, vatengesi vemavara, uye nharo .
Mutsara wekuita kweTPT ndeyekuti:
= PMT (Nhamba, Nper, Pv, Fv, Rudzi)
Kupi:
Nhamba (inodiwa) = iyo yegore inotora chikwereti chechikwereti. Kana chikwereti ichiitwa mwedzi mumwe nomumwe, gurai nhamba iyi ne12.
Nper (inoda) = nhamba yose yekubhadhara chikwereti. Zvakare, pamwedzi wekubhadhara, wedzera izvi ne12.
Pv (inoda) = kukosha kwezvino kana ikozvino kana mari yakakweretwa.
Fv (zvisarudzo) = kukosha kwemugumo. Kana akasiya, Excel inotora chikamu chichava $ 0.00 pamagumo emenguva. Nezvikwereti, nharo iyi inogona kuregererwa.
Ropa (optional) = rinoratidza kana zvikwereti zvaitika:
- "0" (kana kuregererwa) - pakupera kwenguva yekubhadhara (kuguma kwemwedzi);
- "1" - pakutanga kwekubhadhara nguva (kutanga kwemwedzi).
02 of 05
Excel PMT Basa Remuenzaniso
Mifananidzo iri pamusoro inosanganisira mienzaniso yakawanda yekushandisa basa re PMT kuverenga kubhadhara chikwereti uye zvirongwa zvokuchengetedza.
- Muenzaniso wekutanga (cell D2) inodzorera mutero wemwedzi wega we $ 50 000 chikwereti neinharaunda yekutora ye 5% kubhadharwa kwemakore mashanu
- Muenzaniso wechipiri (sero D3) unodzorera kubhadhara kwemwedzi we $ 15,000, chikwereti chemakore matatu, chikwereti chekuda kwe 6% nechisara chinosvika $ 1 000.
- Muenzaniso wechitatu (cell D4) inotora chikwereti chegore rimwechete kune chirongwa chokuchengetedza nechinangwa che $ 5,000 mushure memakore maviri kune chikwereti chechido che 2%.
Pasi apa zvakatorwa matanho anoshandiswa kupinda muTPT basa mumusero D2
03 of 05
Matanho ekupinda kweMutambo weMDC
Zvisarudzo zvekupinda mubasa uye mazano ayo mueseji yebasa rinosanganisira:
- Kunyora basa rakakwana, rakadai se: = PMT (B2 / 12, B3, B4) muchitokisi D2;
- Kusarudza basa uye nharo dzayo kushandisa PMT basa dialog box.
Kunyange zvazvo zvichibvira kungonyora basa rakakwana manually, vanhu vakawanda vanoona zviri nyore kushandisa bhokisi rebhokisi sezvo rinotarisira kupinda mumashandisirwo emabasa - zvakadai seakabhakisi uye vaparadhara vekuda pakati pemakakatanwa.
Matanho ari pasi apa anopinda muTTT basa basa vachishandisa basa rebhokisi rebhokisi.
- Dzvanya pane cell D2 kuti iite iyo inoshandiswa seki ;
- Dzvanya paMafomu tab yebhoni;
- Sarudza mabasa ekubhadhara mari kuti uzarure basa rakaderera pasi;
- Dzvanya pane PMT murugwaro kuti uburise bhokisi rebasa rebasa;
- Dzvanya paIndaneti iri mubhokisi rebhokisi;
- Dzvanya pane sero B2 kuti upinde muchengeti iyi;
- Tora a forward slash "/" inoteverwa nenhamba 12 mumutsetse weBote rebhokisi rebhokisi kuti uwane chikwereti chekudaidza pamwedzi;
- Dzvanya paNper line mubhokisi rebhokisi;
- Dzvanyira pane sero B3 kuti uise iko rekero rinotarisa;
- Dzvanya pa Pv mutsara mubhokisi rebhokisi;
- Dzvanya pane sero B4 mune pepanheti;
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye upedze basa;
- Mhinduro ($ 943.56) inowanikwa muchitokisi D2;
- Paunenge uchinge uri pavha D2 yakakwana basa = PMT (B2 / 12, B3, B4) inowanikwa mubhairi yepamusoro pane pepa pepaji .
04 of 05
Kubhadhara chikwereti Total
Kuwana mari yose yakabhadharwa kwenguva yakareba iyo chikwereti inonyatsoitwa kuburikidza nekuwedzera PMT kukosha (cell D2) nekukosha kweNper argument (nhamba yekubhadhara).
$ 943.56 x 60 = $ 56,613.70
05 of 05
Kugadzirisa Nhamba Dzakashata muExcel
Mumufananidzo, mhinduro $ 943.56 muchikamu cheD2 yakakomberedzwa nevabereki uye ine ruvara rwemutsvuku rwuri kuratidza kuti iri mari yakaipa - nokuti iri mubhadharo.
Kuonekwa kwenhamba dzisina kunaka mune pepa rekushandura kunogona kuchinjwa uchishandisa Format Cells dialog box .