Shaqada PMT^{(PMT function)} ee Excel waa shaqo maaliyadeed oo loo isticmaalo in lagu xisaabiyo bixinta deynta iyadoo lagu saleynayo lacag bixinta iyo heerka dulsaarka. Qaabka shaqada PMT waa PMT (heerka, nper, pv, [fv], [nooca])^{(PMT(rate,nper,pv,[fv], [type]))} .

Isku dhafka Shaqada PMT

• Heerka^(Rate) : Heerka dulsaarka amaahda (loo baahan yahay).
• Nper : Wadarta tirada guud ee bixinta deynta (loo baahan yahay).
• Pv : Qiimaha hadda ama wadarta qaddarka lacagta taxanaha ah ee mustaqbalka ay hadda qiimo tahay ( Loo baahan yahay).
• FV : Hadhaaga aad rabto inaad ku guulaysato ka dib lacag bixinta ugu dambeysay ee la bixiyay ama lacag bixinta mustaqbalka ( Ikhtiyaar^(Optional) ah ).
• Nooca^(Type) : Nambarka eber ama kow oo tilmaamaya marka lacag bixinta la bixinayo.

Sida loo isticmaalo PMT Function gudaha Excel

Casharradan, waxaan rabnaa inaan ku helno lacag-bixinta billaha ah.

Fur Microsoft Excel .

Isticmaal^(Use) miiska jira ama samee miis.

Qolka ka soo horjeeda lacag-bixinta billaha ah, ku qor =PMT ka dibna garabka.

Gudaha gunta, ku qor B3 sababtoo ah taasi waa unugga ka kooban heerka ribada. Kadibna u qaybi B3 laba iyo tobnaad^(twelfth) ( B3/12 ) si aad ugu beddesho heerka ribada sannadlaha ah heerka ribada bishiiba. Kadibna dhig kooma^(comma) .

Nooca B4 , sababtoo ah kani waa unugga ka kooban sanadka kaas oo gacan ka geysan doona wadarta bixinta deynta, laakiin sababtoo ah waxaan bixineynaa lacag-bixinno bille ah, waa inaan ku dhufano tirada sannadaha laba iyo tobnaad tirada lacag-bixinta ( b4*12 ). Kadibna Comma.

Waxaan hadda gelin doonaa qiimaha hadda ee deynta ( Pv ), taas oo ah qaddarka deynta ee unugga  B2 .

Dabadeed xidh xidhidhka oo taabo Gelida^(Enter) ; waxaad arki doontaa natiijooyin.

Waxaa jira laba ikhtiyaar oo kale oo loo isticmaalo shaqada PMT .

Xulashada kow waa inaad gujiso badhanka Gelida^(fx) ( fx^{(Insert Function)} ) ee ku yaal xagga sare ee xaashida.

Sanduuqa wada hadalka Gelida^{(Insert Function)} ayaa furmi doona.

Insert Function sanduuqa wada hadalka, dooro qaybta Maaliyadda^(Financial) .

PMT ka dooro koox hawleed^(Select) oo guji ^(Function)OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Gudaha sanduuqa wada-hadalka, oo aad ku aragto Heerka^(Rate) , ku qor B3 /12 sanduuqa soo galinta.

Meesha aad ku aragto Nper nooca B4*12 ee sanduuqa gelitaanka.

Meesha aad ku aragto Pv , ku qor B2 , oo guji OK , waxaad arki doontaa natiijooyinka.

Fv iyo Nooca^(Type) waa ikhtiyaari; looma baahna.

Ikhtiyaarka labaad waa in la gujiyo  tab Formulas .

Dhinaca Formula tab, dhagsii badhanka Financia l ee kooxda Maktabada Shaqada^{(Function Library)} , oo dooro PMT .

Sanduuqa wada hadalka Function Arguments^{(Arguments Function)} ayaa soo muuqan doona.

Sanduuqa   wada hadalka Shaqada doodaha^{(Arguments Function)} samee isla waxii aan kor ku soo sheegnay oo ah ikhtiyaarka koowaad si aad u aragto natiijooyinka.

Akhri:  ^(Read: )Sida loo isticmaalo shaqada DSUM ee Microsoft Excel^{(How to use DSUM function in Microsoft Excel)} .

Haddii aad su'aalo qabtid, fadlan hoos ka faallooda

How to use PMT Function in Excel

The PMT function in Excel is a financial function used to calculates the payment of a loan based on payments and interest rates. The formula for the PMT function is PMT(rate,nper,pv,[fv], [type]).

Syntax of the PMT Function

• Rate: The interest rate for the loan (Required).
• Nper:  The total number of payments for the loan (Required).
• Pv: The present value or total amount that a series of future payments is worth now (Required).
• FV: The balance you want to achieve after the last payment paid or future payments (Optional).
• Type: The number zero or one and indicates when the payments are due.

How to use PMT Function in Excel

In this tutorial, we want to find the monthly payment.

Open Microsoft Excel.

Use an existing table or create a table.

In the cell opposite monthly payment, type =PMT then bracket.

Inside the bracket, type B3 because that is the cell that contains the interest rate. Then divide B3 by twelfth (B3/12) to convert a yearly interest rate to a monthly interest rate. Then place a comma.

Type B4, because this is the cell that contains the year which will contribute to the total payments for the loan, but because we are paying monthly payments, we have to multiply the number of years by twelfth to the number of payments (b4*12). Then Comma.

We will now enter the present value of the loan (Pv), which is the loan amount in cell  B2.

Then close the bracket and press Enter; you will see results.

There are two other options to use the PMT function.

Option one is to click the Insert Function (fx) button at the top of the spreadsheet.

An Insert Function dialog box will open.

In the Insert Function dialog box, select the Financial category.

Select PMT from the Select a Function group and click OK.

A Function Arguments dialog box will appear.

Inside the dialog box, where you see Rate, type B3 /12 in the entry box.

Where you see Nper type B4*12 in the entry box.

Where you see Pv, type B2, and click OK, you will see the results.

Fv and Type are optional; they are not necessary.

Option two is to click the  Formulas tab.

On the Formula tab, click the Financial button in the Function Library group, and select PMT.

An Arguments Function dialog box will appear.

In the  Arguments Function dialog box do the same thing mentioned above in option one to see results.

Read: How to use DSUM function in Microsoft Excel.

If you have questions, please comment below.

Related posts

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo shaqada IF ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel