Excel Financial Function PMT Explained in Hindi - PMT Formula in Excel

Excel Financial Function PMT Explained - How To Calculate Loan EMI Using PMT Function in Excel in Hindi In This Video You Will Learn About PMT Function. PMT Formula allows you to calculate the EMI for a loan. . Nowadays People Take A Loan For Buying Cars, Buying A House, Studies Of Children, And Giving Some Installments Every Month/every year/semi yearly/quarterly/weekly To Repay The Loan. If We Want To Know, How Much Interest Will Be Charged For Particular Loan Amount, And What Will Be Monthly/ yearly / semiyearly/ quarterly/ weekly Installment, Then, To Know The Amount Of Installments, The PMT Function Is Used in ms excel 2007 2010 2013 2016 2019 2021 #pmtfunction #excel #deepakeduworld
Enter an interest rate, the number of payments, and the loan amount on the worksheet. Then, refer to those cells in the PMT formula.
Download Training File : drive.google.com/open?id=1F-R...
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
Tags:
advence excel course, Pmt Formula, excel financial formulas, advanced excel tutorial in hindi, deepak eduworld, deepak nehra, excel tips, excel user, computer user, technology, computer tips

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@Akshaycreation7888]

में आपके सारे वीडियो देखता हु । आपने बहुत ही सरल तरीके से समझाया है। मेरा excel के प्रति जो डर था वह गायब हो गया । Thank you so much ❤️ se

[@surajgaud2330]

You are out of this world as a trainer, Sir

[@khalidalisubhanallah2947]

Bundle of Thanks Sir G Nice Video

[@diwakarprasad318]

Jitna tarif karo kam hain ❣️love you sir ❣️❣️❣️❣️❣️❣️❣️❣️

[@iambangladeshi1431]

Excellent class sir.

[@pritamdigitalworld2410]

bohot hi must he sir.. how great your teaching style waiting for next video

[@daleepsingh6725]

deepak sir dhanyvad ese video dikhane ke liye me asa karta hu ki ap nye video send karte rhna

[@kumargautam6997]

Very useful sir Thanx

[@rakhinavait9378]

You are too good Sir ji aapne bahut hi acche se samjhaya

[@1955rauf]

Mr deepak So nice video Step by step clear Raja London Uk 🇬🇧

[@plok_idea]

Thanku sir. So helpful 💖

[@manjit.sarania]

Very helpful sir

[@Sonii.sisters96]

Very useful👌👌

[@diwakarprasad318]

Just awesome sir...

[@NavneetKumar-wf4pl]

Very nice sir 🙏🙏

[@sonali2852]

Thanku so much sir. It is very helpful video

[@deshigirl2993]

Thanks sir this formula is very useful for me 😁😁👌👌👍👍 aap bohot achhi video bnate h sir

[@noorqamar7580]

excellent sir

[@NivasBS]

nice video and well explained deepak ji

[@ravidas4880]

Very nice video very nice Deepak sir

[@ankushjadhav9052]

Thank you sir 🥰🤗

[@skd5218]

Sir,it's very clear TQ

[@sagaedxd6091]

Nice BHai Jaan Very Nice

[@moodkn]

Great.... Thanks..!

[@niju71]

very great full

[@nilanjanachoudhury8545]

thanks a lot sir

[@kajalkashyap6664]

Thank you sir🙏

[@rajandhiman3003]

you are great

[@AmitPal-ek9mw]

Nice video sir

[@akashkelkar1128]

sir very very nice

[@BanaoGameplay]

Very Nice Bro 😍

[@rohitrajsaini8542]

Very nice Deepak Sir

[@digitalcomputerinsitituter5377]

Thank you sir

[@rameshsahu9284]

Thank you Sir 😍🙏🏻

[@iamrider7979]

Behatreen sir

[@sheikhmuhammadadnan3]

Very Good

[@vermaeducationworld7765]

Thanks sir you are genius

[@DeepakEduWorld]

🤗

[@bikihari2530]

Very nice video

[@sapnachauhan6635]

very very nice sir

[@bantikhan8380]

Happy Teacher Day May God always keep you healthy.

[@DeepakEduWorld]

God bless you dear 🤗🤗🤗🤗😊😊😊😊😊😊♥️♥️♥️♥️

[@futureonlineguru2879]

Thankyou sir

[@JitendraKumar-dw5kj]

Thank you

[@ilyasnasirfromlahore9849]

Good work

[@xlpointacademy5127]

Super Sir

[@priyankashukla285]

Thnq u sir

[@sachinjain5698]

Hi deepak.. make a video on compare two list, to identify common and unique records... Try not to use match and count if function.

[@surojsantra4172]

thank you

[@odiaeducation4954]

thanks sir

[@sumitkumardas3404]

very nice

[@rajandhiman3003]

super cool

[@mannumichael7860]

Mast hai video sir

[@KBMALEKAR]

Nice.

[@kaushikanand4160]

nice sir

[@badbloodgamer2280]

Aapke samjhaneka tarika baht hi jada acha he...

[@vivekkalshan3589]

sir very good video

[@DeepakEduWorld]

😊

[@ashishmore7242]

Thkuuu

[@maonojkumarkhilarmuna3748]

super

[@pragyanlok]

Make a video regarding score chart used in cricket in excel...and provide the .xlx sheet

[@ITCE2018]

Nice

[@odiaeducation4954]

thanks

[@rohitkumargupta2162]

Very nice sir or p pmt ipmt ki videos bhi dalie

[@DeepakEduWorld]

G

[@luckyk7809]

sir make a video on PPMT & IPMT function in excel

[@sanjanasaini6829]

sir make a video on how to use mailing function in ms word

[@Muzammiljamil6]

Kia bat hay sir apki

[@karthikrajgopal8627]

nice, please pubish video on how to convert emi into principal and interest..

[@DeepakEduWorld]

Ys.. I will publish

[@anmoljadhav6100]

Sir how do you calculated no of payments of bi weekly and weekly, could u pls explain

[@rajandhiman3003]

sir ak question ha mera math bahut jayda weak ha isliya apki video ko dekhna ka baad thodi bahot problem hoti ha seekhna ma kyoki kabi kisi na mujha math seekna ko mila hi nahi

[@mannukumari7022]

PPMT, IPMT,. PV, FV,RATE,NPER ka video daalo

[@akshayvibhar6092]

Sir pv, fv, rate aur nper formula ki bhi ek ek video banaiye please 🙏

[@harishsharma3910]

SIR MSACCESS PR BHI VDEO BNAO

[@anjalimitra4941]

thanks sir for this pmt video.... ap mujhe npv,xnpv,irr.... k bareme bolo to help hoga sir

[@DeepakEduWorld]

Ys i will publish all these formats shortly

[@ramenkumarbir845]

deepak vi GROSS ANNUAL VALUE CALCULATION OF( INCOME FROM HOUSE PROPERTY)IN EXCEL SHEET. Yea topic me ek video banaye plz.

[@DeepakEduWorld]

Asap 👍

[@lokendrachand7859]

Very nice Deepak bhai or AAP Shikha kaha se

[@kalicharanmaharana2730]

Firstly Thank you deepak sir for uploading videos, For that we learn excels. When i calculate the formula works, but the mark of pound came before the number. How to remove the pound mark.

[@jackie2118]

When I calculate it's comes in rupee sing please help

[@Joyce.john14588]

@@jackie2118 Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert

[@Joyce.john14588]

Press CTRL + 1 on the price and Go to FORMATE CELL then use NUMBER TAB there you will get the options of CURRENCY Option Select the currency which you want to insert

[@azeemsiddiqui1859]

Plz clear my confusion that yearly emi is 24000 22561 is wrong Because 80000*5/100=4000 yearly interest so 4 year interest is 16000 So total amount 96000 And 96000/4=24000

[@kumarsandeep7232]

👍😘

[@umairmomin8868]

Sir how to use this formula if no of month i odd like 25 month or 27 month

[@paramjeet975singh3]

Sir simple interst aur ipmt formula mai kya antar hai..

[@AnilSingh-nd8hy]

Please make video how to separate number and words...in simple mode

[@DeepakEduWorld]

Ok

[@adityanegi6678]

hlow dear sir ek scenario manager pe bhi video banana tq

[@DeepakEduWorld]

G

[@odiaeducation4954]

namaskar sir

[@sushilaadangale1281]

Which version do you use ?

[@nadeemkhanani2393]

Sir what if analsisi function sikhao plz Goal seek function

[@prakash1547]

Sir, PMT ko operator se kaise nikale jise hme pata chale ki mera value sahi h

[@ashy4u4ever]

I am trying to create button with hyperlink but when i create its show error "this operation has been cancelled due to restrictions in effect on this computer please contact your system administrator." what is the solution of this please help me

[@pankajhiralalpatel4454]

Sir,Mera ek question hai ki agar Rs.100000 lac ki loan Rs.5000 ke 20 installment me pay karni hai Rate of interest 12%p.a hai magar 8 installment ke bad loan phir se renew karni hai to kaise kare ? Matlab ke 8x5000 =40000 jama huye hai Renew karne par grahak ko payment Rs.40000 milega or loan amount 100000 ka renew ho jayega or phirse 1st installment gina jayega. Please solve this and make a video about it.

[@rajneekantmaurya6612]

Sir customer ki emi collection aur fixed date ke bad penalty bhi add ho kya excel me asa ho sakta hai Agar haa to please ek video jarur banayie🙏

[@DeepakEduWorld]

👍 ASAP

[@Imrankhan-th2mh]

Hey sir I'm New Subscriber of ur channel Sir plz tell me the default row height and default column width in excel 2003 .....

[@Imrankhan-th2mh]

Sir iska bhi reply kr dijiye

[@babitabhatt3912]

Sal bhar ka emi ka samjh aagaya lekin sal se Kam samay ka loan jaisale 8 month 6th month ka Janna he kaise banega

[@ashfaqkhaskheli1634]

Bro i have only understand the formula application and i want to know formula background and logics which is not is this video

[@LokendrasirTezzdimag]

Hii sir mi nikalne ke liy ham kopi par kese nikale

[@priyankaqueen2081]

PMT or impt ,ppmt, bhi karaiyee

[@iqclasses7367]

kzbin.info/www/bejne/gJClaYmKbJd_qrs Check it all in one pmt ppmt ipmt

[@puneetvij8433]

Deepak Sir, मैनें pmt के videos देखे है, उसमें तो बताया कि 'nper' में number of months डालो और हमेशा months में ही value डालो? ये क्या चक्कर है? : )

[@DeepakEduWorld]

we mostly pay for monthly installment... that's may be the resion...... and its not number of months . its total number of payment in 1 year..... if you wanna calculate weekly/yearly/semi yearly installment.... you can calculate in this way....

[@smilesformiles7336]

Yearly Emi 22,561 n Semi Yearly 11,157 if we multiply 11,157*2 we will get 22,315 ... 22,561 ke nearby amount aana chaiye tha na please explain

[@binayapradhan8844]

You should be subtract 11157 from 80000 after that you use same formula. Because you pay ur emi every 6mnt not a early . That why every 6mnt subtract 11157 form ur main loan 80,000

[@GopalKumar-po9vw]

NPER means no. of period or no. of payment ?

[@jackie2118]

No. of payment is right

[@anis4u2009]

Good evening Deepak sir. Mai excel me student ki marksheet Bana rahu to isme grand total point me aata he kaise 65.5 to ye mark Ko pure number me convert karna ho to kaise kare. Pls reply me.

[@DeepakEduWorld]

Gud evening... From HOME tab.. Go to number block.. Select cell and select NUMBER from number format dropdown list

[@shrikantdeshpande4601]

I want to make a series of numbers in text i.e. one, two three....hundred & so on. How can I make it in excel? pl. guide on this topic.

[@DeepakEduWorld]

Ok i will check it and discuss it in my next excel trick video

[@anis4u2009]

Good noon sir, I hope you are very well. Sir vlookup me student ke roll no ke saath date of birth kofta hu to error aati hai to DOB Ko kaise vlookup kare pls answer me.

[@DeepakEduWorld]

Same as other data.. But the column in which lookup vale is present.. Must be first column when you select table array..

[@anis4u2009]

Many many thanks sir

[@amitvashishtha298]

Sir ipmt or ppmt ki videos baniye

[@DeepakEduWorld]

Ok g

[@DeepakEduWorld]

Thoda sa wait kro bas